It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Database load Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Database load" Watch "Database load" New topic

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

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.
I agree. Here's the link:
subject: Database load
jQuery in Action, 3rd edition