Need help in solving org.apache.commons.dbcp.SQLNestedException

Hi,

i have an application depoyed in tomcat 5.0.24. In server.xml i gave the Resource context binding entries but it throws exception.

The exception is

org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.jdbc.sqlserver.SQLServerDriver', cause:

java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

Where should i Place my mysqlserver.jar in webapplication's lib or tomcat's lib folder.

Thanks

[502 byte] By [mclarena] at [2007-10-3 4:01:16]

«« Failed to realize
»» Need Help Urgently......!

# 1

You have an exception that says it can't find the SQL Server driver. You are trying to solve this with the MySQL server driver. Think about it for second or two.

sabre150a at 2007-7-14 22:00:28 >

top of Java-index,Java Essentials,Java Programming...

# 2

> Where should i Place my mysqlserver.jar in

> webapplication's lib or tomcat's lib folder.

> Thanks

You should put it in <TOMCAT_HOME>\common\lib

As it says in the manual directly under the rows that explains how to delcare a resource... ;-)

Lajma at 2007-7-14 22:00:28 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Need help in solving org.apache.commons.dbcp.SQLNestedException

Java Essentials New Topic

Java Essentials Hot Topic

Java Essentials

All Classified