using JDBC type BLOB and sql-type LONGVARBINARY work just fine. Either set/getBinaryStream or set/getBytes should do the job. We're using Sybase SQL Anywhere 9 (a pre-release version).
-----Ursprüngliche Nachricht----- Von: Stephen Coy [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 6. August 2003 14:31 An: [EMAIL PROTECTED] Betreff: Re: [JBoss-user] CMP support for blobs broken using Sybase Hi, The current JBoss implementation does the following mapping for JDBC access: Types.CLOB, LONGVARCHAR: use set/getCharacterStream Types.BLOB, LONGVARBINARY use set/getBinaryStream Types.BINARY, VARBINARY use set/getBytes So, you could try setting the JDBC type to LONGVARBINARY. I recently said the following to an Oracle user, and I think it applies to you as well: "In my opinion (knowing what I know now about EJB entity beans), you should not be storing LOBs in your primary entities anyway. Getting the LOB data to your client may result in multiple copies of it being instantiated in memory - and given the nature of LOBs (they can be BIG ;-) ), this may be quite expensive and it won't scale very well. I would either keep the LOB data in separate related tables, or use the same table and hide the LOB columns from the CMP engine by mapping the table to a couple of views. Then use a business facade style of session bean to load the LOB data in whatever fashion you see fit using pure JDBC or even the Oracle extensions. It may even be advantageous to load it directly from the client side using a business delegate and get full and proper advantage of the streaming interfaces. Use the CMP engine to get yourself up and running quickly (you seem to have accomplished that) and then refine it as above and I think your application will be much happier." Regards, Steve Coy On Wednesday, August 6, 2003, at 12:36 AM, Jonathan.O'[EMAIL PROTECTED] wrote: > 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.jav > a: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(SybPreparedStateme > nt.java:1168) > at > com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1621 > ) > at > com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedSta > tement.java:91) > at > org.jboss.resource.adapter.jdbc.local.LocalPreparedStatement.executeUpd > ate(LocalPreparedStatement.java:308) > at > org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.insertEntity(JDB > CCreateEntityCommand.java:196) > at > org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.execute(JDBCCrea > teEntityCommand.java:131) > at > org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreM > anager.java:527) > at > org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistence > Manager.java:253) > at > org.jboss.resource.connectionmanager.CachedConnectionInterceptor.create > Entity(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(DelegatingMethodAccesso > rImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityCon > tainer.java:1119) > at > org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractIntercepto > r.java:73) > at > org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(Entit > ySynchronizationInterceptor.java:207) > at > org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke > Home(CachedConnectionInterceptor.java: > 215) > at > org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractIntercepto > r.java:73) > at > org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstan > ceInterceptor.java:90) > at > org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterc > eptor.java:79) > at > org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreati > onInterceptor.java:44) > at > org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterc > eptor.java:111) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercepto > rCMT.java:228) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java > :62) > at > org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityIntercepto > r.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(BaseLo > calContainerInvoker.java:230) > at > org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:1 > 10) > at $Proxy145.create(Unknown Source) > at > xcom.traxbahn.bproc.ejb.DisputeBcBean.createNewDispute(DisputeBcBean.ja > va:84) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja > va:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso > rImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(Sta > telessSessionContainer.java:660) > at > org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke > (CachedConnectionInterceptor.java:186) > > at > org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(Statel > essSessionInstanceInterceptor.java:77) > > at > org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterc > eptor.java:107) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercepto > rCMT.java:228) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:92) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.ja > va:130) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204) > at > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContaine > r.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:38 > 2) > at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso > rImpl.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.j > ava: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(L > ocalManagedCon > nection.java:282) > 13:14:31,928 ERROR [STDERR] at > org.jboss.resource.connectionmanager.LocalTxConnectionManager$LocalConn > ectionEventLis > 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(TxIntercepto > rCMT.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.ja > va: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(StatelessSessionContaine > r.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:38 > 2) > 13:14:31,928 ERROR [STDERR] at > sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source) > 13:14:31,928 ERROR [STDERR] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso > rImpl.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.j > ava: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 ------------------------------------------------------- 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 This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. ------------------------------------------------------- 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
