Oracle 11G R2 Hibernate
Things you should know if you are using Hibernate with Oracle 11G R2. Sep 26
Get flash to fully experience Pearltrees
This issue was already reported on the forums ( http://forum.hibernate.org/viewtopic.php?t=968578 ), but I can find no actual JIRA entry. The issue is that when the hibernate.jdbc.wrap_result_sets property is set to true, ResultSets are never removed from the AbstractBatcher's resultSetsToClose set, eventually causing memory to fill up with ResultSet objects and their associated resources (like PreparedStatements). This issue was witnessed in 3.2.6, but a look at the 3.3 CR1 source code reveals that it's still in there.
HI all, This has worked fine for very long, but starting a few days ago I started getting this error everytime the code tries to write (insert or update) into the db: java.sql.SQLException: Protocol violation The oracle code error is 17401
With Oracle 11g, the deprecated package oracle.jdbc.driver no longer exists and this causes issues with all OracleDialect classes making it impossible to use Hibernate. This issue affects all of the following classes: Oracle9iDialect.java Oracle9Dialect.java Oracle10gDialect.java The line error in question is: Class types = ReflectHelper.classForName("oracle.jdbc.driver.OracleTypes"); This simply needs to be changed to: Class types = ReflectHelper.classForName("oracle.jdbc.OracleTypes"); From the Oracle 11g readme.txt
We are using hibernet3.2.1, jboss 4.2.3 cp 09, jdk1.5, Oracle10G and 11G
Oracle JDBC Drivers release 126.96.36.199.0 - Production README What Is New In This Release ?