Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
0.4.1
-
None
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'.