aspose file tools*
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 Soft Skills this week in the Jobs Discussion 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: 3611
    
  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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC- Oracle RAC URL