aspose file tools*
The moose likes JDBC and the fly likes how to connect jdbc with oracle 9i database using all 4 types of driver? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to connect jdbc with oracle 9i database using all 4 types of driver?" Watch "how to connect jdbc with oracle 9i database using all 4 types of driver?" New topic
Author

how to connect jdbc with oracle 9i database using all 4 types of driver?

smita mishra
Ranch Hand

Joined: May 18, 2006
Posts: 31
Can anybody tell me
how to connect jdbc with oracle 9i database using all 4 types of driver?

Is there any book or material available for JDBC for beginners?
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39547
    
  27
We have a number of FAQ pages about JDBC, starting here. Particularly the link to the Sun JDBC tutorial on the GeneralJdbcQuestions page would be interesting to you, as well as the various "What's new in JDBC 2/3/4?" articles linked on the same page.

The JdbcLinks page links to Oracle 9i-specific material.
[ December 30, 2006: Message edited by: Ulf Dittmer ]

Ping & DNS - updated with new look and Ping home screen widget
Piyush K Gupta
Greenhorn

Joined: Aug 26, 2009
Posts: 1
Fist of all you can use oracle driver with jdk 1.5 or jdk 1.6
First of all try to change classpath:
1. remove c:\oracle\ora92\jdbc\lib\classes12.zip;
2. change classes12.jar ojdc14.jar
Second:
jdbc:oracle:oci8:@tcp1105008:1521:oradev01 - uses oci driver, oracle client should be installed on client. I think where is small bug here it should be:
jdbc:oracle:oci:@tcp1105008:1521:oradev01

I prefer to use thin version (we had huge problems with oci driver for oracle 9.2), try to change just connection string:
jdbc:oracle:thin:@tcp1105008:1521:oradev01
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 36486
    
  16
Welcome to JavaRanch

Your reply may not be very useful after 2½ years, however.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to connect jdbc with oracle 9i database using all 4 types of driver?
 
Similar Threads
how to connect JDBC with oracle 9i
how to setup jdbc classpath for oracle 9i
How to connect Oracle with Java
connection of JDBC with oracle 9i database
Connection to Database