Discussions

EJB design: Weblogic JDBC connection pooling

  1. Weblogic JDBC connection pooling (4 messages)

    Anybody used weblogic connection pooling using oracle thin drivers?
     do I have to use weblogic jDrivers inorder to use connection pooling?. I would appreciate any code snippets on how to use the weblogic connection pooling,

    thanks,
    Srinivas

    Threaded Messages (4)

  2. Hi,

    In my experience I used Oracle JDBC Driver (classes111.zip) a lot with WebLogic. Here the part of the weblogic.properties that declares connection pool:
      weblogic.jdbc.connectionPool.TestDataSource=\
           url=jdbc:oracle:thin:@db_host:1521:orcl,\
           driver=oracle.jdbc.driver.OracleDriver,\
           loginDelaySecs=1,\
           initialCapacity=4,\
           maxCapacity=10,\
           capacityIncrement=2,\
           allowShrinking=true,\
           shrinkPeriodMins=15,\
           refreshMinutes=10,\
           testTable=dual,\
           props=user=test_user;password=test_password
    Also, look into the WebLogic documentation they have enough information.

    Best regards,

    Taras
  3. Sorry, one more thing...

    Do not gforget to add path to the Oracle JDBC Driver classes to the weblogic classpath, you can use wlconfig.exe utility to do that.

    Best regards,

    Taras
  4. I've used classes111.zip and classes12.zip and experienced no problems. It is a configuration exercise and there is already a good post on this.

    We are about to move off the thin drivers as automatic failover in a clustered db environment is non-existent. You may or may not care about this, but worth bearing in mind. That said, swapping the drivers later is easy.

    Mark
  5. Weblogic JDBC connection pooling[ Go to top ]

    I use oracle Type 4 thin JDBC driver. But you'd better create a datasource first and then point to oraclePool.