Hi

I am trying to get Hibernate 2 working with the Oracle OCI driver. As you might all know there is a size limit of 4K when using CLOBs through the JDBC Thin Driver. When using the OCI, you won't have that issue.
Problem is, I can't get Hibernate to work with this driver. If anyone has any thoughts on this, please..

This is what I get when using the other driver and the following URL:
jdbc:oracle:oci:@localhost:1521:ORCL

[WARN] SettingsFactory - Could not obtain connection metadata <java.sql.SQLException: Invalid Oracle URL specified>
java.sql.SQLException: Invalid Oracle URL specified
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:273)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:182)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1160)
at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:794)

Thanks, Chris Schuit

Hi all,

To solve my own question, when using the OCI, the following things should be dealt with:

Download the OCI driver from oracle.com and install the .dll (windows) or .so library approrpiately

.

Set your URL in hibernate.properties: jdbc:oracle:oci8:@ORCL (make sure your database it set up in the servers TNSNAMES.ORA (mine is called ORCL).

Set your driver class in hibernate.properties: oracle.jdbc.driver.OracleDriver

Make sure the classes12.zip from the package you just downloaded is in the classpath and the old classes12.zip is gone.

Well, that's about it :) Hope this solves a lot of questions for a lot of people. The 4K horror has been mentioned a lot of times on the web.

Chris