提示错误：无法创建net.sourceforge.jtds.jdbc.Driver

simonllf

按要求在baas下配置好了context.xml和web.xml，写好servlet运行后提示以下问题：
Cannot create JDBC driver of class 'net.sourceforge.jtds.jdbc.Driver' for connect URL 'jdbc:sqlserver://localhost:1433; DatabaseName=bidemo'
十二月 01, 2015 11:44:36 上午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet biDemo Servlet threw exception
java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getDriver(DriverManager.java:278)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at com.justep.baas.data.Util.getConnection(Util.java:32)
        at com.justep.baas.test.BiDemoTest.queryArea(BiDemoTest.java:58)
        at com.justep.baas.test.BiDemoTest.service(BiDemoTest.java:37)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)

        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at com.justep.baas.data.Util.getConnection(Util.java:32)
        at com.justep.baas.test.BiDemoTest.queryArea(BiDemoTest.java:58)
        at com.justep.baas.test.BiDemoTest.service(BiDemoTest.java:37)
        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:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getDriver(DriverManager.java:278)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)
        ... 17 more

请问是什么原因？缺少引用？

liangyongfei

net.sourceforge.jtds.jdbc.Driver
缺少sqlserver数据库连接的jar包，你可以网上下载个，然后放在apache-tomcat\lib目录下！然后重启服务！

simonllf

我查了下BAAS项目里边和apache-tomcat\lib都包含了jtds1.2的呀

liangyongfei

simonllf 发表于 2015-12-1 14:47
我查了下BAAS项目里边和apache-tomcat\lib都包含了jtds1.2的呀

是配置错了吗？参考下：http://bbs.wex5.com/forum.php?mo ... 6&pid=165177526

simonllf

liangyongfei 发表于 2015-12-1 14:50
是配置错了吗？参考下：http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=79106&pid=1 ...

  <Resource name="jdbc/bidemo" type="javax.sql.DataSource" maxActive="100" maxIdle="30"
    driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:sqlserver://localhost:1433; DatabaseName=bidemo"
    username="sa" password="xxxx"/>

web.xml配置：
        <servlet>
                <servlet-name>biDemo Servlet</servlet-name>
                <servlet-class>com.justep.baas.test.BiDemoTest</servlet-class>
                <load-on-startup>1</load-on-startup>
        </servlet>
        <servlet-mapping>
                <servlet-name>biDemo Servlet</servlet-name>
                <url-pattern>/bidemo</url-pattern>
        </servlet-mapping>
看有没问题？。。

simonllf

解决了。其实就是配置那里要改一点点。。让它和\conf下的context.xml一样就可以了
  <Resource name="jdbc/bidemo" type="javax.sql.DataSource" maxActive="100" maxIdle="30"
    driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://localhost:1433/bidemo"
    username="sa" password="xxxx"/>