Re: SQL Maps connection mgmt in servlet

2010-03-08 Thread François Schiettecatte
Andrew The answer is yes, though I am not sure how efficient the simple data source is as pooling, you might want to look at C3P0 which I use ( http://www.mchange.com/projects/c3p0/ ) or DBCP from Apache ( http://commons.apache.org/dbcp/ ). François On Mar 6, 2010, at 4:28 PM, Andrew Broderi

Re: SQL Maps connection mgmt in servlet

2010-03-06 Thread Andrew Broderick
Good to know, thanks. I'd only used it in conjunction with Spring before, never in a raw servlet, so I wasn't sure. How about the connection pooling? Couldn't find it in the documentation, although I'm sure it's in there. Does it release connections to the pool immediately on completion of a query

Re: SQL Maps connection mgmt in servlet

2010-03-06 Thread François Schiettecatte
Andrew I should have been more specific, technically it not considered thread safe but it seems to be, at least it has been for me for the past 18 months. F. On Mar 6, 2010, at 1:13 PM, Andrew Broderick wrote: > Hi, > > I am fairly new to iBATIS. I am using SQL Maps v. 2.3.4 in a servlet. >

Re: SQL Maps connection mgmt in servlet

2010-03-06 Thread François Schiettecatte
Andrew Not sure about the first question, but the answer to 2 is yes it is thread safe. François On Mar 6, 2010, at 1:13 PM, Andrew Broderick wrote: > Hi, > > I am fairly new to iBATIS. I am using SQL Maps v. 2.3.4 in a servlet. > > My config is outlined here: > > > > ... connection pr

SQL Maps connection mgmt in servlet

2010-03-06 Thread Andrew Broderick
Hi, I am fairly new to iBATIS. I am using SQL Maps v. 2.3.4 in a servlet. My config is outlined here: ... connection properties My DB is PostgreSql. I have a single SqlMapClient instance as a member variable of the servlet, initialized in its init() method. Then, multiple clients c