Here is the following : | [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.SupplierDiscountSession] Created table 'SUPPLIERDISCOUNTSESSION' successfully. | 2004-05-19 12:06:42,578 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.CustomerDiscountSession] Created table 'CUSTOMERDISCOUNTSESSION' successfully. | 2004-05-19 12:06:42,593 INFO [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.CustomerCommand] Table 'CUSTOMERCOMMAND' already exists | 2004-05-19 12:06:42,656 ERROR [org.jboss.ejb.EntityContainer] Starting failed | org.jboss.deployment.DeploymentException: Error while creating table SUPPLIERTYPE; - nested throwable: (java.sql.SQLException: Unexpected token: ; in statement [CREATE TABLE SUPPLIERTYPE (supplierTypeId INTEGER NOT NULL, name VARCHAR(10);, CONSTRAINT PK_SUPPLIERTYPE PRIMARY KEY (supplierTypeId))]) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:232) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:93) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:484) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:388) | at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:152) | at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:342) | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192) | at sun.reflect.GeneratedMethodAccessor29.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976) | at $Proxy14.start(Unknown Source) | at org.jboss.system.ServiceController.start(ServiceController.java:394) | at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy31.start(Unknown Source) | at org.jboss.ejb.EjbModule.startService(EjbModule.java:331) | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192) | at sun.reflect.GeneratedMethodAccessor29.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976) | at $Proxy14.start(Unknown Source) | at org.jboss.system.ServiceController.start(ServiceController.java:394) | at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy12.start(Unknown Source) | at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:544) | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605) | at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy6.deploy(Unknown Source) | at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302) | at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476) | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201) | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:212) | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:191) | Caused by: java.sql.SQLException: Unexpected token: ; in statement [CREATE TABLE SUPPLIERTYPE (supplierTypeId INTEGER NOT NULL, name VARCHAR(10);, CONSTRAINT PK_SUPPLIERTYPE PRIMARY KEY (supplierTypeId))] | at org.hsqldb.Trace.getError(Unknown Source) | at org.hsqldb.jdbcResultSet.<init>(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.executeUpdate(Unknown Source) | at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:262) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:219) | ... 54 more | 2004-05-19 12:06:42,671 WARN [org.jboss.system.ServiceController] Problem starting service jboss.j2ee:jndiName=Product,service=EJB | org.jboss.deployment.DeploymentException: Error while creating table SUPPLIERTYPE; - nested throwable: (java.sql.SQLException: Unexpected token: ; in statement [CREATE TABLE SUPPLIERTYPE (supplierTypeId INTEGER NOT NULL, name VARCHAR(10);, CONSTRAINT PK_SUPPLIERTYPE PRIMARY KEY (supplierTypeId))]) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:232) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:93) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:484) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:388) | at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:152) | at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:342) | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192) | at sun.reflect.GeneratedMethodAccessor29.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976) | at $Proxy14.start(Unknown Source) | at org.jboss.system.ServiceController.start(ServiceController.java:394) | at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy31.start(Unknown Source) | at org.jboss.ejb.EjbModule.startService(EjbModule.java:331) | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192) | at sun.reflect.GeneratedMethodAccessor29.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976) | at $Proxy14.start(Unknown Source) | at org.jboss.system.ServiceController.start(ServiceController.java:394) | at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy12.start(Unknown Source) | at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:544) | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642) | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605) | at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) | at java.lang.reflect.Method.invoke(Method.java:324) | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) | at $Proxy6.deploy(Unknown Source) | at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302) | at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476) | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201) | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:212) | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:191) | Caused by: java.sql.SQLException: Unexpected token: ; in statement [CREATE TABLE SUPPLIERTYPE (supplierTypeId INTEGER NOT NULL, name VARCHAR(10);, CONSTRAINT PK_SUPPLIERTYPE PRIMARY KEY (supplierTypeId))] | at org.hsqldb.Trace.getError(Unknown Source) | at org.hsqldb.jdbcResultSet.<init>(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.executeUpdate(Unknown Source) | at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:262) | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:219) | ... 54 more | 2004-05-19 12:06:42,671 INFO [org.jboss.ejb.EjbModule] Started jboss.j2ee:module=jstockEJB.jar,service=EjbModule | 2004-05-19 12:06:42,671 INFO [org.jboss.ejb.EJBDeployer] Deployed: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jstockEJB.jar | 2004-05-19 12:06:42,953 INFO [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/Utilitaires/App-Server/jboss-3.2.3/server/default/deploy/jstockEJB.jar | 2004-05-19 12:06:42,953 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()' | Cause: Incomplete Deployment listing: | Packages waiting for a deployer: | <none> | Incompletely deployed packages: | <none> | MBeans waiting for classes: | <none> | MBeans waiting for other MBeans: | [ObjectName: jboss.j2ee:jndiName=Product,service=EJB | state: FAILED | I Depend On: | Depends On Me: org.jboss.deployment.DeploymentException: Error while creating table SUPPLIERTYPE; - nested throwable: (java.sql.SQLException: Unexpected token: ; in statement [CREATE TABLE SUPPLIERTYPE (supplierTypeId INTEGER NOT NULL, name VARCHAR(10);, CONSTRAINT PK_SUPPLIERTYPE PRIMARY KEY (supplierTypeId))])] |
Well, it seems that it puts an ";" where it shouldn't. Anyone has an idea about that ? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835472#3835472 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835472 ------------------------------------------------------- This SF.Net email is sponsored by: SourceForge.net Broadband Sign-up now for SourceForge Broadband and get the fastest 6.0/768 connection for only $19.95/mo for the first 3 months! http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
