[CTJUG Forum] Re: EJB 2.1 Problem with JBoss and MySQL

Paul Gilowey Wed, 24 May 2006 23:46:29 -0700

Hi Fritz

<rant>

Lisa will problebly flame me for this ;) but scheeesh, why can't JBoss give more helpful error messages??? We often get weird error messages.

</rant>

Just on a cursory look, doesn't it seem as though there's something wrong with the brackets in the SQL statement?

Souldn't this

CREATE TABLE TEST (id INTEGER, randomField VARCHAR(256), CONSTRAINT PK_TEST PRIMARY KEY ()

be this

CREATE TABLE TEST (id INTEGER, randomField VARCHAR(256), CONSTRAINT PK_TEST PRIMARY KEY ())

Paul

>>> [EMAIL PROTECTED] 05/23/06 11:28 PM >>>

Hi,

I have a problem with an EJB 2.1 project I am working on at the moment; it seems that JBoss is not generating the correct SQL statement to create tables in the MySQL database that I am running. JBoss generated the output below on deployment. Has anyone encountered anything like this before? I have an idea that the problem with the SQL statement might be that JBoss is trying to use syntax intended for a different database (most probably the default HypersonicSQL db) but I can't spot anywhere in the config files a reason why it would be doing that.

Alternatively, someone else in my class mentioned that he had problems whenever constraints were involved, so could that be the problem?

Running MySQL 4.1.7 and JBoss 4.04GA

Output follows:

23:09:55,807 INFO [EARDeployer] Init J2EE application: file:/C:/jboss-4.0.4.GA/server/default/deploy/Fibo.ear
23:09:56,260 INFO [EjbModule] Deploying Test
23:09:56,276 INFO [EjbModule] Deploying Fibo
23:09:56,338 INFO [EntityInstancePool] Registration is not done -> stop
23:09:56,463 INFO [StatelessSessionInstancePool] Registration is not done -> stop
23:09:56,588 INFO [ProxyFactory] Bound EJB Home 'Test' to jndi 'ejb/Test'
23:09:56,635 INFO [ProxyFactory] Bound EJB Home 'Fibo' to jndi 'ejb/Fibo'
23:09:56,792 WARN [ServiceController] Problem starting service jboss.j2ee:service=EjbModule,module=FiboEJB.jar
org.jboss.deployment.DeploymentException : Error while creating table TEST; - nested throwable: (java.sql.SQLException: Unexpected token: ) in statement [CREATE TABLE TEST (id INTEGER, randomField VARCHAR(256), CONSTRAINT PK_TEST PRIMARY KEY ()])
   at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable (JDBCStartCommand.java:613)
   at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:210)
   at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:499)
   at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:396)
   at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:172)
   at org.jboss.ejb.EntityContainer.startPmAndInterceptors (EntityContainer.java:1063)
   at org.jboss.ejb.EjbModule.startService(EjbModule.java:422)
   at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
   at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle (ServiceMBeanSupport.java:245)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
   at org.jboss.mx.server.Invocation.dispatch (Invocation.java:94)
   at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
   at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
   at org.jboss.mx.server.MBeanServerImpl.invoke (MBeanServerImpl.java:659)
   at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
   at $Proxy0.start(Unknown Source)
   at org.jboss.system.ServiceController.start(ServiceController.java :417)
   at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java :585)
   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
   at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
   at org.jboss.mx.server.Invocation.invoke(Invocation.java :86)
   at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
   at org.jboss.mx.util.MBeanProxyExt.invoke (MBeanProxyExt.java:210)
   at $Proxy33.start(Unknown Source)
   at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:662)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)
   at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
   at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
   at org.jboss.mx.server.Invocation.invoke (Invocation.java:88)
   at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
   at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)
   at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)
   at org.jboss.ws.server.WebServiceDeployer.start(WebServiceDeployer.java:117)
   at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start (SubDeployerInterceptorSupport.java:188)
   at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)
   at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
   at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)
   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
   at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
   at $Proxy34.start(Unknown Source)
   at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1007)
   at org.jboss.deployment.MainDeployer.start(MainDeployer.java:997)
   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:808)
   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:771)
   at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java :25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
   at org.jboss.mx.server.Invocation.dispatch(Invocation.java :94)
   at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
   at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
   at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke (ModelMBeanOperationInterceptor.java:142)
   at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
   at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
   at org.jboss.mx.server.MBeanServerImpl.invoke (MBeanServerImpl.java:659)
   at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
   at $Proxy6.deploy(Unknown Source)
   at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java :421)
   at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
   at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
   at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:274)
   at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java :225)
Caused by: java.sql.SQLException: Unexpected token: ) in statement [CREATE TABLE TEST (id INTEGER, randomField VARCHAR(256), CONSTRAINT PK_TEST PRIMARY KEY ()]
   at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
   at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
   at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
   at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java :184)
   at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:600)
   ... 72 more

Regards,
Fritz

SANTAM Bpk / Ltd
Reg. No. 1918/001680/06

Directors: DK Smith (Chairman), SC Gilbert (Chief Executive), S Bray (Company Secretary), JJ Geldenhuys, JG le Roux, Dr NM Magau, AR Martin, Mr EA Moolla, JE Newbury, P de V Rademeyer, GE Rudman, Dr J van Zyl, BP Vundla, (Executive) MJ Reyneke

Please note: This email and its content are subject to the disclaimer as displayed at the following link http://www.santam.co.za/disclaimer.htm. Should you not have Web access, send a mail to [EMAIL PROTECTED] and a copy will be emailed to you.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CTJUG Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/CTJUG-Forum
For the ctjug home page see http://www.ctjug.org.za
-~----------~----~----~----~------~----~------~--~---

[CTJUG Forum] Re: EJB 2.1 Problem with JBoss and MySQL

Reply via email to