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

["Suneel Marthi (JIRA)" <ji...@apache.org>]

Suneel Marthi created NIFI-1411:
-----------------------------------

             Summary: TestJdbcTypesDerby: java.sql.SQLSyntaxErrorException: TYPE 'DATETIME' does not exist
                 Key: NIFI-1411
                 URL: https://issues.apache.org/jira/browse/NIFI-1411
             Project: Apache NiFi
          Issue Type: Bug
          Components: Core Framework
    Affects Versions: 0.4.1
            Reporter: Suneel Marthi
            Priority: Minor
             Fix For: 0.5.0


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 drop DateTime column in the create table SQL. 
 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)