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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Excel Data Population using Java
 
Similar Threads
how to insert CLOB data type
Not able to store ukrainian characters in Oracle 10g database
Connection pooling with my own cofiguration file instead of Initial Context.
junk values written into a file when column values taken from the database table..
How to know whether a particular row exists in table