Solved

Java Vs Perl for File Read and Database Update

Posted on 2004-08-09
1
372 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
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…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
The viewer will learn how to implement Singleton Design Pattern in Java.
Suggested Courses

624 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