Further migration problems have reared their head. The Sybase JDBC driver
throws an exception when I try to write a blob using CMP. It complains
that SQL Type 1004 is not supported. This is SqlType.BLOB.
On talking to colleagues who have written JDBC code for sybase and blobs,
I have been told that we should use SqlType.BINARY and call
PreparedStatement.setBinaryStream() instead of setBytes().
Whatever, I would like to hear of anybody out there who is using JBoss
(We're on 3.0.6) and Sybase 12.0 to write blobs (IMAGE in Sybase SQL).
Finally, here's the stack trace:
13:14:31,918 ERROR [Dispute] Could not create entity
java.sql.SQLException: JZ006: Caught IOException: java.io.IOException:
JZ0SL: Unsupported SQL type 2004.
at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:526)
at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:762)
at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3160)
at com.sybase.jdbc2.tds.Tds.language(Tds.java:702)
at
com.sybase.jdbc2.jdbc.SybStatement.sendQuery(SybStatement.java:1451)
at
com.sybase.jdbc2.jdbc.SybPreparedStatement.sendQuery(SybPreparedStatement.java:1168)
at
com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1621)
at
com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:91)
at
org.jboss.resource.adapter.jdbc.local.LocalPreparedStatement.executeUpdate(LocalPreparedStatement.java:308)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.insertEntity(JDBCCreateEntityCommand.java:196)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.execute(JDBCCreateEntityCommand.java:131)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:527)
at
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:253)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.jav
a:270)
at
org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:580)
at sun.reflect.GeneratedMethodAccessor40.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:1119)
at
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:73)
at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:207)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:
215)
at
org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:73)
at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:90)
at
org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:79)
at
org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:44)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:111)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:228)
at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:62)
at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:105)
at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:129)
at
org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:487)
at
org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.invokeHome(BaseLocalContainerInvoker.java:230)
at
org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
at $Proxy145.create(Unknown Source)
at
xcom.traxbahn.bproc.ejb.DisputeBcBean.createNewDispute(DisputeBcBean.java:84)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:660)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:77)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:107)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:228)
at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:92)
at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:313)
at org.jboss.ejb.Container.invoke(Container.java:712)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
at
org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:382)
at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:536)
13:14:31,928 ERROR [STDERR] com.sybase.jdbc2.jdbc.SybSQLException: A wrong
datastream has been sent to the server. The s
erver was expecting token 236 but got the token 33. This is an internal
error.
13:14:31,928 ERROR [STDERR] at
com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2672)
13:14:31,928 ERROR [STDERR] at
com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2032)
13:14:31,928 ERROR [STDERR] at
com.sybase.jdbc2.tds.Tds.doCommand(Tds.java:2718)
13:14:31,928 ERROR [STDERR] at
com.sybase.jdbc2.tds.Tds.endTransaction(Tds.java:1586)
13:14:31,928 ERROR [STDERR] at
com.sybase.jdbc2.jdbc.SybConnection.rollback(SybConnection.java:840)
13:14:31,928 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.rollback(LocalManagedCon
nection.java:282)
13:14:31,928 ERROR [STDERR] at
org.jboss.resource.connectionmanager.LocalTxConnectionManager$LocalConnectionEventLis
tener.rollback(LocalTxConnectionManager.java:658)
13:14:31,928 ERROR [STDERR] at
org.jboss.tm.TxCapsule.rollbackResources(TxCapsule.java:1779)
13:14:31,928 ERROR [STDERR] at
org.jboss.tm.TxCapsule.rollback(TxCapsule.java:475)
13:14:31,928 ERROR [STDERR] at
org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:83)
13:14:31,928 ERROR [STDERR] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:241)
13:14:31,928 ERROR [STDERR] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:92)
13:14:31,928 ERROR [STDERR] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
13:14:31,928 ERROR [STDERR] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
13:14:31,928 ERROR [STDERR] at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:313)
13:14:31,928 ERROR [STDERR] at
org.jboss.ejb.Container.invoke(Container.java:712)
13:14:31,928 ERROR [STDERR] at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
13:14:31,928 ERROR [STDERR] at
org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:382)
13:14:31,928 ERROR [STDERR] at
sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)
13:14:31,928 ERROR [STDERR] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
13:14:31,928 ERROR [STDERR] at
java.lang.reflect.Method.invoke(Method.java:324)
13:14:31,928 ERROR [STDERR] at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
13:14:31,928 ERROR [STDERR] at
sun.rmi.transport.Transport$1.run(Transport.java:148)
13:14:31,938 ERROR [STDERR] at
java.security.AccessController.doPrivileged(Native Method)
13:14:31,938 ERROR [STDERR] at
sun.rmi.transport.Transport.serviceCall(Transport.java:144)
13:14:31,938 ERROR [STDERR] at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
13:14:31,938 ERROR [STDERR] at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
13:14:31,938 ERROR [STDERR] at java.lang.Thread.run(Thread.java:536)
Ciao,
Jonathan O'Connor
XCOM Dublin
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
