当前位置: 代码迷 >> SQL >> Eclipse使用连接池连接SQL Server时出现异常
  详细解决方案

Eclipse使用连接池连接SQL Server时出现异常

热度:97   发布时间:2016-05-05 13:22:08.0
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" />

  相关解决方案