my dog learned polymorphism*
The moose likes JDBC and the fly likes JDBC WITH ORACLE 8i Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
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://aspose.com/file-tools
 
subject: JDBC WITH ORACLE 8i