Hello,

The code runs fine without jndi dataSource configuration. But when jndi DataSource is configured in the following context :

Using an Oracle 8.0.4 oracle.jdbc.pool.OracleConnectionPoolDataSource Jndi bound DataSource in Websphere 4.0.6

I'm getting a wiered "java.sql.SQLException: internal error" when calling the commit method on net.sf.hibernate.transaction.JDBCTransaction.

The traces show the folowing :

DEBUG net.sf.hibernate.transaction.JDBCTransaction - commit
DEBUG net.sf.hibernate.impl.SessionImpl - flushing session
...
DEBUG net.sf.hibernate.impl.SessionImpl - Flushed: 0 insertions, 1 updates, 0 deletions to 1 objects
....
DEBUG net.sf.hibernate.impl.SessionImpl - executing flush
DEBUG net.sf.hibernate.persister.EntityPersister - Updating entity: ...
DEBUG net.sf.hibernate.impl.SessionFactoryImpl - prepared statement get: ....
...
DEBUG net.sf.hibernate.impl.SessionFactoryImpl - closing statement

DEBUG net.sf.hibernate.util.JDBCExceptionReporter - SQL Exception
java.sql.SQLException: internal error
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:219)
at oracle.jdbc.dbaccess.DBDataSet.setDBItem(DBDataSet.java:310)
at oracle.jdbc.driver.OraclePreparedStatement.clearParameters(OraclePreparedStatement.java:2512)
at com.ibm.ejs.cm.cache.CachedStatement.clearParameters(CachedStatement.java:446)
at com.ibm.ejs.cm.cache.StatementCache.releaseStatement(StatementCache.java:193)
at com.ibm.ejs.cm.cache.CachedStatement.close(CachedStatement.java:52)
at com.ibm.ejs.cm.proxy.StatementProxy.close(StatementProxy.java:104)
at net.sf.hibernate.impl.SessionFactoryImpl.closePreparedStatement(SessionFactoryImpl.java:555)
at net.sf.hibernate.impl.BatcherImpl.closeStatement(BatcherImpl.java:115)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:108)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2103)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2062)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2005)
at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:57)


WARN net.sf.hibernate.util.JDBCExceptionReporter - SQL Error: 17089, SQLState: null

ERROR net.sf.hibernate.util.JDBCExceptionReporter - internal error

ERROR net.sf.hibernate.util.JDBCExceptionReporter - Could not synchronize database state with session


Thank's for your help.

Alain.