Solved

Java Vs Perl for File Read and Database Update

Posted on 2004-08-09
1
366 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…

896 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now