Has anyone ever tried sending a BINARY data of about 145k to the database and succeed. I am using JDBC 2.0 Connection pooling and when i try to send a data bigger than 32K i get an CLI0102E Invalid conversion SQLSTATE-07006. Here is the code i used.Any thoughts. I register the parameter as callStmt.registerOutParameter(2, Types.LONGVARBINARY); //where b is bytes of length 145K callStmt.setObject(2, b, Types.LONGVARBINARY);
well..i declare it as a BLOB. This was working when i was using JDBC 1.0 Driver. But when we upgraded to DB2(FP10) and started using the JDBC 2.0 it stopped working and gives the error mentioned earlier.
I lied. That link just had all the keywords on it. It does not appear to be the error you are reporting. I can't think of anything else. Check out that DB2 support site. Hopefully someone with DB2 experience will see this thread.