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 : jdbcracle: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 !
[ January 04, 2005: Message edited by: Shailesh Welankar ]
[ January 04, 2005: Message edited by: Shailesh Welankar ] [ January 04, 2005: Message edited by: Shailesh Welankar ]
Ok !! my problem is solved !! I am using Oracle 9.x and WSAD 5.1.1. Now this combination for some reasons does not recognize the ".WORLD" phrase after the database name in the connection string ! So, I did many changes along with the one mentioned above and now I have got my application up and running in the WSAD internal browser. The other things included : using the latest JRE (and unistalling the older version(s) from the PC), making sure that the ojdbc14.jar file is used and NOT classes12.jar, Deleting and recreating the server in the WSAD's Server perspective. Hope this helps other ppl with similar problems.