java.sql.SQLException: Io exception: No route to host

[bongdadienanh1]

Hi all,

I'm using bonecp but when running the application I get an error "
java.sql.SQLException: Io exception: No route to host
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:815)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:197)
at com.viettel.ussdPay.receiver.services.USSDPayBusiness.executeResponse(USSDPayBusiness.java:342)
at com.viettel.ussdPay.receiver.services.USSDPayBusiness.executeResponse(USSDPayBusiness.java:308)
at com.viettel.ussdPay.receiver.process.ThreadUSSDResponse.process(ThreadUSSDResponse.java:48)
at com.viettel.mmserver.base.ProcessThread.run(ProcessThread.java:125)
at java.lang.Thread.run(Unknown Source)
"

I do not know because this is an error or a connection pool by the way my network problem you helped me with.

My application has about 30 processes running independently I use setMaxConnectionsPerPartition (8), I should set up setPartitionCount is how much?

[wwadge]

That just means: it cannot connect to your database i.e. it's a network problem.

Check your jdbcURL configuration.