wood burning stoves 2.0*
The moose likes JDBC and the fly likes New to JDBC, Please Help Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "New to JDBC, Please Help" Watch "New to JDBC, Please Help" New topic
Author

New to JDBC, Please Help

Metelda Ganugapanta
Greenhorn

Joined: Jul 10, 2003
Posts: 12
Hi Everyone
I am new to JDBC.
I have Oracle 8.1.7
j2sdk1.4.0 installed on my Windows XP machine.
Can anyone get me the links I have to go through to connect to Oracle.
Do I have to download any drivers specifically???
Everything is so confusing for me.
Is there any detailed procedure anywhere?
I have been searching for information for a while
and I just now read that Oracle 8.1.7 supports only jdk1.2.x. If that is the case ,Do I need Oracle 9i?
Thanks
Metelda
Pavel Halas
Ranch Hand

Joined: Jul 05, 2003
Posts: 35
At first you must download any oracle JDBC driver (from oracle web or anywhere else). It is a .jar file, that you will put in your classpath. Some information could be found at JDBC intro, but that's not the only information source -- I googled it using: oracle + jdbc.
... I just now read that Oracle 8.1.7 supports only jdk1.2.x. If that is the case ,Do I need Oracle 9i?

No, that has nothing to do with JDBC. Due to you're new in that, it's not important now.
Sujatha Ranganathan
Greenhorn

Joined: May 29, 2003
Posts: 12
For details on connecting to Oracle Database through JDBC refer to this documentation
You will find JDBC Samples here
Hopt this helps.
Metelda Ganugapanta
Greenhorn

Joined: Jul 10, 2003
Posts: 12
Thanks very much for your help,Pavel.
Thanks very much ,Sujatha.
anushree ari
Ranch Hand

Joined: Sep 30, 2002
Posts: 98
hi,
iam also new to JDBC, I got my Sun certification couple of months before,i like to learn about JDBC now.
Is it possible to download Oracle 9i free from Oracle site,otherwise where i can find ?,
help me
please
thx in advance


anushree
Matthew Phillips
Ranch Hand

Joined: Mar 09, 2001
Posts: 2676
Oracle 9i is available at Oracle's site. It may not be the full version, but it should be enough to start learning.


Matthew Phillips
anushree ari
Ranch Hand

Joined: Sep 30, 2002
Posts: 98
thx phillips,
is there any resource (to start jdbc) available on the net for free?
thx
Sujatha Ranganathan
Greenhorn

Joined: May 29, 2003
Posts: 12
Hi,
Have a look at the JDBC Page on OTN.
This has links to documentation, sample code and JDBC driver downloads.
Hope this helps.
Sujatha.
anushree ari
Ranch Hand

Joined: Sep 30, 2002
Posts: 98
thx sujatha,
i hope this is enough,if i have any trouble help me.
thx
James Redpath
Greenhorn

Joined: Aug 02, 2003
Posts: 13
If you have Oracle 8.1.7 you don;t have to down load anything when you install it. The JDBC jar classes are installed in the directory named jdbc. SImply copy this file typically called class111.jar and include in your CLASSPATH variable.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: New to JDBC, Please Help
 
Similar Threads
Map a nested table in an session-managed Entity Bean
Which driver to use
which JDBC driver to use
Datasource Configuration
Oracle JDBC Driver for JDK 1.3