[jboss-user] [Datasource Configuration] - unable to setup mysql database on JBoss 5.1.0GA

[Ralph Soika]

Ralph Soika [http://community.jboss.org/people/rsoika] created the discussion

"unable to setup mysql database on JBoss 5.1.0GA"

To view the discussion, visit: http://community.jboss.org/message/549799#549799

--------------------------------------------------------------
Hi,
I need some help to setup a mysql database.
I followed this wiki
 http://community.jboss.org/wiki/SetUpAMySQLDatasource http://community.jboss.org/wiki/SetUpAMySQLDatasource

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"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>jdbc/workflow-db</jndi-name>
    <connection-url>jdbc:mysql://localhost:3306/jboss_test</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>xxx</user-name>
    <password>yyy</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>
  </local-tx-datasource>
</datasources>

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

Ralph

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

Reply to this message by going to Community
[http://community.jboss.org/message/549799#549799]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100627/310aacce/attachment.html