配置连接池出错
mmxy 2004-09-15 10:22:44 server.xml文件加入:
<Context path="/" docBase="D:\test\" debug="0" >
<Resource name="jdbc/SqlServerDB" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/SqlServerDB">
......
</Context>
测试代码:
<%@ page import= "java.sql.* "%>
<%@ page import= "javax.naming.* "%>
<%
try{
Context initCtx = new InitialContext();
Context ctx = (Context) initCtx.lookup("java:comp/env");
//获取连接池对象
Object obj = (Object) ctx.lookup("jdbc/SqlServerDB");
//类型转换
javax.sql.DataSource ds = (javax.sql.DataSource)obj;
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String strSql = " insert into test(id,name) values('00001','holen') ";
stmt.executeUpdate(strSql);
出错信息:
D:\JmEport\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\test_jsp.java:60: cannot resolve symbol
symbol : class DataSource
location: package sql
javax.sql.DataSource ds = (javax.sql.DataSource)obj;
什么回事?