I have a table (DB2 is the database) that has a Date column. Here is the
definition for the column:
c_since date,
The correspondinig CMP field is a java.sql.Date.
I get the exception below when executing a finder Tx. I'm making the
assumption that the problem is on the Date field. I'm interested in how this
code works so if you can point me to the source so I can become a bit
independent.
Thanks,
- Matt
15:45:55,685 WARN [SystemExceptionInterceptor] CustomerEnt
javax.ejb.TransactionRolledbackLocalException
at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolicy.java:123)
at
org.openejb.transaction.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:80)
at
org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor.java:82)
at org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:228)
at
org.openejb.proxy.EJBMethodInterceptor.intercept(EJBMethodInterceptor.java:129)
at
org.openejb.proxy.EntityEJBLocalObject$$EnhancerByCGLIB$$779ad2e9.getDataBean(<generated>)
at
org.spec.jappserver.corp.customerses.ejb.CustomerSesEJB.getCustomerInfo(CustomerSesEJB.java:150)
at
org.spec.jappserver.corp.customerses.ejb.CustomerSesEJB$$FastClassByCGLIB$$c445ce6f.invoke(<generated>)
at
org.openejb.dispatch.AbstractMethodOperation.invoke(AbstractMethodOperation.java:90)
at org.openejb.slsb.BusinessMethod.execute(BusinessMethod.java:67)
at
org.openejb.dispatch.DispatchInterceptor.invoke(DispatchInterceptor.java:72)
at
org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke(ComponentContextInterceptor.java:56)
at
org.openejb.ConnectionTrackingInterceptor.invoke(ConnectionTrackingInterceptor.java:81)
at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolicy.java:119)
at
org.openejb.transaction.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:80)
at
org.openejb.slsb.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:98)
at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolicy.java:140)
at
org.openejb.transaction.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:80)
at
org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor.java:82)
at org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:228)
at
org.openejb.proxy.EJBMethodInterceptor.intercept(EJBMethodInterceptor.java:129)
at
org.openejb.proxy.SessionEJBObject$$EnhancerByCGLIB$$623dde14.getCustomerInfo(<generated>)
at
org.spec.jappserver.servlet.helper.SpecAction.getCustomerData(SpecAction.java:514)
at
org.spec.jappserver.servlet.helper.SpecServletAction.doHome(SpecServletAction.java:202)
at
org.spec.jappserver.servlet.helper.SpecServletAction.doLogin(SpecServletAction.java:268)
at
org.spec.jappserver.servlet.SpecAppServlet.performTask(SpecAppServlet.java:147)
at
org.spec.jappserver.servlet.SpecAppServlet.doPost(SpecAppServlet.java:111)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
at
org.apache.geronimo.jetty.JettyServletHolder.handle(JettyServletHolder.java:92)
at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:832)
at
org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:171)
at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823)
at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
at
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:623)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
at org.mortbay.http.HttpServer.service(HttpServer.java:954)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)
at
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Caused by: org.tranql.ql.QueryException: Error executing statement: SELECT
C.C_ID, C.C_SINCE, C.C_BALANCE, C.C_CREDIT, C.C_CREDIT_LIMIT, C.C_YTD_PAYMENT,
C.C_PHONE, C.C_ZIP, C.C_COUNTRY, C.C_STATE, C.C_CITY, C.C_STREET2, .C_STREET1,
C.C_CONTACT, C.C_LAST, C.C_FIRST FROM C_CUSTOMER C WHERE C.C_ID = ?
at
org.tranql.sql.jdbc.JDBCQueryCommand.execute(JDBCQueryCommand.java:78)
at
org.tranql.cache.QueryFaultHandler.rowFault(QueryFaultHandler.java:53)
at
org.openejb.entity.cmp.CMPInstanceContext.associate(CMPInstanceContext.java:146)
at
org.apache.geronimo.transaction.context.AbstractTransactionContext.associate(AbstractTransactionContext.java:47)
at
org.apache.geronimo.transaction.context.AbstractTransactionContext.beginInvocation(AbstractTransactionContext.java:85)
at
org.openejb.entity.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:125)
at
org.openejb.entity.cmp.InTxCacheInterceptor.invoke(InTxCacheInterceptor.java:82)
at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolicy.java:119)
... 45 more
Caused by: com.ibm.db2.jcc.b.xd: Invalid data conversion: Wrong result column
type for requested conversion.
at com.ibm.db2.jcc.b.r.O(r.java:1281)
at com.ibm.db2.jcc.b.rc.getBinaryStream(rc.java:918)
at
org.tranql.connector.jdbc.ResultSetHandle.getBinaryStream(ResultSetHandle.java:215)
at org.tranql.sql.jdbc.binding.BlobBinding.getValue(BlobBinding.java:44)
at
org.tranql.sql.jdbc.binding.TypeConverterBinding.getValue(TypeConverterBinding.java:81)
at
org.tranql.sql.jdbc.binding.TypeConverterBinding.getValue(TypeConverterBinding.java:85)
at
org.tranql.sql.jdbc.JDBCQueryCommand.execute(JDBCQueryCommand.java:72)
... 52 more
