aspose file tools*
The moose likes EJB and other Java EE Technologies and the fly likes CMP EJB - BLOB - VisualAge - Sybase Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "CMP EJB - BLOB - VisualAge - Sybase" Watch "CMP EJB - BLOB - VisualAge - Sybase" New topic
Author

CMP EJB - BLOB - VisualAge - Sybase

i robot
Greenhorn

Joined: Sep 05, 2001
Posts: 3
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
Greenhorn

Joined: Sep 08, 2001
Posts: 14
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: CMP EJB - BLOB - VisualAge - Sybase