1 Reply Latest reply on Apr 30, 2003 2:54 AM by Jon Barnett

    Jboss.jcml for Connection Pooling with oracle 8i

    Seet Seet Newbie

      Hi all,

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

      If yes, pls. post the snippet.

      Seetesh

        • 1. Re: Jboss.jcml for Connection Pooling with oracle 8i
          Jon Barnett Master

          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.