Hi all,
Has anybody passed an BLOB to a database via a CMP
EJB?
I am trying to do this but I appear to be having a little difficulty.
First what Vap Converter should I use for the column in the Schema setup.
I am using Sybase and I have setup a image type column in my table.
Is this the correct type?
I have setup a CMP BLOB field in my Entity.
public java.sql.Blob data_block;
Setup the Simple Schema mapping, using:
Column Logical Name: data_block
Column PhysicalName: data_block
Column Type: BLOB (2048)
Nulls Allowed: yes
Part of Primary key: no
Converter Class: VapBinaryStreamToSerializableObjectConverter
When I run the Entity in the Tesy Client it falls over with the following error:
java.rmi.ServerException: RemoteException occurred in server
thread; nested exception is:
com.ibm.ejs.persistence.EJSPersistenceException: com.ibm.ejs.cm.portability.StaleConnectionException: JZ006: Caught IOException: java.io.IOException: JZ0SM: Unsupported SQL type 2004.; nested exception is:
com.ibm.ejs.cm.portability.StaleConnectionException: JZ006: Caught IOException: java.io.IOException: JZ0SM: Unsupported SQL type 2004.
Any help much appreciated.
Thanks in advance
Steve