This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Driver for Oracle RDB

 
Kash Mhai
Greenhorn
Posts: 29
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Kash Mhai
Greenhorn
Posts: 29
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1082
Java Oracle Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic