[CTAKES-281] JdbcCollectionReader throw SQLException on empty input row from external param file

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.1
• Fix Version/s: 3.2.0
• Component/s: ctakes-core
• Assignee: britt fitch
• Reporter: britt fitch
• Created: 25/Jan/14 16:00
• Updated: 24/Apr/14 20:10
• Resolved: 25/Jan/14 16:04

Description

When supplying an external input file for the JdbcCollectionReader if there are blank lines at the end of the input file defined in the xml descriptor for variable 'ValueFileResrcName' the reader will throw SQLException attempting to assign 'null' to input param.

Caused by: java.sql.SQLException: No value specified for parameter 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2612)
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2587)
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2511)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2260)