问一个问题,struts中使用proxool连接池连接oracle数据库,怎么发生下列错误了?求救!!!!
proxool.xml配置:
<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
<proxool>
<alias>ricky</alias>
<driver-url>jdbc:oracle:thin:@52.12.48.221:1521:QXTERM</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="QXTERM"/>
<property name="password" value="QXTERM"/>
</driver-properties>
<maximum-connection-count>500</maximum-connection-count>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
</proxool>
</something-else-entirely>
程序中加载:
public static Connection getConnection()
{
Connection ret = null;
try
{
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
ret = DriverManager.getConnection("proxool.ricky");
}
catch (SQLException e)
{
Log.getLogger().fatal("获得数据库连接失败。", e);
}
catch (ClassNotFoundException e)
{
Log.getLogger().fatal("获得数据库连接失败。", e);
}
return ret;
}
我在启动项目的时候发生如下报错,真困扰人:
java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:260)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)