to usando o seguinte driver com.microsoft.jdbc.sqlserver.SQLServerDriver, sendo q qnd chamo o servlet sa o seguinte erro. Já coloquei os jar do driver no common\lib tanto do servidor qnt no lib da aplicacao mas ta dizendo q nao encontra o driver. baixei ele do seguinte site:
http://www.minq.se/products/dbvis/drivers.html#sqlserver. algem sabe o q pode ser o erro???
root cause
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.jdbc.sqlserver.SQLServerDriver'
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766)
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
app.Conexao.init(Conexao.java:34)
javax.servlet.GenericServlet.init(GenericServlet.java:211)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
java.lang.Thread.run(Thread.java:595)
Servlet
package app;
/**
* @author cu_ringa
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
public class Conexao extends HttpServlet implements SingleThreadModel
{
Connection con;
PreparedStatement pstmt ;
public void init() throws ServletException
{
try {
Context ctxt = new InitialContext();
Context ct = (Context)ctxt.lookup("java:comp/env");
DataSource ds = (DataSource)ct.lookup("jdbc/conexoes");
System.out.println(ds);
Connection con = ds.getConnection();
System.out.println(con);
System.out.println("bernardino");
}
catch (SQLException ex) {
throw new ServletException("Cannot create database connection",ex);
}
catch (Exception ex) {
throw new ServletException("Cannot create database connection",ex);
}
}
}
web.xml
<web-app>
<servlet>
<servlet-name>hi</servlet-name>
<servlet-class>app.Conexao</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>hi</servlet-name>
<url-pattern>/hi</url-pattern>
</servlet-mapping>
<resource-ref>
<res-ref-name>jdbc/conexoes</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
