Build "distrib" failed: SQLException
eric138 Jul 24, 2003 8:41 AMHello,
I got the most updated source from CVS. But it still has SQLException for the Timestamp in HSQLDB:
assembledb:
[sql] Executing file: D:\Projects\nukes\distrib\output\sql\setup\hsqldb.ddl
[sql] Failed to execute: INSERT INTO nuke_journal_stats (pn_sid,pn_uid,pn_nop,pn_lp,pn_micro) VALUES (1,1,0,'2003-01-20:11:33:19','2003-01-20:11-33-19')
BUILD FAILED
file:D:/Projects/nukes/distrib/build.xml:188: java.sql.SQLException: Wrong data type: Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff in statement [INSERT INTO nuke_journal_stats (pn_sid,pn_uid,pn_nop,pn_lp,pn_micro) VALUES (1,1,0,'2003-01-20:11:33:19','2003-01-20:11-33-19')]
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:406)
at org.apache.tools.ant.Task.perform(Task.java:319)
at org.apache.tools.ant.Target.execute(Target.java:309)
at org.apache.tools.ant.Target.performTasks(Target.java:336)
at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
at org.apache.tools.ant.Project.executeTargets(Project.java:1250)
at org.apache.tools.ant.Main.runBuild(Main.java:610)
at org.apache.tools.ant.Main.start(Main.java:196)
at org.apache.tools.ant.Main.main(Main.java:235)
Caused by: java.sql.SQLException: Wrong data type: Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff in statement [INSERT INTO nuke_journal_stats (pn_sid,pn_uid,pn_nop,pn_lp,pn_micro) VALUES (1,1,0,'2003-01-20:11:33:19','2003-01-20:11-33-19')]
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.jdbcResultSet.(Unknown Source)
at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
at org.hsqldb.jdbcConnection.execute(Unknown Source)
at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbcStatement.execute(Unknown Source)
at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:494)
at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:470)
at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:617)
at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:580)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:382)
... 8 more
--- Nested Exception ---
java.sql.SQLException: Wrong data type: Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff in statement [INSERT INTO nuke_journal_stats (pn_sid,pn_uid,pn_nop,pn_lp,pn_micro) VALUES (1,1,0,'2003-01-20:11:33:19','2003-01-20:11-33-19')]
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.jdbcResultSet.(Unknown Source)
at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
at org.hsqldb.jdbcConnection.execute(Unknown Source)
at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbcStatement.execute(Unknown Source)
at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:494)
at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:470)
at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:617)
at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:580)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:382)
at org.apache.tools.ant.Task.perform(Task.java:319)
at org.apache.tools.ant.Target.execute(Target.java:309)
at org.apache.tools.ant.Target.performTasks(Target.java:336)
at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
at org.apache.tools.ant.Project.executeTargets(Project.java:1250)
at org.apache.tools.ant.Main.runBuild(Main.java:610)
at org.apache.tools.ant.Main.start(Main.java:196)
at org.apache.tools.ant.Main.main(Main.java:235)