Inconsistent CMP
imhungry Sep 4, 2001 7:17 AMMy cmp bean is a bit crazy after the update executes it cannot load again, could any one help?
Retrieving for the First time
[JAWS] Load command executing: SELECT leaveRecord,status,commencementDate,name FROM LeaveRecord WHERE name=? [JAWS] Set parameter: idx=1, jdbcType=VARCHAR, value=A [JAWS] Got a oracle.sql.BLOB: 'oracle.sql.BLOB@3ec2dd' while looking for a ecbeans.leave.LeaveRecord [JAWS] Store command executing: UPDATE LeaveRecord SET leaveRecord=?,status=?,commencementDate=?,name=? WHERE name=? [JAWS] Set parameter: idx=1, jdbcType=JAVA_OBJECT, value=ecbeans.leave.EcquariaLeaveRecord:name=A [JAWS] Set parameter: idx=2, jdbcType=INTEGER, value=0 [JAWS] Set parameter: idx=3, jdbcType=DATE, value=2001-01-01 [JAWS] Set parameter: idx=4, jdbcType=VARCHAR, value=A [JAWS] Set parameter: idx=5, jdbcType=VARCHAR, value=A
Retrieving for the second time
[JAWS] Exists command executing: SELECT COUNT(*) FROM LeaveRecord WHERE name=? [JAWS] Set parameter: idx=1, jdbcType=VARCHAR, value=A [LeaveRecord] Activated bean LeaveRecord with id = A [JAWS] Load command executing: SELECT leaveRecord,status,commencementDate,name FROM LeaveRecord WHERE name=? [JAWS] Set parameter: idx=1, jdbcType=VARCHAR, value=A [LeaveRecord] Copying:null [JAWS] Store command executing: UPDATE LeaveRecord SET leaveRecord=?,status=?,commencementDate=?,name=? WHERE name=? [JAWS] Set parameter: idx=1, jdbcType=JAVA_OBJECT, value=NULL [JAWS] java.sql.SQLException: Invalid column type [JAWS] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114) [JAWS] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156) [JAWS] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:219) [JAWS] at oracle.jdbc.driver.OracleStatement.get_internal_type(OracleStatement.java:4027) [JAWS] at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:913) [JAWS] at org.opentools.minerva.jdbc.PreparedStatementInPool.setNull(PreparedStatementInPool.java:92) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBCCommand.java:280) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCStoreEntityCommand.setParameters(JDBCStoreEntityCommand.java:134) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:159) [JAWS] at org.jboss.ejb.plugins.jaws.jdbc.JDBCStoreEntityCommand.execute(JDBCStoreEntityCommand.java:97) [JAWS] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.storeEntity(JAWSPersistenceManager.java:156) [JAWS] at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPersistenceManager.java:401) [JAWS] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor$InstanceSynchronization.beforeCompletion(EntitySynchronizationInterceptor.java:342) [JAWS] at org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1228) [JAWS] at org.jboss.tm.TxCapsule.commit(TxCapsule.java:322) [JAWS] at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:318) [JAWS] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99) [JAWS] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:190) [JAWS] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195) [JAWS] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:271) [JAWS] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:482) [JAWS] at org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(StatelessSessionProxy.java:152) [JAWS] at $Proxy21.getLeaveRecord(Unknown Source) [JAWS] at ecbeans.leave.servlet.MaintainLeaveRecordServlet.doRetrieve(MaintainLeaveRecordServlet.java:153) [JAWS] at ecbeans.leave.servlet.MaintainLeaveRecordServlet.doGet(MaintainLeaveRecordServlet.java:55) [JAWS] at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) [JAWS] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) [JAWS] at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) [JAWS] at org.apache.tomcat.core.Handler.service(Handler.java:286) [JAWS] at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) [JAWS] at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797) [JAWS] at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) [JAWS] at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210) [JAWS] at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) [JAWS] at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498) [JAWS] at java.lang.Thread.run(Thread.java:484)