DB2 database is not returning query even though JDBC connection is successful, returns error

user_4108566 0
Viewed 484

I am trying to connect to a DB2 database using JDBC. The JDBC connection is successful, but the moment query is executed, it returns exception. On further analysis, following error is returned:

Error code - -30025 Localized Error message -> ;DSN12015:*:V12R1M502;0600;0002

Checking the error code on IBM docs, it said something about setting APPL COMPAT LEVEL to BIND/REBIND etc which made no sense to me as I am new to SQL like DB2.

I am trying to operate the above on my personal laptop with Windows 10.

Anybody who can guide me around this would be a great help !

Same error (404) is returned when the same is run Eclipse in server using Tomcat.

db2-zos db2 jdbc websphere tomcat
1 Answers

Check out the IBM Knowledge Center for DB2 error code -30025 for more information. Looking over the help text in the Database administrator response section (since your identifier is in the format product-identifier:*:package-applcompat-value and it looks like you are dealing with a reason code 600), it gives you two options:

  1. Upgrade the client or driver. Refer to V12R1Mnnn application compatibility levels.

  2. If it is not yet possible to upgrade the client or driver, bind or rebind the client or driver packages with the APPLCOMPAT value set to V12R1M500 or lower.

Note: This is just a basic summary, please review the entire section on the help text page for additional information.

user_123283170
Related