If you are updating a million records...don't use iBATIS. If you can coerce the native loaders of your databases to read the file, do that.
I recently had to do a similar exercise: inserting / updating 200,000+ rows of data from a text file into an Oracle database. I ended up using a stored procedure with a single connection committing every 100 iterations or so. Even using iBATIS to call the procedure (when you do it that many times) is enough that you'll feel it. I was getting about 50 rows/second with iBATIS, and got that up to about 2,000 rows/second with straight jdbc. Looking at that, you might think iBATIS is slow - but we are talking about a difference of less than 20ms per operation. It is just that in this case, the number of iterations made an insignificant amount of time more significant Larry On 2/9/06, Brent Ryan <[EMAIL PROTECTED]> wrote: > > If I have a java bean that contains only String data types, is there a way > to have iBatis insert/update rows in the database that have a data type of > 'Numeric'? > > For Example... I read in a string of data from a text file, create my bean, > then call my iBatis service to insert the row of data into the database. > However, the database has a numeric data type for some of the fields. Can > iBatis handle this? I don't want my bean to have int, Date or other data > types because then I have to figure that out during the read of this text > file. I just want to treat everything as a String. > > I know that if you do this in Hibernate that it knows how to insert the > String into a numeric data field. However, Hibernates performance is bad > when I'm trying to insert 1 million rows of data into a single table so I > can't use it. I need to use straight JDBC or iBatis possibly....
