GeeCON Prague 2014*
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.
 
GeeCON Prague 2014
 
subject: Database load