File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Java in General and the fly likes Loading file data into a DB2 table using java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "Loading file data into a DB2 table using java" Watch "Loading file data into a DB2 table using java" New topic
Author

Loading file data into a DB2 table using java

sanjeev askjeev
Greenhorn

Joined: Oct 12, 2005
Posts: 5
Loading file data into a DB2 table using java. How to achieve this.
Any code snippet will be more helpful.
Thanks
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18902
    
    8

JDBC.
Aviroop Ghosh
Greenhorn

Joined: May 17, 2005
Posts: 4
Look in any Java code that uses JDBC to access any database. The key for you would be to trace out the connection strings and the Driver class and names correctly.
You could take a look at the following article. See if this helps you in any way
Hooking up DB2 from Java
Edward Harned
Ranch Hand

Joined: Sep 19, 2005
Posts: 291

java.sql.DriverManager.registerDriver((Driver)
Class.forName
("name of driver").newInstance());

Connection con = DriverManager.getConnection( Your URL );

Statement stmt = con.createStatement();


Ed's latest article: A Java Parallel Calamity http://coopsoft.com/ar/Calamity2Article.html
jiju ka
Ranch Hand

Joined: Oct 12, 2004
Posts: 306
Seems like a batch job. Use prepared statements for better performance.

Don't read full flat file at a stretch. Instead read only sufficient information to create a record in db2.

Depending on the problem you can maintain transaction level at record level or file level. For record level after each record insert you need to commit. Else a single commit after every records are inserted.
sanjeev askjeev
Greenhorn

Joined: Oct 12, 2005
Posts: 5
thanks for the responses. there is a LOAD utility in db2 n just figured out that only i can use it directly in a statement would be have a stored procedure.
The other way could be read file line by line calling Insert stmts at every iteration.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Loading file data into a DB2 table using java