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
Hi You have a problem bec. as of now VAP does not support CLOB or BLOB I have written my own converter but it still does not work I have a PMR(support)open with IBM but they really have nothing to go on but they are working on it They did send me an efix that did not help the Issue is the JDBC specification where Oracle says they are compliant and IBM says The way Oracle deals with Clobs is not compliant Good luck and if you do figure out how to doit please share it with me Thank you Fred