Unable 2 Create the Connection Pool Oracle Pool in Weblogic 5.1

Discussions

General J2EE: Unable 2 Create the Connection Pool Oracle Pool in Weblogic 5.1

  1. Hi,

    Iam getting the following exception in the weblogic log file when i have provided the following in the weblogic's properties file.

    weblogic.jdbc.connectionPool.myPool=\
    driver=sun.jdbc.odbc.JdbcOdbcDriver,\
    url=jdbc.Oracle:thin:@localhost:1521", \
           loginDelaySecs=1,\
           initialCapacity=4,\
           maxCapacity=10,\
           capacityIncrement=2,\
           allowShrinking=true,\
           shrinkPeriodMins=15,\
           refreshMinutes=10,\
           testTable=dual,\
           props=user=SCOTT;password=tiger;server=DEMO


    Iam getting the following messages at the weblogic log file
    Thu Sep 11 16:44:52 GMT+05:30 1997:<I> <JDBC Pool> Creating connection pool myPool with:
    {refreshMinutes=10, poolName=myPool, testTable=dual, maxCapacity=10, props=user=SCOTT;password=tiger;server=DEMO, allowShrinking=true, driver=sun.jdbc.odbc.JdbcOdbcDriver, loginDelaySecs=1, aclName=weblogic.jdbc.connectionPool.myPool, capacityIncrement=2, initialCapacity=4, url=jdbc.Oracle:thin:@localhost:1521", shrinkPeriodMins=15}
    Thu Sep 11 16:44:52 GMT+05:30 1997:<I> <JDBC Pool> Sleeping in createResource()
    Thu Sep 11 16:44:53 GMT+05:30 1997:<E> <JDBC Pool> Failed to create connection pool "myPool"
    weblogic.common.ResourceException: weblogic.common.ResourceException:
    Could not create pool connection. The DBMS driver exception was:
    DriverManager failed with 'No suitable driver' while trying to create
     a Connection for the 'myPool' pool. This indicates that the URL,

    jdbc.Oracle:thin:@localhost:1521"

     is not supported by the Driver

    sun.jdbc.odbc.JdbcOdbcDriver

     The acceptsURL method on sun.jdbc.odbc.JdbcOdbcDriver retured false
     for the url jdbc.Oracle:thin:@localhost:1521".

     The following is a list of currently loaded JDBC Drivers:
    weblogic.jdbc.pool.Driver
    sun.jdbc.odbc.JdbcOdbcDriver

    at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:182)
    at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:109)
    at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java, Compiled Code)

    I HAVE EVEN TRIED WITH THE WEBLOGIC OCI ,IAM GETTING A DIFFERENT EXCEPTION;


    CAN ANYONE HELP ME OUT IN SOLVING THE PROBLEM;
    IS THERE ANY PROBLEM WITH THE ORACLE OR ANY DRIVER 2 B INSTALLED WHATEVER ...
    THANK U
  2. this url --> jdbc.Oracle:thin
    is not supported by the jdbc:odbc drivers

    your url should look like this --> jdbc:odbc:xxx
    where xxx is your odbc data source.

    have a look at the this basic tutorial on jdbc first:
    http://java.sun.com/docs/books/tutorial/jdbc/basics/connecting.html
  3. Iam sorry I had given it as

    weblogic.jdbc.connectionPool.myPool=\
    driver=oracle.jdbc.driver.OracleDriver,\
            ur=jdbc.Oracle:thin:@localhost:1521,\
    loginDelaySecs=1,\
           initialCapacity=4,\
           maxCapacity=10,\
           capacityIncrement=2,\
           allowShrinking=true,\
           shrinkPeriodMins=15,\
           refreshMinutes=10,\
           testTable=dual,\
           props=user=SCOTT;password=tiger;server=DEMO

    By providing the above information in the weblogic5.1 Properties file
    am getting the following exception

    EXCEPTION AT THE WEBLOGIC LOG FILE:

    Creating connection pool myPool with:
    {refreshMinutes=10, poolName=myPool, loginDelaySecs=1, testTable=dual, maxCapacity=10, props=user=SCOTT;password=tiger;server=DEMO, allowShrinking=true, driver=oracle.jdbc.driver.OracleDriver, aclName=weblogic.jdbc.connectionPool.myPool, capacityIncrement=2, initialCapacity=4, shrinkPeriodMins=15, ur=jdbc.Oracle:thin:@localhost:1521}
    Fri Sep 12 17:30:56 GMT+05:30 1997:<E> <JDBC Pool> Failed to create connection pool "myPool"
    java.lang.Exception: Missing startup value "url" in JDBC Connection Pool myPool
    at weblogic.jdbc.common.internal.ConnectionPool.getPoolValue(ConnectionPool.java:359)
    at weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:246)
    at weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java, Compiled Code)
    at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
    at weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
    at java.lang.reflect.Method.invoke(Native Method)
    at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
    at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java, Compiled Code)
    at weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
  4. is that a typo or is your URL line spelled UR (missing the L)?
  5. Hi Dat Nguyen

    Thanx a lot for the information yah i had missed the letter
    "L" in the word "url".
    Now even after giving the proper things ,Iam still getting the following exception.


    Failed to create connection pool "myPool"
    weblogic.common.ResourceException: weblogic.common.ResourceException:
    Could not create pool connection. The DBMS driver exception was:
    DriverManager failed with 'No suitable driver' while trying to create
     a Connection for the 'myPool' pool. This indicates that the URL,

    jdbc.Oracle:thin:@localhost:1521

     is not supported by the Driver

    oracle.jdbc.driver.OracleDriver

     The acceptsURL method on oracle.jdbc.driver.OracleDriver retured false
     for the url jdbc.Oracle:thin:@localhost:1521.

     The following is a list of currently loaded JDBC Drivers:
    weblogic.jdbc.pool.Driver
    oracle.jdbc.driver.OracleDriver

    at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:182)



    I TRIED TO RUN THE SAME USING A SIMPLE MAIN STANDALONE APPLICATION WITH THE FOLLOWING CODE
    Object objc = Class.forName("oracle.jdbc.driver.OracleDriver");
    System.out.println("i am here 3");
          if(objc == null)
    System.out.println("not found");
    else
    System.out.println("found" );
    Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger"); N THE CODE FOLLOWS

    IAM GETTING THE EXCEPTION AS "NETWORK ADAPTER NOT FOUND"

    THANX



    ,BUT IAM GETTING
    EXCEPTIONS AS