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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 0.4.1
    • 0.5.0
    • Core Framework
    • 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

            markap14 Mark Payne
            smarthi Suneel Marthi
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: