tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "White, Joshua A (CASD, IT)" <Joshua.Wh...@thehartford.com>
Subject RE: JNDI datasource frustrations...
Date Fri, 14 Feb 2003 02:24:58 GMT
It looks like this is a common problem.  I have found several posts on
several boards about this problem.  Unfortunately, no solution.  

Does it matter whether I declare the resource in the server.xml under the
global naming resources or do I need to define one specific to my
applications path?

Has anyone successfully connected with MSSQL Server 2k?

-Joshua 

-----Original Message-----
From: White, Joshua A (CASD, IT) 
Sent: Thursday, February 13, 2003 5:17 PM
To: 'pqin@shareowner.com'; tomcat-user@jakarta.apache.org
Subject: RE: JNDI datasource frustrations...


Here is my entry in my web.xml:

  <resource-ref>
      <description>Sql Server Database Connection</description>
      <res-ref-name>jdbc/joshsDB</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
  </resource-ref>

I am still at a loss.  Any other ideas?

-Joshua






-----Original Message-----
From: pqin@shareowner.com [mailto:pqin@shareowner.com]
Sent: Thursday, February 13, 2003 3:43 PM
To: tomcat-user@jakarta.apache.org
Subject: RE: JNDI datasource frustrations...


What about your app's web.xml? This is a classic question, You many search
through this list or struts/commons lists for answer. There is also a
documentation on Jakarta.apache.org's.

Regards,
 
 
PQ
 
"This Guy Thinks He Knows Everything"
"This Guy Thinks He Knows What He Is Doing"

-----Original Message-----
From: White, Joshua A (CASD, IT) [mailto:Joshua.White@thehartford.com] 
Sent: February 13, 2003 3:36 PM
To: 'tomcat-user@jakarta.apache.org'
Subject: JNDI datasource frustrations...

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

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


Mime
View raw message