aspose file tools*
The moose likes JDBC and the fly likes JDBC Driver for Oracle RDB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Driver for Oracle RDB" Watch "JDBC Driver for Oracle RDB" New topic
Author

JDBC Driver for Oracle RDB

Kash Mhai
Greenhorn

Joined: Apr 01, 2005
Posts: 29
Hi all,
I have a requirement to connect to Oracle RDB from Java. The Oracle RDB is hosted on a VAX Server.
The queries I have are -
1. Is classes12.zip used for Oracle 9i sufficient for accessing RDB?
2. Is there a jar file available taht can be used the same way as regular Oracle Thin Drivers?
3. Is there a specific way to approach this connectivity?
4. Any info on this is appreciated

Looking forward for ANY replies whatsoever,

Thanks
Kash


-------------<br />There are wheels within wheels...<br />P.G Wodehouse
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

Originally posted by Kash Mhai:

I have a requirement to connect to Oracle RDB from Java. The Oracle RDB is hosted on a VAX Server.
The queries I have are -
1. Is classes12.zip used for Oracle 9i sufficient for accessing RDB?


Yes it is sufficient, you can also use ojdbc14.jar

2. Is there a jar file available taht can be used the same way as regular Oracle Thin Drivers?


Already answered above,


3. Is there a specific way to approach this connectivity?


For better performance, connection pooling etc..establish your connection via data source


Shailesh


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Kash Mhai
Greenhorn

Joined: Apr 01, 2005
Posts: 29
Shaliesh,
Thanks!
I also should have mentioned that my machine is a windows 2000 and the VAX machine is a seperate one. Do I also need to have a RDB Client installed on my machine?
Also have you used the RDB anytime? Is the method of getting a connection similar to what we do for regular database accesses!?

Thanks for the earlier replies!

Kash
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

Hi Kash,

Seems I missed your question, and I answered you question for connecting with 'Oracle DB' instead of 'Oracle RDB'. Please accept my apologies..........I am not sure if ojdbc14.jar or any other jar will do the task for you


Here is answer of your initial question

There are two flavors of Oracle JDBC for Rdb Drivers

First Type Oracle JDBC for Rdb Native Driver

The Oracle JDBC for Rdb Native Driver that connects directly to Rdb SQL via a native API. This driver requires an Rdb client installation, and therefore is Rdb-specific and not suitable for applets. The Native driver, written in a combination of Java and C, converts JDBC invocations to calls to SQLMOD modules, using native methods to call C-entry points.

The Oracle JDBC for Rdb Driver uses the Rdb libraries on the client machine on which it is installed.

Second TypeOracle JDBC for Rdb Thin Driver

The Oracle JDBC for Rdb Thin Driver which is a 100% pure JAVA driver that communicates directly to the Oracle JDBC for Rdb Thin servers via JAVA Sockets over TCP/IP.

The Oracle JDBC for Rdb servers are the server-side components that service JDBC requests issued by applications using the Oracle JDBC for Rdb Thin driver. The Oracle JDBC for Rdb Thin Driver requires no additional Oracle software to be installed on the client side. For applets it can be downloaded into a browser along with the Java applet being run. The Oracle JDBC for Rdb servers require Rdb and JAVA to be installed on the server side.


You can download these drivers from Oracle's website.I haven't used RDB drivers ever.

Shailesh
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Driver for Oracle RDB