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
posted
0
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
0
