Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Compatibility Problem???

 
Tualha Khan
Ranch Hand
Posts: 287
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Thomas Paul
mister krabs
Ranch Hand
Posts: 13974
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Instead of using ODBC, why don't you try using an actual Oracle JDBC driver?
 
Tualha Khan
Ranch Hand
Posts: 287
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 532
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic