4 Replies Latest reply on Jun 28, 2010 5:04 AM by Ralph Soika

    unable to setup mysql database on JBoss 5.1.0GA

    Ralph Soika Apprentice


      I need some help to setup a mysql database.

      I followed this wiki



      So after configuration I see in the JBoss Web console now two "Local Tx Datasources"

      The DefaultDS and a new one named "jdbc/workflow-db"

      The DefaultDS shows the Status "UP" but my new datasource shows the status "DOWN"


      In the log file I got error messages like this:


      10:53:51,772 ERROR [InventoryManager] Call to getAvailablity() on ResourceComponent for Resource[id=-9, type=Local Tx Datasource, key=DataSource:LocalTx:jdbc/workflow-db, name=jdbc/workflow-db, parent=JBoss AS 5 (imixs), version=?] failed.
      java.lang.IllegalStateException: Failed to find [ComponentType{type=DataSource, subtype=LocalTx}] ManagedComponent named [jdbc/workflow-db].
          at org.rhq.plugins.jbossas5.ManagedComponentComponent.getManagedComponent(ManagedComponentComponent.java:340)


      I am using mysql-connector-java-5.1.7-bin.jar and my database is up and running.

      I checked everything more than once.


      My mysql-ds.xml file looks like this.


      <?xml version="1.0" encoding="UTF-8"?>


      Can any body give me a hint what I did wrong?

      Thanks for any help