3 Replies Latest reply on May 9, 2014 4:51 PM by chaluwa

Can't Use MySQL Datasource

chaluwa May 9, 2014 12:20 PM

I have not been able to successfully deploy a MySQL datasource to EAP 6.2.0 and WildFly 8.0.0 and I don't know what the problem is. I created a com/mysql/main directory under the modules directory of the server, and placed mysql-connector-java-5.0.8.jar and a module.xml file there.

Then, I aded a datasourse configuration to standalone.xml, but cannot start any of the servers without the following errors:

EAP server :

JBAS014775: New missing/unsatisfied dependencies:

service jboss.jdbc-driver.mysql (missing) dependents: [service jboss.data-source.java:jboss/datasources/UniaccessDS, service jboss.driver-demander.java:jboss/datasources/UniaccessDS]

So, I removed the configuration from standalone.xml and decided to use EAP admin console to add it. This lead to an Unknown Error complaining about (by my understanding) the MySQL driver. Details of error messages are here: http://ur1.ca/ha86a

WildFly server

http://ur1.ca/haceb

Pls what am I getting wrong? How do I get this to work at least in WildFly ??

1. Re: Can't Use MySQL Datasource

jamezp May 9, 2014 1:04 PM (in response to chaluwa)

Have you had a look at Data Source Configuration in AS 7?

--
James R. Perkins
1 of 1 people found this helpful
Actions
2. Re: Can't Use MySQL Datasource

wdfink May 9, 2014 1:23 PM (in response to chaluwa)

If it is the same in your environment the path is wrong, you wrote eap-home/modules/com/mysql/man/module.xml
This is man instead of main
Actions
3. Re: Can't Use MySQL Datasource

chaluwa May 9, 2014 4:51 PM (in response to chaluwa)

Thanks for the pointers. I followed the guide at Data Source Configuration in AS 7 , and although it was identical to what I earlier did, I decided to download the attached driver module from that page and it solved the problem.
Actions

Go to original post