0 Replies Latest reply on Sep 28, 2011 12:28 PM by Marcel Bussien

    whats wrong with my MySQL datasource

    Marcel Bussien Newbie

      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

      java:jboss/datasources/MySQLDS

      java:jboss/datasources/MySQLDS

      MySQLDS

       

      thanks for any suggestions