[ajug-members] Hibernate Insert/Update failing
Balu
ttrbalu at yahoo.com
Fri Mar 11 10:11:17 EST 2005
Hi
I am using Hibernate/Websphere with oracle as
Database.I am having problem with Insert(s)/Update(s).
I am getting the following error once hibernate issues
either insert/update
the following is part of my debug statement
[3/10/05 16:52:45:433 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(SessionImpl.java:1340) - object already associated
with session
[3/10/05 16:52:45:434 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(SessionImpl.java:2242) - flushing session
[3/10/05 16:52:45:435 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(SessionImpl.java:2435) - Flushing entities and
processing referenced collections
[3/10/05 16:52:45:440 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(AbstractEntityPersister.java:274) -
com.ko.na.ccrrc.hibernate.TUser.userNm is dirty
[3/10/05 16:52:45:441 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(AbstractEntityPersister.java:274) -
com.ko.na.ccrrc.hibernate.TUser.lastUpdTs is dirty
[3/10/05 16:52:45:442 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(SessionImpl.java:2529) - Updating entity:
[com.ko.na.ccrrc.hibernate.TUser#ln10 at na.ko.com]
[3/10/05 16:52:45:446 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(SessionImpl.java:2880) - Collection found:
[com.ko.na.ccrrc.hibernate.TUser.surveys#ln10 at na.ko.com],
was:
[com.ko.na.ccrrc.hibernate.TUser.surveys#ln10 at na.ko.com]
[3/10/05 16:52:45:447 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(SessionImpl.java:2880) - Collection found:
[com.ko.na.ccrrc.hibernate.TUser.tripSizes#ln10 at na.ko.com],
was:
[com.ko.na.ccrrc.hibernate.TUser.tripSizes#ln10 at na.ko.com]
[3/10/05 16:52:45:449 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(SessionImpl.java:2880) - Collection found:
[com.ko.na.ccrrc.hibernate.TUser.contacts#ln10 at na.ko.com],
was:
[com.ko.na.ccrrc.hibernate.TUser.contacts#ln10 at na.ko.com]
[3/10/05 16:52:45:450 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(SessionImpl.java:2776) - Processing unreferenced
collections
[3/10/05 16:52:45:511 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(SessionImpl.java:2790) - Scheduling collection
removes/(re)creates/updates
[3/10/05 16:52:45:512 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(SessionImpl.java:2266) - Flushed: 0 insertions, 1
updates, 0 deletions to 1 objects
[3/10/05 16:52:45:513 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(SessionImpl.java:2271) - Flushed: 0 (re)creations, 0
updates, 0 removals to 3 collections
[3/10/05 16:52:45:516 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8] (Printer.java:75)
- listing entities:
[3/10/05 16:52:45:518 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8] (Printer.java:82)
- com.ko.na.ccrrc.hibernate.TUser{lastUpdTs=10 March
2005 16:52:45, userId=ln10 at na.ko.com, userNm=ln10
fn10NOTRANS HIBERNATE UPDATE, contacts=uninitialized,
tripSizes=uninitialized, surveys=uninitialized}
[3/10/05 16:52:45:519 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(SessionImpl.java:2355) - executing flush
[3/10/05 16:52:45:520 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(EntityPersister.java:648) - Updating entity:
[com.ko.na.ccrrc.hibernate.TUser#ln10 at na.ko.com]
[3/10/05 16:52:45:521 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(BatcherImpl.java:196) - about to open: 0 open
PreparedStatements, 0 open ResultSets
[3/10/05 16:52:45:523 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(BatcherImpl.java:237) - update T_USER set USER_NM=?,
LAST_UPD_TS=? where USER_ID=?
[3/10/05 16:52:45:523 EST] 46d70537 SystemOut U
Hibernate: update T_USER set USER_NM=?, LAST_UPD_TS=?
where USER_ID=?
[3/10/05 16:52:45:524 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(BatcherImpl.java:241) - preparing statement
[3/10/05 16:52:45:526 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(EntityPersister.java:388) - Dehydrating entity:
[com.ko.na.ccrrc.hibernate.TUser#ln10 at na.ko.com]
[3/10/05 16:52:45:527 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(NullableType.java:46) - binding 'ln10 fn10NOTRANS
HIBERNATE UPDATE' to parameter: 1
[3/10/05 16:52:45:529 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(NullableType.java:46) - binding '10 March 2005
16:52:45' to parameter: 2
[3/10/05 16:52:45:530 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(NullableType.java:46) - binding 'ln10 at na.ko.com' to
parameter: 3
[3/10/05 16:52:45:531 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(BatchingBatcher.java:28) - Adding to batch
[3/10/05 16:52:45:533 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(BatchingBatcher.java:50) - Executing batch size: 1
[3/10/05 16:52:45:551 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(BatchingBatcher.java:58) - success of batch update
unknown: 0
[3/10/05 16:52:45:555 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(BatcherImpl.java:203) - done closing: 0 open
PreparedStatements, 0 open ResultSets
[3/10/05 16:52:45:556 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(BatcherImpl.java:261) - closing statement
[3/10/05 16:52:45:580 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(JDBCExceptionReporter.java:36) - 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:2498)
at
com.ibm.ejs.cm.cache.CachedStatement.clearParameters(CachedStatement.java:447)
at
com.ibm.ejs.cm.cache.StatementCache.releaseStatement(StatementCache.java:193)
at
com.ibm.ejs.cm.cache.CachedStatement.close(CachedStatement.java:53)
at
com.ibm.ejs.cm.proxy.StatementProxy.reallyClose(StatementProxy.java:153)
at
com.ibm.ejs.cm.proxy.StatementProxy.close(StatementProxy.java:93)
at
net.sf.hibernate.impl.BatcherImpl.closePreparedStatement(BatcherImpl.java:262)
at
net.sf.hibernate.impl.BatcherImpl.closeStatement(BatcherImpl.java:136)
at
net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:125)
at
net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2417)
at
net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2368)
at
net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2236)
at
com.ko.na.ccrrc.dao.CcrrcDao.checkUserWithoutHibernateTransaction(CcrrcDao.java:423)
at
com.ko.na.ccrrc.dao.CcrrcDao.checkUser(CcrrcDao.java:143)
at
com.ko.na.ccrrc.interfaces.CcrrcDataAccessDelegate.checkUser(CcrrcDataAccessDelegate.java:43)
at
com.ko.na.ccrrc.action.LogonAction.execute(LogonAction.java:115)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:465)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:523)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at
com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled
Code))
at
com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled
Code))
at
com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[3/10/05 16:52:45:582 EST] 46d70537 SystemOut U
WARN [Servlet.Engine.Transports:8]
(JDBCExceptionReporter.java:38) - SQL Error: 17089,
SQLState: null
[3/10/05 16:52:45:583 EST] 46d70537 SystemOut U
ERROR [Servlet.Engine.Transports:8]
(JDBCExceptionReporter.java:46) - internal error
[3/10/05 16:52:45:588 EST] 46d70537 SystemOut U
DEBUG [Servlet.Engine.Transports:8]
(JDBCExceptionReporter.java:36) - 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:2498)
at
com.ibm.ejs.cm.cache.CachedStatement.clearParameters(CachedStatement.java:447)
at
com.ibm.ejs.cm.cache.StatementCache.releaseStatement(StatementCache.java:193)
at
com.ibm.ejs.cm.cache.CachedStatement.close(CachedStatement.java:53)
at
com.ibm.ejs.cm.proxy.StatementProxy.reallyClose(StatementProxy.java:153)
at
com.ibm.ejs.cm.proxy.StatementProxy.close(StatementProxy.java:93)
at
net.sf.hibernate.impl.BatcherImpl.closePreparedStatement(BatcherImpl.java:262)
at
net.sf.hibernate.impl.BatcherImpl.closeStatement(BatcherImpl.java:136)
at
net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:125)
at
net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2417)
at
net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2368)
at
net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2236)
at
com.ko.na.ccrrc.dao.CcrrcDao.checkUserWithoutHibernateTransaction(CcrrcDao.java:423)
at
com.ko.na.ccrrc.dao.CcrrcDao.checkUser(CcrrcDao.java:143)
at
com.ko.na.ccrrc.interfaces.CcrrcDataAccessDelegate.checkUser(CcrrcDataAccessDelegate.java:43)
at
com.ko.na.ccrrc.action.LogonAction.execute(LogonAction.java:115)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:465)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:523)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at
com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled
Code))
at
com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled
Code))
at
com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[3/10/05 16:52:45:589 EST] 46d70537 SystemOut U
WARN [Servlet.Engine.Transports:8]
(JDBCExceptionReporter.java:38) - SQL Error: 17089,
SQLState: null
[3/10/05 16:52:45:610 EST] 46d70537 SystemOut U
ERROR [Servlet.Engine.Transports:8]
(JDBCExceptionReporter.java:46) - internal error
[3/10/05 16:52:45:615 EST] 46d70537 SystemOut U
ERROR [Servlet.Engine.Transports:8]
(JDBCException.java:38) - Could not execute JDBC batch
update
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:2498)
at
com.ibm.ejs.cm.cache.CachedStatement.clearParameters(CachedStatement.java:447)
at
com.ibm.ejs.cm.cache.StatementCache.releaseStatement(StatementCache.java:193)
at
com.ibm.ejs.cm.cache.CachedStatement.close(CachedStatement.java:53)
at
com.ibm.ejs.cm.proxy.StatementProxy.reallyClose(StatementProxy.java:153)
at
com.ibm.ejs.cm.proxy.StatementProxy.close(StatementProxy.java:93)
at
net.sf.hibernate.impl.BatcherImpl.closePreparedStatement(BatcherImpl.java:262)
at
net.sf.hibernate.impl.BatcherImpl.closeStatement(BatcherImpl.java:136)
at
net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:125)
at
net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2417)
at
net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2368)
at
net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2236)
at
com.ko.na.ccrrc.dao.CcrrcDao.checkUserWithoutHibernateTransaction(CcrrcDao.java:423)
at
com.ko.na.ccrrc.dao.CcrrcDao.checkUser(CcrrcDao.java:143)
at
com.ko.na.ccrrc.interfaces.CcrrcDataAccessDelegate.checkUser(CcrrcDataAccessDelegate.java:43)
at
com.ko.na.ccrrc.action.LogonAction.execute(LogonAction.java:115)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:465)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:523)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at
com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled
Code))
at
com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled
Code))
at
com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
[3/10/05 16:52:45:622 EST] 46d70537 SystemOut U
ERROR [Servlet.Engine.Transports:8]
(SessionImpl.java:2375) - Could not synchronize
database state with session
net.sf.hibernate.JDBCException: Could not execute JDBC
batch update
at
net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:129)
at
net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2417)
at
net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2368)
at
net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2236)
at
com.ko.na.ccrrc.dao.CcrrcDao.checkUserWithoutHibernateTransaction(CcrrcDao.java:423)
at
com.ko.na.ccrrc.dao.CcrrcDao.checkUser(CcrrcDao.java:143)
at
com.ko.na.ccrrc.interfaces.CcrrcDataAccessDelegate.checkUser(CcrrcDataAccessDelegate.java:43)
at
com.ko.na.ccrrc.action.LogonAction.execute(LogonAction.java:115)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:465)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:523)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:721)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:374)
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:118)
at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:317)
at
com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled
Code))
at
com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled
Code))
at
com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)
Caused by:
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:2498)
at
com.ibm.ejs.cm.cache.CachedStatement.clearParameters(CachedStatement.java:447)
at
com.ibm.ejs.cm.cache.StatementCache.releaseStatement(StatementCache.java:193)
at
com.ibm.ejs.cm.cache.CachedStatement.close(CachedStatement.java:53)
at
com.ibm.ejs.cm.proxy.StatementProxy.reallyClose(StatementProxy.java:153)
at
com.ibm.ejs.cm.proxy.StatementProxy.close(StatementProxy.java:93)
at
net.sf.hibernate.impl.BatcherImpl.closePreparedStatement(BatcherImpl.java:262)
at
net.sf.hibernate.impl.BatcherImpl.closeStatement(BatcherImpl.java:136)
at
net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:125)
... 32 more
I am having 2 different environments 1)Development
where everything works fine,even insert and updates
2)Test environment where hibernate select works but
not insert and updates
I really appreciate if any one can reply me.
Thanks
Balu
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
More information about the ajug-members
mailing list