• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle ODBC Driver

 
Sita Yo
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to access an oracle database from a linux machine using Java programs. I try to load the oracle driver using:
Class.forName("sun.jdbc.odbc.OracleDriver");
However I got an message:
java.lang.ClassNotFoundException: sun/jdbc/odbc/OracleDriver
Does anyone know if there is any Orale Odbc drivers for Jdk1.3 on linux? Or where can I donwload it?
Thanks
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is not exactly a reply to your question, but I have to ask why you want to use the somewhat limited and flaky jdbc/odbc bridge to talk to an odbc/oracle bridge whan you can use the much more full-featured oracle "thin" driver (a free download from Oracle) directly.
 
Sita Yo
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Frank Carver:
This is not exactly a reply to your question, but I have to ask why you want to use the somewhat limited and flaky jdbc/odbc bridge to talk to an odbc/oracle bridge whan you can use the much more full-featured oracle "thin" driver (a free download from Oracle) directly.

The oracle database is installed on a Unix machine and I am using another linux machine with jdk1.3, but they are on the same network. Sorry I am not really familiar with oracle. How can I use the "this" driver?
Thanks!
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The Oracle "thin" driver is a pure-java driver which implements JDBC for your java programs, and communicates with a local or remote database using the native Oracle network protocols.
I use this same driver zip file on Windows NT, Windows 95, Linux and DEC Unix to communicate with databases running on several different Unix machines. All you need to do is to put the supplied zip or jar file in your classpath and off you go.
 
rani bedi
Ranch Hand
Posts: 358
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
JDBC driver type 3 -- the net-protocol/all-Java driver -- follows a three-tiered approach whereby the JDBC database requests are passed through the network to the middle-tier server. The middle-tier server then translates the request (directly or indirectly) to the database-specific native-connectivity interface to further the request to the database server. If the middle-tier server is written in Java, it can use a type 1 or type 2 JDBC driver to do this.
 
Desai Sandeep
Ranch Hand
Posts: 1157
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
This is my first post in this forum.
As regards Oracle Drivers, I would suggest you use the Oracle thin Driver.This is a Type-3 Driver which doesnot require any client installation.
This is how you could use it

For thin drivers, the Database URL is of the form :
jdbcracle:thin:@HostId:port:SidName
Oracle also ships one more driver, which is a server-side driver called KBRP driver.This driver is used specifically by EJBs to connect it to the DB.The speciality of this driver is it takes the connection information from the Connection the Client made to the server.The KBRP connection which is created cannot be closed.
You can establish a KBRP connection as follows:

Hope this helps,
Sandeep

  • Sun Certified Programmer for Java 2 Platform Scored 93 per cent
  • Oracle JDeveloper Rel. 3.0 - Develop Database Applications with Java Scored 56 out of 59
  • IBM Enterprise Connectivity with J2EE Scored 72 per cent
  • Enterprise Development on the Oracle Internet Platform Scored 44 out of 56

  • [This message has been edited by Desai Sandeep (edited June 01, 2001).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic