Hi,
I've done it (mysql and jboss 3.0 communication)
but...
-1- I can't connect with the user/password I want
though I've added the user/password in mysql.user and
granted all on my db for this user. The only user who
have access is 'root' (without password).
-2- After JBoss created the first SQL table (for the
1st CMP entity bean deployment), I get the following
error:
11:20:37,625 INFO [EjbModule] Creating
11:20:37,655 INFO [EjbModule] Deploying
myrpg-atlas/AdministratorEntity
11:20:38,527 INFO [EjbModule] Deploying
myrpg-atlas/CharacterEntity
11:20:38,547 INFO [EjbModule] Deploying
myrpg-atlas/ConfigurationEntity
11:20:38,567 INFO [EjbModule] Deploying
myrpg-atlas/SequenceEntity
11:20:38,587 INFO [EjbModule] Deploying
myrpg-atlas/UserEntity
11:20:38,617 INFO [EjbModule] Deploying
myrpg-atlas/WorldEntity
11:20:38,647 INFO [EjbModule] Deploying
myrpg-atlas/AdministratorSession
11:20:38,667 INFO [EjbModule] Deploying
myrpg-atlas/Logger
11:20:38,677 INFO [EjbModule] Deploying
myrpg-atlas/SequenceSession
11:20:38,697 INFO [EjbModule] Deploying
myrpg-atlas/UserSession
11:20:42,442 INFO [EjbModule] Created
11:20:42,442 INFO [EjbModule] Starting
11:20:42,492 INFO [myrpg-atlas/AdministratorEntity]
Table 'AdministratorEntity' already exists
11:20:42,612 ERROR [EjbModule] Starting failed
org.jboss.deployment.DeploymentException: Error while
creating table; - nested throwable:
(java.sql.SQLException: General erro
r: You have an error in your SQL syntax near 'INTEGER
NOT NULL, CONSTRAINT pk_SequenceEntity PRIMARY KEY
(name))' at line 1)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:190)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:84)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:383)
at
org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
at
org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
at
org.jboss.ejb.Container.invoke(Container.java:793)
at
org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
at $Proxy6.start(Unknown Source)
at
org.jboss.system.ServiceController.start(ServiceController.java:340)
at
sun.reflect.GeneratedMethodAccessor5.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:491)
at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy19.start(Unknown Source)
at
org.jboss.ejb.EjbModule.startService(EjbModule.java:440)
at
org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:162)
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:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
at $Proxy6.start(Unknown Source)
at
org.jboss.system.ServiceController.start(ServiceController.java:340)
at
sun.reflect.GeneratedMethodAccessor5.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:491)
at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy5.start(Unknown Source)
at
org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:398)
at
org.jboss.deployment.MainDeployer.start(MainDeployer.java:678)
at
org.jboss.deployment.MainDeployer.start(MainDeployer.java:671)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:513)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
at
sun.reflect.GeneratedMethodAccessor8.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:491)
at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy4.deploy(Unknown Source)
at
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405)
at
org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:586)
at
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:465)
at
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:237)
at
org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:162)
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:491)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
at $Proxy0.start(Unknown Source)
at
org.jboss.system.ServiceController.start(ServiceController.java:340)
at
sun.reflect.GeneratedMethodAccessor5.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:491)
at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy3.start(Unknown Source)
at
org.jboss.deployment.SARDeployer.start(SARDeployer.java:243)
at
org.jboss.deployment.MainDeployer.start(MainDeployer.java:678)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:513)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:465)
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:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
at
org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:314)
at
org.jboss.system.server.ServerImpl.start(ServerImpl.java:216)
at org.jboss.Main.boot(Main.java:142)
at org.jboss.Main$1.run(Main.java:375)
at java.lang.Thread.run(Thread.java:536)
Caused by: java.sql.SQLException: General error: You
have an error in your SQL syntax near 'INTEGER NOT
NULL, CONSTRAINT pk_Se
quenceEntity PRIMARY KEY (name))' at line 1
at
org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
at
org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown
Source)
at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown
Source)
at org.gjt.mm.mysql.Connection.execSQL(Unknown
Source)
at org.gjt.mm.mysql.Connection.execSQL(Unknown
Source)
at
org.gjt.mm.mysql.Statement.executeUpdate(Unknown
Source)
at
org.gjt.mm.mysql.jdbc2.Statement.executeUpdate(Unknown
Source)
at
org.jboss.resource.adapter.jdbc.local.LocalStatement.executeUpdate(LocalStatement.java:231)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:169)
... 83 more
Does anybody know why the second request to create the
table failed?
here is some indormation about the second entity bean:
* @ejb:bean name="myrpg-atlas/SequenceEntity"
* display-name="."
* type="CMP"
* jndi-name="ejb/SequenceEntity"
* view-type="local"
* primkey-field="name"
*
* @ejb:pk class="java.lang.String"
*
* @ejb:transaction type="Required"
*
* @ejb:data-object
extends="org.myrpg.atlas.core.AbstractData"
* setdata="false"
*
* @jboss:table-name table-name="SequenceEntity"
*
* @jboss:create-table create="true"
*
* @jboss:remove-table remove="false"
tia,
Wonder Sonic
___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
_______________________________________________________________
Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
