ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From François Schiettecatte <fschietteca...@gmail.com>
Subject Re: SQL Maps connection mgmt in servlet
Date Mon, 08 Mar 2010 15:57:21 GMT
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 <fschiettecatte@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-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
> 
> 
> 
> 
> -- 
> Thanks,
> 
> Andrew Broderick


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message