database - tomcat JNDI 数据库配置

Question

我在 C:/Tomcat6/conf/context.xml 中有以下内容:

<Context>

    <!-- Default set of monitored resources -->
    <WatchedResource>WEB-INF/web.xml</WatchedResource>

    <ResourceLink global="jdbc/MyDatasource" name="jdbc/MyDatasource" type="javax.sql.DataSource"/>


</Context>

以及 C:/Tomcat6/conf/server.xml 中的以下内容:

<Resource name="jdbc/MyDatasource"
    auth="Container"
    driverClassName="net.sourceforge.jtds.jdbc.Driver"
    maxactive="100"
    maxidle="30"
    maxwait="10000"
    type="javax.sql.DataSource"    
    jdbcUrl="jdbc:jtds:sqlserver://localhost/SAFEHOUSE-UK;integratedSecurity=true;">

我在 C:/Tomcat6/lib 中有 jtds-1.2.5.jar。

然而，当我点击我的应用程序时，我得到以下信息:

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class 'net.sourceforge.jtds.jdbc.Driver' for connect URL 'null' 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.safehouse.safeservices.authenticate.AdminLoginForm.getpassword(Unknown Source)

任何帮助将不胜感激

Answer 1

1、修改连接url

 jdbcUrl="jdbc:jtds:sqlserver://localhost:1305;DatabaseName=your databasename"