It can be done, use poolman. Easiest DB pool to get going, works well with more DB than others.
http://sourceforge.net/projects/poolman Edgar > -----Original Message----- > From: Vic Cekvenich [mailto:[EMAIL PROTECTED] > Sent: Monday, December 22, 2003 4:50 PM > To: [EMAIL PROTECTED] > Subject: Re: How find DataSource? > > > > > e-denton Java Programmer wrote: > > > > > Has anyone set up a connection pool using web.xml? Steps? Examples? > > Tips? > > > No one has, it can't be done. You can declare it in web.xml, > that's all. Read Rick Reumans tutorial on ibatis dao and > ibatis petstore 3 example > and do that, and you will be in a good place. > > It's sad, no books on this. All JDBC books talk about JDBC 1.0, not > about JDBC 3 pooleddatasource, or DAO. > > > > > Vic, I might have two problems with keeping it in a static > block. 1. > > My container can be passivated, so everything must be serializable. > > Passivation is not a good idea ever, so just ignore it. > Change the co-lo > or host if you have to. It sure does not give scalability > to the host > or to app. > > hth, > .V > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]