Problem inserting Blob data (invalid LO argument )

Dear All, I have IDS 9.4 on Win 2000. I have installed client sdk 2.81, i have also installed Informix JDBC Driver 2.21.JC5. I have a blob table. I could insert data into the table through java. Now i have installed IDS 9.3 on Sun Solaris and when i try to insert data, i get the foll. error - java.sql.SQLException: blob_assign: error during processing or invalid LO argument at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3124) at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3435) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2259) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2179) at com.informix.jdbc.IfxSqli.sendStatementExecute(IfxSqli.java:1178) at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2105) at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2042) at com.informix.jdbc.IfxResultSet.executeExecute(IfxResultSet.java:394) at com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:924) at com.informix.jdbc.IfxPreparedStatement.execute(IfxPreparedStatement.java:301) at InsertBlob.main(InsertBlob.java:57) What could the problem be. Do i need to set some additional parameters. Please advice. Thanks & Regards, Lloyd

Llyod , I looked at code snippet you send , and it looks fine. I am suspecting that you have created a blob space instead of a smart blobspace on your 9.30 engine. You need to use -S (instead of -b , which creates a blob space) option of onspaces to create smart blob space. Verify that you have a smart blob space by looking at third field from 'flags' column of onstat -d output. An 'S' indicates a smart blob space and 'B' indicates a blob space. See the link for ready reference. http://www.oninit.com/database/index.html --- LLOYD <lloyd_s@rediffmail.com> wrote: > Dear All, > > I have IDS 9.4 on Win 2000. I have installed client > sdk 2.81, i have also installed Informix JDBC Driver > 2.21.JC5. I have a blob table. I could insert data > into the table through java. Now i have installed > IDS 9.3 on Sun Solaris and when i try to insert > data, i get the foll. error - > > java.sql.SQLException: blob_assign: error during > processing or invalid LO argument > at > com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3124) > > at > com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3435) > > at > com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2259) > > at > com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2179) > > at > com.informix.jdbc.IfxSqli.sendStatementExecute(IfxSqli.java:1178) > > at > com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2105) > > at > com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2042) > > at > com.informix.jdbc.IfxResultSet.executeExecute(IfxResultSet.java:394) > > at > com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:924) > > at > com.informix.jdbc.IfxPreparedStatement.execute(IfxPreparedStatement.java:301) > > at InsertBlob.main(InsertBlob.java:57) > > > What could the problem be. Do i need to set some > additional parameters. Please advice. > > Thanks & Regards, > > Lloyd > > __________________________________ Do you Yahoo!? Find out what made the Top Yahoo! Searches of 2003 http://search.yahoo.com/top2003