mssql 驱动程序链接

jqzynanjiong

谁能发一下MSSQL驱动程序配置的完整的示例，
我的数据源配置如下，不知道是否正确
        <Resource name="jdbc/pay" type="javax.sql.DataSource"
                maxActive="100" maxIdle="30"
                driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:sqlserver://192.168.8.162:1433/kfty"
                username="sa" password="xxxx" />
但是运行的时候有如下错误：
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class 'net.sourceforge.jtds.jdbc.Driver' for connect URL 'jdbc:sqlserver://192.168.8.162:1433/kfty'
        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.pay.PayServlet.queryGzTable(PayServlet.java:56)
        at com.justep.baas.pay.PayServlet.service(PayServlet.java:36)
        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

参考：http://bbs.wex5.com/forum.php?mo ... 6&pid=165177526