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