Exception with DriverManager.getConnection to Oracle DB

[celia05es]

Hello,
I am new to JDBC and I do hope you can help me.
I am only trying to connect to an ORACLE database but I get "E/S Exception: Connection refused"
I don't know if it is relevant but here is what I have:
- Jakarta-Tomcat 5.0.19
- j2sdk-1_4_0_02-solaris-sparc[1].tar.gz
- in my WEB-INF/lib I have, for the driver:
classes12.jar nls_charset12.jar

I am doing the following:
try
{
String JdbcDriver= "oracle.jdbc.driver.OracleDriver";
Class.forName(JdbcDriver).newInstance();
}
catch(Exception ex)
{
System.out.println("Can't find the driver");
}
try
{
System.out.println("Trying to connect...");
String JdbcURL=""jdbcracle:thin:aaa/aaa123@172.16.20.150:1521:siu";
conn=DriverManager.getConnection(JdbcURL);
connected=true;
}
catch (Exception e)
{
connected=false;
System.out.println("SQL Exception="+e.getMessage());
}

When executing the getConnection method, I get the following exception:
Connection refused(DESCRIPTION=(TMP=)(V
SNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

Anyone can help me or at least give me a hint about where to look?

Thank you in advance.

 

[venur]

Hi,

Are u able to connect to the Oracle DB from the SQLPlus ?

username:sui
password:
hoststring:aaa/aaa123@172.16.20.150

Just make sure your connectURL is correct.

Cheers
Venu

 

[celia05es]

Problem solved. The database instance was incorrect. It was "nr" instead of "siu"!