Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Failed to connect to Postgresql db using JDBC Multitable Consumer

Hi,

I attempted this issue when I connect to Postgresql JDBC table:

"Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: The connection attempt failed"

Just wanna know the root cause of causing this issue.

I had referred to this answer: https://ask.streamsets.com/question/368/jdbc_06-failed-to-initialize-connection-pool-comzaxxerhikaripoolpoolinitializationexception-exception-during-pool-initialization-io-error-the-network/

But I still dont have clue on how to fix. May I know there is any suggestions on fixing this issue.

Thanks