Oracle 11g NL exception
Started by
jasonmanley87
, Nov 14 2011 05:24 PM
1 reply to this topic
#1
Posted 14 November 2011 - 05:24 PM
Hey, I keep getting an NL exception no matter what I change on this jdbc URL.
jdbc:oracle:thin:user/pass\"@\"(DESCRIPTION = (ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=testdb01.northamerica.company.net)(Port=1521)))(CONNECT_DATA=(SID=TSPC1)(SERVER=DEDICATED)))
with the username, password, and company name changed of course.
Or does this have to do with a permissions issue?
Thank you for your help.
jdbc:oracle:thin:user/pass\"@\"(DESCRIPTION = (ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=testdb01.northamerica.company.net)(Port=1521)))(CONNECT_DATA=(SID=TSPC1)(SERVER=DEDICATED)))
with the username, password, and company name changed of course.
Or does this have to do with a permissions issue?
Thank you for your help.
#2
Posted 20 November 2011 - 09:40 PM
Hey, I keep getting an NL exception no matter what I change on this jdbc URL.
jdbc:oracle:thin:user/pass\"@\"(DESCRIPTION = (ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=testdb01.northamerica.company.net)(Port=1521)))(CONNECT_DATA=(SID=TSPC1)(SERVER=DEDICATED)))
with the username, password, and company name changed of course.
Or does this have to do with a permissions issue?
Thank you for your help.
Why is your tnsnames entry at the end of that string instead of just a host name? What am I missing here?
Oh, and you can probably Google the answer you are seeking. I work with Oracle all the time and Google is my best friend for solving stuff like this.
BinRev is hosted by the great people at Lunarpages!











