Solved

Java Vs Perl for File Read and Database Update

Posted on 2004-08-09
1
369 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 500 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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

Suggested Solutions

Title # Comments Views Activity
simple java question 3 59
jsp login check 12 42
How  can  i  resolve  HTTP Status 404 -? 8 42
Tagging and Merging on Branch 1 29
Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
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…
The viewer will learn how to implement Singleton Design Pattern in Java.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

840 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