geronimo-dev mailing list archives

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 <matt@hogstrom.org>
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
>
>
>