spring反射时报的异常java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection

Question

你数据库连接池用的是什么？如果用dbcp建议最好换成proxool或c3po

Answer 1

数据源呢???
validateJarFile(F:\apache-tomcat-5.5.23\apache-tomcat-5.5.23\webapps\netctoss.myeclipse.bak\WEB-INF\lib\servlet-api.jar) - jar not loaded
你加载了相应的包没????

Answer 2

我重装了系统也没用，不知道还有什么原因会引起这个问题了。难道要我重买电脑不成？TOT

Answer 3

检查连接池的配置,SID,UserName,Password等

Answer 4

首先你需要在工程中引入proxool的jar包，然后需要在工程中创建连接池的配置文件
proxool.xml<?xml version="1.0" encoding="UTF-8"?>
<proxool-config>
  <proxool>
    <alias>acmsdb</alias>
    <driver-url>jdbc:oracle:thin:@192.168.1.168:1521:test</driver-url>
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <driver-properties>
      <property name="user" value="test"/>
      <property name="password" value="test"/>
    </driver-properties>
    
    <maximum-connection-count>100</maximum-connection-count>
    <house-keeping-sleep-time>60000</house-keeping-sleep-time>
    <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
  </proxool>
</proxool-config>
然后在web.xml中加入
 <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
   <servlet>
    <servlet-name>proxoolServletConfigurator</servlet-name>
    <servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
    <init-param>
      <param-name>xmlFile</param-name>
      <param-value>
      /WEB-INF/classes/proxool.xml
      </param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
  </servlet>
  <servlet>
    <servlet-name>proxooladmin</servlet-name>
    <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>proxooladmin</servlet-name>
    <url-pattern>/proxooladmin</url-pattern>
  </servlet-mapping>
   <servlet>
    <servlet-name>Admin</servlet-name>
      <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>
   </servlet>
   <servlet-mapping>
    <servlet-name>Admin</servlet-name>
    <url-pattern>/admin</url-pattern>
   </servlet-mapping> 
之后需要在spring的配置文件中加入
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  <property name="driverClassName"
value="org.logicalcobwebs.proxool.ProxoolDriver" />
<property name="url" value="proxool.acmsdb" />
</bean>
这样就应该OK了~~~

Answer 5

pengtao0615(Class 涛) 说的不错