File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Jdbc - Help needed Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Jdbc - Help needed" Watch "Jdbc - Help needed" New topic
Author

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
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

Joined: Oct 24, 2000
Posts: 18
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

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.
Regards
Ram
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Jdbc - Help needed
 
Similar Threads
Please Help!
JdbcOdbcDriver/Stored procedures. Please help
JDBC Driver
Oracle ODBC Driver Problems. Please help
JDBC, Help please