wood burning stoves*
The moose likes JDBC and the fly likes Problem with Oracle Thin Driver!!!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem with Oracle Thin Driver!!!!!" Watch "Problem with Oracle Thin Driver!!!!!" New topic
Author

Problem with Oracle Thin Driver!!!!!

Rajesh Venkatesh
Greenhorn

Joined: Feb 14, 2002
Posts: 21
Hi ,
I created a connection pool in weblogic 6.0 using the
following parameters:
url ---
jdbc: oracle:thin:@oraclemachineip:1521:service
Oracle driver class name --- oracle.jdbc.driver.OracleDriver
properties ---
user=scott
password=tiger
dll=ocijdbc8
server=none
protocol=thin
When i try to create a connection pool
it gives me the error pasted below.
Can somebody tell what me what is wrong here?
Thanks for the help in advance.
Regards,
Rajesh.
---------------------------------------------------------------
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:1120)
at
oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:195)
at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:198)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:251)
at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:224)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory)
------------------------------------------------------------------
[ February 15, 2002: Message edited by: Rajesh .V ]
martin samm
Ranch Hand

Joined: Nov 09, 2000
Posts: 31
i dont know if it's a typo in your posting, but you need a ':' between 1521 and orcl (should be machineip:1521 rcl


martin samm<BR>m_sam@rroom.net
Rajesh Venkatesh
Greenhorn

Joined: Feb 14, 2002
Posts: 21
Originally posted by martin samm:
i dont know if it's a typo in your posting, but you need a ':' between 1521 and orcl (should be machineip:1521 rcl

Yes I have included the :
URL=
jdbc: oracle:thin:@163.122.10.12:1521:<service>
Driver = oracle.jdbc.driver.OracleDriver
Is the service name case sensitive ... i am
working on Solaris...
I am still getting the same error
oracle.net.TNSAddress : SO Exception
Regards,
Rajesh.
Nigel Browne
Ranch Hand

Joined: May 15, 2001
Posts: 673
I believe the SID is case sensitive
Mahesh Mamani
Ranch Hand

Joined: Jun 25, 2001
Posts: 110
Are u able to connect to database first. Check it out first.
Secondly try to use TNSPING <TNSNAME> to resolve whether u are able to connect to database using TNS NAME from the OS(SOlaris) command prompt.
Mahesh
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Problem with Oracle Thin Driver!!!!!