Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Java Vs Perl for File Read and Database Update

Posted on 2004-08-09
1
Medium Priority
?
377 Views
Last Modified: 2006-11-17
Hi Experts,


I want to write a class in Java and I have to justify why writting a solution in Java will be better then Perl.
 
I have the following task at hand.


1. FTP a flat file containing stocks and prices from another server or (connects to the URL and downloads the data).
2. Read valid curent stocks into a hash from an Oracle table.
3. Read each stock/price from flat file and check if valid against hash in 2.
4. If valid store stock/price in another hash map/table.
5. Update database table with latest price for stock.

We do not want to store the flat file in a DB table , it's to big and we only use 400 stock values out of about 2500.
(Would have to load the data into a DB table if we were using a stored procedure).

Can you advise please?  

Azsat


0
Comment
Question by:azsat
1 Comment
 
LVL 7

Accepted Solution

by:
bvanderveen earned 1500 total points
ID: 11755800
I think you will need to compare the libraries you want to use for these tasks, because that will get you to a practical answer without going into java vs. perl arguments. Which language has the API's that are easiest to use and maintain, given the experience in your department?  Which ones are most effecient and fast?

 I find java easier for doing network tasks and database tasks (JDBC, anyway).

One thing you might consider is the possibility of using a Java Stored Procedure in Oracle to accomplish this.  The method you call must be static, but you can do a lot with them, and you have really fast db access when you run Java inside the database.

Perl is best at text manipulation and regex processing.  Beyond that, I prefer Java for readability, maintainability, and strong typing.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
The viewer will learn how to implement Singleton Design Pattern in Java.
Suggested Courses

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question