Solved

Java Vs Perl for File Read and Database Update

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
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…
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

758 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

23 Experts available now in Live!

Get 1:1 Help Now