My first suggestion to you is to read the manuals available in the iBatis download section.
There is a good tutorial for starting users of iBatis.
Larry Meadors gave an example in the java user message thread 1757.
 
I made a program that does something like what you want. But it is far to big to include it in an email.
The steps are as following.
1) Create a class containing file information.
2) You can add a configuration file (dao.xml) for simplicity.
3) In this case, define a Dao interface for your class. (containg a public void insert(List yourClassList); method)
4) Add a yourclass.xml file containg an insert tag with, possibly an iterate tag nested in it (for speed pupose).
5) Add a SqlMapDao class implementing the Dao interface created.
6) Add a sql-map-config.xml file.
7) Initialize the Dao.
8) Make a class that reads the file and parses it in the class. It will make a call to the Dao interface insert method.
 
 
Maybe there is an easy way to copie a file direclty into a table with iBatis, but I never saw such a thing myself.
 
 
If you still have questions about how to use the framework, I will try to help you.
 
 
Christian Poitras
Institut de recherches cliniques de Montréal (IRCM)
[EMAIL PROTECTED]
 

Reply via email to