Discussions

EJB programming & troubleshooting: Connection pool creation problem Oracle thin driver, WLS 5.1

  1. Hi

    I am using weblogic 5.1, win2k and oracle 8.1.6 and oracle thin 8.1.6 drivers. In my weblogic properties file
    I have as followis (as per the thin driver documentation)

    url=jdbc:oracle:thin:user/pwd@localhost:1521:test,\
    driver=oracle.jdbc.driver.OracleDriver,\

    When I start the weblogic, when it comes to creating connection pool it gives the error as follows

    oracle.net.TNSAddress.SOException
            at oracle.net.TNSAddress.ServiceAlias.initFromNV

    But the funny part is the same set up is working for the persistence builder (visual cafe) table mapping.

    Any help is appreciated

    Thanks
    Srinivas
  2. Hi every body,

    The problem is solved.

    The solution is : "server=test" has to be removed for thin driver as oracle SID in URL will take care of it.

    Thanks
    Srinivas