The Connection Pool in Weblogic Server.


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: The Connection Pool in Weblogic Server.

Hybrid View

  1. #1
    Vikas Arora Guest

    The Connection Pool in Weblogic Server.


    Hi Everbody,
    I am using Weblogic with Oracle8i on WindowsNT4.0
    I am connecting to Weblogic via Connection Pooling.
    In my weblogic.properties file I have the following code:

    weblogic.jdbc.connectionPool.oraclePool=\
    url=jdbc:weblogicracle,\
    driver=weblogic.jdbc.oci.Driver,\
    loginDelaySecs=1,\
    initialCapacity=4,\
    maxCapacity=10,\
    capacityIncrement=2,\
    allowShrinking=true,\
    shrinkPeriodMins=15,\
    refreshMinutes=10,\
    testTable=dual,\
    props=user=SCOTT;password=tiger;server=Oracle8
    [I am able to connect to DB by SQL Plus with given parameters]

    But when I write it in My Servlet:

    Class.forName("weblogic.jdbc.pool.Driver");
    conn = DriverManager.getConnection"jdbc:weblogicoolraclePool");

    I am getting the Error and not able to connect to the DB.The error raised
    is:
    java.SQL.Exception: Poolconnect failed: Connection Pool oraclePool does not
    exist.

    Can anybodyof you tell me that what might be the problem??? How I can rectify
    it????
    TIA.



  2. #2
    Steve Franklin Guest

    Re: The Connection Pool in Weblogic Server.


    "Vikas Arora" <vikas_arora80@rediffmail.com> wrote:
    >I am getting the Error and not able to connect to the DB.The error raised
    >is:
    >java.SQL.Exception: Poolconnect failed: Connection Pool oraclePool
    >does not exist.


    Hi Vikas,

    You should be able to confirm that the connection pool is
    being created on startup via the weblogic.log associated with
    your app server instance. Look for errors there. Also, you can
    take the raw parameters and write a small jdbc app/applet that
    connects to the database directly. That can help you to test
    your drivers, URI, etc. Other than that, this is a tricky thing
    to troubleshoot and you may simply have to go back to the docs
    to make sure you're doing everything correctly.

    Steve


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center