Re: Dynamic Query and Prepared Statement Caching

2009-01-05 Thread Ian Butcher
log still comes out with the info that the statement is being prepared before its executed. Thanks, Anurag --- On Mon, 1/5/09, Jeff Butler wrote: From: Jeff Butler Subject: Re: Dynamic Query and Prepared Statement Caching To: user-java@ibatis.apache.org, asethi...@yahoo.com Date: Monday

Re: Dynamic Query and Prepared Statement Caching

2009-01-05 Thread Anurag Sethi
: Jeff Butler Subject: Re: Dynamic Query and Prepared Statement Caching To: user-java@ibatis.apache.org, asethi...@yahoo.com Date: Monday, January 5, 2009, 3:46 PM iBATIS does cache prepared statements. The cache is based on the SQL string that is created after the dynamic query is resolved. So if

Re: Dynamic Query and Prepared Statement Caching

2009-01-05 Thread Jeff Butler
iBATIS does cache prepared statements. The cache is based on the SQL string that is created after the dynamic query is resolved. So if you have 300 different combinations of criteria, then you will have 300 cached prepared statements. Jeff Butler On Sun, Jan 4, 2009 at 9:01 PM, Anurag Sethi w

Dynamic Query and Prepared Statement Caching

2009-01-04 Thread Anurag Sethi
Hi, I am using the Abator generated queryByExample sql/DAO classes. I am specifically using the Criteria class in there and have a bunch of criteria ored in the example that I send as the parameter. So in general, I have the actual query with different number of criteria ored. Does Ibatis cache