CMP EJB - BLOB - VisualAge - Sybase

[i robot]

Hi all,
I am using IBM Visual 3.5.3.
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

[Ashish Saraf]

What is the data type of the property which maps the BLOB column in the data base?
Try using byte[]
It works at my end
Tell me if this works. should you need sample code write to me
regards,
Ashish Saraf

Originally posted by i robot:
Hi all,
I am using IBM Visual 3.5.3.
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