Unable to create connection pool error in weblogic6.0

Discussions

EJB programming & troubleshooting: Unable to create connection pool error in weblogic6.0

  1. Friends

    When I try to create a connection pool in WL6.0 with service pack 2.It gives the following error.

    java.sql.SQLException: unable to create connection pool

    My url name,jdbc driver name(Oracle thin driver) are right.
    How can I solve this problem?

    Any help?
    Thanks

    Lawrence
  2. Lawrence,

    I'm using WLS 6.0sp1 with Oracle 8.1.7 and these are
    the settings that I'm successfully using:

    Name: fooPool
    URL: jdbc:oracle:thin:@localhost:1521:foo
    Driver Classname: oracle.jdbc.driver.OracleDriver
    Properties: user=aaa
                pasword=bbb

    You also need to make sure that the CLASSPATH is set
    to include the Oracle JDBC drivers:
    C:\oracle\ora81\jdbc\lib\classes12.zip
    C:\oracle\ora81\jdbc\lib\nls_charset12.zip (optional)
    If you are using a script such as startWebLogic.cmd,
    then update the CLASSPATH there.

    It's hard to guess what else may be the problem without
    seeing the error messages that you are receiving.

    Mark Ponthier
    SDSS, Inc.