This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes JDBC- Oracle RAC URL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "JDBC- Oracle RAC URL" Watch "JDBC- Oracle RAC URL" New topic
Author

JDBC- Oracle RAC URL

Arjun Shastry
Ranch Hand

Joined: Mar 13, 2003
Posts: 1874
Hi,
I am getting "java.sql.SQLException NL Exception was generated" when connecting to Oracle 11.2 Database. Driver used- Oracle Thin,(ojdbc5.jar).
I am using RAC URL like this-

Any idea?


MH
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

did you copy and paste the SID from somewhere as all those hosts sharing the port looks a bit suspicious to me.

it is where i would start looking.
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

If the hosts could no be reached, it would give a different exception (I'd say). Of course, the connection string can (and should!) be verified using TNSPING.

I've never heard of the NL Exception, but a cursory search on the net shows it is a wild beast. I'll move this question to our Oracle forum, where our Oracle folks hang out.

Also, ojdbc5.jar comes in different versions. You might try to download the most recent one.
Arjun Shastry
Ranch Hand

Joined: Mar 13, 2003
Posts: 1874
Wendy Gibbons wrote:did you copy and paste the SID from somewhere as all those hosts sharing the port looks a bit suspicious to me.

it is where i would start looking.

I copied from tnsnames.ora file from database server. All port values are 1521. I will try using ojdbc6.jar
Arjun Shastry
Ranch Hand

Joined: Mar 13, 2003
Posts: 1874
I used Service URL and was able to connect.
 
Don't get me started about those stupid light bulbs.
 
subject: JDBC- Oracle RAC URL