5:56 a.m.
Marcel Bussien [http://community.jboss.org/people/bussien] created the discussion
"whats wrong with my MySQL datasource"
To view the discussion, visit: http://community.jboss.org/message/629077#629077
--------------------------------------------------------------
*the login excemple produces this error:*
+18:15:31,859 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) Starting
deployment of "login.war"+
+18:15:32,037 INFO [org.jboss.jpa] (MSC service thread 1-2) read persistence.xml for
loginDatabase+
+18:15:32,040 INFO [org.jboss.as.jpa] (MSC service thread 1-2) added
javax.persistence.api, javaee.api, org.jboss.as.jpa, org.javassist dependencies to
login.war+
+18:15:32,040 INFO [org.jboss.as.jpa] (MSC service thread 1-2) added (default provider)
org.hibernate dependency to application deployment (since 1 PU(s) didn't specify
jboss.as.jpa.providerModule)+
+18:15:32,041 INFO [org.jboss.as.jpa] (MSC service thread 1-2) added org.hibernate
dependency to application deployment+
+18:15:32,102 INFO [org.jboss.weld] (MSC service thread 1-2) Processing CDI deployment:
login.war+
+18:15:32,102 INFO
[org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC
service thread 1-2) JNDI bindings for session bean named EJBUserManager in deployment unit
deployment "login.war" are as follows:+
+ java:global/login/EJBUserManager!org.jboss.as.quickstarts.login.UserManager+
+ java:app/login/EJBUserManager!org.jboss.as.quickstarts.login.UserManager+
+ java:module/EJBUserManager!org.jboss.as.quickstarts.login.UserManager+
+ java:global/login/EJBUserManager+
+ java:app/login/EJBUserManager+
+ java:module/EJBUserManager+
+18:15:32,137 INFO [org.jboss.weld] (MSC service thread 1-2) Starting Services for CDI
deployment: login.war+
+18:15:32,255 INFO [org.jboss.as.server.controller] (HttpManagementService-threads - 1)
Deployment of "login.war" was rolled back with failure message Operation handler
failed to complete+
+18:15:32,462 INFO [org.jboss.as.server.deployment] (MSC service thread 1-4) Stopped
deployment login.war in 185ms+
*the 'C:\jboss-as-web-7.0.2.Final\standalone\configuration\standalone.xml looks like
this:*
+... ExampleDS" pool-name="H2DS"...*
*+
+</datasource>+
+<datasource jndi-name="java:jboss/datasources/MySQLDS"
pool-name="MySQLDS" enabled="true" jta="true"
use-java-context="true" use-ccm="true">+
+ <connection-url>+
+ jdbc:mysql://localhost:3306/sty+
+ </connection-url>+
+ <driver>+
+ mysql-connector-java-5.1.17.jar+
+ </driver>+
+ <pool>+
+ <min-pool-size>+
+ 10+
+ </min-pool-size>+
+ <max-pool-size>+
+ 100+
+ </max-pool-size>+
+ <prefill>+
+ true+
+ </prefill>+
+ <use-strict-min>+
+ false+
+ </use-strict-min>+
+ <flush-strategy>+
+ FailingConnectionOnly+
+ </flush-strategy>+
+ </pool>+
+ <security>+
+ <user-name>+
+ hokus+
+ </user-name>+
+ <password>+
+ bokus+
+ </password>+
+ </security>+
+ </datasource>+
+ <drivers>+
+ <driver name="mysql-connector-java-5.1.17.jar"
module="com.mysql">+
+ <xa-datasource-class>+
+ com.mysql.jdbc.jdbc2.optional.MysqlXADataSource+
+ </xa-datasource-class>+
+ </driver>+
+ <driver name="h2"
module="com.h2database.h2">+
+ <xa-datasource-class>+
+ org.h2.jdbcx.JdbcDataSource+
+ </xa-datasource-class>+
+ </driver>+
+ </drivers>+
+ </datasources>+
*and the jar lies here*
+C:\jboss-as-web-7.0.2.Final\standalone\deployments\mysql-connector-java-5.1.17.zip+
*it's enabled too:*
+Registered Datasources+
| | +java:jboss/datasources/ExampleDS+ | +java:jboss/datasources/ExampleDS+ | +H2DS+ |
+http://127.0.0.1:9990/console/app/clear.cache.gif+ |
| +java:jboss/datasources/MySQLDS+ | +java:jboss/datasources/MySQLDS+ | +MySQLDS+ |
|
*thanks for any suggestions*+
+
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/629077#629077]
Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]