<!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;">
    driver-class ignored?
</h3>
<span style="margin-bottom: 10px;">
    created by <a href="http://community.jboss.org/people/lysy78">Hubert Lyczek</a> in <i>Datasource Configuration</i> - <a href="http://community.jboss.org/message/619933#619933">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">

<div class="jive-rendered-content"><p>Hello,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>My environment is:</p><p>1. Java: jdk1.6.0_23</p><p>2. AS: jboss-6.0.0.Final</p><p>3. Database: MySQL 5.1</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>In order to connect to database it is needed to configure data source.</p><p>I created file mysql-ds.xml, and everything was ok. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>But lately decided to use third party driver (different from original: com.mysql.jdbc.Driver), so I changed xml element driver-class. But nothing expected happened. So i decided to get the original environment and change value of driver-class element to something completely stupid: foo.bar.bla.bla.NotExistingDriver. And do you know what? - my data source was still ok. I didn't believe that. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>Then I removed mysql connector jar, and i received exception:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><blockquote class="jive-quote"><p>java.lang.ClassNotFoundException: foo.bar.bla.bla.NotExistingDriver</p></blockquote><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>Jboss did not find this class, becouse this class did and still does not exist. But after adding mysql connector jar to lib directory again, everything was ok again. Did it mean that this class was found in mysql connector jar? Strange.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>This is my mysql-ds.xml:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><pre class="jive-pre"><code class="jive-code jive-xml"><span class="jive-xml-tag">&lt;datasources&gt;</span>
&#160; 
&#160; 
&#160; 
&#160; <span class="jive-xml-tag">&lt;local-tx-datasource&gt;</span>
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; <span class="jive-xml-tag">&lt;jndi-name&gt;</span>TestDS<span class="jive-xml-tag">&lt;/jndi-name&gt;</span>
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; <span class="jive-xml-tag">&lt;connection-url&gt;</span>jdbc:mysql://localhost:3306/test<span class="jive-xml-tag">&lt;/connection-url&gt;</span>
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; 
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; <span class="jive-xml-tag">&lt;driver-class&gt;</span>foo.bar.bla.bla.NotExistingDriver<span class="jive-xml-tag">&lt;/driver-class&gt;</span>
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; 
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; <span class="jive-xml-tag">&lt;user-name&gt;</span>test<span class="jive-xml-tag">&lt;/user-name&gt;</span>
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; <span class="jive-xml-tag">&lt;password&gt;</span>test<span class="jive-xml-tag">&lt;/password&gt;</span>
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; <span class="jive-xml-tag">&lt;exception-sorter-class-name&gt;</span>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter<span class="jive-xml-tag">&lt;/exception-sorter-class-name&gt;</span>
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; <span class="jive-xml-tag">&lt;valid-connection-checker-class-name&gt;</span>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker<span class="jive-xml-tag">&lt;/valid-connection-checker-class-name&gt;</span>
&#160;&#160;&#160; 
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; 
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; <span class="jive-xml-comment">&lt;!--
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; <span class="jive-xml-tag">&lt;new-connection-sql&gt;</span>select * from test<span class="jive-xml-tag">&lt;/new-connection-sql&gt;</span>
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; --&gt;
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; &lt;!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; <span class="jive-xml-tag">&lt;check-valid-connection-sql&gt;</span>some arbitrary sql<span class="jive-xml-tag">&lt;/check-valid-connection-sql&gt;</span>
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; --&gt;
&#160;&#160;&#160;&#160;&#160; 
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; &lt;!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --&gt;</span>
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; <span class="jive-xml-tag">&lt;metadata&gt;</span>
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; <span class="jive-xml-tag">&lt;type-mapping&gt;</span>mySQL<span class="jive-xml-tag">&lt;/type-mapping&gt;</span>
&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; <span class="jive-xml-tag">&lt;/metadata&gt;</span>
&#160; <span class="jive-xml-tag">&lt;/local-tx-datasource&gt;</span>
&#160; 
<span class="jive-xml-tag">&lt;/datasources&gt;</span>

</code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>So... the question is: </p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>Is the element driver-class ignored by jboss?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>Could anyone explain it to me, please?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>Thanks in advance</p><p>Hubert</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/619933#619933">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>