tomcat连接oracle连接不上
server.xml配置
<ResourceParams name="jdbc/test">
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
<parameter>
<name>password</name>
<value>tiger</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@192.168.123.16:1521:shan</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>username</name>
<value>scott</value>
</parameter>
</ResourceParams>
index.jsp内容
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.naming.*"%>
<%@ page import="javax.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD
HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body>
<%
Context initContext = new InitialContext();
Context envContext = (Context) initContext.lookup("java:/comp/test");
DataSource db = (DataSource) envContext.lookup("jdbc/test");
//javablogorl为<Resource>元素中name属性的值
Connection conn = db.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM emp");
while (rs.next()) {
out.print(rs.getString("empno") + " ");
out.print(rs.getString("ename") + "<br>");
}
rs.close();
stmt.close();
conn.close();
%>
</bady>
</html>
执行index.jsp时页面会报出
javax.servlet.ServletException: Name test is not bound in this Context
这个错误，不知道哪里设置有问题，请高手指导！
最新回答
风清淡雅
2024-09-30 11:32:13
Connection conn = db.getConnection();
如果没记错的话
连接池应该这样写吧
你那错误提示意思就是那个连接池的名字没找到好像是你写错了
热门标签
