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)