[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - JBoss 3.2.8SP1/CMP/SQL TIME & DATETIME

[mailinator]

I migrated an existing JBoss application to mySQL from MSSQL that has a DATETIME activityTime column in a specific table and a CMP EntityBean that uses the java.sql.Time to get and set values from that column.

Now I am getting the following exception:
javax.ejb.CreateException: Could not create entity:java.sql.SQLException: Data truncated for column 'activityTime' at row 1
        at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:339)
        at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:150)
        at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:587)
        at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:226)
        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:282)
        at org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:587)
        at sun.reflect.GeneratedMethodAccessor617.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1080)
        at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:103)
        at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:219)
        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:227)
        at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:103)
        at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:112)
        at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:76)
        at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:43)
        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105)
        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:348)
        at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:159)
        at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:99)
        at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:135)
        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:107)
        at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:492)
        at org.jboss.ejb.Container.invoke(Container.java:743)
        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:362)
        at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:125)
        at $Proxy259.create(Unknown Source)
......


After some Jboss debugging I noticed the following code in the org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil.coerceToSQLType()

      if(value.getClass() == java.util.Date.class)
      {


Since the value in my case is a java.sql.Time and not a Date the if evaluates to false and the value returned by this method is the Time object. Now shouldnt the if use instanceof instead of the == operator since Time is a subclass of Date?

NOTE: I then realized that this code wasnt working in MSSQL. The difference there is that MSSQL was automatically coercing the value to a default Time value.



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3963788#3963788

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3963788