JDBC test step throws null pointer exception

book

Article ID: 221956

calendar_today

Updated On:

Products

Service Virtualization

Issue/Introduction

There is a JDBC execution step in the test case. When Select query is executed, getting below exception in DevTest 10.6 workstation:

java.lang.NullPointerException
at com.itko.lisa.jdbc.JDBCResultSetCache.getRowData(JDBCResultSetCache.java:75)
at com.itko.lisa.jdbc.JDBCResultSetCache.<init>(JDBCResultSetCache.java:59)
at com.itko.lisa.jdbc.JDBCNode.makeGenericCall(JDBCNode.java:475)
at com.itko.lisa.jdbc.JDBCNode.executeSQL(JDBCNode.java:394)
at com.itko.lisa.jdbc.JDBCNodeEditor.doExec(JDBCNodeEditor.java:483)
at com.itko.lisa.jdbc.JDBCNodeEditor$6.doCallback(JDBCNodeEditor.java:417)
at com.itko.util.swing.panels.ProcessingDialog$2.run(ProcessingDialog.java:195)
at java.lang.Thread.run(Thread.java:748)
 
The query result set has some null values. However, same test is working fine in DevTest 10.3.
So all the JDBC database tests which were running fine using DevTest 10.3, are throwing null pointer exception using DevTest 10.6. 

Cause

Post 10.3 version of DevTest, a regression bug got into the product that caused this Null Pointer Exception.

Environment

Release : 10.4 and above

Component : CA Application Test

Resolution

This bug has been fixed a patch is available. Open a support case and request for patch patch_DE511479_10.6.0_GA.jar.

Steps to Apply:

NOTE: The patch is needed only on Workstation and Simulator machines

1. Exit Workstation/Stop Simulator Service

2. Place the patch file "patch_DE511479_10.6.0_GA.jar" at LISA_HOME/lib/patches folder

3. Add the following entry to LISA_HOME\logging.properties file and save it

      log4j.logger.com.itko.lisa.resultset.ResultSetCacheBase=DEBUG

4. Launch Workstation/Start Simulator Service

5. Repeat the same use case that failed earlier and confirm if the patch resolves the reported problem.