I have been stuck on this for a while now. My connection configuration is present in spring application context and it used to work perfectly fine for a test db. When i moved to a prod DB, it gives an error saying that is "Cannot Create PoolableConnectionFactory". I tried to create a raw java Connection and query the DB and it worked fine. Following is the stack trace :


Caused by: org.springframework.jdbc.CannotGetJdbcConnectionEx ception: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection)
at org.springframework.jdbc.datasource.DataSourceUtil s.getConnection(DataSourceUtils.java:82)
at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:382)
at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:458)
at org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:466)
at com.amazon.tips.InvoicePlugin.OutboundInvoicePlugi n.getUnprocessedInvoices(OutboundInvoicePlugin.jav a:327)
... 3 more

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection)
at org.apache.commons.dbcp.BasicDataSource.createPool ableConnectionFactory(BasicDataSource.java:1549)
at org.apache.commons.dbcp.BasicDataSource.createData Source(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnect ion(BasicDataSource.java:1044)
at org.springframework.jdbc.datasource.DataSourceUtil s.doGetConnection(DataSourceUtils.java:113)
at org.springframework.jdbc.datasource.DataSourceUtil s.getConnection(DataSourceUtils.java:79)
... 7 more

Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:145)
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:190)
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:363)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnecti on.java:401)
at oracle.jdbc.driver.PhysicalConnection.<init>(Physi calConnection.java:447)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnect ion.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnectio n(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:839)
at org.apache.commons.dbcp.DriverConnectionFactory.cr eateConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory. makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.dbcp.BasicDataSource.validateCo nnectionFactory(BasicDataSource.java:1556)
at org.apache.commons.dbcp.BasicDataSource.createPool ableConnectionFactory(BasicDataSource.java:1545)
... 11 more

I am banging my head on the wall. Can i get some help with this ?