File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Excel Data Population using Java

 
Hareesh Ram Chanchali
Ranch Hand
Posts: 110
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Nathan Pruett
Bartender
Posts: 4121
IntelliJ IDE Java Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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!
 
Hareesh Ram Chanchali
Ranch Hand
Posts: 110
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13411
Firefox Browser Redhat VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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/
 
Dan Novik
Ranch Hand
Posts: 39
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can read Excel files through JDBC
(e.g. via JDBC-ODBC bridge - it is free)
 
Ben Souther
Sheriff
Posts: 13411
Firefox Browser Redhat VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 39
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
>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
Posts: 13411
Firefox Browser Redhat VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 110
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic