my dog learned polymorphism*
The moose likes JDBC and the fly likes Connection Error: Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection Error:" Watch "Connection Error:" New topic
Author

Connection Error:

Maanik kandan
Greenhorn

Joined: Aug 26, 2009
Posts: 4

is this correct URL for oracle database connection..it gives me an error:

jdbcracle:thin:@localhost:1521racle

SQL problems: Io exception: The Network Adapter could not establish the connection
jdbcracle:thin:@localhost:1521racle

please sort out my issue..
Sagar Rohankar
Ranch Hand

Joined: Feb 19, 2008
Posts: 2902
    
    1

1. For Oracle JDBC url:
http://www.herongyang.com/jdbc/Oracle-JDBC-Driver-Connection-URL.html

2. Make sure oracle database instance is running on port 1521 and that port is open.

3. Disable the similes.


[LEARNING bLOG] | [Freelance Web Designer] | [and "Rohan" is part of my surname]
Maanik kandan
Greenhorn

Joined: Aug 26, 2009
Posts: 4
I have tried that type of URL too ..but its give me an same Error..please give me suggestion regarding my issue
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Is Oralce running locally? Are you using a SID and is it correctly configured?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Maanik kandan
Greenhorn

Joined: Aug 26, 2009
Posts: 4
yeah am doing...in my home PC..during my installation of oracle i gave my sid and global database as oracle..

is that right?
Asmita Khamkar
Greenhorn

Joined: Mar 28, 2009
Posts: 25
Hi,
I am also getting Network adapter error could not establish connection, but I get this error when my internet connection is on, otherwise it connects to oracle properly and all my queries work properly when my Internet is off.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Connection Error: