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)
