1 Reply Latest reply on Sep 3, 2001 4:16 AM by MrB

    Invalid column

    IMHungry Newbie

      Has anyone seen this problem before and know how to solve it, i m using cmp but i already have on bean with almost the same configuration working fine
      and this is not constant i can create and retrieve without any prob for the first time but the exception surface after i restart jboss.

      [LeaveManager] java.rmi.ServerException: Store failed; nested exception is:
      [LeaveManager] java.sql.SQLException: Invalid column type
      [LeaveManager] java.sql.SQLException: Invalid column type
      [LeaveManager] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:1
      14)
      [LeaveManager] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:1
      56)
      [LeaveManager] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:2
      19)
      [LeaveManager] at oracle.jdbc.driver.OracleStatement.get_internal_type(OracleSt
      atement.java:4027)
      [LeaveManager] at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePrep
      aredStatement.java:913)
      [LeaveManager] at org.opentools.minerva.jdbc.PreparedStatementInPool.setNull(Pr
      eparedStatementInPool.java:92)
      [LeaveManager] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.setParameter(JDBC
      Command.java:280)
      [LeaveManager] at org.jboss.ejb.plugins.jaws.jdbc.JDBCStoreEntityCommand.setPar
      ameters(JDBCStoreEntityCommand.java:134)
      [LeaveManager] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCC
      ommand.java:159)
      [LeaveManager] at org.jboss.ejb.plugins.jaws.jdbc.JDBCStoreEntityCommand.execut
      e(JDBCStoreEntityCommand.java:97)
      [LeaveManager] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.storeEntity
      (JAWSPersistenceManager.java:156)
      [LeaveManager] at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPe
      rsistenceManager.java:401)
      [LeaveManager] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor$Instan
      ceSynchronization.beforeCompletion(EntitySynchronizationInterceptor.java:342)
      [LeaveManager] at org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1228
      )
      [LeaveManager] at org.jboss.tm.TxCapsule.commit(TxCapsule.java:322)
      [LeaveManager] at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76)
      [LeaveManager] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(Tx
      InterceptorCMT.java:318)
      [LeaveManager] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCM
      T.java:99)
      [LeaveManager] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInte
      rceptor.java:190)
      [LeaveManager] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.ja
      va:195)
      [LeaveManager] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessi
      onContainer.java:271)
      [LeaveManager] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke
      (JRMPContainerInvoker.java:482)
      [LeaveManager] at org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.i
      nvoke(StatelessSessionProxy.java:152)
      [LeaveManager] at $Proxy21.getLeaveRecord(Unknown Source)
      [LeaveManager] at ecbeans.leave.servlet.MaintainLeaveRecordServlet.doRetrieve(M
      aintainLeaveRecordServlet.java:122)
      [LeaveManager] at ecbeans.leave.servlet.MaintainLeaveRecordServlet.doGet(Mainta
      inLeaveRecordServlet.java:51)
      [LeaveManager] at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
      [LeaveManager] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      [LeaveManager] at org.apache.tomcat.core.ServletWrapper.doService(ServletWrappe
      r.java:404)
      [LeaveManager] at org.apache.tomcat.core.Handler.service(Handler.java:286)
      [LeaveManager] at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.
      java:372)
      [LeaveManager] at org.apache.tomcat.core.ContextManager.internalService(Context
      Manager.java:797)
      [LeaveManager] at org.apache.tomcat.core.ContextManager.service(ContextManager.
      java:743)
      [LeaveManager] at org.apache.tomcat.service.http.HttpConnectionHandler.processC
      onnection(HttpConnectionHandler.java:210)
      [LeaveManager] at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoi
      nt.java:416)
      [LeaveManager] at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadP
      ool.java:498)
      [LeaveManager] at java.lang.Thread.run(Thread.java:484)
      java.lang.reflect.UndeclaredThrowableException: [EmbeddedTomcat] javax.transacti
      on.RollbackException: Unable to commit, tx=XidImpl [FormatId=257, GlobalId=imhun
      gry//1, BranchQual=] status=STATUS_ROLLEDBACK
      [EmbeddedTomcat] at org.jboss.tm.TxCapsule.commit(TxCapsule.java:368)
      [EmbeddedTomcat] at org.jboss.tm.TransactionImpl.commit(TransactionImpl.j
      ava:76)
      [EmbeddedTomcat] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransac
      tions(TxInterceptorCMT.java:318)
      [EmbeddedTomcat] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInter
      ceptorCMT.java:99)
      [EmbeddedTomcat] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(Secu
      rityInterceptor.java:190)
      [EmbeddedTomcat] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterc
      eptor.java:195)
      [EmbeddedTomcat] at org.jboss.ejb.StatelessSessionContainer.invoke(Statel
      essSessionContainer.java:271)
      [EmbeddedTomcat] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoke
      r.invoke(JRMPContainerInvoker.java:482)
      [EmbeddedTomcat] at org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessio
      nProxy.invoke(StatelessSessionProxy.java:152)
      [EmbeddedTomcat] at $Proxy21.getLeaveRecord(Unknown Source)
      [EmbeddedTomcat] at ecbeans.leave.servlet.MaintainLeaveRecordServlet.doRe
      trieve(MaintainLeaveRecordServlet.java:122)
      [EmbeddedTomcat] at ecbeans.leave.servlet.MaintainLeaveRecordServlet.doGe
      t(MaintainLeaveRecordServlet.java:51)
      [EmbeddedTomcat] at javax.servlet.http.HttpServlet.service(HttpServlet.ja
      va:740)
      [EmbeddedTomcat] at javax.servlet.http.HttpServlet.service(HttpServlet.ja
      va:853)
      [EmbeddedTomcat] at org.apache.tomcat.core.ServletWrapper.doService(Servl
      etWrapper.java:404)
      [EmbeddedTomcat] at org.apache.tomcat.core.Handler.service(Handler.java:2
      86)
      [EmbeddedTomcat] at org.apache.tomcat.core.ServletWrapper.service(Servlet
      Wrapper.java:372)
      [EmbeddedTomcat] at org.apache.tomcat.core.ContextManager.internalService
      (ContextManager.java:797)
      [EmbeddedTomcat] at org.apache.tomcat.core.ContextManager.service(Context
      Manager.java:743)
      [EmbeddedTomcat] at org.apache.tomcat.service.http.HttpConnectionHandler.
      processConnection(HttpConnectionHandler.java:210)
      [EmbeddedTomcat] at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolT
      cpEndpoint.java:416)
      [EmbeddedTomcat] at org.apache.tomcat.util.ThreadPool$ControlRunnable.run
      (ThreadPool.java:498)
      [EmbeddedTomcat] at java.lang.Thread.run(Thread.java:484)