Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-1411

TestJdbcTypesDerby: java.sql.SQLSyntaxErrorException: TYPE 'DATETIME' does not exist

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 0.4.1
    • Fix Version/s: 0.5.0
    • Component/s: Core Framework
    • Labels:
      None

      Description

      Seeing the below error in TestJdbcTypesDerby.testSQLTypesMapping():

      java.sql.SQLSyntaxErrorException: TYPE 'DATETIME' does not exist.

      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)

      The error is due to 'DATETime' being not a valid SQL datatype in Apache DB per the listing in http://db.apache.org/derby/docs/10.1/ref/crefsqlj31068.html

      Quick fix would be to change that to either 'DATE' or 'Timestamp'.

        Attachments

          Activity

            People

            • Assignee:
              markap14 Mark Payne
              Reporter:
              smarthi Suneel Marthi
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: