• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

Oracle ODBC Driver

 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Sheriff
Posts: 7001
6
Eclipse IDE Python C++ Debian Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 7001
6
Eclipse IDE Python C++ Debian Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 358
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 1157
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 :
jdbc:oracle: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).]
 
I am mighty! And this is a mighty small ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/wiki/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic