hi,
I was not able to create a connection pool in weblogic 6.1 but the same url is working fine in weblogic 5.1
url=jdbc:oracle:thin:@(DESCRIPTION= (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.131.255.24)(PORT=1521)))(CONNECT_DATA=(INSTANCE_NAME=HERO)(SERVICE_NAME=HERO)))
and the driver is also in classpath. It's giving exception
oracle.net.TNSAddress.SOException
at oracle.net.TNSAddress.ServiceAlias.initFromNVPair(Unknown Source)
at oracle.net.TNSAddress.ServiceAlias.initFromString(Unknown Source)
at oracle.net.resolver.AddrResolution.resolveAddrTree(Unknown Source)
at oracle.net.resolver.AddrResolution.resolveAndExecute(Unknown Source)
at oracle.net.ns.NSProtocol.establishConnection(Unknown Source)
at oracle.net.ns.NSProtocol.connect(Unknown Source)
at oracle.jdbc.ttc7.TTC7Protocol.connect(TTC7Protocol.java:1213)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:209)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:246)
-
weblogic6.1 creating connection pool error (3 messages)
- Posted by: Deepak Rustagi
- Posted on: June 13 2002 00:52 EDT
Threaded Messages (3)
- weblogic6.1 creating connection pool error by Matthew Machczynski on June 13 2002 12:21 EDT
- weblogic6.1 creating connection pool error by Jim Clark on June 13 2002 13:07 EDT
- weblogic6.1 creating connection pool error by Matthew Machczynski on June 13 2002 04:41 EDT
- weblogic6.1 creating connection pool error by Jim Clark on June 13 2002 13:07 EDT
-
weblogic6.1 creating connection pool error[ Go to top ]
- Posted by: Matthew Machczynski
- Posted on: June 13 2002 12:21 EDT
- in response to Deepak Rustagi
It looks like an LD_LIBRARY_PATH issue
SOException typically stands for shared object, so it probably can't read the .so files it needs to from oracle....just mod the LD_LIBRARY_PATH to include it appropriately.
m. -
weblogic6.1 creating connection pool error[ Go to top ]
- Posted by: Jim Clark
- Posted on: June 13 2002 13:07 EDT
- in response to Matthew Machczynski
Though it looks as if he's using the thin driver, so he shouldn't need any native code (i.e. .so files)
Jim -
weblogic6.1 creating connection pool error[ Go to top ]
- Posted by: Matthew Machczynski
- Posted on: June 13 2002 16:41 EDT
- in response to Jim Clark
ahh...i should actually read next time...i'm so used to getting the other one.
if it's an initFromNVPair then it's one of a couple other things...I've seen it if you pass some other connection parameters (like it usually chokes on server=) or it might just not be able to find the tnsnames.ora file.