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]
_______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
