This is using WebSphere 5.1 datasource, Oracle 9i.
2.1.6:
Mapping documents:
Transaction txn = null; try{ Transaction txn = session.beginTransaction(); Long id = (Long) session.save(note); txn.commit(); }catch(HibernateException he){ try{ if(txn != null) txn.commit; }catch (HibernateException he1) { processHibernateException(he1); } processHibernateException(he); }
Full stack trace of any exception that occurs:
[10/27/04 10:03:50:356 EDT] 129c146c JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: 0, SQLState: null [10/27/04 10:03:50:372 EDT] 129c146c JDBCException E net.sf.hibernate.util.JDBCExceptionReporter Outstanding work on this connection which was not comitted or rolledback by the user has been rolledback. [10/27/04 10:03:50:372 EDT] 129c146c JDBCException E net.sf.hibernate.util.JDBCExceptionReporter Cannot close connection [10/27/04 10:03:50:388 EDT] 129c146c JDBCException E net.sf.hibernate.util.JDBCExceptionReporter TRAS0014I: The following exception was logged com.ibm.ejs.cm.exception.WorkRolledbackException: . at com.ibm.ejs.cm.pool.ConnectO.decRef(ConnectO.java(Compiled Code)) at com.ibm.ejs.cm.pool.ConnectionPool.freeConnection(ConnectionPool.java:211) at com.ibm.ejs.cm.proxy.ConnectionProxy.close(ConnectionProxy.java:816) at net.sf.hibernate.connection.DatasourceConnectionProvider.closeConnection(DatasourceConnectionProvider.java:64) at net.sf.hibernate.impl.BatcherImpl.closeConnection(BatcherImpl.java:305) at net.sf.hibernate.impl.SessionImpl.disconnect(SessionImpl.java:3352) at net.sf.hibernate.impl.SessionImpl.close(SessionImpl.java:576)
Name and version of the database you are using: Oracle 9i
The generated SQL (show_sql=true): Hibernate: select FMID_SEQ.nextval from dual Hibernate: insert into NOTE (SUBJECT_REFERENCE, NOTE_TYPE, NOTE, EFFECTIVE_DATE, END_DATE, CREATED_BY, LAST_UPDATED_BY, DEACTIVATED_BY, DEACTIVATED_REASON_CD, CREATED_ON_BEHALF_OF, UPDATED_ON_BEHALF_OF, DEACTIVATED_ON_BEHALF_OF, NOTE_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Debug level Hibernate log excerpt:
|