一个JSP项目,问题如何解决?sql2000数据库的。有几个程序如下:
context.xml
<?xml version='1.0' encoding='utf-8'?>
<Context>
<Resource name="jdbc/survey" type="javax.sql.DataSource"
driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=survey"
username="sa" password="zaq123456" maxActive="200" maxIdle="10"
maxWait="-1" />
</Context>sql2000的三个包也导入了啊,就是提示Cannot load JDBC driver class 'com.microsoft.jdbc.sqlserver.SQLServerDriver'
还有就是web.xml里面有如下代码:
<env-entry>
<env-entry-name>JNDIname</env-entry-name>
<env-entry-type>java.lang.String</env-entry-type>
<env-entry-value>jdbc/survey</env-entry-value>
</env-entry>
数据库连接语句有这样的代码:
public class ConnectionFactory {
private ConnectionFactory(){
}
/**
* 通过web.xml的JNDIname参数配置创建连接
* @return
*/
public static Connection getConnection(){
try {
String JNDIname=(String)new javax.naming.InitialContext().lookup("java:comp/env/JNDIname");
return ConnectionFactory.getConnection(JNDIname);
} catch (NamingException e) {
System.out.print("数据库未启动或连接池未配置!");
}
return null;
}
/**
* 通过指定的JNDI名称获取数据库连接,如JDBC/SURVEY
* @param JNDIname
* @return Connection
*/
public static Connection getConnection(String JNDIname){
try {
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource) envCtx.lookup(JNDIname); return ds.getConnection();
} catch (NamingException e1) {
System.out.print("数据库未启动或连接池未配置!");
return null;
} catch (SQLException e) {
e.printStackTrace();
return null;
}
}
}错误提示:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.jdbc.sqlserver.SQLServerDriver'
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
请问如何解决?
context.xml
<?xml version='1.0' encoding='utf-8'?>
<Context>
<Resource name="jdbc/survey" type="javax.sql.DataSource"
driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=survey"
username="sa" password="zaq123456" maxActive="200" maxIdle="10"
maxWait="-1" />
</Context>sql2000的三个包也导入了啊,就是提示Cannot load JDBC driver class 'com.microsoft.jdbc.sqlserver.SQLServerDriver'
还有就是web.xml里面有如下代码:
<env-entry>
<env-entry-name>JNDIname</env-entry-name>
<env-entry-type>java.lang.String</env-entry-type>
<env-entry-value>jdbc/survey</env-entry-value>
</env-entry>
数据库连接语句有这样的代码:
public class ConnectionFactory {
private ConnectionFactory(){
}
/**
* 通过web.xml的JNDIname参数配置创建连接
* @return
*/
public static Connection getConnection(){
try {
String JNDIname=(String)new javax.naming.InitialContext().lookup("java:comp/env/JNDIname");
return ConnectionFactory.getConnection(JNDIname);
} catch (NamingException e) {
System.out.print("数据库未启动或连接池未配置!");
}
return null;
}
/**
* 通过指定的JNDI名称获取数据库连接,如JDBC/SURVEY
* @param JNDIname
* @return Connection
*/
public static Connection getConnection(String JNDIname){
try {
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource) envCtx.lookup(JNDIname); return ds.getConnection();
} catch (NamingException e1) {
System.out.print("数据库未启动或连接池未配置!");
return null;
} catch (SQLException e) {
e.printStackTrace();
return null;
}
}
}错误提示:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.jdbc.sqlserver.SQLServerDriver'
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
请问如何解决?
tomcat中context.xml文件中加入
<ResourceLink global="jdbc/survey" name="jdbc/survey" type="javax.sql.DataSource"/>
tomcat中server.xml中加入
<Resource
name="jdbc/survey"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="sa"
password="qwerty123"
driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=survey"/>
tomcat最好不要用eclipse自带的,用自己的tomcat就好了缺包的话是这三个包:msbase.jar,mssqlserver.jar,msutil.jar
还有问题或者需要jar包联系我
邮箱是:[email protected]