El pool de conexiones de Acceso Cabal, está basado en el driver de Tomcat. Ejemplo de configuración: | Code Block |
|---|
| language | actionscript3 |
|---|
| theme | Eclipse |
|---|
| title | En Tomcat -> server.xml |
|---|
| collapse | true |
|---|
| <GlobalNamingResources>
<Resource
name="jdbc/commercePortalDB"
auth="Container"
factory="oracle.ucp.jdbc.PoolDataSourceImpl"
type="oracle.ucp.jdbc.PoolDataSource"
description="Commerce portal data source"
connectionFactoryClassName="oracle.jdbc.pool.OracleDataSource"
initialPoolSize="2"
minPoolSize="2"
maxPoolSize="4"
inactiveConnectionTimeout="5"
user="portal"
password="portal"
url="jdbc:oracle:thin:@10.5.2.16:1521:BAPY"
connectionPoolName="ComercePortalPol"
validateConnectionOnBorrow="true"
sqlForValidateConnection="select 1 from DUAL" />
</GlobalNamingResources> |
| Code Block |
|---|
| language | actionscript3 |
|---|
| theme | Eclipse |
|---|
| title | En Tomcat -> context.xml |
|---|
| collapse | true |
|---|
| <Context>
<ResourceLink name="jdbc/commercePortalDB" global="jdbc/commercePortalDB" type="javax.sql.DataSource" />
</Context> |
Links importantes: http://redmine.cabal.coop.py/projects/dpto-informaticb/wiki/Pool_de_conexiones
| 