This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes You can't do that in Java - Oracle 9i database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "You can Watch "You can New topic

You can't do that in Java - Oracle 9i database

Warren WagonWheel

Joined: Jan 17, 2003
Posts: 5
I am trying to write a Java application to bridge from a legacy file manager (used as a database) to Oracle 9i database. This will enable us to continue to use about 300 Fortran programs that are mission critical for our multi-store retail operation. Once we consolidate/migrate to our Oracle 9i database, we plan to gradually rewrite our applications in Java. We currently struggle with frequent batch mode data transfers to try to keep the 2 databases consistent.
My problem is that the Fortran guy and the consultant tell me it is impossible to write this �bridge� program in Java because the Fortran calls machine-executable subroutines and Java has bytecode rather than fully compiled code. I think they are probably correct. They want to write it in C with embedded SQL.
I want to work on this project, but I don�t know C and I don�t want to learn it since I think it�s becoming as dead as Fortran. Any suggestions on how I can use my knowledge of Java to work on this project?
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1121

Hi Warren,
So you are looking for a Java/Fortran interface? Did you try an Internet search? When I searched for "java fortran", I got 270,000 hits. The second one in the list was a tutorial entitled Java/Fortran Interface and the fourth one was a document entitled Putting a Java Interface on your C, C++, or Fortran Code.
Hope this helps.
Good Luck,
SJ Adnams
Ranch Hand

Joined: Sep 28, 2001
Posts: 925
you can only call c from fortran, so c with embedded sql is the correct (& I believe only) way to do it.
fortran is a VERY easy language to learn, so don't be to afraid of it.
of course you can call c++/fortran from java but I doubt this fact will help you much.
Salman Khattak
Ranch Hand

Joined: Mar 23, 2003
Posts: 33

I want to work on this project, but I don�t know C and I don�t want to learn it since I think it�s becoming as dead as Fortran.[/QB]

IMHO never be afraid to learn something new or, for that matter, old. Java and C++ evolved out of C. C has its issues but it is not extinct.
My suggestion to you is that the FORTRAN programmer and the consultant might be trying to stay in their realm of experience. I believe with the right experience in Java and with the help of the internet it is possible to write Java with any interface.
So be mindful of the people who resist change for personal reasons.

SCJP Java 1.4 - 06/2003<br />Power corrupts and absolute power corrupts absolutely!
Warren WagonWheel

Joined: Jan 17, 2003
Posts: 5
I meant to thank you all for your kind help on my problem. I had a lightning strike and blew out my monitor so I was down for about a week. Anyway, thanks!
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17249

Sorry for asking, but Warren is that your real last name?

Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Billy Tsai
Ranch Hand

Joined: May 23, 2003
Posts: 1297
The lowest level programming i ever did was alpha assmebly, the compiler(alpha simulator) that was used to complie and run the asm program was written in Java.
So basically its a Java program simulating the Alpha operating system and compiling assembly codes and running assembly programs.

BEA 8.1 Certified Administrator, IBM Certified Solution Developer For XML 1.1 and Related Technologies, SCJP, SCWCD, SCBCD, SCDJWS, SCJD, SCEA,
Oracle Certified Master Java EE 5 Enterprise Architect
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: You can't do that in Java - Oracle 9i database
Similar Threads
Transaction Exception
Database Upgrade and Spring Framework's JMS capability
image uploading in jsp
Questions about exam schedule
Jboss JMS API question