• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

Io exception: Connection refused in WSAD 5.1.1

 
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 :
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 !

--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 ]
 
Shailesh Welankar
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic