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);
Thanks
Praveen