Hi sirs,
I am using SmartClient 6.5.1 with Tomcat 6.0 and ORACLE 11. I want to activte the connection pooling. After setting the parameter "pooling.default.whenExhaustedAction":"block" the JVM can only read one file.
For the next file the JVM get a time out. It seems, there is no pool.
Where is my mistake?
Here is a part of my configview:
Merged Configuration (interpolated):
"datasources.enableUpToDateCheck":"true",
"datasources.pool.enabled":"true",
"datasources.pool.maxActive":"5",
"datasources.pool.maxIdle":"5",
"datasources.pool.minEvictableIdleTimeMillis":"5000",
"datasources.pool.numTestsPerEvictionRun":"5",
"datasources.pool.testOnBorrow":"false",
"datasources.pool.testOnReturn":"true",
"datasources.pool.testWhileIdle":"true",
"datasources.pool.timeBetweenEvictionRunsMillis":"10000",
"datasources.simpleModeList":"supplyItem supplyCategory animals
....
"pooling.default.maxActive":"5",
"pooling.default.maxIdle":"5",
"pooling.default.maxWait":"5000",
"pooling.default.minEvictableIdleTimeMillis":"5000",
"pooling.default.numTestsPerEvictionRun":"5",
"pooling.default.testOnBorrow":"false",
"pooling.default.testOnReturn":"true",
"pooling.default.testWhileIdle":"true",
"pooling.default.timeBetweenEvictionRunsMillis":"10000",
"pooling.default.whenExhaustedAction":"block",
.....
"sql.Oracle.database.supportsSQLLimit":"false",
"sql.Oracle.database.type":"oracle",
"sql.Oracle.driver":"oracle.jdbc.pool.OracleDataSource",
"sql.Oracle.driver.context":"_container_",
"sql.Oracle.driver.databaseName":"xxx",
"sql.Oracle.driver.driverType":"thin",
"sql.Oracle.driver.networkProtocol":"tcp",
"sql.Oracle.driver.password":"xxx",
"sql.Oracle.driver.portNumber":"1521",
"sql.Oracle.driver.serverName":"xxxx",
"sql.Oracle.driver.user":"xxxx",
"sql.Oracle.interface.type":"dataSource",
"sql.Oracle.pool.enabled":"true",
"sql.Oracle_JNDI.driver.context":"sqlDataSources",
"sql.Oracle_JNDI.driver.name":"Oracle",
"sql.oracle.pingTest":"select 1 from dual",
"sql.oracle.quoteColumnNames":"true",
....
"sql.pool.enabled":"true",
"sql.pool.maxActive":"5",
"sql.pool.maxIdle":"5",
"sql.pool.minEvictableIdleTimeMillis":"5000",
"sql.pool.numTestsPerEvictionRun":"5",
"sql.pool.testOnBorrow":"true",
"sql.pool.testWhileIdle":"true",
"sql.pool.timeBetweenEvictionRunsMillis":"10000",
"sql.poold.testOnReturn":"true",
"sql.postgresql.quoteColumnNames":"true",
"sql.sqlserver.quoteColumnNames":"false",
....
and here is my startup protocol:
.....
=== 2009-02-05 14:51:33,593 [main] INFO PreCache - Isomorphic PreCache servlet loading
=== 2009-02-05 14:51:33,859 [main] DEBUG XML - Parsed XML from D:\Tomcat 6.0\webapps\SDE\isomorphic\system\schema\DataSource.ds.xml: 16ms
=== 2009-02-05 14:51:33,859 [main] DEBUG XML - Parsed XML from D:\Tomcat 6.0\webapps\SDE\isomorphic\system\schema\builtinTypes.xml: 0ms
Problem loading builtinTypes.xml
Exception when loading from D:/Tomcat 6.0/webapps/SDE/isomorphic/system/schema/builtinTypes.xml:
java.util.NoSuchElementException: Timeout waiting for idle object
at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:827)
at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:70)
at com.isomorphic.datasource.DataSourceManager.getDataSource(DataSourceManager.java:56)
at com.isomorphic.datasource.ValidationContext.getType(ValidationContext.java:160)
at com.isomorphic.datasource.BasicDataSource.handleExtraElementValue(BasicDataSource.java:763)
at com.isomorphic.datasource.BasicDataSource.elementAsRecord(BasicDataSource.java:739)
at com.isomorphic.datasource.BasicDataSource.toRecord(BasicDataSource.java:431)
at com.isomorphic.datasource.BasicDataSource.toRecords(BasicDataSource.java:393)
at com.isomorphic.datasource.DataSource.recordsFromXML(DataSource.java:586)
at com.isomorphic.xml.XML.toDSRecords(XML.java:250)
....
Thank you for your efforts
best regards
I am using SmartClient 6.5.1 with Tomcat 6.0 and ORACLE 11. I want to activte the connection pooling. After setting the parameter "pooling.default.whenExhaustedAction":"block" the JVM can only read one file.
For the next file the JVM get a time out. It seems, there is no pool.
Where is my mistake?
Here is a part of my configview:
Merged Configuration (interpolated):
"datasources.enableUpToDateCheck":"true",
"datasources.pool.enabled":"true",
"datasources.pool.maxActive":"5",
"datasources.pool.maxIdle":"5",
"datasources.pool.minEvictableIdleTimeMillis":"5000",
"datasources.pool.numTestsPerEvictionRun":"5",
"datasources.pool.testOnBorrow":"false",
"datasources.pool.testOnReturn":"true",
"datasources.pool.testWhileIdle":"true",
"datasources.pool.timeBetweenEvictionRunsMillis":"10000",
"datasources.simpleModeList":"supplyItem supplyCategory animals
....
"pooling.default.maxActive":"5",
"pooling.default.maxIdle":"5",
"pooling.default.maxWait":"5000",
"pooling.default.minEvictableIdleTimeMillis":"5000",
"pooling.default.numTestsPerEvictionRun":"5",
"pooling.default.testOnBorrow":"false",
"pooling.default.testOnReturn":"true",
"pooling.default.testWhileIdle":"true",
"pooling.default.timeBetweenEvictionRunsMillis":"10000",
"pooling.default.whenExhaustedAction":"block",
.....
"sql.Oracle.database.supportsSQLLimit":"false",
"sql.Oracle.database.type":"oracle",
"sql.Oracle.driver":"oracle.jdbc.pool.OracleDataSource",
"sql.Oracle.driver.context":"_container_",
"sql.Oracle.driver.databaseName":"xxx",
"sql.Oracle.driver.driverType":"thin",
"sql.Oracle.driver.networkProtocol":"tcp",
"sql.Oracle.driver.password":"xxx",
"sql.Oracle.driver.portNumber":"1521",
"sql.Oracle.driver.serverName":"xxxx",
"sql.Oracle.driver.user":"xxxx",
"sql.Oracle.interface.type":"dataSource",
"sql.Oracle.pool.enabled":"true",
"sql.Oracle_JNDI.driver.context":"sqlDataSources",
"sql.Oracle_JNDI.driver.name":"Oracle",
"sql.oracle.pingTest":"select 1 from dual",
"sql.oracle.quoteColumnNames":"true",
....
"sql.pool.enabled":"true",
"sql.pool.maxActive":"5",
"sql.pool.maxIdle":"5",
"sql.pool.minEvictableIdleTimeMillis":"5000",
"sql.pool.numTestsPerEvictionRun":"5",
"sql.pool.testOnBorrow":"true",
"sql.pool.testWhileIdle":"true",
"sql.pool.timeBetweenEvictionRunsMillis":"10000",
"sql.poold.testOnReturn":"true",
"sql.postgresql.quoteColumnNames":"true",
"sql.sqlserver.quoteColumnNames":"false",
....
and here is my startup protocol:
.....
=== 2009-02-05 14:51:33,593 [main] INFO PreCache - Isomorphic PreCache servlet loading
=== 2009-02-05 14:51:33,859 [main] DEBUG XML - Parsed XML from D:\Tomcat 6.0\webapps\SDE\isomorphic\system\schema\DataSource.ds.xml: 16ms
=== 2009-02-05 14:51:33,859 [main] DEBUG XML - Parsed XML from D:\Tomcat 6.0\webapps\SDE\isomorphic\system\schema\builtinTypes.xml: 0ms
Problem loading builtinTypes.xml
Exception when loading from D:/Tomcat 6.0/webapps/SDE/isomorphic/system/schema/builtinTypes.xml:
java.util.NoSuchElementException: Timeout waiting for idle object
at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:827)
at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:70)
at com.isomorphic.datasource.DataSourceManager.getDataSource(DataSourceManager.java:56)
at com.isomorphic.datasource.ValidationContext.getType(ValidationContext.java:160)
at com.isomorphic.datasource.BasicDataSource.handleExtraElementValue(BasicDataSource.java:763)
at com.isomorphic.datasource.BasicDataSource.elementAsRecord(BasicDataSource.java:739)
at com.isomorphic.datasource.BasicDataSource.toRecord(BasicDataSource.java:431)
at com.isomorphic.datasource.BasicDataSource.toRecords(BasicDataSource.java:393)
at com.isomorphic.datasource.DataSource.recordsFromXML(DataSource.java:586)
at com.isomorphic.xml.XML.toDSRecords(XML.java:250)
....
Thank you for your efforts
best regards
Comment