Current connection pool (Tyrex) provides just straight connections.
Try DBCP. It's not released yet but works.
You need three subprojects: collections, pool, and dbcp. All are under
commons. Take nightly builds (collections is released) and put all three
jars into $CATALINA_HOME/common/lib.
In Jndi resource for your pool add:
<parameter><name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
The next question is where are going to create pool.
To share connections you need something with application scope.
I use bean with scope=application.
As soon you destroy your datasource you lose your connection pool.
[EMAIL PROTECTED] wrote:
>
> Hi,
>
> Does anybody have experience with jakarta-tomcat-4.0.2 and connection pooling
> setup as a jndi resource (server.xml) for Informix DB (vIDS2000)
>
> I use the informix jdbc driver (ifxjdbc.jar).
>
> In fact everything works, I get no errors, except that the application keeps
> opening and closing the database connectinos which is not the meaning of
> connection pooling.
>
> I didn't experience this behaviour with the same config and application for eg
> Oracle, My Sql ... so I think it isn't the configuration.
>
> did anyone manage to setup a working connection pooling for informix via jndi
> resource, or experienced the same problems?
>
> greetings,
>
> Erwin Ravau
>
> -------------------------------------------------
> This mail sent through Tiscali Webmail (http://webmail.tiscali.be)
>
> --
> To unsubscribe: <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>
--
Lev Assinovsky Peterlink Web
Programmer St. Petersburg, Russia
Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7�
E-mail: [EMAIL PROTECTED]
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
