aspose file tools*
The moose likes JDBC and the fly likes How do you connect Java 1.4.1 to Oracle 8i Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How do you connect Java 1.4.1 to Oracle 8i" Watch "How do you connect Java 1.4.1 to Oracle 8i" New topic
Author

How do you connect Java 1.4.1 to Oracle 8i

Dolfandave Uyemura
Ranch Hand

Joined: Jun 11, 2002
Posts: 31
Hi all,
I have seen similar posts and replies but they are 2-3 years old. Are there any recent instructions on how to connect a Java application to Oracle 8i's Enterprise Edition? I have both installed on my standalone PC running Windows98 at home and am practicing. I already have MS Access and want to move on to Oracle. Thanks in advance.
ddave
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1135

Dave,
Oracle have a JDBC driver for use with JRE version 1.4 which is available for download from:
http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html
I hope this helps you -- since I'm not sure that this answers your question (because your question was unclear to me).
Good Luck,
Avi.
Dolfandave Uyemura
Ranch Hand

Joined: Jun 11, 2002
Posts: 31
Hi,
I will start w/ the download but I guess what I need to know is if there are step by step instructions to creating the syntax in the Java application to make the application interact with the Oracle database? I can create the tables with the appropriate keys in Oracle. The part I am less familiar with is the actual Java syntax to interact with the database. JavaRanch has the database tutorial to interact with Access and I have an application that does interact with an Access database. I understand and feel comfortable with this part. What I want to do is take the next step and have an application interact with an Oracle database. Thanks.
ddave
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1135

Dave,
In case you didn't notice, the Web page (whose URL I gave you in my previous reply) also contains hyperlinks to other Web pages with documentation and sample code and discussion forums.
I am quite certain that you will find more htan enough sample code in those Web pages to get you going.
Also, you should have a "jdbc\demo" subdirectory in your Oracle installation that contains sample code.
Hope this helps.
Good Luck,
Avi.
Dolfandave Uyemura
Ranch Hand

Joined: Jun 11, 2002
Posts: 31
Hi again,
Thanks for the further clarification. No, I didn't notice that at first but I was at work and trying to reply while looking over my shoulder, if you know what I mean, at the same time. I will look at the info on the site.
Regards,
ddave
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How do you connect Java 1.4.1 to Oracle 8i