Re: More Oracle woes...
I will mail a concise and terse update tomorrow... Spent most of today trying to create some JMeter components to test this stuff. --jason -Original Message- From: Matt Hogstrom [EMAIL PROTECTED] Date: Tue, 07 Feb 2006 17:36:20 To:dev@geronimo.apache.org Subject: Re: More Oracle woes... Jason, I'm catching up with your thread. Can you post an update and I'll be back on this evening. Sorry for the pain :( Jason Dillon wrote: 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
More Oracle woes...
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
Re: More Oracle woes...
Jason, I'm catching up with your thread. Can you post an update and I'll be back on this evening. Sorry for the pain :( Jason Dillon wrote: 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