File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Jdbc - Help needed Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Jdbc - Help needed" Watch "Jdbc - Help needed" New topic

Jdbc - Help needed

Ambrose Tati
Ranch Hand

Joined: Oct 03, 2000
Posts: 55
Dear all,
I need to connect to the local Personal Oracle7 on my Windows98.
The Oracle driver gets registered ok by calling
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

Joined: Oct 24, 2000
Posts: 18
If you are going to use the thin drivers, then the URl would be
( 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.
[This message has been edited by Chitra Sundaram (edited November 16, 2000).]
ram menon

Joined: Oct 24, 2000
Posts: 5
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.
I agree. Here's the link:
subject: Jdbc - Help needed
It's not a secret anymore!