DB Step producing Invalid column type: getString/getNString error while running

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)

Issue/Introduction

We created a "Database execution step" to select data from database. When we execute the step, getting an error as below:

 

java.sql.SQLException: Invalid column type: getString/getNString not implemented for class oracle.jdbc.driver.T4CBlobAccessor at oracle.jdbc.driver.Accessor.unimpl(Accessor.java:288) 

at oracle.jdbc.driver.BlobAccessor.getString(BlobAccessor.java:250) 

at oracle.jdbc.driver.GeneratedStatement.getString(GeneratedStatement.java:327) 

at oracle.jdbc.driver.GeneratedScrollableResultSet.getString(GeneratedScrollableResultSet.java:973) 

at com.itko.lisa.jdbc.JDBCResultSetCache.getRowData(JDBCResultSetCache.java:69) 

at com.itko.lisa.jdbc.JDBCResultSetCache.<init>(JDBCResultSetCache.java:54) 

at com.itko.lisa.jdbc.JDBCNode.makeGenericCall(JDBCNode.java:463) 

at com.itko.lisa.jdbc.JDBCNode.executeSQL(JDBCNode.java:387) 

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:194) 

at java.lang.Thread.run(Unknown Source)

Environment

Database: Oracle 11g Release2 and Release 12c

DevTest 10.7.2 or newer

Cause

 Oracle JDBC Driver 11g Release 2 (11.2) no longer supports getString() method for retrieving BLOB column values using ojdbc7 driver, so to resolve the problem is to not use " select * " and select only none-blob type columns in the select statement.

Resolution

Modified database query in "Database execution step" with required column names (instead of giving * for select query) and run the test case.