Jan 31st, 2008, 06:03 PM
Flat File to DB mapping via config files?
I need to import flat files into a database. I am using the sample fixedLengthImportJob as a starting point. So far, so good.
I would like to be able to add or delete fields without changing code. To add a field to fixedLengthImportJob it looks like you would have to change at least 3 java files: Trade.java, JdbcTradeWriter.java, and TradeFieldSetMapper.java in addition to the fixedLengthImportJob.xml. Not so good. Ideally, the behavior of these java classes would be driven from the job configuration file.
My questions are:
1. Is the paragraph above correct?
2. If yes, is it only because fixedLengthImportJob is simplified for example purposes?
3. Can anyone refer me to an example of what I want to do or give me a hint as to how to get started?