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

0
votes

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 !

2
javaoraclejdbc
Can you connect using SQL*Plus? Are you sure you started the Oracle instance and the listener? – a_horse_with_no_name
yes , i did started the services ! and it works fine with SQL*Plus! – dip

2 Answers

0
votes

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

0
votes

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!