Yes, the cache will work, as the table name simply becomes a query parameter.
The only time the cache should really be avoided is if you return different sets of results (i.e. different columns with a dynamic select clause). Your case should work fine. iBATIS doesn't know what a table is. :-) clinton On Fri, Jul 24, 2009 at 3:04 AM, Régis BRULEY <re...@bruley.org> wrote: > Hello, > > I need some advises. I have a lot of data in 250 tables. > > Each table have the same desgin : Id, Date, Value (Value can be a double, > boolean, varchar, or datetime depends of the table). > > In my ibatis xml configuration file, i think i will pass a parameter for > the table name in my select, inset, delete, update. > > But what about the cache ? Can i still use cache ? > > Am I right, at your sense, using one xml file for 250 tables ? > > Thanks > > Régis > > > >