配置数据源之后 执行程序 出现 Cannot create jdbc of class '' for url='null'
如何解决此问题 我用的是SQLServer 2000数据库,已将3个包拷贝到common/lib下
server.xml已加入代码:
<Context path="/test" docBase="E:\study\JAVA\eclipse\workspace\hibernate1\" debug="5" reloadable="true" crossContext="true">
<Resource name="jdbc/jndibbs" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/jndibbs">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value>""</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bbs</value>
</parameter>
</ResourceParams>
</Context> web.xml代码: <?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.0" >
<resource-ref>
<description>bbs</description>
<res-ref-name>jdbc/jndibbs</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>测试代码 test.jsp:
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<%!
final String JNDINAME = "java:comp/env/jdbc/jndibbs" ;
%>
<%
Connection conn = null ;
try
{
Context ctx = new InitialContext() ;
DataSource ds = (DataSource)ctx.lookup(JNDINAME) ;
conn = ds.getConnection() ;
}
catch(Exception e)
{
System.out.println(e) ;
}
%>
<%=conn%>
<%
conn.close() ;
%>
如何解决此问题 我用的是SQLServer 2000数据库,已将3个包拷贝到common/lib下
server.xml已加入代码:
<Context path="/test" docBase="E:\study\JAVA\eclipse\workspace\hibernate1\" debug="5" reloadable="true" crossContext="true">
<Resource name="jdbc/jndibbs" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/jndibbs">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value>""</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bbs</value>
</parameter>
</ResourceParams>
</Context> web.xml代码: <?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.0" >
<resource-ref>
<description>bbs</description>
<res-ref-name>jdbc/jndibbs</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>测试代码 test.jsp:
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<%!
final String JNDINAME = "java:comp/env/jdbc/jndibbs" ;
%>
<%
Connection conn = null ;
try
{
Context ctx = new InitialContext() ;
DataSource ds = (DataSource)ctx.lookup(JNDINAME) ;
conn = ds.getConnection() ;
}
catch(Exception e)
{
System.out.println(e) ;
}
%>
<%=conn%>
<%
conn.close() ;
%>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货