Tomcat6.0事件源的配置

1.将文件tom-cat-users.xml最后的注释去掉（否则会弹出输入用户名密码框）:

<tomcat-users> ...... <role rolename="tomcat"/> <role rolename="role1"/> <user username="tomcat" password="tomcat" roles="tomcat"/> <user username="both" password="tomcat" roles="tomcat,role1"/> <user username="role1" password="tomcat" roles="role1"/> </tomcat-users>

2.在server.xml中添加内容:

<Context path="/TestJDBC" docBase="D:/CL/workspace/TestJDBC/WebRoot"> <Resource auth="Container" name="jdbc/oracleds" type="javax.sql.DataSource" maxWait="-1" maxIdle="10" maxAction="10" username="scott" password="tiger" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@127.0.0.1:1521:oracle" /> </Context>

3.将OJDBC14.JAR复制到 D:/apache-tomcat-6.0.26/lib 文件夹下

PS:

在Servlet中得到Connection对象：

Context context = new InitialContext(); DataSource ds = (DataSource) context.lookup("java:/comp/env/jdbc/oracleds"); Connection conn = ds.getConnection(); ...