white_angel_22 | Bonjour,
j'ai un problème pour intégrer MySql à JBOSS
J'ai configuré JBOSS pour tenir compte de MySql en rajoutant mysql-connector dans le répertoire lib de server/default et j'ai modifié mysql-ds.xml en mettant :
Code :
- <?xml version="1.0" encoding="UTF-8"?>
- <!-- $Id: mysql-ds.xml,v 1.3.2.1 2004/12/01 11:46:00 schrouf Exp $ -->
- <!-- Datasource config for MySQL using 3.0.9 available from:
- http://www.mysql.com/downloads/api-jdbc-stable.html
- -->
- <datasources>
- <local-tx-datasource>
- <jndi-name>group23</jndi-name>
- <connection-url>jdbc:mysql://1**.***.*.**/epizza_group23</connection-url>
- <driver-class>com.mysql.jdbc.Driver</driver-class>
- <user-name>***</user-name>
- <password>***</password>
- <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
- <!-- sql to call when connection is created
- <new-connection-sql>some arbitrary sql</new-connection-sql>
- -->
- <!-- sql to call on an existing pooled connection when it is obtained from pool
- <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
- -->
- <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
- <metadata>
- <type-mapping>mySQL</type-mapping>
- </metadata>
- </local-tx-datasource>
- </datasources>
|
(les étoiles sont remplacées par des chiffres et lettres)
Mon problème, lorsque je lance JBOSS j'ai les erreurs :
Code :
- --- 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
- ObjectName: jboss.mq.destination:service=Topic,name=testTopic
- State: CONFIGURED
- I Depend On:
- jboss.mq:service=DestinationManager
- jboss.mq:service=SecurityManager
- ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
- State: CONFIGURED
- I Depend On:
- jboss.mq:service=DestinationManager
- jboss.mq:service=SecurityManager
- ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
- State: CONFIGURED
- I Depend On:
- jboss.mq:service=DestinationManager
- jboss.mq:service=SecurityManager
- ObjectName: jboss.mq.destination:service=Queue,name=testQueue
- State: CONFIGURED
- I Depend On:
- jboss.mq:service=DestinationManager
- jboss.mq:service=SecurityManager
- ObjectName: jboss.mq.destination:service=Queue,name=A
- State: CONFIGURED
- I Depend On:
- jboss.mq:service=DestinationManager
- ObjectName: jboss.mq.destination:service=Queue,name=B
- State: CONFIGURED
- I Depend On:
- jboss.mq:service=DestinationManager
- ObjectName: jboss.mq.destination:service=Queue,name=C
- State: CONFIGURED
- I Depend On:
- jboss.mq:service=DestinationManager
- ObjectName: jboss.mq.destination:service=Queue,name=D
- State: CONFIGURED
- I Depend On:
- jboss.mq:service=DestinationManager
- ObjectName: jboss.mq.destination:service=Queue,name=ex
- State: CONFIGURED
- I Depend On:
- jboss.mq:service=DestinationManager
- ObjectName: jboss.mq:service=Invoker
- State: CONFIGURED
- I Depend On:
- jboss.mq:service=TracingInterceptor
- jboss:service=Naming
- Depends On Me:
- jboss.mq:service=InvocationLayer,type=HTTP
- jboss.mq:service=InvocationLayer,type=JVM
- 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.destination:service=Queue,name=DLQ
- State: CONFIGURED
- I Depend On:
- jboss.mq:service=DestinationManager
- jboss.mq:service=SecurityManager
- ObjectName: jboss.mq:service=InvocationLayer,type=JVM
- State: CONFIGURED
- I Depend On:
- jboss.mq:service=Invoker
- ObjectName: jboss.mq:service=DestinationManager
- State: CONFIGURED
- I Depend On:
- jboss.mq:service=MessageCache
- 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.jca:service=DataSourceBinding,name=MySqlDS
- Depends On Me:
- jboss.mq:service=DestinationManager
- ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
- State: CONFIGURED
- I Depend On:
- jboss.mq:service=Invoker
- --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
- ObjectName: jboss.jca:service=DataSourceBinding,name=MySqlDS
- State: NOTYETINSTALLED
- Depends On Me:
- jboss.mq:service=PersistenceManager
|
Le serveur Jboss démarre mais il a un problème avec mysql
J'ai écumé plusieurs forums et je n'ai pas trouvé de solutions à ce problème.
Merci pour votre aide |