aspose file tools*
The moose likes JSP and the fly likes Excel Data Population using Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "Excel Data Population using Java" Watch "Excel Data Population using Java" New topic
Author

Excel Data Population using Java

Hareesh Ram Chanchali
Ranch Hand

Joined: Jan 31, 2005
Posts: 110
What is the best and efficient way to read and populate the data in to oracle database....

Large number of sheets' data should be trasfered to the oracle database
using the j2EE technologies


Hareesh Ram Chanchali
SCJP 5.0, IBM Certified Solution Designer
Nathan Pruett
Bartender

Joined: Oct 18, 2000
Posts: 4121

"hareesh" -

Welcome to the JavaRanch! Please adjust your displayed name to meet the
JavaRanch Naming Policy. User names cannot be obviously fake and must constist of a first name and a last name.

You can change your user name here.

Also, I think that you need to describe your problem in a little more detail... are you looking for information on EJBs vs. other technologies? And also a description of what "sheets' data" means... data from web forms?

Thanks! and welcome to the JavaRanch!


-Nate
Write once, run anywhere, because there's nowhere to hide! - /. A.C.
Hareesh Ram Chanchali
Ranch Hand

Joined: Jan 31, 2005
Posts: 110
I want to use j2ee framework for uploading the data in EXCEL (.XLS) sheets to the orcle database.

Suggest me the best solution which is good at performance and accuracy
Ben Souther
Sheriff

Joined: Dec 11, 2004
Posts: 13410

A Google search on Excel Java brought up these two products.
There is nothing native in J2EE for working with Excel.

http://officewriter.softartisans.com/OfficeWriter-306.aspx
http://jakarta.apache.org/poi/


Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
Dan Novik
Ranch Hand

Joined: Jan 26, 2005
Posts: 39
You can read Excel files through JDBC
(e.g. via JDBC-ODBC bridge - it is free)
Ben Souther
Sheriff

Joined: Dec 11, 2004
Posts: 13410

According to Sun, the jdbc-odbc bridge is not suitable for production apps:
http://java.sun.com/products/jdbc/faq.html#20


The Bridge is a normal ODBC client. Note, however, that you should use the JDBC-ODBC Bridge only for experimental prototyping or when you have no other driver available.
Dan Novik
Ranch Hand

Joined: Jan 26, 2005
Posts: 39
>According to Sun, the jdbc-odbc bridge is not suitable for production
>apps:

And according your own experience? ;-)

Actually all the problems belong to the concurrent access/scalability. If you need to move once data from Excel to Db � it is probably Ok, there in no concurrency
Ben Souther
Sheriff

Joined: Dec 11, 2004
Posts: 13410

Originally posted by Dan Novik:

And according your own experience? ;-)

I've used it without incident, but not in a production environment.
Hareesh Ram Chanchali
Ranch Hand

Joined: Jan 31, 2005
Posts: 110
thank for giving me suggestions

but I am using JXL package

do u have any idea about its capabilities
 
jQuery in Action, 2nd edition
 
subject: Excel Data Population using Java