Eclipse使用连接池连接SQL Server时出现错误

2010-7-13 11:37:15 org.apache.catalina.core.AprLifecycleListener init
信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre6\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Program Files/Java/jre6/bin/client;C:/Program Files/Java/jre6/bin;d:\ORANT\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\ORANT\BIN;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;D:\Program Files\Java\jdk1.6.0_10\bin;D:\Program Files\Java\jdk1.6.0_10\jre\bin
2010-7-13 11:37:15 org.apache.coyote.http11.Http11Protocol init
信息: Initializing Coyote HTTP/1.1 on http-8000
2010-7-13 11:37:15 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 853 ms
2010-7-13 11:37:15 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
2010-7-13 11:37:15 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/6.0.26
2010-7-13 11:37:15 org.apache.catalina.startup.HostConfig deployDescriptor
信息: Deploying configuration descriptor oc.xml
2010-7-13 11:37:16 org.apache.coyote.http11.Http11Protocol start
信息: Starting Coyote HTTP/1.1 on http-8000
2010-7-13 11:37:16 org.apache.jk.common.ChannelSocket init
信息: JK: ajp13 listening on /0.0.0.0:8009
2010-7-13 11:37:16 org.apache.jk.server.JkMain start
信息: Jk running ID=0 time=0/47  config=null
2010-7-13 11:37:16 org.apache.catalina.startup.Catalina start
信息: Server startup in 755 ms
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1150)
 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
 at org.apache.jsp.test_jsp._jspService(test_jsp.java:64)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
 at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
 at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(Unknown Source)
 at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(Unknown Source)
 at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(Unknown Source)
 at java.sql.DriverManager.getDriver(Unknown Source)
 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143)
 ... 20 more

 

解决方法：

   在eclipse\workspace\Servers\Tomcat v6.0 Server at localhost (2)-config文件夹的context.xml加入下面的内容:

   <Resource name="jdbc/GUESTBOOK" scope="Shareable" type="javax.sql.DataSource"   username="sa"
        driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
        maxIdle="5" maxWait="5000"
        url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=OC" maxActive="100"/>
     <ResourceLink global="jdbc/GUESTBOOK" name="jdbc/GUESTBOOK" ype="javax.sql.DataSource" />