Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes JDBC2 support Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC2 support" Watch "JDBC2 support" New topic
Author

JDBC2 support

Dmitry Shekhter
Greenhorn

Joined: Feb 21, 2001
Posts: 26
Does the Oracle driver that comes with Oracle 8.1.6 fully support JDBC 2. Do i have to do anything other than add classes12.zip to my class path to be able to use the jdbc2 driver?
Thanks in advance
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
From the oracle web site:
http://technet.oracle.com/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#_29_
In Oracle 8.1.6, we provide JDBC drivers for Java1.1.x and for Java2 (aka 1.2). Our 1.2 Oracle drivers are fully JDK 1.2 compliant. Both our 1.1.x and our 1.2 JDBC drivers are JDBC 2.0 compliant except for Calender datatype support. Features supported include:
Core JDBC:

  • Beta support for scrollable cursors
  • Support for structured types and lob types.
  • Batching support compliant with the JDBC 2.0 API

  • JDBC 2.0 Extensions:

    • Connection Pooling
    • JDBC-XA support (but not "recover()").

    • Moderator of the JDBC Forum

      [This message has been edited by Thomas Paul (edited February 21, 2001).]


Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
Dmitry Shekhter
Greenhorn

Joined: Feb 21, 2001
Posts: 26
Thank you for the prompt response, one more thing though, the classes12.zip file, does it contain more than one driver, if so, how can i find out the class names of the drivers. I tried unzipping the file, but it just created a couple of empty directories. Based on a couple of posts i've read, the classes12.zip file contains a driver with class name oracle.jdbc.driver.OracleDriver - is that the name for the JDBC2 compliant, thin Oracle driver?
Again, thank you for your help.
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Take a look at this document:
http://technet.oracle.com/tech/java/sqlj_jdbc/pdf/accessingoracle.pdf
Dmitry Shekhter
Greenhorn

Joined: Feb 21, 2001
Posts: 26
Thank you.
Dmitry
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: JDBC2 support
 
Similar Threads
JDBC Connection pooling in postgresql
Help....Pass parameter to PL
Diff bet execute() and executeQuery()
JDBC2 Driver for oracle
Problem with ResultSet