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: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 3:43 PM
To: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: February 13, 2003 3:36 PM
To: '[EMAIL PROTECTED]'
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
