Re: SimplePooledConnection Exception

2009-01-27 Thread Zsolt Koppany
Nathan, we do that. Zsolt Nathan Maves schrieb: Sounds like you need to use a validation query to ensure your connections are not stale. On Sun, Jan 25, 2009 at 10:06 AM, Zsolt Koppany zkoppanyl...@intland.com mailto:zkoppanyl...@intland.com wrote: Hi, after getting the

odd behaviour with select, resultset and header

2009-01-27 Thread loctorp
hi there, I experienced something rather peculiar yesterday: My map: select id=getDataspaceValue parameterClass=java.util.Map resultClass=java.lang.String select $columnName$ from DATASPACE_TBL where NAME=$dataspace$; /select I execute this query 2 times. First time

Re: SimplePooledConnection Exception

2009-01-27 Thread Nicholoz Koka Kiknadze
Maybe it makes sense to switch to DBCP as it has testOnBorrow setting (needs a validation query of course) and the DBCP docs saying: testOnBorrow: The indication of whether objects will be validated before being borrowed from the pool. If the object fails to validate, it will be dropped from the

Re: [VOTE] Should iBATIS support SQLJ?

2009-01-27 Thread Mario Ds Briggs
We see it as 'iBATIS uses JDBC', 'iBATIS can also use SQLJ' Mario Clinton Begin clinton.be...@gm

RE: odd behaviour with select, resultset and header

2009-01-27 Thread Niels Beekman
When injecting SQL (using $) that affects column names, you should use remapResults=true on your select-statement. Niels -Original Message- From: loctorp [mailto:boris.kartasch...@logica.com] Sent: Tuesday, January 27, 2009 10:33 AM To: user-java@ibatis.apache.org Subject: odd behaviour

Re: Adding Tables To From Clause and Corresponding Entries To Where Clause

2009-01-27 Thread Nathan Maves
Try reading the developer's guide pdf. It will put you on the right track when you get to the dynamic sql section. Nathan On Mon, Jan 26, 2009 at 5:26 PM, John Bz john1...@inbox.com wrote: Hi, I'm new to iBatis and am trying to figure out the best way to dynamically build a query that