You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@geronimo.apache.org by Jason Dillon <ja...@planet57.com> on 2006/02/07 23:29:25 UTC

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...

Posted by Matt Hogstrom <ma...@hogstrom.org>.
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
> 
> 
>