CSV/ flat file <-> db mapping

[m.zywno]

Hey,

I'm looking for a Java library that would help in persisting data that
is stored in flat files like e.g. CSV into a database. I would like
the tool to be configurable in a way that I could set which flat file
columns map to which database table column.

Have you come across a similar tool? I've already starter working on my
own solution but maybe someone's already implemented it..

Thanks,

Maciej Zywno

 

[Manish Pandit]

Try http://csvjdbc.sourceforge.net/

I have not used it in scenarios where I needed to do the CSV column ->
db column mapping though - this is the jdbc driver. You may want to do
the mapping in your code.

-cheers,
Manish