Best regards
Mike Savvy
Best regards
Mike Savvy
Best regards
Mike Savvy
D:\JavaDevelopment\Testing\DataBase\db-derby-10.14.2.0-bin>java -cp .;lib\derby.jar SetupDerbyDataBase
Exception in thread "main" java.sql.SQLDataException: The syntax of the string representation of a date/time value is incorrect.
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)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeLargeUpdate(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Source)
at SetupDerbyDataBase.main(SetupDerbyDataBase.java:21)
Caused by: ERROR 22007: The syntax of the string representation of a date/time value is incorrect.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.types.DateTimeParser.parseInt(Unknown Source)
at org.apache.derby.iapi.types.SQLTimestamp.parseDateOrTimestamp(Unknown Source)
at org.apache.derby.iapi.types.SQLTimestamp.parseTimestamp(Unknown Source)
at org.apache.derby.iapi.types.SQLTimestamp.<init>(Unknown Source)
at org.apache.derby.iapi.types.SQLChar.getTimestamp(Unknown Source)
at org.apache.derby.iapi.types.SQLChar.getTimestamp(Unknown Source)
at org.apache.derby.iapi.types.SQLTimestamp.setFrom(Unknown Source)
at org.apache.derby.iapi.types.DataType.setValue(Unknown Source)
at org.apache.derby.iapi.types.DataType.normalize(Unknown Source)
at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeColumn(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
... 5 more
D:\JavaDevelopment\Testing\DataBase\db-derby-10.14.2.0-bin>MORE
Norm Radder wrote:Here is the console I get when I run the code:
Best regards
Mike Savvy
Best regards
Mike Savvy
// Derby supports the following formats for TIMESTAMP: yyyy-mm-dd hh:mm:ss[.nnnnnn]
Best regards
Mike Savvy
bacon. tiny ad:
the value of filler advertising in 2020
https://coderanch.com/t/730886/filler-advertising
|