• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC- Oracle RAC URL

 
Arjun Shastry
Ranch Hand
Posts: 1898
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1898
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1898
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I used Service URL and was able to connect.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic