nifi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (NIFI-1411) TestJdbcTypesDerby: java.sql.SQLSyntaxErrorException: TYPE 'DATETIME' does not exist
Date Thu, 21 Jan 2016 14:32:40 GMT

    [ https://issues.apache.org/jira/browse/NIFI-1411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15110655#comment-15110655
] 

ASF subversion and git services commented on NIFI-1411:
-------------------------------------------------------

Commit e1588d41367287af05ab3b5bd33dc1df80960024 in nifi's branch refs/heads/NIFI-259 from
[~smarthi]
[ https://git-wip-us.apache.org/repos/asf?p=nifi.git;h=e1588d4 ]

[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
>            Assignee: Mark Payne
>            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)

Mime
View raw message