File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Compatibility Problem??? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Compatibility Problem???" Watch "Compatibility Problem???" New topic
Author

Compatibility Problem???

Tualha Khan
Ranch Hand

Joined: Nov 22, 2000
Posts: 287
Dear All,
Hey,
I have been developing code using jdbc for quite some time. However recently I have been facing a problem after upgrading my system. I am using the following configuration:
Windows 2000 Professional Edition
Oracle 8i for (Windows NT) 8.1.6 (i think)
JDK 1.3 (HotsSpot JVM)
I am getting problem while making a connection to the database.
The programme (sort of) hangs when the connection line is executed. I have checked this using System.out at different connection stages. Also, I am using simple ODBC32 from the win2000 control panel.
I get throught the registration part using:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
My connection object is like this:
Connection con=driverManager.getConnection("jdbc dbc:MyDSN", "userid", "password");
I was working with this application absolutely fine, but earlier, but now it does not work. However, changing the DSN to point at an Access database solves the problem. It gives no problem then.
Please help. I need to somehow work around with Oracle 8i, JDK1.3, JDBC.
Thanks a lot.
Bye,
Tualha Khan

SCJP2, BEA WLS 6.0, DB2 UDB 7.1
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Instead of using ODBC, why don't you try using an actual Oracle JDBC driver?


Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
Tualha Khan
Ranch Hand

Joined: Nov 22, 2000
Posts: 287
Fine, please guide me a bit more. where are these drivers available, are they free? How to use them with Oracle and JDBC??
Thanks a lot.
Bye,
Tualha Khan
Jim Baiter
Ranch Hand

Joined: Jan 05, 2001
Posts: 532
In Oracle 8i, there should be a JDBC directory under %ORACLE_HOME%. There is documentation in there. You will need
to do something like put classes12.zip in your classpath and
figure out the JDBC URL to use in your code. The document
explains how to do this.
 
Consider Paul's rocket mass heater.
 
subject: Compatibility Problem???