01-19-2018 03:53 AM - edited 06-04-2019 02:36 AM
The connection was working fine around a month ago. But currently I have got the following when trying to connect
```
Exception in thread "main" java.sql.SQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
com.compositesw.common.pool.PoolableInvalidException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at com.compositesw.common.pool.jdbc.JdbcConnectionFactory.create(JdbcConnectionFactory.java:134)
at com.compositesw.common.pool.jdbc.JdbcConnectionFactory.create(JdbcConnectionFactory.java:26)
at com.compositesw.common.pool.Pool.createTimedPoolable(Pool.java:1620)
at com.compositesw.common.pool.Pool.checkOut(Pool.java:495)
at com.compositesw.common.pool.Pool.checkOut(Pool.java:333)
at com.compositesw.server.repository.internal.JdbcRepository.fetchResourceState(JdbcRepository.java:1437)
at com.compositesw.server.repository.internal.RepositoryImpl.getResourceState(RepositoryImpl.java:1388)
at com.compositesw.server.repository.internal.RepositoryConnectionImpl.getResourceInternal(RepositoryConnectionImpl.java:1087)
at com.compositesw.server.repository.internal.RepositoryConnectionImpl.getResourceInternal(RepositoryConnectionImpl.java:1038)
at com.compositesw.server.repository.internal.ContainerImpl.getResourceInternal(ContainerImpl.java:318)
at com.compositesw.server.repository.internal.RepositoryConnectionImpl.getResourceInternal(RepositoryConnectionImpl.java:497)
at com.compositesw.server.repository.internal.RepositoryConnectionImpl.getResource(RepositoryConnectionImpl.java:431)
at com.compositesw.server.dbchannel.CsSessionManager.startSession(CsSessionManager.java:111)
at com.compositesw.server.dbchannel.ServerChannelConnection.startSession(ServerChannelConnection.java:395)
at com.compositesw.server.dbchannel.ServerCommand.init(ServerCommand.java:439)
at com.compositesw.server.dbchannel.ServerCommand.dispatchCommand(ServerCommand.java:124)
at com.compositesw.server.dbchannel.ServerCommand.run(ServerCommand.java:86)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:138)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:32)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at com.compositesw.common.pool.jdbc.JdbcConnectionInitiator.createConnection(JdbcConnectionInitiator.java:60)
at com.compositesw.common.pool.jdbc.JdbcConnectionInitiator.initiateConnection(JdbcConnectionInitiator.java:50)
at com.compositesw.common.pool.jdbc.JdbcConnectionFactory.initiateConnection(JdbcConnectionFactory.java:145)
at com.compositesw.common.pool.jdbc.JdbcConnectionFactory.create(JdbcConnectionFactory.java:102)
... 19 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.postgresql.core.PGStream.<init>(PGStream.java:62)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
... 31 more
at cs.jdbc.driver.ClientChannelConnection.checkErrorResponse(ClientChannelConnection.java:1099)
at cs.jdbc.driver.ClientChannelConnection.invokeCommand(ClientChannelConnection.java:1051)
at cs.jdbc.driver.ClientChannelConnection.init(ClientChannelConnection.java:1153)
at cs.jdbc.driver.ClientChannelConnection.<init>(ClientChannelConnection.java:220)
at cs.jdbc.driver.CompositeConnection.getChannel(CompositeConnection.java:179)
at cs.jdbc.driver.DatabaseMetaDataImpl.<init>(DatabaseMetaDataImpl.java:44)
at cs.jdbc.driver.CompositeConnection.<init>(CompositeConnection.java:137)
at cs.jdbc.driver.CompositeDriver.connect(CompositeDriver.java:62)
at cs.jdbc.driver.CompositeDriver.connect(CompositeDriver.java:25)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
```
I have connected to Lab VPN and double checked the credentials I use but still no luck. Any suggestions might help
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide