mruff
asked on
DB2 SQL0727N when inserting BLOB after updating DB2 client from V7 to V8.5
Dear experts,
the following code fragment* worked with DB2 client V7, after upgrading to V8
the following exception is returned
SQL0727N An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE"-10", SQLSTATE"42603" and message tokens "AND RequestID=4352392". SQLSTATE=56098
*
File file = new File(inputFileName);
FileInputStream fis= new FileInputStream(file);
BufferedInputStream bis = new BufferdInputStream(fis);
ps = db2_connection.PepareState ment("Upda te field1 set PdfBlob=? WHERE Id_Job="+jobID);
ps.setBinaryStream(1, bis,(int)file.length());
ps.executeUpdate();
the following code fragment* worked with DB2 client V7, after upgrading to V8
the following exception is returned
SQL0727N An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE"-10", SQLSTATE"42603" and message tokens "AND RequestID=4352392". SQLSTATE=56098
*
File file = new File(inputFileName);
FileInputStream fis= new FileInputStream(file);
BufferedInputStream bis = new BufferdInputStream(fis);
ps = db2_connection.PepareState
ps.setBinaryStream(1, bis,(int)file.length());
ps.executeUpdate();
ASKER
Hi Thomas,
Thank you, the issue must be related to the DB2 client upgrade
The code runs UNCHANGED with a db2 V7 client and NOT with a V8 db2 client set up
Thank you, the issue must be related to the DB2 client upgrade
The code runs UNCHANGED with a db2 V7 client and NOT with a V8 db2 client set up
Hi!
Have you located/found the statement that is causing the error ?
There seems to be some parsing issues with that statement.
Regards,
Tomas Helgi
Have you located/found the statement that is causing the error ?
There seems to be some parsing issues with that statement.
Regards,
Tomas Helgi
ASKER
Hi Thomas,
Unfortunately I do not have the source code.
But as mentioned earlier:
This error arises after upgrading the db2 client from V7 to V8
The code causing the problem DID NOT change so the root cause MUST be related to the db2 client upgrade.
The current code uses a Type 2 DB2 JDBC driver, probably it's worth trying the the Type 4 driver
Unfortunately I do not have the source code.
But as mentioned earlier:
This error arises after upgrading the db2 client from V7 to V8
The code causing the problem DID NOT change so the root cause MUST be related to the db2 client upgrade.
The current code uses a Type 2 DB2 JDBC driver, probably it's worth trying the the Type 4 driver
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
And the quoted statement should of course be
ps = db2_connection.prepareStatement("Update field1 set PdfBlob=? WHERE Id_Job=?");
The sqlcode you are getting is SQLCODE"-10" which means that
"The string constant begining with stringA is not terminated."
In your case the stringA is "AND ...
You need to check your code and the sqlstatement involved and repair/add a string termination in the correct place.
The error doesn't seem to do with the update statement you provided. ;)
Regards,
Tomas Helgi