Jdbc - Help needed

[Ambrose Tati]

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]

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]

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