CODEWITHSUNDEEP
javaoracle-databasejdbc
dip
dip

Reputation: 3598

Can not connect oracle 10g personal edition r2 database using JDBC

i tried to perform connection test on netbeans as by creating new connection from databases node.

i am trying to connect with ojdbc6.jar driver and my sid of databse is orcl (oracle personal edition).

while creating new connection i did locate the oracle thin driver, used port 1521, i am using hr user which i have unlocked previously, the connection string of my connection is jdbc:oracle:thin:@localhost:1521:orcl but when i perform testing it throws message

Cannot establish a connection to jdbc:oracle:thin:@localhost:1521:orcl using oracle.jdbc.OracleDriver (IO Error: The Network Adapter could not establish the connection),

need help ,thanks in advance !

Upvotes: 0

Views: 537

Answers (2)

dip
dip

Reputation: 3598

it was easy ! just do not forgot to conform your database connection string.

as in figure , if u filled fields like HOST , PORT , SID then ti will change the connection string that is generated automatically,

it was my simple mistake which bother me for one week ! thanks lot for everyone who guided me and specially for @Stanley!

Upvotes: 0

Stanley Mungai
Stanley Mungai

Reputation: 4150

You first need to make sure that the Oracle service is running, next I think you need to try ojdbc14.

Upvotes: 0

Related Questions