whats wrong with my MySQL datasource
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
|
thanks for any suggestions