Jboss.jcml for Connection Pooling with oracle 8i

[seeteshh]

Hi all,

Has anyone configured the jboss.jcml file to have a oracle 8i connection pool?

If yes, pls. post the snippet.

Seetesh

[jonlee]

Configure thus:


org.hsqldb.jdbcDriver,oracle.jdbc.driver.OracleDriver



false
AmityPool

org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl


jdbc:oracle:this:@address:port/database
1200000
DBUser
DBPassword
false
false
false
true
120000
1800000
false
false
1.0
10
0


Substitute in your DB login for DBUser and DBPassword. Make sure your JDBC URL is configured to connect to your database as per Oracle recommendations. Change your poolname from "AmityPool" to the actual JNDI name you want the pool to be called. Adjust your pool MinSize and MaxSize to your requirements.