TomCat连接池问题(在线等待!)
我配好了server.xml和web.xml文件。
server.xml:----------------------------
<Context path="/tom" docBase="tom" debug="0"
reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_tom_log." suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/OracleDB"
auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/OracleDB">
<parameter><name>factory</name><value>org.apache.commons.dbcp.BasicDataSourceFactory</value></parameter>
<parameter><name>maxActive</name><value>20</value></parameter>
<parameter><name>maxIdle</name><value>10</value></parameter>
<parameter><name>maxWait</name><value>10000</value></parameter>
<parameter><name>username</name><value>scott</value></parameter>
<parameter><name>password</name><value>tiger</value></parameter>
<parameter><name>driverClassName</name><value>oracle.jdbc.driver.OracleDriver</value></parameter>
<parameter><name>url</name><value>jdbc:oracle:thin:@localhost:1521:ora8i</value></parameter>
</ResourceParams>
</Context>
web.xml:--------------------------------------------------
<web-app>
<display-name>Welcome to Tomcat</display-name>
<description>
Welcome to Tomcat
</description>
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/OracleDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
在程序中的代码如下:
Context ctx = new InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource)ctx.lookup("java:comp/env/jdbc/OracleDB");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
String sqlStr = "select * from emp";
ResultSet rs = stmt.executeQuery(sqlStr);
while(rs.next())
{
out.println(rs.getString("ename"));
}
----------------------------------
最后报错:
DBCP borrowObject failed: java.sql.SQLException: Io 异常: The Network Adapter co
uld not establish the connection
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Io 异常: The Netwo
rk Adapter could not establish the connection
请问各位,这是那里有问题阿?