JBoss 3.2.0 and MySQL

[sysuser1]

Hi,

I've just installed JBoss 3.2.0 and configured to set MySQL as the default datasource.
I have installed the mysql .jar driver, deployed the mysql-ds.xml file and configured mysql-ds.xml and standardjbosscmp-jdbc.xml files so the MySQL DDBB is the default datasource.
When I startup the JBoss server, two errors appear (there were no error when I did it with the JBoss 3.0.0 server):

10:38:58,651 ERROR [PersistenceManager] Starting failed
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: General error: Table 'negociador.JMS_MESSAGES' doesn't exist)
at org.jboss.mq.pm.jdbc2.Persist...
......................................................................
10:39:11,450 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
Cause: Incomplete Deployment listing:
Packages waiting for a deployer:

Incompletely deployed packages:

MBeans waiting for classes:

MBeans waiting for other MBeans:
[ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
state: CREATED
I Depend On: jboss.mq:service=Invoker
jboss.web:service=WebServer

Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testTopic
state: CREATED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
state: CREATED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager...
......................................................................

It looks like it works, because a new table (JMS_TRANSACTIONS) is created.

Any help to avoid these errors? Do I have to create a table by hand? I don't hope so.

Thanks

[pup99]

I think the easiest way to deal with this is to leave the default datasource as Hypersonic SQL, and just have your application make MySQL the database to use, that is how I have it running, and I am not getting these errors, if you don't want to run it that way, perhaps the create-table being true would help. Those are my suggestions.

Pup

[davidjencks]

I think the sql supplied for the jms jdbc2 persistence manager doesn't work with mysql. Look in that mbeans config to see if you can change it to more mysql-friendly syntax. if you arent using jms, you can remove all the jms mbeans. You can also change to e.g. the file or rolling logged persistence manager.

[cubeur]

hi, i have the same problems, except that i just have the MBeanException at the end. Do you have resolve it ? and how ? How to remove all the JMS beans ? thx

[cubeur]

"cubeur" wrote:
with the help of -Wai Kim Or 01- i tried do this

----------------------------

1. create mysql data base [db.name]

2. copy mysql-connector-java-3.0.6-stable-bin.jar to [jboss.dir]/server/default/lib

3. server/default/conf/standardjbosscmp-jdbc.xml, replace the Hyper SQL with these 2:
<datasource>java:/MySqlDS</datasource>
<datasource-mapping>mySQL</datasource-mapping>

4. server/default/conf/standardjaws.xml, replace the Hyper SQL with these 2:
<datasource>java:/MySqlDS</datasource>
<type-mapping>mySQL</type-mapping>

5. copy docs/examples/jca/mysql-ds.xml into /server/default/deploy

6. update mysql-ds.xml with your MySql login/password, and use the following:
<jndi-name>[db-jndi.name]</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/[db.name]</connection-url>

7. restart jboss

----------------------------

the jms-transactions table is created with one field and then at the end of the JBoss start...


12:51:47,328 ERROR [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.mq:service=InvocationLayer,type=HTTP
state: CONFIGURED
I Depend On: jboss.mq:service=Invoker
jboss.web:service=WebServer

Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testTopic
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=testQueue
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=A
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager

Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=B
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager

Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=C
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager

Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=D
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager

Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=ex
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager

Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=JVM
state: CONFIGURED
I Depend On: jboss.mq:service=Invoker

Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=RMI
state: CONFIGURED
I Depend On: jboss.mq:service=Invoker

Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL
state: CONFIGURED
I Depend On: jboss.mq:service=Invoker

Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=UIL
state: CONFIGURED
I Depend On: jboss.mq:service=Invoker

Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL2
state: CONFIGURED
I Depend On: jboss.mq:service=Invoker

Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
state: CONFIGURED
I Depend On: jboss.mq:service=Invoker

Depends On Me: , ObjectName: jboss.mq:service=Invoker
state: CONFIGURED
I Depend On: jboss.mq:service=TracingInterceptor

Depends On Me: jboss.mq:service=InvocationLayer,type=HTTP
jboss.mq:service=InvocationLayer,type=JVM
jboss.mq:service=InvocationLayer,type=RMI
jboss.mq:service=InvocationLayer,type=OIL
jboss.mq:service=InvocationLayer,type=UIL
jboss.mq:service=InvocationLayer,type=OIL2
jboss.mq:service=InvocationLayer,type=UIL2
, ObjectName: jboss.mq:service=TracingInterceptor
state: CONFIGURED
I Depend On: jboss.mq:service=SecurityManager

Depends On Me: jboss.mq:service=Invoker
, ObjectName: jboss.mq:service=SecurityManager
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager

Depends On Me: jboss.mq.destination:service=Topic,name=testTopic
jboss.mq.destination:service=Topic,name=securedTopic
jboss.mq.destination:service=Topic,name=testDurableTopic
jboss.mq.destination:service=Queue,name=testQueue
jboss.mq:service=TracingInterceptor
jboss.mq.destination:service=Queue,name=DLQ
, ObjectName: jboss.mq:service=DestinationManager
state: CONFIGURED
I Depend On: jboss.mq:service=PersistenceManager
jboss.mq:service=StateManager

Depends On Me: jboss.mq.destination:service=Topic,name=testTopic
jboss.mq.destination:service=Topic,name=securedTopic
jboss.mq.destination:service=Topic,name=testDurableTopic
jboss.mq.destination:service=Queue,name=testQueue
jboss.mq.destination:service=Queue,name=A
jboss.mq.destination:service=Queue,name=B
jboss.mq.destination:service=Queue,name=C
jboss.mq.destination:service=Queue,name=D
jboss.mq.destination:service=Queue,name=ex
jboss.mq:service=SecurityManager
jboss.mq.destination:service=Queue,name=DLQ
, ObjectName: jboss.mq:service=PersistenceManager
state: CONFIGURED
I Depend On: jboss.mq:service=MessageCache
jboss.jca:service=LocalTxCM,name=DefaultDS

Depends On Me: jboss.mq:service=DestinationManager
, ObjectName: jboss.mq.destination:service=Queue,name=DLQ
state: CONFIGURED
I Depend On: jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

Depends On Me: ]
12:51:47,343 INFO [URLDeploymentScanner] Started
12:51:47,390 INFO [MainDeployer] Deployed package: file:/C:/jboss/server/default/conf/jboss-service.xml
12:51:47,390 INFO [Server] JBoss (MX MicroKernel) [3.2.0 (build: CVSTag=JBoss_3_2_0 date=200304110033)] Started in 19s:594ms





is someone have a solution ?

[cubeur]

look at the solution on another topic of this day :)