View Issue Details

IDProjectCategoryView StatusLast Update
0006122SymmetricDSBugpublic2024-05-22 17:17
Reportergoulloum Assigned To 
Prioritynormal 
Status closedResolutionno change required 
Product Version3.15.1 
Summary0006122: Informix driver Could not get a connection to the database: Cannot create PoolableConnectionFactory
DescriptionWhen creating a node for informix DB :

[corp-000] - ClientSymmetricEngine - Could not get a connection to the database: Cannot create PoolableConnectionFactory (Method not supported : IfxSqliConnect.isValid(int)). Waiting for 10 seconds before trying to connect to the database again. java.sql.SQLException: Cannot create PoolableConnectionFactory (Method not supported : IfxSqliConnect.isValid(int))
        at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:653)
        at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:531)
        at org.jumpmind.db.util.ResettableBasicDataSource.createDataSource(ResettableBasicDataSource.java:55)
        at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:731)
        at org.jumpmind.symmetric.ClientSymmetricEngine.waitForAvailableDatabase(ClientSymmetricEngine.java:452)
        at org.jumpmind.symmetric.ClientSymmetricEngine.createDatabasePlatform(ClientSymmetricEngine.java:363)
        at org.jumpmind.symmetric.ClientSymmetricEngine.createDatabasePlatform(ClientSymmetricEngine.java:327)
        at org.jumpmind.symmetric.ClientSymmetricEngine.createDatabasePlatform(ClientSymmetricEngine.java:320)
        at org.jumpmind.symmetric.AbstractSymmetricEngine.init(AbstractSymmetricEngine.java:267)
        at org.jumpmind.symmetric.ClientSymmetricEngine.init(ClientSymmetricEngine.java:197)
        at org.jumpmind.symmetric.web.ServerSymmetricEngine.init(ServerSymmetricEngine.java:80)
        at org.jumpmind.symmetric.ClientSymmetricEngine.<init>(ClientSymmetricEngine.java:148)
        at org.jumpmind.symmetric.web.ServerSymmetricEngine.<init>(ServerSymmetricEngine.java:59)
        at org.jumpmind.symmetric.web.SymmetricEngineHolder.create(SymmetricEngineHolder.java:347)
        at org.jumpmind.symmetric.web.SymmetricEngineStarter.run(SymmetricEngineStarter.java:38)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
        at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: java.sql.SQLException: Method not supported : IfxSqliConnect.isValid(int)
        at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:488)
        at com.informix.jdbc.IfxSqliConnect.isValid(IfxSqliConnect.java:7921)
        at org.apache.commons.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:590)
        at org.apache.commons.dbcp2.PoolableConnection.validate(PoolableConnection.java:334)
        at org.apache.commons.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:653)
        at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:109)
        at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:649)
        ... 17 more
TagsNo tags attached.

Activities

elong

2023-11-23 14:20

developer   ~0002399

Add this line to your engine property file:

db.validation.query=select 1

Let us know if that resolves it.

pmarzullo

2023-11-29 18:51

developer   ~0002401

Did the additional property in the engine file fix the issue?

Issue History

Date Modified Username Field Change
2023-11-23 14:12 goulloum New Issue
2023-11-23 14:20 elong Note Added: 0002399
2023-11-29 18:51 pmarzullo Assigned To => pmarzullo
2023-11-29 18:51 pmarzullo Status new => feedback
2023-11-29 18:51 pmarzullo Note Added: 0002401
2024-05-22 17:17 emiller Assigned To pmarzullo =>
2024-05-22 17:17 emiller Status feedback => closed
2024-05-22 17:17 emiller Resolution open => no change required