[JBOSS et MySql] Pb de configuration

Pb de configuration [JBOSS et MySql] - Java - Programmation

Marsh Posté le 02-02-2006 à 13:19:59    

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 :
  1. <?xml version="1.0" encoding="UTF-8"?>
  3. <!-- $Id: mysql-ds.xml,v 1.3.2.1 2004/12/01 11:46:00 schrouf Exp $ -->
  4. <!--  Datasource config for MySQL using 3.0.9 available from:
  5. http://www.mysql.com/downloads/api-jdbc-stable.html
  6. -->
  8. <datasources>
  9.   <local-tx-datasource>
  10.     <jndi-name>group23</jndi-name>
  11.     <connection-url>jdbc:mysql://1**.***.*.**/epizza_group23</connection-url>
  12.     <driver-class>com.mysql.jdbc.Driver</driver-class>
  13.     <user-name>***</user-name>
  14.     <password>***</password>
  15.     <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
  16.     <!-- sql to call when connection is created
  17.     <new-connection-sql>some arbitrary sql</new-connection-sql>
  18.       -->
  19.     <!-- sql to call on an existing pooled connection when it is obtained from pool
  20.     <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
  21.       -->
  23.     <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
  24.     <metadata>
  25.        <type-mapping>mySQL</type-mapping>
  26.     </metadata>
  27.   </local-tx-datasource>
  28. </datasources>


 
(les étoiles sont remplacées par des chiffres et lettres)
 
Mon problème, lorsque je lance JBOSS j'ai les erreurs :
 
 

Code :
  1. --- MBeans waiting for other MBeans ---
  2. ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
  3.   State: CONFIGURED
  4.   I Depend On:
  5.     jboss.mq:service=Invoker
  6.     jboss.web:service=WebServer
  8. ObjectName: jboss.mq.destination:service=Topic,name=testTopic
  9.   State: CONFIGURED
  10.   I Depend On:
  11.     jboss.mq:service=DestinationManager
  12.     jboss.mq:service=SecurityManager
  14. ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
  15.   State: CONFIGURED
  16.   I Depend On:
  17.     jboss.mq:service=DestinationManager
  18.     jboss.mq:service=SecurityManager
  20. ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
  21.   State: CONFIGURED
  22.   I Depend On:
  23.     jboss.mq:service=DestinationManager
  24.     jboss.mq:service=SecurityManager
  26. ObjectName: jboss.mq.destination:service=Queue,name=testQueue
  27.   State: CONFIGURED
  28.   I Depend On:
  29.     jboss.mq:service=DestinationManager
  30.     jboss.mq:service=SecurityManager
  32. ObjectName: jboss.mq.destination:service=Queue,name=A
  33.   State: CONFIGURED
  34.   I Depend On:
  35.     jboss.mq:service=DestinationManager
  37. ObjectName: jboss.mq.destination:service=Queue,name=B
  38.   State: CONFIGURED
  39.   I Depend On:
  40.     jboss.mq:service=DestinationManager
  42. ObjectName: jboss.mq.destination:service=Queue,name=C
  43.   State: CONFIGURED
  44.   I Depend On:
  45.     jboss.mq:service=DestinationManager
  47. ObjectName: jboss.mq.destination:service=Queue,name=D
  48.   State: CONFIGURED
  49.   I Depend On:
  50.     jboss.mq:service=DestinationManager
  52. ObjectName: jboss.mq.destination:service=Queue,name=ex
  53.   State: CONFIGURED
  54.   I Depend On:
  55.     jboss.mq:service=DestinationManager
  57. ObjectName: jboss.mq:service=Invoker
  58.   State: CONFIGURED
  59.   I Depend On:
  60.     jboss.mq:service=TracingInterceptor
  61.     jboss:service=Naming
  62.   Depends On Me:
  63.     jboss.mq:service=InvocationLayer,type=HTTP
  64.     jboss.mq:service=InvocationLayer,type=JVM
  65.     jboss.mq:service=InvocationLayer,type=UIL2
  67. ObjectName: jboss.mq:service=TracingInterceptor
  68.   State: CONFIGURED
  69.   I Depend On:
  70.     jboss.mq:service=SecurityManager
  71.   Depends On Me:
  72.     jboss.mq:service=Invoker
  74. ObjectName: jboss.mq:service=SecurityManager
  75.   State: CONFIGURED
  76.   I Depend On:
  77.     jboss.mq:service=DestinationManager
  78.   Depends On Me:
  79.     jboss.mq.destination:service=Topic,name=testTopic
  80.     jboss.mq.destination:service=Topic,name=securedTopic
  81.     jboss.mq.destination:service=Topic,name=testDurableTopic
  82.     jboss.mq.destination:service=Queue,name=testQueue
  83.     jboss.mq:service=TracingInterceptor
  84.     jboss.mq.destination:service=Queue,name=DLQ
  86. ObjectName: jboss.mq.destination:service=Queue,name=DLQ
  87.   State: CONFIGURED
  88.   I Depend On:
  89.     jboss.mq:service=DestinationManager
  90.     jboss.mq:service=SecurityManager
  92. ObjectName: jboss.mq:service=InvocationLayer,type=JVM
  93.   State: CONFIGURED
  94.   I Depend On:
  95.     jboss.mq:service=Invoker
  97. ObjectName: jboss.mq:service=DestinationManager
  98.   State: CONFIGURED
  99.   I Depend On:
  100.     jboss.mq:service=MessageCache
  101.     jboss.mq:service=PersistenceManager
  102.     jboss.mq:service=StateManager
  103.   Depends On Me:
  104.     jboss.mq.destination:service=Topic,name=testTopic
  105.     jboss.mq.destination:service=Topic,name=securedTopic
  106.     jboss.mq.destination:service=Topic,name=testDurableTopic
  107.     jboss.mq.destination:service=Queue,name=testQueue
  108.     jboss.mq.destination:service=Queue,name=A
  109.     jboss.mq.destination:service=Queue,name=B
  110.     jboss.mq.destination:service=Queue,name=C
  111.     jboss.mq.destination:service=Queue,name=D
  112.     jboss.mq.destination:service=Queue,name=ex
  113.     jboss.mq:service=SecurityManager
  114.     jboss.mq.destination:service=Queue,name=DLQ
  116. ObjectName: jboss.mq:service=PersistenceManager
  117.   State: CONFIGURED
  118.   I Depend On:
  119.     jboss.jca:service=DataSourceBinding,name=MySqlDS
  120.   Depends On Me:
  121.     jboss.mq:service=DestinationManager
  123. ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
  124.   State: CONFIGURED
  125.   I Depend On:
  126.     jboss.mq:service=Invoker
  128. --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
  129. ObjectName: jboss.jca:service=DataSourceBinding,name=MySqlDS
  130.   State: NOTYETINSTALLED
  131.   Depends On Me:
  132.     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

Reply

Marsh Posté le 02-02-2006 à 13:19:59   

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed