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:[email protected] 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 > > >
