So, I was going to punt on the TranQL Oracle-specific connector and
just try to bundled generic version with the Oracle driver. So I used
the wizard to generate a plan, and installed it... but when I try to
use it I get fluff like:
<snip>
13:46:07,901 WARN [GeronimoConnectionEventListener]
connectionErrorOccurred called with null
java.sql.SQLException: Unsupported feature
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at
oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:690)
at
oracle.jdbc.OracleDatabaseMetaData.supportsGetGeneratedKeys(OracleDatabaseMetaData.java:3766)
at
org.tranql.connector.jdbc.DatabaseMetaDataHandle.supportsGetGeneratedKeys(DatabaseMetaDataHandle.java:1089)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:80)
at
net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1155)
at
net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:789)
at
org.springframework.orm.hibernate.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:535)
...
</snip>
So, it looks like "boolean supportsGetGeneratedKeys()" is getting
called, but for some reason "boolean
OracleDatabaseMetaData.supportsGetGeneratedKeys()" throws an exception
instead of just returning false.
I get the same behavior with these:
* oracle/ojdbc14/9.2.0.5/jar
* oracle/classes12/9.2.0.5/jar
But, seems like this guy is much happier:
* oracle/classes12/10.1.0.2.0_g/jar
* * *
Anyways, I guess this is just useful for chronicling my pain with
Oracle, hopefully I'll get this sorted soon and then we can document
the magic so no one has to go through this again.
:-(
--jason
