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 connection with oracle 10g 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 connection with oracle 10g" Watch "jdbc connection with oracle 10g" New topic

jdbc connection with oracle 10g

swapna marepally

Joined: Apr 04, 2007
Posts: 3
please provide me the code

what should i give at class.forName()
and what to put in the getConnection()
my user is hr and password is also hr
as it was given by the product when i installed

service name is oracle

when i run this program it is throwing ClassNotFoundException and
at getConnection method UnReportedException

i have set the class path like this
set CLASSPATH=ojdbc14.jar
and when i say %CLASSPATH% to check the classpath
it is not showing the classpath instead it is opening the ojdbc14.jar related window

please help in this problem

thanks in advance
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1323

Paul Sturrock reply,

This is covered in Oracle's documentation, all we could do here is repeat what is written. Read the "JDBC Developer's Guide and Reference". If you are still confused feel freee to ask more questions.

follow this link where most of parts of your question is already covered.

[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
I agree. Here's the link:
subject: jdbc connection with oracle 10g
It's not a secret anymore!