Crap. I bet the check for a specific Oracle type in the new drivers. I'll switch it back to JAVA_OBJECT for 9i. Can someone please test Oracle 8? If it doesn't work with either one, I'm going to delete the new code.
Does anyone want to work on the real fix for this? I can walk you through what needs to be changed. -dain Stephen Coy wrote: > Initial testing in Oracle 9i was not promising (using the latest driver > (Oracle JDBC Driver version - 9.0.2.0.0): > > 2002-06-18 23:39:05,843 DEBUG > [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.SimpleEJB] > Executing SQL: UPDATE SIMPLE SET booleanPrimitive=?, booleanObject=?, > bytePrimitive=?, byteObject=?, shortPrimitive=?, shortObject=?, > integerPrimitive=?, integerObject=?, longPrimitive=?, longObject=?, > floatPrimitive=?, floatObject=?, doublePrimitive=?, doubleObject=?, > stringValue=?, utilDateValue=?, sqlDateValue=?, timeValue=?, > timestampValue=?, bigDecimalValue=?, byteArrayValue=?, objectValue=? > WHERE id=? > 2002-06-18 23:39:05,848 TRACE > >[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.booleanPrimitive] > > > Set parameter: index=1, jdbcType=BIT, value=true > 2002-06-18 23:39:05,849 TRACE > [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.booleanObject] > > Set parameter: index=2, jdbcType=BIT, value=false > 2002-06-18 23:39:05,849 TRACE > [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.bytePrimitive] > > Set parameter: index=3, jdbcType=TINYINT, value=11 > 2002-06-18 23:39:05,849 TRACE > [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.byteObject] > > Set parameter: index=4, jdbcType=TINYINT, value=22 > 2002-06-18 23:39:05,849 TRACE > >[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.shortPrimitive] > > Set parameter: index=5, jdbcType=SMALLINT, value=33 > 2002-06-18 23:39:05,850 TRACE > [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.shortObject] > > Set parameter: index=6, jdbcType=SMALLINT, value=44 > 2002-06-18 23:39:05,850 TRACE > >[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.integerPrimitive] > > > Set parameter: index=7, jdbcType=INTEGER, value=55 > 2002-06-18 23:39:05,850 TRACE > [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.integerObject] > > Set parameter: index=8, jdbcType=INTEGER, value=66 > 2002-06-18 23:39:05,850 TRACE > [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.longPrimitive] > > Set parameter: index=9, jdbcType=BIGINT, value=77 > 2002-06-18 23:39:05,851 TRACE > [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.longObject] > > Set parameter: index=10, jdbcType=BIGINT, value=88 > 2002-06-18 23:39:05,851 TRACE > >[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.floatPrimitive] > > Set parameter: index=11, jdbcType=REAL, value=11.11 > 2002-06-18 23:39:05,851 TRACE > [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.floatObject] > > Set parameter: index=12, jdbcType=REAL, value=22.22 > 2002-06-18 23:39:05,855 TRACE > >[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.doublePrimitive] > > > Set parameter: index=13, jdbcType=DOUBLE, value=33.33 > 2002-06-18 23:39:05,855 TRACE > [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.doubleObject] > > Set parameter: index=14, jdbcType=DOUBLE, value=44.44 > 2002-06-18 23:39:05,855 TRACE > [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.stringValue] > > Set parameter: index=15, jdbcType=VARCHAR, value=test string value > 2002-06-18 23:39:05,856 TRACE > [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.utilDateValue] > > Set parameter: index=16, jdbcType=TIMESTAMP, value=Thu Jan 01 11:00:01 > EST 1970 > 2002-06-18 23:39:05,856 TRACE > [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.sqlDateValue] > > Set parameter: index=17, jdbcType=DATE, value=1981-05-05 > 2002-06-18 23:39:05,857 TRACE > [org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.timeValue] > > Set parameter: index=18, jdbcType=TIME, value=22:33:44 > 2002-06-18 23:39:05,858 TRACE > >[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.timestampValue] > > Set parameter: index=19, jdbcType=TIMESTAMP, value=1970-01-01 11:00:04.444 > 2002-06-18 23:39:05,858 TRACE > >[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.bigDecimalValue] > > > Set parameter: index=20, jdbcType=DECIMAL, value=12345678 > 2002-06-18 23:39:05,859 TRACE > >[org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCCMP2xFieldBridge.SimpleEJB.byteArrayValue] > > Set parameter: index=21, jdbcType=BLOB, value=[B@2d54c5 > 2002-06-18 23:39:05,861 ERROR [org.jboss.ejb.GlobalTxEntityMap] Store > failed on entity: simple > javax.ejb.EJBException: Store failed; CausedByException is: > org.jboss.ejb.plugins.cmp.jdbc.ByteArrayBlob > at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.execute > (JDBCStoreEntityCommand.java:94) > at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.storeEntity > (JDBCStoreManager.java:586) > at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity > (CMPPersistenceManager.java:458) > at > org.jboss.resource.connectionmanager.CachedConnectionInterceptor.storeEntity( > > CachedConnectionInterceptor.java:388) > at org.jboss.ejb.EntityContainer.storeEntity(EntityContainer.java:698) > at > org.jboss.ejb.GlobalTxEntityMap.syncEntities(GlobalTxEntityMap.java:99) > at > org.jboss.ejb.GlobalTxEntityMap$GlobalTxEntityMapCleanup.beforeCompletion( > GlobalTxEntityMap.java:168) > at org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1331) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:328) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:74) > at org.jboss.tm.TxManager.commit(TxManager.java:138) > at org.jboss.ejb.EnterpriseContext$UserTransactionImpl.commit > (EnterpriseContext.java:439) > at > net.sourceforge.junitejb.EJBTestRunnerBean.setUpEJB(EJBTestRunnerBean.java: > 77) > at > net.sourceforge.junitejb.EJBTestRunnerBean.run(EJBTestRunnerBean.java:40) > at java.lang.reflect.Method.invoke(Native Method) > at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke > (StatelessSessionContainer.java:606) > at > org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke > (CachedConnectionInterceptor.java:186) > at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext > (AbstractTxInterceptor.java:96) > at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext > (AbstractTxInterceptorBMT.java:144) > at > org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:62) > at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke > (StatelessSessionInstanceInterceptor.java:77) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java: > 129) > at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:183) > at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke > (ProxyFactoryFinderInterceptor.java:156) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java: > > 303) > at org.jboss.ejb.Container.invoke(Container.java:687) > at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:321) > at java.lang.reflect.Method.invoke(Native Method) > at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241) > at sun.rmi.transport.Transport$1.run(Transport.java:152) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:148) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java: > 706) > at java.lang.Thread.run(Thread.java:496) > java.lang.ClassCastException: org.jboss.ejb.plugins.cmp.jdbc.ByteArrayBlob > at oracle.jdbc.driver.OraclePreparedStatement.setBlob > (OraclePreparedStatement.java:2056) > at org.jboss.resource.adapter.jdbc.local.LocalPreparedStatement.setBlob > (LocalPreparedStatement.java:680) > at > org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil.setParameter(JDBCUtil.java:220) > at > >org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.setArgumentParameters( > > > JDBCAbstractCMPFieldBridge.java:283) > at > >org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.setInstanceParameters( > > > JDBCAbstractCMPFieldBridge.java:262) > at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.execute > (JDBCStoreEntityCommand.java:85) > at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.storeEntity > (JDBCStoreManager.java:586) > at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity > (CMPPersistenceManager.java:458) > at > org.jboss.resource.connectionmanager.CachedConnectionInterceptor.storeEntity( > > CachedConnectionInterceptor.java:388) > at org.jboss.ejb.EntityContainer.storeEntity(EntityContainer.java:698) > at > org.jboss.ejb.GlobalTxEntityMap.syncEntities(GlobalTxEntityMap.java:99) > at > org.jboss.ejb.GlobalTxEntityMap$GlobalTxEntityMapCleanup.beforeCompletion( > GlobalTxEntityMap.java:168) > at org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1331) > at org.jboss.tm.TxCapsule.commit(TxCapsule.java:328) > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:74) > at org.jboss.tm.TxManager.commit(TxManager.java:138) > at org.jboss.ejb.EnterpriseContext$UserTransactionImpl.commit > (EnterpriseContext.java:439) > at > net.sourceforge.junitejb.EJBTestRunnerBean.setUpEJB(EJBTestRunnerBean.java: > 77) > at > net.sourceforge.junitejb.EJBTestRunnerBean.run(EJBTestRunnerBean.java:40) > at java.lang.reflect.Method.invoke(Native Method) > at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke > (StatelessSessionContainer.java:606) > at > org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke > (CachedConnectionInterceptor.java:186) > at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext > (AbstractTxInterceptor.java:96) > at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext > (AbstractTxInterceptorBMT.java:144) > at > org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:62) > at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke > (StatelessSessionInstanceInterceptor.java:77) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java: > 129) > at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:183) > at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke > (ProxyFactoryFinderInterceptor.java:156) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java: > > 303) > at org.jboss.ejb.Container.invoke(Container.java:687) > at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:321) > at java.lang.reflect.Method.invoke(Native Method) > at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241) > at sun.rmi.transport.Transport$1.run(Transport.java:152) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:148) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:465) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java: > 706) > at java.lang.Thread.run(Thread.java:496) > > One observable difference between this driver and its predecessors is > that java.lang.Byte and java.lang.Short mappings to TINYINT and SMALLINT > now work from PreparedStatement.setObject. These were previously > required to be NUMERIC, otherwise a ClassCastException like the above > would occur. > > > On Sunday, June 16, 2002, at 03:28 PM, Dain Sundstrom wrote: > >> I just committed the code from patch [ 525663 ] CMP and oracle blobs. >> Can some with Oracle check if the code actually works? >> >> The following command will execute a new test I added which has a >> field of every type: >> >> ./build.sh -Dtest=org.jboss.test.cmp2.simple.SimpleUnitTestCase one-test >> >> You'll need to change the datasource and datasource-mapping in the >> src/resources/cmp2/simple/META-INF/jbosscmp-jdbc.xml file. >> >> This won't work perfectly for every database vendor, because some >> vendor's don't support millisecond precise time and nanosecond precise >> timestamp values. The test that is important for blobs is >> testObjectValue. > > > > ---------------------------------------------------------------------------- > > Bringing you mounds of caffeinated joy > >>> http://thinkgeek.com/sf <<< > > _______________________________________________ > Jboss-development mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-development -- xxxxxxxxxxxxxxxxxxxxxxxx Dain Sundstrom Chief Architect JBossCMP JBoss Group, LLC xxxxxxxxxxxxxxxxxxxxxxxx ---------------------------------------------------------------------------- Bringing you mounds of caffeinated joy >>> http://thinkgeek.com/sf <<< _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
