This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes JDBC WITH ORACLE 8i Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "JDBC WITH ORACLE 8i" Watch "JDBC WITH ORACLE 8i" New topic
Author

JDBC WITH ORACLE 8i

ashokw2002
Greenhorn

Joined: Feb 08, 2002
Posts: 2
I HAVE WRITTEN CODE IN JDK1.3\BIN DIRECTORY FOR CONNECTION TO ORACLE 8i BUT ITS SHOWING PROBLEM IN LINE :- IMPORT ORACLE.JDBC.DRIVER PACKAGE DOEST NOT EXITS PLEASE SEND ME COMPLETE PROCEDURE TO CONNECT ORACLE 8i AND ACCESS AND HOW TO SE CLASSPATH FOR ORACLE DRIVERS
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

please don't use cap locks. They are harder to read.
These should be all the Oracle resources you need to get started, get familiar with jdbc, trouble shoot your problems, and eventually become advanced!
download your oracle drivers at http://technet.oracle.com/software/tech/java/sqlj_jdbc/content.html and follow the download procedures
enable the client to connect(set environment)
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/java.817/a83728/05confi3.htm#1003460
To find all the Oracle specific code that you could ever need
http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/content.html -->look for the "JDBC Samples" links
If you just want code snippets that explain various tasks(including connections), this is a good link too:
http://technet.oracle.com/sample_code/tech/java/sqlj_jdbc/htdocs/templates.htm
if you come accross a problem, check this list before you post here:
http://otn.oracle.com/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm
if you come accross an Oracle SQLException, then you can investigate the ORA-XXXXX error messages and solutions at:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76999/toc.htm
good luck,
Jamie
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: JDBC WITH ORACLE 8i
 
Similar Threads
Changing job roles, from team leader to DBA, what to think about ?
oracle 8i features
Connection Pooling help needed
Connection Pooling help needed
Tell me one (Handy) DataBase for Java ?