<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
        <table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                <tbody>
                        <tr>
                                <td>
                                        <table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                                                <tbody>
                                                        <tr>
                                                                <td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
                                                                        <h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
                                                                        <!-- To have a header image/logo replace the name below with your img tag -->
                                                                        <!-- Email clients will render the images when the message is read so any image -->
                                                                        <!-- must be made available on a public server, so that all recipients can load the image. -->
                                                                        <a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
                                                                </td>
                                                        </tr>
                                                        <tr>
                                                                <td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
whats wrong with my MySQL datasource
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/bussien">Marcel Bussien</a> in <i>Datasource Configuration</i> - <a href="http://community.jboss.org/message/629077#629077">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p><strong>the login excemple produces this error:</strong></p><p><em>18:15:31,859 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3) Starting deployment of "login.war"</em></p><p><em>18:15:32,037 INFO  [org.jboss.jpa] (MSC service thread 1-2) read persistence.xml for loginDatabase</em></p><p><em>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</em></p><p><em>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)</em></p><p><em>18:15:32,041 INFO  [org.jboss.as.jpa] (MSC service thread 1-2) added org.hibernate dependency to application deployment</em></p><p><em>18:15:32,102 INFO  [org.jboss.weld] (MSC service thread 1-2) Processing CDI deployment: login.war</em></p><p><em>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:</em></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><em>          java:global/login/EJBUserManager!org.jboss.as.quickstarts.login.UserManager</em></p><p><em>          java:app/login/EJBUserManager!org.jboss.as.quickstarts.login.UserManager</em></p><p><em>          java:module/EJBUserManager!org.jboss.as.quickstarts.login.UserManager</em></p><p><em>          java:global/login/EJBUserManager</em></p><p><em>          java:app/login/EJBUserManager</em></p><p><em>          java:module/EJBUserManager</em></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><em>18:15:32,137 INFO  [org.jboss.weld] (MSC service thread 1-2) Starting Services for CDI deployment: login.war</em></p><p><em>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</em></p><p><em>18:15:32,462 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4) Stopped deployment login.war in 185ms</em></p><p><strong>the 'C:\jboss-as-web-7.0.2.Final\standalone\configuration\standalone.xml looks like this:</strong></p><p><em>... ExampleDS" pool-name="H2DS"...<strong><br/></strong></em></p><p><em></datasource></em></p><p><em><datasource jndi-name="java:jboss/datasources/MySQLDS" pool-name="MySQLDS" enabled="true" jta="true" use-java-context="true" use-ccm="true"></em></p><p><em>                    <connection-url></em></p><p><em>                        jdbc:mysql://localhost:3306/sty</em></p><p><em>                    </connection-url></em></p><p><em>                    <driver></em></p><p><em>                        mysql-connector-java-5.1.17.jar</em></p><p><em>                    </driver></em></p><p><em>                    <pool></em></p><p><em>                        <min-pool-size></em></p><p><em>                            10</em></p><p><em>                        </min-pool-size></em></p><p><em>                        <max-pool-size></em></p><p><em>                            100</em></p><p><em>                        </max-pool-size></em></p><p><em>                        <prefill></em></p><p><em>                            true</em></p><p><em>                        </prefill></em></p><p><em>                        <use-strict-min></em></p><p><em>                            false</em></p><p><em>                        </use-strict-min></em></p><p><em>                        <flush-strategy></em></p><p><em>                            FailingConnectionOnly</em></p><p><em>                        </flush-strategy></em></p><p><em>                    </pool></em></p><p><em>                    <security></em></p><p><em>                        <user-name></em></p><p><em>                            hokus</em></p><p><em>                        </user-name></em></p><p><em>                        <password></em></p><p><em>                            bokus</em></p><p><em>                        </password></em></p><p><em>                    </security></em></p><p><em>                </datasource></em></p><p><em>                <drivers></em></p><p><em>                    <driver name="mysql-connector-java-5.1.17.jar" module="com.mysql"></em></p><p><em>                        <xa-datasource-class></em></p><p><em>                            com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</em></p><p><em>                        </xa-datasource-class></em></p><p><em>                    </driver></em></p><p><em>                    <driver name="h2" module="com.h2database.h2"></em></p><p><em>                        <xa-datasource-class></em></p><p><em>                            org.h2.jdbcx.JdbcDataSource</em></p><p><em>                        </xa-datasource-class></em></p><p><em>                    </driver></em></p><p><em>                </drivers></em></p><p><em>            </datasources></em></p><p><strong>and the jar lies here</strong></p><p><em>C:\jboss-as-web-7.0.2.Final\standalone\deployments\mysql-connector-java-5.1.17.zip</em></p><p><strong>it's enabled too:</strong></p><p class="content-group-label"><em>Registered Datasources</em></p><table cellpadding="0" cellspacing="0" class="fill-layout-width"><tbody><tr><td align="left" style=";"><table cellspacing="0" class="default-cell-table"><tbody><tr class="cellTableEvenRow cellTableSelectedRow"><td class="cellTableCell cellTableEvenRowCell cellTableFirstColumn cellTableSelectedRowCell" style=";"><p><em>java:jboss/datasources/ExampleDS</em></p></td><td class="cellTableCell cellTableEvenRowCell cellTableSelectedRowCell" style=";"><p><em>java:jboss/datasources/ExampleDS</em></p></td><td class="cellTableCell cellTableEvenRowCell cellTableSelectedRowCell" style=";"><p><em>H2DS</em></p></td><td class="cellTableCell cellTableEvenRowCell cellTableSelectedRowCell cellTableLastColumn" style=";"><p><em><a href="http://127.0.0.1:9990/console/app/clear.cache.gif"><span> http://127.0.0.1:9990/console/app/clear.cache.gif </span></a></em></p></td></tr><tr class="cellTableOddRow cellTableHoveredRow"><td class="cellTableCell cellTableOddRowCell cellTableFirstColumn cellTableHoveredRowCell" style=";"><p><em>java:jboss/datasources/MySQLDS</em></p></td><td class="cellTableCell cellTableOddRowCell cellTableHoveredRowCell" style=";"><p><em>java:jboss/datasources/MySQLDS</em></p></td><td class="cellTableCell cellTableOddRowCell cellTableHoveredRowCell" style=";"><p><em>MySQLDS</em></p></td></tr></tbody></table></td></tr></tbody></table><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #ff0000;"><strong>thanks for any suggestions</strong></span><em><br/></em></p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/629077#629077">going to Community</a></p>
        <p style="margin: 0;">Start a new discussion in Datasource Configuration at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>