jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes JDBC/ORACLE Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC/ORACLE" Watch "JDBC/ORACLE" New topic


Fred Guo

Joined: Nov 20, 2000
Posts: 4
Hi, all:
Does Oracle7.3.4 support JDBC, if yes, is there any difference using JDBC to connect Oracle 7.3.4 from Oracle 8.0.4. I did not find the jdbc driver, such as classes111.zip or classes102.zip in the directory of Oracle 7.3.4.
Frank Carver

Joined: Jan 07, 1999
Posts: 6920
As far as I am aware you can use the same JDBC drivers - the wire protocol is the same for both versions. I happily use classes111.zip and classes12_01.zip with Oracle 7.3.4, and I know of others who use the same files with Oracle 8.
So if you have one of the drivers lying around, give it a try. If not, they can be found on Oracle's web site.

Read about me at frankcarver.me ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
NageswaraRao Karra
Ranch Hand

Joined: Nov 12, 2000
Posts: 34
if you did not find classes101/...111.zip files just run the oracle installer again. from cd in the directory of jdbc install the product file to the directory of oracle home.that's all.use them after setting classpath.

Joined: Nov 29, 2000
Posts: 6
The Oracle Drivers are backward compatible which means you can use any of the higher version drivers to connect to 7.3.4. But in case you are using the OCI driver, you should have the client instllation corresponding to the driver version. For thin drivers there is absolutely no problem.
Hope this helps,
Fred Guo

Joined: Nov 20, 2000
Posts: 4
Thank you all.
The platform I am working on is Unix. I can not install software (such as, classes111.zip) myself. I simply FTP the classes111.zip to the server and included it in the classpath, it does not work. There is a web application runing on this server, which also use jdbc to connect database, but I wonder how it works. It might be wrapped the jdbc in its API.
I agree. Here's the link: http://aspose.com/file-tools
subject: JDBC/ORACLE
It's not a secret anymore!