[NIFI-1411] TestJdbcTypesDerby: java.sql.SQLSyntaxErrorException: TYPE 'DATETIME' does not exist

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.4.1
• Fix Version/s: 0.5.0
• Component/s: Core Framework
• Assignee: Mark Payne
• Reporter: Suneel Marthi
• Created: 19/Jan/16 16:18
• Updated: 21/Jan/16 14:32
• Resolved: 21/Jan/16 04:10

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'.