Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 791
  • Last Modified:

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();
0
mruff
Asked:
mruff
  • 3
  • 2
1 Solution
 
Tomas Helgi JohannssonCommented:
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
0
 
mruffAuthor Commented:
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
0
 
Tomas Helgi JohannssonCommented:
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
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
mruffAuthor Commented:
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
0
 
Tomas Helgi JohannssonCommented:
Hi!

Have you located/found the statement that is causing the error ?
This error is not related to this statement below as the "AND..." does not appear in it.

ps = db2_connection.PepareStatement("Update field1 set PdfBlob=? WHERE Id_Job="+jobID);

The error clearly indicates parsing error in one of your statements. There has been some improvements in parsing between versions of DB2 after v7 but some actions
needed from the programmer if I remembered it correctly.

Regards,
    Tomas Helgi
0
 
CEHJCommented:
And the quoted statement should of course be

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

Open in new window

0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now