Guys,
I am facing the following issue when I am trying to connect to Kx database using KDB provided JDBC jar file. I am suspecting the application which i am trying to connect to KDB is the culprit for the below. But, i like to know the thoughts/depth of this issue from Kx Developers team also.
Anticipating your finding if any.
com.informatica.cep.sc.dataadapter.api.IOAdapterException: com.informatica.cep.sc.dataadapter.api.IOAdapterException: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out. at com.informatica.cep.services.builtin.adapters.input.JDBCInputAdapter.pollInput(JDBCInputAdapter.java:95) at com.informatica.cep.sc.datasource.InputDatasource.poll(InputDatasource.java:109) at com.informatica.cep.sc.scheduling.quartz.ServiceJob.execute(ServiceJob.java:114) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) Caused by: com.informatica.cep.sc.dataadapter.api.IOAdapterException: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out. at com.informatica.cep.services.builtin.adapters.input.JDBCPooledConnectionInputAdapter.query(JDBCPooledConnectionInputAdapter.java:197) at com.informatica.cep.services.builtin.adapters.input.JDBCInputAdapter.pollInput(JDBCInputAdapter.java:82) at com.informatica.cep.sc.datasource.InputDatasource.poll(InputDatasource.java:109) at com.informatica.cep.sc.scheduling.quartz.ServiceJob.execute(ServiceJob.java:114) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) Caused by: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out. at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:527) at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128) at com.informatica.cep.services.builtin.adapters.input.JDBCPooledConnectionInputAdapter.query(JDBCPooledConnectionInputAdapter.java:149) at com.informatica.cep.services.builtin.adapters.input.JDBCInputAdapter.pollInput(JDBCInputAdapter.java:82) at com.informatica.cep.sc.datasource.InputDatasource.poll(InputDatasource.java:109) at com.informatica.cep.sc.scheduling.quartz.ServiceJob.execute(ServiceJob.java:114) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@4a245d6d – timeout at awaitAvailable() at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1317) at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557) at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525) at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128) at com.informatica.cep.services.builtin.adapters.input.JDBCPooledConnectionInputAdapter.query(JDBCPooledConnectionInputAdapter.java:149) at com.informatica.cep.services.builtin.adapters.input.JDBCInputAdapter.pollInput(JDBCInputAdapter.java:82) at com.informatica.cep.sc.datasource.InputDatasource.poll(InputDatasource.java:109) at com.informatica.cep.sc.scheduling.quartz.ServiceJob.execute(ServiceJob.java:114) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)