JNDI datasource frustrations...

["White, Joshua A (CASD, IT)" <Jo...@thehartford.com>]

All,

It seems that I may be having a problem instantiating the Sql server jdbc
driver.  I have copied the following jars into my $CATALINA_HOME/common/lib
directory:
msbase.jar
mssqlserver.jar
msutil.jar


I have the following in my server.xml file:

            <Resource name="jdbc/joshsDB"
                auth="Container"
                type="javax.sql.DataSource"/>


<ResourceParams name="jdbc/joshsDB">
    <parameter>
        <name>username</name>
        <value>someuser</value>
    </parameter>
    <parameter>
        <name>password</name>
        <value>password</value>
    </parameter>
    <parameter>
        <name>driverClassName</name>
        <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
    </parameter>
    <parameter>
        <name>url</name>
        <value>jdbc:microsoft:sqlserver://localhost:1433</value>
    </parameter>
    <parameter>
        <name>maxActive</name>
        <value>100</value>
    </parameter>
    <parameter>
        <name>maxIdle</name>
        <value>10000</value>
    </parameter>
    <parameter>
        <name>maxWait</name>
        <value>10000</value>
    </parameter>
</ResourceParams>


In the Tomcat console, I see the following:

java.sql.SqlException: Cannot load JDBC driver class 'null'

What am I doing wrong here?

Joshua




This communication, including attachments, is for the exclusive use of 
addressee and may contain proprietary, confidential or privileged 
information. If you are not the intended recipient, any use, copying, 
disclosure, dissemination or distribution is strictly prohibited. If 
you are not the intended recipient, please notify the sender 
immediately by return email and delete this communication and destroy all copies.


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org