Troubleshooting
Problem
Applications that implement the Java™ Persistence API (JPA) and are configured to run static Structured Query Language (SQL) can experience various exceptions. These exceptions might occur with the wsdb2gen command, which you can use to prepare the application, or when the application is running and calls a JPA method.
Symptom
You might receive any of the following exceptions:
- SQLException sqlcode -516 reported from PureQuery run time for SQLs run statically for IBM i (formerly i5/OS and iSeries)
- SQLException sqlcode -270 occurs when using the RowChangeTimestamp version strategy and a DB2 z/OS database.
- DataRuntimeException or ClassCastException occurs when running SQL.
Environment
You have a JPA application that uses the static SQL option.
Resolving The Problem
To resolve this issue:
- Install the program temporary fixes (PTF) for the iSeries JDBC Driver V5R4. Install PTF numbers SI32561 and SI32562. You can find the PTFs through the IBM System i Support : PTF Cover Letters Web site.
If you use DB2 Universal Database for iSeries V6R1, visit the following web site: - Install the required level of PureQuery, which is Version 1.3.100 or later. For more information, see the IBM Data Studio pureQuery Runtime Web site.
- Install the latest JCC drivers, which is Version 3.52.95 or later, with the fix for APAR PK65069. The latest JCC drivers are part of the IBM DB2 software package.
- For DB2 on a z/OS server, install PTF UK39204 for the V8 alternate driver or PTF UK39205 for V9, and install the fix for APAR PK67706. Visit the following sites to obtain the DB2 updates:
Related Information
[{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"DB Connections\/Connection Pooling","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.0","Edition":"Base;Network Deployment","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21317999