• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Some problems with JDBC thin

 
Trong Hieu
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I use Oracle8.1.7, but some thinh have error logs below :
java.sql.SQLException: Io exception: Connection
refused(DESCRIPTION=(TMP=)(VSNNUM=135294976)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12500)(EMFI=4))(ERROR=(CODE=12540)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=510)(EMFI=4))(ERROR=(BUF='Solaris
Error: 11: Resource temporarily unavailable'))))
Please help !
Thanks
 
Dave Vick
Ranch Hand
Posts: 3244
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
NDTH
Welcome to the Java Ranch, we hope you�ll enjoy visiting as a regular however,
your name is not in keeping with our naming policy here at the ranch. Please change your display name to an appropriate name as shown in the policy.
Thanks again and we hope to see you around the ranch!!
 
Rene Larsen
Ranch Hand
Posts: 1179
Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How do you connect to the database?
Try post the code.
/Rene
 
Trong Hieu
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I used :
jdbc racle:thin:@host ort:string
Web server and database server on two server !
Thanks
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Trong Hieu:
I used :
jdbc racle:thin:@host ort:string
Web server and database server on two server !
Thanks

The only things that I have come accross that might cause this is:
1. mispelled/non-existant username or password for connecting
2. firewall issues not letting you access the database
Jamie
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
or maybe the instance isn't running/listening?
 
rajusaravanan
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,
Please try this syntax to connect to the database it really worked for me:
String url = "jdbc racle:thin:@(DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname> (PORT = <port> ))(CONNECT_DATA =(SERVICE_NAME = <servicename> ))";
.getConnection(url,"username", "password");
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"rajusaravanan"
We appreciate that your first post is answering someone's proble, we appreciate it.
However...
You name does not comply with the JavaRanch naming policy which can be found at http://www.javaranch.com/name.jsp
You can edit your display name here: http://www.coderanch.com/forums/user/edit
thanks,
Dave
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic