INFO 2009-08-04 08:55:14,250 [Worker-5] Initializing WebContext #1
INFO 2009-08-04 08:55:14,250 [Worker-5] WebContext #1 initialized in 0 ms.
INFO 2009-08-04 08:55:14,843 [Worker-5] Models loaded in 0 milliseconds
INFO 2009-08-04 08:55:14,843 [Worker-5] Memory delta:36264
INFO 2009-08-04 08:55:16,343 [Worker-5] Handlers loaded in 859 milliseconds
INFO 2009-08-04 08:55:16,343 [Worker-5] Memory delta:3625360
ERROR 2009-08-04 08:55:16,343 [Worker-5] Request ID:20090804-08:55:14:250 [Worker-5]
Failed to execute SQL statement
Details:
Statement:CREATE TABLE SYSTEM1_ONCALL_DB (Jobname VARCHAR,Critical VARCHAR,Instructions VARCHAR,Work_Group VARCHAR,Primary VARCHAR,Secondary VARCHAR,Manger_1_ VARCHAR,Manager_2 VARCHAR,Phone_Number VARCHAR,Email VARCHAR, CONSTRAINT SYSTEM1_ONCALL_DB_PK PRIMARY KEY (Jobname))
at tersus.runtime.RuntimeContext.executeUpdate(RuntimeContext.java:234)
at tersus.runtime.PersistenceHandler.createTable(PersistenceHandler.java:342)
at tersus.runtime.PersistenceHandler.ensureTableExists(PersistenceHandler.java:283)
at tersus.runtime.CompositeDataHandler.initDB(CompositeDataHandler.java:147)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:163)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:151)
at tersus.runtime.ContextPool.initOrCheckDB(ContextPool.java:262)
at tersus.runtime.ContextPool.startUp(ContextPool.java:216)
at tersus.webapp.ContextPool.contextInitialized(ContextPool.java:198)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at tersus.appserver.ApplicationServer.start(ApplicationServer.java:364)
at tersus.appserver.ui.LaunchApplicationActionDelegate$1.run(LaunchApplicationActionDelegate.java:85)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: java.sql.SQLException: Unexpected token VARCHAR, requires KEY in statement [CREATE TABLE SYSTEM1_ONCALL_DB (Jobname VARCHAR,Critical VARCHAR,Instructions VARCHAR,Work_Group VARCHAR,Primary VARCHAR]
at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at tersus.runtime.RuntimeContext.executeUpdate(RuntimeContext.java:226)
... 27 more
ERROR 2009-08-04 08:55:16,343 [Worker-5] Startup failed
Failed to execute SQL statement
Details:
Statement:CREATE TABLE SYSTEM1_ONCALL_DB (Jobname VARCHAR,Critical VARCHAR,Instructions VARCHAR,Work_Group VARCHAR,Primary VARCHAR,Secondary VARCHAR,Manger_1_ VARCHAR,Manager_2 VARCHAR,Phone_Number VARCHAR,Email VARCHAR, CONSTRAINT SYSTEM1_ONCALL_DB_PK PRIMARY KEY (Jobname))
at tersus.runtime.RuntimeContext.executeUpdate(RuntimeContext.java:234)
at tersus.runtime.PersistenceHandler.createTable(PersistenceHandler.java:342)
at tersus.runtime.PersistenceHandler.ensureTableExists(PersistenceHandler.java:283)
at tersus.runtime.CompositeDataHandler.initDB(CompositeDataHandler.java:147)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:163)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:151)
at tersus.runtime.ContextPool.initOrCheckDB(ContextPool.java:262)
at tersus.runtime.ContextPool.startUp(ContextPool.java:216)
at tersus.webapp.ContextPool.contextInitialized(ContextPool.java:198)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at tersus.appserver.ApplicationServer.start(ApplicationServer.java:364)
at tersus.appserver.ui.LaunchApplicationActionDelegate$1.run(LaunchApplicationActionDelegate.java:85)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: java.sql.SQLException: Unexpected token VARCHAR, requires KEY in statement [CREATE TABLE SYSTEM1_ONCALL_DB (Jobname VARCHAR,Critical VARCHAR,Instructions VARCHAR,Work_Group VARCHAR,Primary VARCHAR]
at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at tersus.runtime.RuntimeContext.executeUpdate(RuntimeContext.java:226)
... 27 more
ERROR 2009-08-04 08:55:16,359 [Worker-5] Startup failed
Failed to execute SQL statement
Details:
Statement:CREATE TABLE SYSTEM1_ONCALL_DB (Jobname VARCHAR,Critical VARCHAR,Instructions VARCHAR,Work_Group VARCHAR,Primary VARCHAR,Secondary VARCHAR,Manger_1_ VARCHAR,Manager_2 VARCHAR,Phone_Number VARCHAR,Email VARCHAR, CONSTRAINT SYSTEM1_ONCALL_DB_PK PRIMARY KEY (Jobname))
at tersus.runtime.RuntimeContext.executeUpdate(RuntimeContext.java:234)
at tersus.runtime.PersistenceHandler.createTable(PersistenceHandler.java:342)
at tersus.runtime.PersistenceHandler.ensureTableExists(PersistenceHandler.java:283)
at tersus.runtime.CompositeDataHandler.initDB(CompositeDataHandler.java:147)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:163)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:167)
at tersus.runtime.PersistenceManager.initDB(PersistenceManager.java:151)
at tersus.runtime.ContextPool.initOrCheckDB(ContextPool.java:262)
at tersus.runtime.ContextPool.startUp(ContextPool.java:216)
at tersus.webapp.ContextPool.contextInitialized(ContextPool.java:198)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at tersus.appserver.ApplicationServer.start(ApplicationServer.java:364)
at tersus.appserver.ui.LaunchApplicationActionDelegate$1.run(LaunchApplicationActionDelegate.java:85)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: java.sql.SQLException: Unexpected token VARCHAR, requires KEY in statement [CREATE TABLE SYSTEM1_ONCALL_DB (Jobname VARCHAR,Critical VARCHAR,Instructions VARCHAR,Work_Group VARCHAR,Primary VARCHAR]
at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at tersus.runtime.RuntimeContext.executeUpdate(RuntimeContext.java:226)
... 27 more
INFO 2009-08-04 08:55:16,359 [Worker-5] Initializing WebContext #2
INFO 2009-08-04 08:55:16,359 [Worker-5] WebContext #2 initialized in 0 ms.
INFO 2009-08-04 08:55:16,468 [Worker-5] Context destroyed
INFO 2009-08-04 08:55:16,468 [Worker-5] Context destroyed
