自己写一个Oracle的JDBC driver - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Java - 爪哇娇娃

自己写一个Oracle的JDBC driver

自己写一个Oracle的JDBC driver# Java - 爪哇娇娃

l*e2005-02-15 08:02

1 楼

打算自己写一个oracle的type 3 or type 4 jdbc driver, 就不要问为什么要自己写了，
原因很复杂，但是从oracle的网站上找不到API的doc, 谁能指点一下？还是Oracle的API
是不公开的

c*g2005-02-15 08:02

2 楼

Not sure if I understand your question. Basically the interface for
all JDBC driver is the same, namely package java.sql and javax.sql.
The JDBC specification and java.sql/javax.sql pretty much define
everything.

【在 l*****e 的大作中提到】

: 打算自己写一个oracle的type 3 or type 4 jdbc driver, 就不要问为什么要自己写了，
: 原因很复杂，但是从oracle的网站上找不到API的doc, 谁能指点一下？还是Oracle的API
: 是不公开的

l*e2005-02-15 08:02

3 楼

Sorry for being clear at the first place. I am trying to implement my own JDBC
driver for Oracle DBMS. It talks with Oracle CLI (as I understand what a type
4 JDBC driver should do) and provides the standard JDBC interface specified by
Sun to other Java applications.

了，

【在 c**g 的大作中提到】

: Not sure if I understand your question. Basically the interface for
: all JDBC driver is the same, namely package java.sql and javax.sql.
: The JDBC specification and java.sql/javax.sql pretty much define
: everything.

c*s2005-02-15 08:02

4 楼

虽然没有烟酒过，不过我深信你是找不到源码的。
虽然你说不要问为什么自己写，但我实在想不出有什么理由不能用oracle提供的包。何况
给任何一个数据库写个jdbc driver都不是件容易的事儿。

，
谁能指点一下？还是Oracle的API

【在 l*****e 的大作中提到】

r*l2005-02-15 08:02

5 楼

NIU

，
谁能指点一下？还是Oracle的API

【在 l*****e 的大作中提到】

m*t2005-02-15 08:02

6 楼

JDBC
type
by
So all you need is the Oracle CLI spec, which I'd be surprised if you can't
find in Oracle documentation.
sigh, like other folks I guess I just can't help with this - you don't have to
answer - "why? why? why?!" 8-)
写
谁能指点一下？还是Oracle的

【在 l*****e 的大作中提到】

: Sorry for being clear at the first place. I am trying to implement my own JDBC
: driver for Oracle DBMS. It talks with Oracle CLI (as I understand what a type
: 4 JDBC driver should do) and provides the standard JDBC interface specified by
: Sun to other Java applications.
:
: 了，

l*e2005-02-15 08:02

7 楼

specified
to
The reason is rather stupid and i feel kinda embarassed to say :) the bright
side is I don't have to implement all the JDBC API's spec'd by Sun which seems
to be a daunting task. I googled 'oracle cli api' and tried to find it on it's
website but nothing turned out. Care to shed some light on where I might be
getting the info? Thanks in advance

【在 m******t 的大作中提到】

:
: JDBC
: type
: by
: So all you need is the Oracle CLI spec, which I'd be surprised if you can't
: find in Oracle documentation.
: sigh, like other folks I guess I just can't help with this - you don't have to
: answer - "why? why? why?!" 8-)
: 写
: 谁能指点一下？还是Oracle的

m*t2005-02-15 08:02

8 楼

seems
it's
Do you have the Oracle Documentation CD (should be part of
the Oracle package)? I think it's also available at Oracle's
support site (metalink), which however requires you to register with
your product key.

【在 l*****e 的大作中提到】

:
: specified
: to
: The reason is rather stupid and i feel kinda embarassed to say :) the bright
: side is I don't have to implement all the JDBC API's spec'd by Sun which seems
: to be a daunting task. I googled 'oracle cli api' and tried to find it on it's
: website but nothing turned out. Care to shed some light on where I might be
: getting the info? Thanks in advance

v*e2005-02-15 08:02

9 楼

Although I am a little rusty on the JDBC driver thing, you are even rusty than
I am from what you said. You can only write a type 2 JDBC driver by yourself.
Type 3 needs a RMI/JNDI server. Type 4 is pure java which means you need to
have contract with Oracle in order to know the detail of wire level format.
If you don't like oracle's jdbc driver, you can use BEA weblogic's JDBC
driver.

own
can't
have
seems
it's

【在 l*****e 的大作中提到】

f*g2005-02-15 08:02

10 楼

seems
it's
If Type 3, it is pretty simple. SQL*Net and OCI are both public. Go
OTN for detail documentations.
Type 4, you may need to do some reverse engineer, AFAIK.

【在 l*****e 的大作中提到】