1 Reply Latest reply on Jan 29, 2003 8:25 AM by Dheeraj

    Inconsistent CMP

    IMHungry Newbie

      My 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)


        • 1. Re: Inconsistent CMP
          Dheeraj Newbie

          Hi

          I have a similar problem. My CMP is absolutely clean. I am using Cactus suite to test and the suite works fine.
          However the CMP is inconsistent. Once a while it add data to the database, which is hsqldb. But it works fine if I debug it. I am using JBoss3.0.4 with Tomcat.

          Does anyone what is happening.

          Cheers

          Dheeraj