RE: Create statement used wrongly?

2009-01-26 Thread Jonathan Moores
You are passing a String object in not a bean and you are using SQL param substitution (using #) but it seems you want to pass in the whole sql text (use $) Change #sqlString# to $value$ #sqlString# is looking for a field called sqlString on the String object. -Original Message- From: J

RE: Transactions and Pooling

2009-01-24 Thread Jonathan Moores
which sux. :-) Cheers, Clinton On Fri, Jan 23, 2009 at 5:17 PM, Jonathan Moores wrote: > Hi, > > I was wondering why there is a need to explicitly call > SqlMapClient.endTransaction() in order to return a connection to the pool > even after a commitTransaction()? > > &

RE: SqlMapConfig.xml and subsequent sqlMap entries

2009-01-23 Thread Jonathan Moores
Not sure but is there any reason that there are spaces after .xml? From: Stanley, Eric [mailto:eric.r.stan...@qwest.com] Sent: zaterdag 24 januari 2009 0:40 To: user-java@ibatis.apache.org Subject: SqlMapConfig.xml and subsequent sqlMap entries All, New to iBATIS, just trying to get t

Transactions and Pooling

2009-01-23 Thread Jonathan Moores
Hi, I was wondering why there is a need to explicitly call SqlMapClient.endTransaction() in order to return a connection to the pool even after a commitTransaction()? I am using Tomcat 6.018 with Ibatis 2.34.726 and I see that the connections used in a transaction are never returned without th