Re: PingQuery with BasicDataSource

http://commons.apache.org/dbcp/apidocs/org/apache/commons/dbcp/BasicDataSource.html#validationQuery Brandon On 10/16/07, Julien Thewys <[EMAIL PROTECTED]> wrote: > > Hi, > > I used to defined my pool parameters in the sqlMapConfig file, thus in > XML. > I now have to explicitly declare a datasour

Cache - flush on interval referring statement from another sql ma p file

Hi I have a cache model defined like this: Here the statements used in do not belong to same sql map file in which this cache is defined. When I run, iBatis does not recogaise these statements and give error like : There is

Re: How to achieve Dynamic SQL query in delete statement

The problem got resolved after restarting the server. I guess there is some table lock problem. ~Navanee~ Hi Lisa and Nathan, Thank you very much for your response. Here is my code again to generate dynamic SQL SQL Map --- http://www.ibatis.com/dtd/sql-map-2.dtd";>

PingQuery with BasicDataSource

Hi, I used to defined my pool parameters in the sqlMapConfig file, thus in XML. I now have to explicitly declare a datasource: for this I use DBCP with a BasicDataSource. How can I set the PingQuery parameters on a BasicDataSource, like I did in the sqlMapConfig file ()? Thanks, -- jt