You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Amitabh Dubey <du...@petris.com> on 2002/09/23 19:48:30 UTC
Poolman Configuration
Does anyone have poolman successfully configured. If so, please could you
post your poolman.xml. If you have used it with SQL Server, then that would
be perfect.
Thanks
Amitabh
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Poolman Configuration
Posted by Rick Fincher <rn...@tbird.com>.
Hi Amitabh,
A lot of folks seem to like Tyrex, but it may be overkill for you.
SourceForge has one project called Proxool, that may be useful. The project
is active (released new version on 9/20/02), and seems well documented.
Search for "pooling" on www.sourceforge.net for a list of projects (many of
these are object pools not JDBC pools specifically).
I can't say personally, I haven't used either of these, though.
----- Original Message -----
> DBCP does not work well with SQL Server, so i was told. I guess i will
have
> to look into some commercial product then. Any suggestions?
>
> Thank you
> Amitabh
>
> -----Original Message-----
>
>
> Is anybody still developing Poolman? I heard the original developer
retired
> it. If you are just starting out you might want to use another connection
> pooling package like DBCP in the Jakarta Commons project, so you don't get
> locked into a defunct product.
>
> This is from the web site listed on SourceForge as Poolman's home page
> (www.codestudio.com):
>
> PoolMan is no longer available or supported through this site. It did
> exceedingly well during its lifetime, and I appreciate the important role
it
> played in so many distributed applications over the past three years. If
you
> are looking for connection and object pooling mechanisms, they can now be
> found in application servers such as JRun, Tomcat and the Jakarta Project,
> and other J2EE products and servers.
>
> -PS Neville
>
>
> Rick
>
> ----- Original Message -----
>
> > Does anyone have poolman successfully configured. If so, please could
you
> > post your poolman.xml. If you have used it with SQL Server, then that
> would
> > be perfect.
> >
> > Thanks
> > Amitabh
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
DBCP w/ SQL Server
Posted by Dennis Muhlestein <de...@zserve.com>.
I'm not sure what we have applies. We use a tds implemenation that is
not provided by microsoft for the jdbc driver (www.inetsoftware.de).
All I've done is copy/paste the example config for dbcp and replace the
driver name/username/url etc with my own info and it all works good.
On Mon, 2002-09-23 at 21:52, Amitabh Dubey wrote:
> If you have a snippet of the server.xml file that uses DBCP, please could
> you post it here. Although I think i got DBCP to work with SQLServer,
> pooling was not being used. The reason i say this is because, i had set my
> maxActive to 7 and my pool kept growing.
>
> I would really appreciate it if you could post your server.xml here.
>
> Thanks
> Amitabh
>
> -----Original Message-----
> From: Dennis Muhlestein [mailto:dennis@zserve.com]
> Sent: Monday, September 23, 2002 3:33 PM
> To: tomcat-user@jakarta.apache.org
> Subject: RE: Poolman Configuration
>
>
> We use DBCP with SQL Server and haven't had a single problem. Am I
> missing something or are you?
>
> -Dennis
>
> On Mon, 2002-09-23 at 12:11, Amitabh Dubey wrote:
> > DBCP does not work well with SQL Server, so i was told. I guess i will
> have
> > to look into some commercial product then. Any suggestions?
> >
> > Thank you
> > Amitabh
> >
> > -----Original Message-----
> > From: Rick Fincher [mailto:rnf@tbird.com]
> > Sent: Monday, September 23, 2002 1:06 PM
> > To: Tomcat Users List; dubey@petris.com
> > Subject: Re: Poolman Configuration
> >
> >
> > Is anybody still developing Poolman? I heard the original developer
> retired
> > it. If you are just starting out you might want to use another connection
> > pooling package like DBCP in the Jakarta Commons project, so you don't get
> > locked into a defunct product.
> >
> > This is from the web site listed on SourceForge as Poolman's home page
> > (www.codestudio.com):
> >
> > PoolMan is no longer available or supported through this site. It did
> > exceedingly well during its lifetime, and I appreciate the important role
> it
> > played in so many distributed applications over the past three years. If
> you
> > are looking for connection and object pooling mechanisms, they can now be
> > found in application servers such as JRun, Tomcat and the Jakarta Project,
> > and other J2EE products and servers.
> >
> > -PS Neville
> >
> >
> > Rick
> >
> > ----- Original Message -----
> >
> > > Does anyone have poolman successfully configured. If so, please could
> you
> > > post your poolman.xml. If you have used it with SQL Server, then that
> > would
> > > be perfect.
> > >
> > > Thanks
> > > Amitabh
> >
> >
> >
> > --
> > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> >
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> >
>
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Poolman Configuration
Posted by Amitabh Dubey <du...@petris.com>.
If you have a snippet of the server.xml file that uses DBCP, please could
you post it here. Although I think i got DBCP to work with SQLServer,
pooling was not being used. The reason i say this is because, i had set my
maxActive to 7 and my pool kept growing.
I would really appreciate it if you could post your server.xml here.
Thanks
Amitabh
-----Original Message-----
From: Dennis Muhlestein [mailto:dennis@zserve.com]
Sent: Monday, September 23, 2002 3:33 PM
To: tomcat-user@jakarta.apache.org
Subject: RE: Poolman Configuration
We use DBCP with SQL Server and haven't had a single problem. Am I
missing something or are you?
-Dennis
On Mon, 2002-09-23 at 12:11, Amitabh Dubey wrote:
> DBCP does not work well with SQL Server, so i was told. I guess i will
have
> to look into some commercial product then. Any suggestions?
>
> Thank you
> Amitabh
>
> -----Original Message-----
> From: Rick Fincher [mailto:rnf@tbird.com]
> Sent: Monday, September 23, 2002 1:06 PM
> To: Tomcat Users List; dubey@petris.com
> Subject: Re: Poolman Configuration
>
>
> Is anybody still developing Poolman? I heard the original developer
retired
> it. If you are just starting out you might want to use another connection
> pooling package like DBCP in the Jakarta Commons project, so you don't get
> locked into a defunct product.
>
> This is from the web site listed on SourceForge as Poolman's home page
> (www.codestudio.com):
>
> PoolMan is no longer available or supported through this site. It did
> exceedingly well during its lifetime, and I appreciate the important role
it
> played in so many distributed applications over the past three years. If
you
> are looking for connection and object pooling mechanisms, they can now be
> found in application servers such as JRun, Tomcat and the Jakarta Project,
> and other J2EE products and servers.
>
> -PS Neville
>
>
> Rick
>
> ----- Original Message -----
>
> > Does anyone have poolman successfully configured. If so, please could
you
> > post your poolman.xml. If you have used it with SQL Server, then that
> would
> > be perfect.
> >
> > Thanks
> > Amitabh
>
>
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Poolman Configuration
Posted by Mike Jackson <mj...@cdi-hq.com>.
Poolman is on sourceforge now. I don't know if any active development
is occuring or not, but it runs extremely well for me.
--mikej
-=-----
mike jackson
mjackson@cdi-hq.com
-----Original Message-----
From: Dennis Muhlestein [mailto:dennis@zserve.com]
Sent: Monday, September 23, 2002 1:33 PM
To: tomcat-user@jakarta.apache.org
Subject: RE: Poolman Configuration
We use DBCP with SQL Server and haven't had a single problem. Am I
missing something or are you?
-Dennis
On Mon, 2002-09-23 at 12:11, Amitabh Dubey wrote:
> DBCP does not work well with SQL Server, so i was told. I guess i will
have
> to look into some commercial product then. Any suggestions?
>
> Thank you
> Amitabh
>
> -----Original Message-----
> From: Rick Fincher [mailto:rnf@tbird.com]
> Sent: Monday, September 23, 2002 1:06 PM
> To: Tomcat Users List; dubey@petris.com
> Subject: Re: Poolman Configuration
>
>
> Is anybody still developing Poolman? I heard the original developer
retired
> it. If you are just starting out you might want to use another connection
> pooling package like DBCP in the Jakarta Commons project, so you don't get
> locked into a defunct product.
>
> This is from the web site listed on SourceForge as Poolman's home page
> (www.codestudio.com):
>
> PoolMan is no longer available or supported through this site. It did
> exceedingly well during its lifetime, and I appreciate the important role
it
> played in so many distributed applications over the past three years. If
you
> are looking for connection and object pooling mechanisms, they can now be
> found in application servers such as JRun, Tomcat and the Jakarta Project,
> and other J2EE products and servers.
>
> -PS Neville
>
>
> Rick
>
> ----- Original Message -----
>
> > Does anyone have poolman successfully configured. If so, please could
you
> > post your poolman.xml. If you have used it with SQL Server, then that
> would
> > be perfect.
> >
> > Thanks
> > Amitabh
>
>
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Poolman Configuration
Posted by Dennis Muhlestein <de...@zserve.com>.
We use DBCP with SQL Server and haven't had a single problem. Am I
missing something or are you?
-Dennis
On Mon, 2002-09-23 at 12:11, Amitabh Dubey wrote:
> DBCP does not work well with SQL Server, so i was told. I guess i will have
> to look into some commercial product then. Any suggestions?
>
> Thank you
> Amitabh
>
> -----Original Message-----
> From: Rick Fincher [mailto:rnf@tbird.com]
> Sent: Monday, September 23, 2002 1:06 PM
> To: Tomcat Users List; dubey@petris.com
> Subject: Re: Poolman Configuration
>
>
> Is anybody still developing Poolman? I heard the original developer retired
> it. If you are just starting out you might want to use another connection
> pooling package like DBCP in the Jakarta Commons project, so you don't get
> locked into a defunct product.
>
> This is from the web site listed on SourceForge as Poolman's home page
> (www.codestudio.com):
>
> PoolMan is no longer available or supported through this site. It did
> exceedingly well during its lifetime, and I appreciate the important role it
> played in so many distributed applications over the past three years. If you
> are looking for connection and object pooling mechanisms, they can now be
> found in application servers such as JRun, Tomcat and the Jakarta Project,
> and other J2EE products and servers.
>
> -PS Neville
>
>
> Rick
>
> ----- Original Message -----
>
> > Does anyone have poolman successfully configured. If so, please could you
> > post your poolman.xml. If you have used it with SQL Server, then that
> would
> > be perfect.
> >
> > Thanks
> > Amitabh
>
>
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Poolman Configuration
Posted by Amitabh Dubey <du...@petris.com>.
Would you be able to tell me how i should tie poolman to tomcat. this is
what my server.xml looks like
<ResourceParams name="SQLServerDS">
<parameter>
<name>validationQuery</name>
<value></value>
</parameter>
<parameter>
<name>user</name>
<value>sa</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>5</value>
</parameter>
<parameter>
<name>password</name>
<value>sa</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://dnas07:1113;DatabaseName=Northwind</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.codestudio.sql.PoolMan</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
</ResourceParams>
But tomcat still seems to use the DBCP factory. What do i need to change in
the above code in order to make tomcat use poolman.
i neeed to have a module ready by end of the week and hence the hurry.
Thanks a ton
Amitabh
-----Original Message-----
From: Mike Jackson [mailto:
Sent: Monday, September 23, 2002 5:28 PM
To: Tomcat Users List; dubey@petris.com
Subject: RE: Poolman Configuration
Use poolman. Poolman good. If you can wait until next week I can send you
a copy of my config file (out of the office until then). And I'll even
throw in a sql server example as well (even though I use Oracle primarily).
--mikej
-=-----
mike jackson
mjackson@cdi-hq.com
-----Original Message-----
From: Amitabh Dubey [mailto:dubey@petris.com]
Sent: Monday, September 23, 2002 11:11 AM
To: Tomcat Users List
Subject: RE: Poolman Configuration
DBCP does not work well with SQL Server, so i was told. I guess i will have
to look into some commercial product then. Any suggestions?
Thank you
Amitabh
-----Original Message-----
From: Rick Fincher [mailto:rnf@tbird.com]
Sent: Monday, September 23, 2002 1:06 PM
To: Tomcat Users List; dubey@petris.com
Subject: Re: Poolman Configuration
Is anybody still developing Poolman? I heard the original developer retired
it. If you are just starting out you might want to use another connection
pooling package like DBCP in the Jakarta Commons project, so you don't get
locked into a defunct product.
This is from the web site listed on SourceForge as Poolman's home page
(www.codestudio.com):
PoolMan is no longer available or supported through this site. It did
exceedingly well during its lifetime, and I appreciate the important role it
played in so many distributed applications over the past three years. If you
are looking for connection and object pooling mechanisms, they can now be
found in application servers such as JRun, Tomcat and the Jakarta Project,
and other J2EE products and servers.
-PS Neville
Rick
----- Original Message -----
> Does anyone have poolman successfully configured. If so, please could you
> post your poolman.xml. If you have used it with SQL Server, then that
would
> be perfect.
>
> Thanks
> Amitabh
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Poolman Configuration
Posted by Mike Jackson <mj...@cdi-hq.com>.
Use poolman. Poolman good. If you can wait until next week I can send you
a copy of my config file (out of the office until then). And I'll even
throw in a sql server example as well (even though I use Oracle primarily).
--mikej
-=-----
mike jackson
mjackson@cdi-hq.com
-----Original Message-----
From: Amitabh Dubey [mailto:dubey@petris.com]
Sent: Monday, September 23, 2002 11:11 AM
To: Tomcat Users List
Subject: RE: Poolman Configuration
DBCP does not work well with SQL Server, so i was told. I guess i will have
to look into some commercial product then. Any suggestions?
Thank you
Amitabh
-----Original Message-----
From: Rick Fincher [mailto:rnf@tbird.com]
Sent: Monday, September 23, 2002 1:06 PM
To: Tomcat Users List; dubey@petris.com
Subject: Re: Poolman Configuration
Is anybody still developing Poolman? I heard the original developer retired
it. If you are just starting out you might want to use another connection
pooling package like DBCP in the Jakarta Commons project, so you don't get
locked into a defunct product.
This is from the web site listed on SourceForge as Poolman's home page
(www.codestudio.com):
PoolMan is no longer available or supported through this site. It did
exceedingly well during its lifetime, and I appreciate the important role it
played in so many distributed applications over the past three years. If you
are looking for connection and object pooling mechanisms, they can now be
found in application servers such as JRun, Tomcat and the Jakarta Project,
and other J2EE products and servers.
-PS Neville
Rick
----- Original Message -----
> Does anyone have poolman successfully configured. If so, please could you
> post your poolman.xml. If you have used it with SQL Server, then that
would
> be perfect.
>
> Thanks
> Amitabh
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Poolman Configuration
Posted by Amitabh Dubey <du...@petris.com>.
DBCP does not work well with SQL Server, so i was told. I guess i will have
to look into some commercial product then. Any suggestions?
Thank you
Amitabh
-----Original Message-----
From: Rick Fincher [mailto:rnf@tbird.com]
Sent: Monday, September 23, 2002 1:06 PM
To: Tomcat Users List; dubey@petris.com
Subject: Re: Poolman Configuration
Is anybody still developing Poolman? I heard the original developer retired
it. If you are just starting out you might want to use another connection
pooling package like DBCP in the Jakarta Commons project, so you don't get
locked into a defunct product.
This is from the web site listed on SourceForge as Poolman's home page
(www.codestudio.com):
PoolMan is no longer available or supported through this site. It did
exceedingly well during its lifetime, and I appreciate the important role it
played in so many distributed applications over the past three years. If you
are looking for connection and object pooling mechanisms, they can now be
found in application servers such as JRun, Tomcat and the Jakarta Project,
and other J2EE products and servers.
-PS Neville
Rick
----- Original Message -----
> Does anyone have poolman successfully configured. If so, please could you
> post your poolman.xml. If you have used it with SQL Server, then that
would
> be perfect.
>
> Thanks
> Amitabh
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Poolman Configuration
Posted by Rick Fincher <rn...@tbird.com>.
Is anybody still developing Poolman? I heard the original developer retired
it. If you are just starting out you might want to use another connection
pooling package like DBCP in the Jakarta Commons project, so you don't get
locked into a defunct product.
This is from the web site listed on SourceForge as Poolman's home page
(www.codestudio.com):
PoolMan is no longer available or supported through this site. It did
exceedingly well during its lifetime, and I appreciate the important role it
played in so many distributed applications over the past three years. If you
are looking for connection and object pooling mechanisms, they can now be
found in application servers such as JRun, Tomcat and the Jakarta Project,
and other J2EE products and servers.
-PS Neville
Rick
----- Original Message -----
> Does anyone have poolman successfully configured. If so, please could you
> post your poolman.xml. If you have used it with SQL Server, then that
would
> be perfect.
>
> Thanks
> Amitabh
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>