Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2012
    Posts
    177

    Unanswered: Issue in the db2 tables

    Hi all,

    In our setup db2 V9.7 with fixpack 4

    Having issues in the table level, Trying to insert the records for the table.

    Getting the below error:

    Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][10429][12554][4.12.55] A processing error occurred on the server which resulted in an unrecoverable error.
    Please set deferPrepares property to false and re-establish the connection. If the problem still persists, please contact support. ERRORCODE=-4225, SQLSTATE=24514
    at com.ibm.db2.jcc.am.hd.a(hd.java:679)
    at com.ibm.db2.jcc.am.hd.a(hd.java:60)


    How to set the deferPrepares property to false ?

    Thanks,
    laxman.

  2. #2
    Join Date
    Jan 2009
    Location
    United Kingdom
    Posts
    77
    This link has a good explanation and steps on how to set defereprepares to false. DB2 JDBC Driver Secrets | Zinox

  3. #3
    Join Date
    Sep 2012
    Posts
    177
    Hi Jack,

    Thanks for your reply.

    We tried that option from

    Java program reads this propety file

    user=pdqpot
    password=pdqpot123
    portNumber=50000
    deferPrepares=false

    But again we are getting the same error.

    How to fix this issue?

    Thanks,
    laxman.

  4. #4
    Join Date
    May 2014
    Posts
    1
    Hi,

    as we are getting also the same Error, if it didn't help to set the deferePrepares property to false what did you do to get rid of the Error ? Do you have any insights what caused your problem and how did you solve the Error?

    Thanks
    Fabian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •