Hello, I'm using JdbcDataSource to get a connection from the connection pool.
Everything work well. So I started to kill session in the the database, everything ok, it just create on other connedtion. When I deconnect the PC from the network, the pool just wait and start again when I plug back the pc to the network. But when I kill the database service running on the same PC, I get this message and my programs stop riht away: java.sql.SQLException: Exception d'E/S: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135290880)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(BUF='32-bit Windows Error: 2: No such file or directory')))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269) at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:210) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:251) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:224) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:139) at org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(AbstractPool.java:82) at org.apache.avalon.excalibur.pool.HardResourceLimitingPool.newPoolable(HardResourceLimitingPool.java:95) at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.newPoolable(JdbcConnectionPool.java:74) at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.get(JdbcConnectionPool.java:154) at org.apache.avalon.excalibur.datasource.JdbcDataSource.getConnection(JdbcDataSource.java:201) at TestPool.main(TestPool.java:57) Process terminated with exit code 0 Or, if I try to stop the service properly, this message: java.sql.SQLException: ORA-01089: immediate shutdown in progress - no operations are permitted at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:429) at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:224) at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:198) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:251) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:224) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:139) at org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(AbstractPool.java:82) at org.apache.avalon.excalibur.pool.HardResourceLimitingPool.newPoolable(HardResourceLimitingPool.java:95) at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.newPoolable(JdbcConnectionPool.java:74) at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.get(JdbcConnectionPool.java:154) at org.apache.avalon.excalibur.datasource.JdbcDataSource.getConnection(JdbcDataSource.java:201) at TestPool.main(TestPool.java:57) Process terminated with exit code 0 I was thinking that the service would wait until it can reconnect to the database: I'm my wrong? What should I do so the pool don't stop? Thanks Franck
