Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Jdbc - Help needed

 
Ambrose Tati
Ranch Hand
Posts: 55
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear all,
I need to connect to the local Personal Oracle7 on my Windows98.
The Oracle driver gets registered ok by calling
Class.forName("oracle.jdbc.driver.OracleDriver");
Now I need to call DriverManager.getConnection(url,userid,pswd);
What should I set the string url to, to connect to my local Personal Oracle7 ?
Please help...
Thanks in advance
Ambrose Tati
 
Chitra Sundaram
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you are going to use the thin drivers, then the URl would be
jdbcracle:thin:@DATABASE_NAME:PORT:SID
( Just fill in your database_name, port and SID values)
if you are using OCI drivers, then use
jdbcracleci7:@database_name for the URL

Hope this helps.
Chitra
[This message has been edited by Chitra Sundaram (edited November 16, 2000).]
 
ram menon
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In case you are using a thin driver, you should explicitly start the listener. It does not start a listener by itself.
On personal oracle 8, the command is "TNSLSNR80". You can run it from a dos prompt. It will leave an empty screen open, just minimize it. After that process is running, youcan connect with the JDBC/Thin Driver.
Regards
Ram
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic