File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Android Security Essentials Live Lessons this week in the Android 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
 
 
subject: JDBC2 support
 
Similar Threads
JDBC2 Driver for oracle
Problem with ResultSet
Help....Pass parameter to PL
JDBC Connection pooling in postgresql
Diff bet execute() and executeQuery()