Uploaded image for project: 'cTAKES'
  1. cTAKES
  2. CTAKES-281

JdbcCollectionReader throw SQLException on empty input row from external param file

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.1
    • Fix Version/s: 3.2.0
    • Component/s: ctakes-core
    • Labels:
      None

      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)

        Attachments

          Activity

            People

            • Assignee:
              britt.fitch britt fitch
              Reporter:
              britt.fitch britt fitch
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: