Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC WITH ORACLE 8i

 
ashokw2002
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic