Link to home
Start Free TrialLog in
Avatar of mruff
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.PepareStatement("Update field1 set PdfBlob=? WHERE Id_Job="+jobID);
ps.setBinaryStream(1, bis,(int)file.length());
ps.executeUpdate();
Avatar of Tomas Helgi Johannsson
Tomas Helgi Johannsson
Flag of Iceland image

Hi!

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
Avatar of mruff
mruff

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
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
Avatar of mruff

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
ASKER CERTIFIED SOLUTION
Avatar of Tomas Helgi Johannsson
Tomas Helgi Johannsson
Flag of Iceland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
And the quoted statement should of course be

ps = db2_connection.prepareStatement("Update field1 set PdfBlob=? WHERE Id_Job=?");

Open in new window