hello:
What causes the following error?
INFO 2010-11-08 17:30:53,468 [Worker-10] Initializing WebContext #1
INFO 2010-11-08 17:30:53,468 [Worker-10] WebContext #1 initialized in 0 ms.
INFO 2010-11-08 17:30:53,734 [Worker-10] Models loaded in 0 milliseconds
INFO 2010-11-08 17:30:53,734 [Worker-10] Memory delta:19512
INFO 2010-11-08 17:30:54,000 [Worker-10] Handlers loaded in 16 milliseconds
INFO 2010-11-08 17:30:54,000 [Worker-10] Memory delta:2172536
ERROR 2010-11-08 17:30:54,000 [Worker-10] Request ID:20101108-17:30:53:468 [Worker-10]
Failed to execute SQL statementDetails:Statement:CREATE TABLE DB (ID DOUBLE,1 DOUBLE,2 DOUBLE,3 DOUBLE,4 DOUBLE,5 DOUBLE,6 DOUBLE,7 DOUBLE,8 DOUBLE,9 DOUBLE,10 DOUBLE,a DOUBLE,b DOUBLE,c DOUBLE,d DOUBLE,e DOUBLE,f DOUBLE,g DOUBLE,h DOUBLE,i DOUBLE,j DOUBLE, CONSTRAINT DB_PK PRIMARY KEY (ID)) TYPE=InnoDB CHARACTER SET utf8 at tersus.runtime.RuntimeContext.executeUpdate(RuntimeContext.java:231) 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: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:86) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 DOUBLE,2 DOUBLE,3 DOUBLE,4 DOUBLE,5 DOUBLE,6 DOUBLE,7 DOUBLE,8 DOUBLE,9 DOUBLE' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1605) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1524) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at tersus.runtime.RuntimeContext.executeUpdate(RuntimeContext.java:223) ... 19 moreERROR 2010-11-08 17:30:54,000 [Worker-10] Startup failed
Failed to execute SQL statementDetails:Statement:CREATE TABLE DB (ID DOUBLE,1 DOUBLE,2 DOUBLE,3 DOUBLE,4 DOUBLE,5 DOUBLE,6 DOUBLE,7 DOUBLE,8 DOUBLE,9 DOUBLE,10 DOUBLE,a DOUBLE,b DOUBLE,c DOUBLE,d DOUBLE,e DOUBLE,f DOUBLE,g DOUBLE,h DOUBLE,i DOUBLE,j DOUBLE, CONSTRAINT DB_PK PRIMARY KEY (ID)) TYPE=InnoDB CHARACTER SET utf8 at tersus.runtime.RuntimeContext.executeUpdate(RuntimeContext.java:231) 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: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:86) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 DOUBLE,2 DOUBLE,3 DOUBLE,4 DOUBLE,5 DOUBLE,6 DOUBLE,7 DOUBLE,8 DOUBLE,9 DOUBLE' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1605) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1524) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at tersus.runtime.RuntimeContext.executeUpdate(RuntimeContext.java:223) ... 19 moreINFO 2010-11-08 17:30:54,000 [Worker-10] Initializing WebContext #2
INFO 2010-11-08 17:30:54,000 [Worker-10] WebContext #2 initialized in 0 ms.
INFO 2010-11-08 17:30:54,015 [Worker-10] Context destroyed
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign
