| Author |
connecting with oracle
|
abhijeet srivastava
Greenhorn
Joined: Aug 22, 2006
Posts: 26
|
|
Hi all!
I am using jdk1.6 and oracle 9i. My jdbc driver is classes111.jar. Though this is getting loaded but i am not able to connect my application with database. Connection string is-
Connection conn = DriverManager.getConnection("jdbc racle:thin@localhost:1521:<SID name>","scott","tiger");
It is throwing SQLException.
Whats wrong??
|
 |
Paul Sturrock
Bartender
Joined: Apr 14, 2004
Posts: 10336
|
|
Why are you using classes111.jar? That is the driver for 7i I think. Have a a look at their driver support page to get the correct one.
What is the SQLException message?
|
JavaRanch FAQ HowToAskQuestionsOnJavaRanch
|
|
Rahul Bhattacharjee
Ranch Hand
Joined: Nov 29, 2005
Posts: 2300
|
|
|
Can you give the full exception ? Any error code associated with the exception.
|
Rahul Bhattacharjee
LinkedIn - Blog
|
|
abhijeet srivastava
Greenhorn
Joined: Aug 22, 2006
Posts: 26
|
|
|
java.sql.SQLException: Invalid Oracle URL specified
|
|
Rahul Bhattacharjee
Ranch Hand
Joined: Nov 29, 2005
Posts: 2300
|
|
The URL seems to be fine.
|
|
abhijeet srivastava
Greenhorn
Joined: Aug 22, 2006
Posts: 26
|
|
|
Ya i Checked but still not working. I have doubt in SID and user password.How can i know what is SID value (where it get stored in oracle directory). is scott and tiger are correct?
|
|
Rahul Bhattacharjee
Ranch Hand
Joined: Nov 29, 2005
Posts: 2300
|
|
|
You can contact the database admin for this clarification.
|
|
 |
|
|
subject: connecting with oracle
|
|
|
0
