我用的连接池连接sql2000,在tomcat下面的server.xml配置如下:
<Context path="/net" docBase="net" debug="5" reloadable="true" corssContext="true">
<Resource
name="jdbc/ConnectionPool"
auth="Container"
type="javax.sql.DataSource"
maxActive="20"
maxIdle="5"
maxWait="10000"
username="sa"
password=""
driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_net"/>
</Context>
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
</Host>
运行错误如下:
Cannot create JDBC driver of class '' 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.wsy.connsqlserver.getConnection(connsqlserver.java:28)
at com.wsy.connsqlserver.executeQuery(connsqlserver.java:40)
at com.wsy.selectsql.selectNews(selectsql.java:138)
........
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.createConnectionFactory(BasicDataSource.java:1437)
... 32 more
------解决思路----------------------
jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=db_net
可能是您的数据库的名称DatabaseName有问题吧。。。
------解决思路----------------------
参考这个。