[
https://issues.apache.org/jira/browse/NIFI-1411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15107007#comment-15107007
]
ASF GitHub Bot commented on NIFI-1411:
--------------------------------------
GitHub user smarthi opened a pull request:
https://github.com/apache/nifi/pull/177
[NIFI-1411] - TestJdbcTypesDerby: java.sql.SQLSyntaxErrorException: TYPE
'DATETIME' does not exist
... also fixed the other TestJdbcXXX.java classes to use @Rule
TemporaryFolder
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/smarthi/incubator-nifi NIFI-1411
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/nifi/pull/177.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #177
----
commit c3c6b129b1d75a0e8c5a76c94b691519fbcdce70
Author: smarthi <[email protected]>
Date: 2016-01-19T17:00:02Z
[NIFI-1411] - TestJdbcTypesDerby: java.sql.SQLSyntaxErrorException: TYPE
'DATETIME' does not exist
----
> 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 change that to either 'DATE' or 'Timestamp'.
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
