Hi
I am trying to access an non-local Oracle 9.x database from a simple
Java application installed on WSAD 5.1.1. My connection
string is :
jdbc
racle:thin:@fully qualified database server name:1521:Service name defined properly in tnsnames.ora file
I can access the Oracle database from the same machine where WSAD is installed using the same credentials and service name from the command prompt using sqlplus command and then entering the User Id in the format : user_name@service_name and then the password.
But when I try running the java application on the WSAD (using its inbuilt browser) I get the :
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
Exception.
My driver string is : oracle.jdbc.driver.OracleDriver
Have tried a lot of combinations for this to no avail.
Any help on this will be highly appreciated. Thanks in advance !
--Shailesh Welankar
[ January 04, 2005: Message edited by: Shailesh Welankar ]
[ January 04, 2005: Message edited by: Shailesh Welankar ]
[ January 04, 2005: Message edited by: Shailesh Welankar ]