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 Broderick wrote: > 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? > > Thanks > > 2010/3/6 François Schiettecatte <fschietteca...@gmail.com> > 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: > > > > <transactionManager type="JDBC"> > > <dataSource type="SIMPLE"> > > ... connection properties > > </dataSource> > > </transactionManager> > > > > 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 call its service() > > method to generate a report, that consists of many select queries, using > > the single SQL map instance. > > > > My questions are: > > 1) What are the default values for connection pool size? Is it 10? > > 2) Is SqlMapClient thread-safe? > > > > Thanks, > > > > Andrew > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > > > > > -- > Thanks, > > Andrew Broderick --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
