Support Article
After upgrade DB2 drivers and unable to connect
SA-21263
Summary
User unable to connect to external database after DB2 JDBC driver upgrade. User has replaced new db2jcc4.jar file, modified the required CLASSPATH entries within IBM WebSphere Application Server, stopped all applications, cleared out the temp files and restarted the applications.
Running "Test Connections" on the Database rule failed throwing the ERROR below:
** There was a database problem when performing an RDBExecute: code: -4460 SQLState: <none> Message: [jcc][10150][10300][4.19.26] Invalid parameter: Unknown column name PZPVSTREAM. ERRORCODE=-4460, SQLSTATE=null
Error Messages
Caused by SQL Problems.
Problem #1, SQLState null, Error code -4460: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.19.26] Invalid parameter: Unknown column name PZPVSTREAM. ERRORCODE=-4460, SQLSTATE=null
Steps to Reproduce
1. Navigate to Records > Database.
2. Click “Test Connection”.
Root Cause
A third-party product configuration issue. The above DB2 ErrorCode is thrown, when the DB2 JDBC Datasource does not have the connection property “useJDBC4ColumnNameAndLabelSemantics” set to “2”. When using a DB2 JDBC driver which uses JDBC 4.0 standards, this property must be set for the database query to handle column labels correctly. This has been documented in the PRPC WAS DB2 installation guide.
Resolution
Make the following local-change to the operating environment:
Set the following DB2 JDBC Datasource connection property -
“useJDBC4ColumnNameAndLabelSemantics=2”
For complete instructions refer to section “Configure Data Source Connection” in Page 45 of the Install guide in link below:
https://pdn.pega.com/documents/prpc-716-installation-guide-websphere-db2-luw
Published May 2, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.