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&...]