aspose file tools*
The moose likes JDBC and the fly likes Database load Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Database load" Watch "Database load" New topic
Author

Database load

Dushy Inguva
Ranch Hand

Joined: Jun 24, 2003
Posts: 264
Does anyone know of a generic database load utility? Obviously we are talking about free stuff here ;-)

I'm looking to load a CSV file into DB2 v7.0


SJCP, SCBCD, SJCD, SCDJWS, SCEA (Part I)
Maximilian Xavier Stocker
Ranch Hand

Joined: Sep 20, 2005
Posts: 381
There are some tools like Squirrel Squirrel Home Page which is a Sourceforge project that is a generic Java based client to DBs. I am pretty certain you can load in files with that... or other tools of that nature.

My experience however suggests that it will probably be best if you just stick with database vendor specific tools. Mostly these types of tools are exponentially faster when it comes to bulk loading data etc. then their generic counterparts.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Database load