[jboss-user] [Datasource Configuration] - whats wrong with my MySQL datasource

Marcel Bussien do-not-reply at jboss.com
Thu Sep 29 06:56:07 EDT 2011


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&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110929/bd32ba6c/attachment.html 


More information about the jboss-user mailing list