[modha]

Hi All

I am not sure if this is MyEclipse issue. Since I start my tomcat from MyEclipse I am thinking there could be an issue.

I am using SQL Server 2005. Tomcat 5.0.28. I am trying to connect to DB using tomcat connection pool. I can open server.xml in IE ( no errors)
and I get this error:

org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class ‘com.microsoft.jdbc.sqlserver.SQLServerDriver’
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766)

Context in Server.xml
================
<Context crossContext=”true” debug=”5″ docBase=”ATF”
path=”/ATF” reloadable=”true”>
<Resource name=”jdbc/modhaDB” type=”javax.sql.DataSource”/>
<ResourceParams name=”jdbc/modhaDB”>
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>password</name>
<value>password</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:sqlserver://cc:1433;DatabaseName=MK</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>username</name>
<value>MKumar</value>
</parameter>
</ResourceParams>
<Resource name=”mail/Session” auth=”Container”
type=”javax.mail.Session”/>
<ResourceParams name=”mail/Session”>
<parameter>
<name>mail.smtp.host</name>
<value></value>
</parameter>
</ResourceParams>
</Context>

Java Code:
========
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup(“java:/comp/env”);
DataSource ds = (DataSource)envContext.lookup(“jdbc/modhaDB”);
conn = ds.getConnection();

Please let me know… what could be the problem

[modha]

I have sqljdbc.jar in tomcat/common/lib

[modha]

I have sqljdbc.jar in tomcat/common/lib

[modha]

Got it 2005 driver is com.microsoft.sqlserver.jdbc.SQLServerDriver

[Author]

Posts