Oracle DataSource Class Difference

fpereira.743203 · June 30, 2009, 12:11am

Hi,

I was wondering what is the difference between using in my jdbc connection one of the following:

1 - oracle.jdbc.pool.OracleDataSource
2 - oracle.jdbc.pool.OracleConnectionPoolDataSource

I’m using Oracle 9i and jdbc driver

/opt/webMethods7/IntegrationServer/packages/WmJDBCAdapter/code/jars/static/ojdbc14.jar

/opt/webMethods7/IntegrationServer/packages/WmJDBCAdapter/code/jars/static/ocrs12.zip

My webMethods version is 7.1.1

Thanks,

Percio_Castro · June 30, 2009, 7:27pm

One implements pooling and the other one doesn’t. For use with the JDBC Adapter, just use the regular OracleDataSource since pooling is handled by the webMethods adapter framework itself.

Percio

Topic		Replies	Views
Difference between JDBC Pools and JDBC Adapter Connection Pools webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	3	5274	April 2, 2021
DB connection pooling webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	4	2476	April 2, 2021
Importance of JDBC pooling in JDBC conn webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	2	2296	April 2, 2021
JDBC Pools webMethods , webMethods-General , webMethods-Upgrade , Integration-Server-and-ESB	2	579	April 2, 2021
JDBC Adapter webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	2	1072	April 2, 2021

Oracle DataSource Class Difference

Related topics