java.sql.SQLRecoverableException: IO Error: NL Exception was generated

Question

Getting java.sql.SQLRecoverableException: IO Error: NL Exception was generated

Trying to connect to Oracle sql developer DB.

Connection string used is :

 jdbc:oracle:thin:@(DESCRIPTION=(CID=ValidCID)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ValidHost)(PORT=1521)))(CONNECT_DATA=(SID =ValidSID)(SERVER = DEDICATED))); User Id=UID;Password=Pwd;

I use the same set of parameters while connecting from QTP. What could be the issue here ?

Mithilesh Indurkar · Accepted Answer · 2017-06-19 09:11:20Z

1

I found it...

instead of supplying User ID and password through connection string, one needs to supply them through the method. So, my connection string would become

 String strConnString = "jdbc:oracle:thin:@(DESCRIPTION=(CID=ValidCID)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ValidHost)(PORT=1521)))(CONNECT_DATA=(SID =ValidSID)(SERVER = DEDICATED)))";

and I would use the following method to creation a connection

 Connection con = DriverManager.GetConnection(strConnString, UserID, Password);

answered Jun 19, 2017 at 9:11

Mithilesh Indurkar

4891 gold badge6 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

java.sql.SQLRecoverableException: IO Error: NL Exception was generated

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related