RE: Who uses connection pool?

2002-03-05 Thread Reynir Hübner 

sure
check out bitmechanic.com, that´s a fine place to start.

-hope it helps
[EMAIL PROTECTED]


> -Original Message-
> From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
> Sent: 5. mars 2002 09:09
> To: 'Tomcat Users List'
> Subject: Who uses connection pool?
> 
> 
> Hi!
> Could you tell me please,
> does anybody successfully use database connection pool?
> 
> 
> --
> Lev AssinovskyPeterlink Web
> ProgrammerSt. Petersburg, Russia
> Tel/Fax: +7 812 3275343   197022 ul.Chapigina 7а
> E-mail: [EMAIL PROTECTED]
> 
> 
> 
> 
> --
> To unsubscribe:   
> For additional commands: 
> Troubles with the list: 
> 
>

Re: Who uses connection pool?

2002-03-05 Thread Lev Assinovsky 

I already looked in there.
I was confused that their pool is for GSP.
Tomcat uses Tyrex by default. How about that?

Reynir H?bner wrote:

> sure
> check out bitmechanic.com, that´s a fine place to start.
>
> -hope it helps
> [EMAIL PROTECTED]
>
> > -Original Message-
> > From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
> > Sent: 5. mars 2002 09:09
> > To: 'Tomcat Users List'
> > Subject: Who uses connection pool?
> >
> >
> > Hi!
> > Could you tell me please,
> > does anybody successfully use database connection pool?
> >
> >
> > --
> > Lev AssinovskyPeterlink Web
> > ProgrammerSt. Petersburg, Russia
> > Tel/Fax: +7 812 3275343   197022 ul.Chapigina 7а
> > E-mail: [EMAIL PROTECTED]
> >
> >
> >
> >
> > --
> > To unsubscribe:   
> > For additional commands: 
> > Troubles with the list: 
> >
> >

--
Lev AssinovskyPeterlink Web
ProgrammerSt. Petersburg, Russia
Tel/Fax: +7 812 3275343   197022 ul.Chapigina 7Á
E-mail: [EMAIL PROTECTED]




--
To unsubscribe:   
For additional commands: 
Troubles with the list:

RE: Who uses connection pool?

2002-03-05 Thread Reynir Hubner 

yeah you can use that one, it is good, and you have docs on it in the
jakarta website.

Bitmechanics pool is not only for GSP. I've never used GSP, but I have
used the JDBC-pool alot. 
it's good for most drivers, I've only had problems using it with DB2
drivers.

hope it helps, 
[EMAIL PROTECTED]




> -Original Message-
> From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
> Sent: 5. mars 2002 09:37
> To: Tomcat Users List
> Subject: Re: Who uses connection pool?
> 
> 
> I already looked in there.
> I was confused that their pool is for GSP.
> Tomcat uses Tyrex by default. How about that?
> 
> Reynir H?bner wrote:
> 
> > sure
> > check out bitmechanic.com, thats a fine place to start.
> >
> > -hope it helps
> > [EMAIL PROTECTED]
> >
> > > -Original Message-
> > > From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
> > > Sent: 5. mars 2002 09:09
> > > To: 'Tomcat Users List'
> > > Subject: Who uses connection pool?
> > >
> > >
> > > Hi!
> > > Could you tell me please,
> > > does anybody successfully use database connection pool?
> > >
> > >
> > > --
> > > Lev AssinovskyPeterlink Web
> > > ProgrammerSt. 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]>
> > >
> > >
> 
> --
> Lev AssinovskyPeterlink Web
> ProgrammerSt. 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]>
> 
> 

--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>

Re: Who uses connection pool?

2002-03-05 Thread Lev Assinovsky 

I am not sure Tyrex's connection pool really works.
Do you use JNDI when you work with bitmechanics staff?
If yes could you please show me that?

Reynir Hubner wrote:

> yeah you can use that one, it is good, and you have docs on it in the
> jakarta website.
>
> Bitmechanics pool is not only for GSP. I've never used GSP, but I have
> used the JDBC-pool alot.
> it's good for most drivers, I've only had problems using it with DB2
> drivers.
>
> hope it helps,
> [EMAIL PROTECTED]
>
> > -Original Message-
> > From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
> > Sent: 5. mars 2002 09:37
> > To: Tomcat Users List
> > Subject: Re: Who uses connection pool?
> >
> >
> > I already looked in there.
> > I was confused that their pool is for GSP.
> > Tomcat uses Tyrex by default. How about that?
> >
> > Reynir H?bner wrote:
> >
> > > sure
> > > check out bitmechanic.com, thats a fine place to start.
> > >
> > > -hope it helps
> > > [EMAIL PROTECTED]
> > >
> > > > -Original Message-
> > > > From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
> > > > Sent: 5. mars 2002 09:09
> > > > To: 'Tomcat Users List'
> > > > Subject: Who uses connection pool?
> > > >
> > > >
> > > > Hi!
> > > > Could you tell me please,
> > > > does anybody successfully use database connection pool?
> > > >
> > > >
> > > > --
> > > > Lev AssinovskyPeterlink Web
> > > > ProgrammerSt. 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]>
> > > >
> > > >
> >
> > --
> > Lev AssinovskyPeterlink Web
> > ProgrammerSt. 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]>
> >
> >
>
> --
> To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>

--
Lev AssinovskyPeterlink Web
ProgrammerSt. 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]>

RE: Who uses connection pool?

2002-03-05 Thread Andrew Rodwell 

Lev,

I have this impression also of Tyrex. Every servlet seems to be a new pool.
Is that your experiance. Each time the servlet runs a new connection.

Andrew

-Original Message-
From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
Sent: 05 March 2002 10:53
To: Tomcat Users List
Subject: Re: Who uses connection pool?


I am not sure Tyrex's connection pool really works.
Do you use JNDI when you work with bitmechanics staff?
If yes could you please show me that?

Reynir Hubner wrote:

> yeah you can use that one, it is good, and you have docs on it in the
> jakarta website.
>
> Bitmechanics pool is not only for GSP. I've never used GSP, but I have
> used the JDBC-pool alot.
> it's good for most drivers, I've only had problems using it with DB2
> drivers.
>
> hope it helps,
> [EMAIL PROTECTED]
>
> > -Original Message-
> > From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
> > Sent: 5. mars 2002 09:37
> > To: Tomcat Users List
> > Subject: Re: Who uses connection pool?
> >
> >
> > I already looked in there.
> > I was confused that their pool is for GSP.
> > Tomcat uses Tyrex by default. How about that?
> >
> > Reynir H?bner wrote:
> >
> > > sure
> > > check out bitmechanic.com, thats a fine place to start.
> > >
> > > -hope it helps
> > > [EMAIL PROTECTED]
> > >
> > > > -Original Message-
> > > > From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
> > > > Sent: 5. mars 2002 09:09
> > > > To: 'Tomcat Users List'
> > > > Subject: Who uses connection pool?
> > > >
> > > >
> > > > Hi!
> > > > Could you tell me please,
> > > > does anybody successfully use database connection pool?
> > > >
> > > >
> > > > --
> > > > Lev AssinovskyPeterlink Web
> > > > ProgrammerSt. 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]>
> > > >
> > > >
> >
> > --
> > Lev AssinovskyPeterlink Web
> > ProgrammerSt. 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]>
> >
> >
>
> --
> To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>

--
Lev AssinovskyPeterlink Web
ProgrammerSt. 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]>

Re: Who uses connection pool?

2002-03-05 Thread Lev Assinovsky 

Andrew, I found the following in Tyrex mailing archive:

- cut here -

Re: [tyrex-dev] JDBC Pool Size in Tomcat 4.0



 Date: Fri, 05 Oct 2001 13:07:46 -0700
 From: arkin <[EMAIL PROTECTED]>
 Subject: Re: [tyrex-dev] JDBC Pool Size in Tomcat 4.0



The connection you get from getConnection() is always a new connection.
This is a logical connection, and the driver is required to always give
a new logical connection when getConnection() is called.

Tyrex obtains a physical connection by calling a different
getConnection() method on a PooledConnectionDataSource. This returns a
PooledConnection, from which any number of logical connections can be
obtained without opening a new network connection.

The driver must support the PooledConnectionDataSource or XADataSource
interfaces, and must implement them in such a way that opening a new
logical connection does not open a new physical connection.

We are using Oracle 8i, Sybase 12.5 and DB2 7.1 and experiencing no
problems.

arkin

 cut here --

So they say that everything depends on your database,
however I found pool related staff in the tyrex source code.
Also I am surprised that people in this mailing list don't response.
Though I am sure (of my experience) the real work is impossible without
connection pool!

Andrew Rodwell wrote:

> Lev,
>
> I have this impression also of Tyrex. Every servlet seems to be a new pool.
> Is that your experiance. Each time the servlet runs a new connection.
>
> Andrew
>
> -Original Message-
> From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
> Sent: 05 March 2002 10:53
> To: Tomcat Users List
> Subject: Re: Who uses connection pool?
>
> I am not sure Tyrex's connection pool really works.
> Do you use JNDI when you work with bitmechanics staff?
> If yes could you please show me that?
>
> Reynir Hubner wrote:
>
> > yeah you can use that one, it is good, and you have docs on it in the
> > jakarta website.
> >
> > Bitmechanics pool is not only for GSP. I've never used GSP, but I have
> > used the JDBC-pool alot.
> > it's good for most drivers, I've only had problems using it with DB2
> > drivers.
> >
> > hope it helps,
> > [EMAIL PROTECTED]
> >
> > > -Original Message-
> > > From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
> > > Sent: 5. mars 2002 09:37
> > > To: Tomcat Users List
> > > Subject: Re: Who uses connection pool?
> > >
> > >
> > > I already looked in there.
> > > I was confused that their pool is for GSP.
> > > Tomcat uses Tyrex by default. How about that?
> > >
> > > Reynir H?bner wrote:
> > >
> > > > sure
> > > > check out bitmechanic.com, thats a fine place to start.
> > > >
> > > > -hope it helps
> > > > [EMAIL PROTECTED]
> > > >
> > > > > -Original Message-
> > > > > From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
> > > > > Sent: 5. mars 2002 09:09
> > > > > To: 'Tomcat Users List'
> > > > > Subject: Who uses connection pool?
> > > > >
> > > > >
> > > > > Hi!
> > > > > Could you tell me please,
> > > > > does anybody successfully use database connection pool?
> > > > >
> > > > >
> > > > > --
> > > > > Lev AssinovskyPeterlink Web
> > > > > ProgrammerSt. 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]>
> > > > >
> > > > >
> > >
> > > --
> > > Lev AssinovskyPeterlink Web
> > > ProgrammerSt. 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]>
> > >
> > >
> >
> > --
> > To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> > For additional commands: <mailto:[EMAIL PROTECTED]>
> > Troubles with the list: <mailto:[EMAIL PROTECTED]>
>
> --
> Lev AssinovskyPeterlink Web
> ProgrammerSt. 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]>

--
Lev AssinovskyPeterlink Web
ProgrammerSt. 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]>

RE: Who uses connection pool?

2002-03-05 Thread Jim Urban 

We do.

Jim Urban
Product Manager
Netsteps Inc.
Suite 505E
1 Pierce Pl.
Itasca, IL  60143
Voice:  (630) 250-3045 x2164
Fax:  (630) 250-3046


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> Of Lev Assinovsky
> Sent: Tuesday, March 05, 2002 3:09 AM
> To: 'Tomcat Users List'
> Subject: Who uses connection pool?
>
>
> Hi!
> Could you tell me please,
> does anybody successfully use database connection pool?
>
>
> --
> Lev AssinovskyPeterlink Web
> ProgrammerSt. Petersburg, Russia
> Tel/Fax: +7 812 3275343   197022 ul.Chapigina 7Á
> E-mail: [EMAIL PROTECTED]
>
>
>
>
> --
> To unsubscribe:   
> For additional commands: 
> Troubles with the list: 
>
>


--
To unsubscribe:   
For additional commands: 
Troubles with the list:

Re: Who uses connection pool?

2002-03-05 Thread Lev Assinovsky 

Which one?
Jim Urban wrote:

> We do.
>
> Jim Urban
> Product Manager
> Netsteps Inc.
> Suite 505E
> 1 Pierce Pl.
> Itasca, IL  60143
> Voice:  (630) 250-3045 x2164
> Fax:  (630) 250-3046
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> > Of Lev Assinovsky
> > Sent: Tuesday, March 05, 2002 3:09 AM
> > To: 'Tomcat Users List'
> > Subject: Who uses connection pool?
> >
> >
> > Hi!
> > Could you tell me please,
> > does anybody successfully use database connection pool?
> >
> >
> > --
> > Lev AssinovskyPeterlink Web
> > ProgrammerSt. Petersburg, Russia
> > Tel/Fax: +7 812 3275343   197022 ul.Chapigina 7Á
> > E-mail: [EMAIL PROTECTED]
> >
> >
> >
> >
> > --
> > To unsubscribe:   
> > For additional commands: 
> > Troubles with the list: 
> >
> >
>
> --
> To unsubscribe:   
> For additional commands: 
> Troubles with the list: 

--
Lev AssinovskyPeterlink Web
ProgrammerSt. Petersburg, Russia
Tel/Fax: +7 812 3275343   197022 ul.Chapigina 7Á
E-mail: [EMAIL PROTECTED]




--
To unsubscribe:   
For additional commands: 
Troubles with the list:

RE: Who uses connection pool?

2002-03-05 Thread King-On Yeung 

yes, i do.

follow suggestion:
http://mikal.org/interests/java/tomcat/archive/view?mesg=41226

it works for JNDI + postgesql .
-- 




__
Your favorite stores, helpful shopping tools and great gift ideas. Experience the 
convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/


--
To unsubscribe:   
For additional commands: 
Troubles with the list:

RE: Who uses connection pool?

2002-03-05 Thread Jim Urban 

DBConnectionBroker http://opensource.devdaily.com/ddConnectionBroker.shtml

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> Of Lev Assinovsky
> Sent: Tuesday, March 05, 2002 7:47 AM
> To: Tomcat Users List
> Subject: Re: Who uses connection pool?
>
>
> Which one?
> Jim Urban wrote:
>
> > We do.
> >
> > Jim Urban
> > Product Manager
> > Netsteps Inc.
> > Suite 505E
> > 1 Pierce Pl.
> > Itasca, IL  60143
> > Voice:  (630) 250-3045 x2164
> > Fax:  (630) 250-3046
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> > > Of Lev Assinovsky
> > > Sent: Tuesday, March 05, 2002 3:09 AM
> > > To: 'Tomcat Users List'
> > > Subject: Who uses connection pool?
> > >
> > >
> > > Hi!
> > > Could you tell me please,
> > > does anybody successfully use database connection pool?
> > >
> > >
> > > --
> > > Lev AssinovskyPeterlink Web
> > > ProgrammerSt. 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]>
> > >
> > >
> >
> > --
> > To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> > For additional commands: <mailto:[EMAIL PROTECTED]>
> > Troubles with the list: <mailto:[EMAIL PROTECTED]>
>
> --
> Lev AssinovskyPeterlink Web
> ProgrammerSt. 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]>
>
>


--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>

Re: Who uses connection pool?

2002-03-05 Thread Lev Assinovsky 

Hello!
I followed your link and found out that example in there is slightly
incorrect. Identifier "dataSrc" is not declared.
Besides Tyrex people acknowledged that if your database doesn't support pooling
then all you have is tyrex EnabledDataSource class without pool support.
I personally is waiting for tyrex-1.0.

King-On Yeung wrote:

> yes, i do.
>
> follow suggestion:
> http://mikal.org/interests/java/tomcat/archive/view?mesg=41226
>
> it works for JNDI + postgesql .
> --
>
> __
> Your favorite stores, helpful shopping tools and great gift ideas. Experience the 
>convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/
>
> Get your own FREE, personal Netscape Mail account today at 
>http://webmail.netscape.com/
>
> --
> To unsubscribe:   
> For additional commands: 
> Troubles with the list: 

--
Lev AssinovskyPeterlink Web
ProgrammerSt. Petersburg, Russia
Tel/Fax: +7 812 3275343   197022 ul.Chapigina 7Á
E-mail: [EMAIL PROTECTED]




--
To unsubscribe:   
For additional commands: 
Troubles with the list:

Re: Who uses connection pool?

2002-03-05 Thread Lev Assinovsky 

Good! I just found out that  ConnectionPoolDataSource is not properly
implemented in tyrex stuff (Tyrex people acknowledged that).
Did  you hardcode pool instance creation or found a way when JNDI do that?

Jim Urban wrote:

> DBConnectionBroker http://opensource.devdaily.com/ddConnectionBroker.shtml
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> > Of Lev Assinovsky
> > Sent: Tuesday, March 05, 2002 7:47 AM
> > To: Tomcat Users List
> > Subject: Re: Who uses connection pool?
> >
> >
> > Which one?
> > Jim Urban wrote:
> >
> > > We do.
> > >
> > > Jim Urban
> > > Product Manager
> > > Netsteps Inc.
> > > Suite 505E
> > > 1 Pierce Pl.
> > > Itasca, IL  60143
> > > Voice:  (630) 250-3045 x2164
> > > Fax:  (630) 250-3046
> > >
> > > > -Original Message-
> > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> > > > Of Lev Assinovsky
> > > > Sent: Tuesday, March 05, 2002 3:09 AM
> > > > To: 'Tomcat Users List'
> > > > Subject: Who uses connection pool?
> > > >
> > > >
> > > > Hi!
> > > > Could you tell me please,
> > > > does anybody successfully use database connection pool?
> > > >
> > > >
> > > > --
> > > > Lev AssinovskyPeterlink Web
> > > > ProgrammerSt. 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]>
> > > >
> > > >
> > >
> > > --
> > > To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> > > For additional commands: <mailto:[EMAIL PROTECTED]>
> > > Troubles with the list: <mailto:[EMAIL PROTECTED]>
> >
> > --
> > Lev AssinovskyPeterlink Web
> > ProgrammerSt. 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]>
> >
> >
>
> --
> To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>

--
Lev AssinovskyPeterlink Web
ProgrammerSt. 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]>

RE: Who uses connection pool?

2002-03-05 Thread Jim Urban 

Here are some code fragments from our servlet (we use a single dispatcher
servlet):

public void init(ServletConfig iConfig) throws ServletException
{
super.init(iConfig);
...
initializeDbConnectionBroker(iConfig);
...
}

private void initializeDbConnectionBroker(ServletConfig iConfig)
{
String dbDriver = getInitParameter("DB_DRIVER");
String dbName = getInitParameter("DB_NAME");
String dbUser = getInitParameter("DB_USER");
String dbPassword = getInitParameter("DB_PSWD");
String logfile = getInitParameter("DB_LOG_FILE");
int initConn = new Integer(getInitParameter("DB_INITCONN")).intValue();
int maxConn = new Integer(getInitParameter(DB_"MAXCONN")).intValue();
int connTimeOut = new
Integer(getInitParameter("DB_CONNTIMEOUT")).intValue();
double maxConnTime = new
Double(getInitParameter("DB_MAXCONNTIME")).doubleValue();
try
{
logMessage("Initializing DB connection pool.");
ConnectionPool.initialize(dbDriver, dbName, dbUser, 
dbPassword, logfile,
initConn, maxConn, connTimeOut , maxConnTime);
logMessage("DB connection pool initialized.");
}
catch (Exception e)
{
logException(e, this);
logMessage("ConnectionPool.init error:  " + e.toString());
}
}


public class ConnectionPool extends Object
{
private static DbConnectionBroker myBroker = null;
private static int connTimeOut = 0;

public static void initialize(String DBDriver, String DBName, String
DBUser, String DBPsWd,
  String Logfile, int initConn, int maxConn, int 
iConnTimeOut, double
maxConnTime)
  throws IOException
{
if (DBDriver != null && DBDriver.length() > 0)
{
myBroker = new DbConnectionBroker(DBDriver, DBName, DBUser, 
DBPsWd,
initConn,
 maxConn, Logfile, 
maxConnTime);
connTimeOut = iConnTimeOut;
}
}

public static synchronized DbConnectionBroker getBroker()
{
return myBroker;
}

public static synchronized void shutDown()
{
try
{
myBroker.destroy(connTimeOut);
}
catch(SQLException e){}
}
}


Jim



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> Of Lev Assinovsky
> Sent: Tuesday, March 05, 2002 9:10 AM
> To: Tomcat Users List
> Subject: Re: Who uses connection pool?
>
>
> Good! I just found out that  ConnectionPoolDataSource is not properly
> implemented in tyrex stuff (Tyrex people acknowledged that).
> Did  you hardcode pool instance creation or found a way when JNDI do that?
>
> Jim Urban wrote:
>
> > DBConnectionBroker
> http://opensource.devdaily.com/ddConnectionBroker.shtml
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> > > Of Lev Assinovsky
> > > Sent: Tuesday, March 05, 2002 7:47 AM
> > > To: Tomcat Users List
> > > Subject: Re: Who uses connection pool?
> > >
> > >
> > > Which one?
> > > Jim Urban wrote:
> > >
> > > > We do.
> > > >
> > > > Jim Urban
> > > > Product Manager
> > > > Netsteps Inc.
> > > > Suite 505E
> > > > 1 Pierce Pl.
> > > > Itasca, IL  60143
> > > > Voice:  (630) 250-3045 x2164
> > > > Fax:  (630) 250-3046
> > > >
> > > > > -Original Message-
> > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> > > > > Of Lev Assinovsky
> > > > > Sent: Tuesday, March 05, 2002 3:09 AM
> > > > > To: 'Tomcat Users List'
> > > > > Subject: Who uses connection pool?
> > > > >
> > > > >
> > > > > Hi!
> > > > > Could you tell me please,
> > > > > does anybody successfully use database connection pool?
> > > > >
> > > > >
> > > > > --
> > > > > Lev Assinovsky

Re: Who uses connection pool?

2002-03-05 Thread Mark Muffett 

Done that, but it still doesn't work (I'm also trying JNDI + postgresql).
Could you point us to a sample server.xml entry for postgres? (or anything
else needed)

Thanks

Mark Muffett

- Original Message -
From: "King-On Yeung" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 1:50 PM
Subject: RE: Who uses connection pool?


> yes, i do.
>
> follow suggestion:
> http://mikal.org/interests/java/tomcat/archive/view?mesg=41226
>
> it works for JNDI + postgesql .
> --
>
>
>
>
> __
> Your favorite stores, helpful shopping tools and great gift ideas.
Experience the convenience of buying online with Shop@Netscape!
http://shopnow.netscape.com/
>
> Get your own FREE, personal Netscape Mail account today at
http://webmail.netscape.com/
>
>
> --
> To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>
>


--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>

RE: Who uses connection pool?

2002-03-05 Thread Julio Castillo 

Is there any connection pool implementation that uses the
ConnectionPoolDataSource provided by the latest JDBC drivers?

** julio

-Original Message-
From: Jim Urban [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 8:27 AM
To: Tomcat Users List
Subject: RE: Who uses connection pool?


Here are some code fragments from our servlet (we use a single dispatcher
servlet):

public void init(ServletConfig iConfig) throws ServletException
{
super.init(iConfig);
...
initializeDbConnectionBroker(iConfig);
...
}

private void initializeDbConnectionBroker(ServletConfig iConfig)
{
String dbDriver = getInitParameter("DB_DRIVER");
String dbName = getInitParameter("DB_NAME");
String dbUser = getInitParameter("DB_USER");
String dbPassword = getInitParameter("DB_PSWD");
String logfile = getInitParameter("DB_LOG_FILE");
int initConn = new Integer(getInitParameter("DB_INITCONN")).intValue();
int maxConn = new Integer(getInitParameter(DB_"MAXCONN")).intValue();
int connTimeOut = new
Integer(getInitParameter("DB_CONNTIMEOUT")).intValue();
double maxConnTime = new
Double(getInitParameter("DB_MAXCONNTIME")).doubleValue();
try
{
logMessage("Initializing DB connection pool.");
ConnectionPool.initialize(dbDriver, dbName, dbUser, 
dbPassword, logfile,
initConn, maxConn, connTimeOut , maxConnTime);
logMessage("DB connection pool initialized.");
}
catch (Exception e)
{
logException(e, this);
logMessage("ConnectionPool.init error:  " + e.toString());
}
}


public class ConnectionPool extends Object
{
private static DbConnectionBroker myBroker = null;
private static int connTimeOut = 0;

public static void initialize(String DBDriver, String DBName, String
DBUser, String DBPsWd,
  String Logfile, int initConn, int maxConn, int 
iConnTimeOut, double
maxConnTime)
  throws IOException
{
if (DBDriver != null && DBDriver.length() > 0)
{
myBroker = new DbConnectionBroker(DBDriver, DBName, DBUser, 
DBPsWd,
initConn,
 maxConn, Logfile, 
maxConnTime);
connTimeOut = iConnTimeOut;
}
}

public static synchronized DbConnectionBroker getBroker()
{
return myBroker;
}

public static synchronized void shutDown()
{
try
{
myBroker.destroy(connTimeOut);
}
catch(SQLException e){}
}
}


Jim



> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> Of Lev Assinovsky
> Sent: Tuesday, March 05, 2002 9:10 AM
> To: Tomcat Users List
> Subject: Re: Who uses connection pool?
>
>
> Good! I just found out that  ConnectionPoolDataSource is not properly
> implemented in tyrex stuff (Tyrex people acknowledged that).
> Did  you hardcode pool instance creation or found a way when JNDI do that?
>
> Jim Urban wrote:
>
> > DBConnectionBroker
> http://opensource.devdaily.com/ddConnectionBroker.shtml
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> > > Of Lev Assinovsky
> > > Sent: Tuesday, March 05, 2002 7:47 AM
> > > To: Tomcat Users List
> > > Subject: Re: Who uses connection pool?
> > >
> > >
> > > Which one?
> > > Jim Urban wrote:
> > >
> > > > We do.
> > > >
> > > > Jim Urban
> > > > Product Manager
> > > > Netsteps Inc.
> > > > Suite 505E
> > > > 1 Pierce Pl.
> > > > Itasca, IL  60143
> > > > Voice:  (630) 250-3045 x2164
> > > > Fax:  (630) 250-3046
> > > >
> > > > > -Original Message-
> > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> > > > > Of Lev Assinovsky
> > > > > Sent: Tuesday, March 05, 2002 3:09 AM
> > > > > To: 'Tomcat Users List'
> > > > > Subject: Who uses connection pool?
> > > > >
> >

RE: Who uses connection pool?

2002-03-05 Thread Julio Castillo 

I just downloaded Tomcat 4.0.3 and didn't see any Tyrex jar files. Are they
bundled inside Tomcat's jar files?

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lev
Assinovsky
Sent: Tuesday, March 05, 2002 1:37 AM
To: Tomcat Users List
Subject: Re: Who uses connection pool?


I already looked in there.
I was confused that their pool is for GSP.
Tomcat uses Tyrex by default. How about that?

Reynir H?bner wrote:

> sure
> check out bitmechanic.com, thats a fine place to start.
>
> -hope it helps
> [EMAIL PROTECTED]
>
> > -Original Message-
> > From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
> > Sent: 5. mars 2002 09:09
> > To: 'Tomcat Users List'
> > Subject: Who uses connection pool?
> >
> >
> > Hi!
> > Could you tell me please,
> > does anybody successfully use database connection pool?
> >
> >
> > --
> > Lev AssinovskyPeterlink Web
> > ProgrammerSt. 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]>
> >
> >

--
Lev AssinovskyPeterlink Web
ProgrammerSt. 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]>




--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>

RE: Who uses connection pool?

2002-03-05 Thread Julio Castillo 

I checked the Exolab.org website for an updated Tyrex, and noticed in their
Change Log that the last version released was 0.9.7 which is more than a
year old. I wonder if anyone is working on the 1.0 version.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lev
Assinovsky
Sent: Tuesday, March 05, 2002 6:59 AM
To: Tomcat Users List
Subject: Re: Who uses connection pool?


Hello!
I followed your link and found out that example in there is slightly
incorrect. Identifier "dataSrc" is not declared.
Besides Tyrex people acknowledged that if your database doesn't support
pooling
then all you have is tyrex EnabledDataSource class without pool support.
I personally is waiting for tyrex-1.0.

King-On Yeung wrote:

> yes, i do.
>
> follow suggestion:
> http://mikal.org/interests/java/tomcat/archive/view?mesg=41226
>
> it works for JNDI + postgesql .
> --
>
> __
> Your favorite stores, helpful shopping tools and great gift ideas.
Experience the convenience of buying online with Shop@Netscape!
http://shopnow.netscape.com/
>
> Get your own FREE, personal Netscape Mail account today at
http://webmail.netscape.com/
>
> --
> To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>

--
Lev AssinovskyPeterlink Web
ProgrammerSt. 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]>




--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>

Re: Who uses connection pool?

2002-03-05 Thread Lev Assinovsky 

Yes, you are partially right.
The last post to their mailing list of one of the Tyrex developers was around
November, 20.

Julio Castillo wrote:

> I checked the Exolab.org website for an updated Tyrex, and noticed in their
> Change Log that the last version released was 0.9.7 which is more than a
> year old. I wonder if anyone is working on the 1.0 version.
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lev
> Assinovsky
> Sent: Tuesday, March 05, 2002 6:59 AM
> To: Tomcat Users List
> Subject: Re: Who uses connection pool?
>
> Hello!
> I followed your link and found out that example in there is slightly
> incorrect. Identifier "dataSrc" is not declared.
> Besides Tyrex people acknowledged that if your database doesn't support
> pooling
> then all you have is tyrex EnabledDataSource class without pool support.
> I personally is waiting for tyrex-1.0.
>
> King-On Yeung wrote:
>
> > yes, i do.
> >
> > follow suggestion:
> > http://mikal.org/interests/java/tomcat/archive/view?mesg=41226
> >
> > it works for JNDI + postgesql .
> > --
> >
> > __
> > Your favorite stores, helpful shopping tools and great gift ideas.
> Experience the convenience of buying online with Shop@Netscape!
> http://shopnow.netscape.com/
> >
> > Get your own FREE, personal Netscape Mail account today at
> http://webmail.netscape.com/
> >
> > --
> > To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> > For additional commands: <mailto:[EMAIL PROTECTED]>
> > Troubles with the list: <mailto:[EMAIL PROTECTED]>
>
> --
> Lev AssinovskyPeterlink Web
> ProgrammerSt. 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]>
>
> --
> To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>

--
Lev AssinovskyPeterlink Web
ProgrammerSt. 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]>

RE: Who uses connection pool?

2002-03-05 Thread Rich Sneiderman 

Hi folks,

Ok, I know we've beaten this to death today but all this discussion
about DB Pooling got me thinking...

Currently I'm using the Oracle thin client JDBC driver (class12.jar) to
talk to a 9i database.  I'm currently using the connection
pooling/caching support Oracle supplies (the OracleConnectionCacheImpl
class). Have any of you used this?  How would you contrast it to say
poolman, Bitmechanic's pool code, or DBConnectionBroker (I think that's
all the ones that have been thrown around today)?  Would one of these be
a better choice?  Based on today's discussion I won't even consider
Tomcat's native pooling (tyrex).

I'm still in development with my code and haven't put it under load so
it would be nice to know if this is a good route to take before we get
into production.

Thanks in advance.

- Rich

--
To unsubscribe:   
For additional commands: 
Troubles with the list:

Re: Who uses connection pool?

2002-03-05 Thread Lev Assinovsky 

Could you send me your latest server.xml fragment.
Connection pool should work as a simple connection.

Mark Muffett wrote:

> Done that, but it still doesn't work (I'm also trying JNDI + postgresql).
> Could you point us to a sample server.xml entry for postgres? (or anything
> else needed)
>
> Thanks
>
> Mark Muffett
>
> - Original Message -
> From: "King-On Yeung" <[EMAIL PROTECTED]>
> To: "Tomcat Users List" <[EMAIL PROTECTED]>
> Sent: Tuesday, March 05, 2002 1:50 PM
> Subject: RE: Who uses connection pool?
>
> > yes, i do.
> >
> > follow suggestion:
> > http://mikal.org/interests/java/tomcat/archive/view?mesg=41226
> >
> > it works for JNDI + postgesql .
> > --
> >
> >
> >
> >
> > __
> > Your favorite stores, helpful shopping tools and great gift ideas.
> Experience the convenience of buying online with Shop@Netscape!
> http://shopnow.netscape.com/
> >
> > Get your own FREE, personal Netscape Mail account today at
> http://webmail.netscape.com/
> >
> >
> > --
> > To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> > For additional commands: <mailto:[EMAIL PROTECTED]>
> > Troubles with the list: <mailto:[EMAIL PROTECTED]>
> >
>
> --
> To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>

--
Lev AssinovskyPeterlink Web
ProgrammerSt. 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]>

Re: Who uses connection pool?

2002-03-05 Thread Lev Assinovsky 

Jim, that's fine!
But how to provide the same through JNDI to be free of
particular DB?

Jim Urban wrote:

> Here are some code fragments from our servlet (we use a single dispatcher
> servlet):
>
> public void init(ServletConfig iConfig) throws ServletException
> {
> super.init(iConfig);
> ...
> initializeDbConnectionBroker(iConfig);
> ...
> }
>
> private void initializeDbConnectionBroker(ServletConfig iConfig)
> {
> String dbDriver = getInitParameter("DB_DRIVER");
> String dbName = getInitParameter("DB_NAME");
> String dbUser = getInitParameter("DB_USER");
> String dbPassword = getInitParameter("DB_PSWD");
> String logfile = getInitParameter("DB_LOG_FILE");
> int initConn = new 
>Integer(getInitParameter("DB_INITCONN")).intValue();
> int maxConn = new Integer(getInitParameter(DB_"MAXCONN")).intValue();
> int connTimeOut = new
> Integer(getInitParameter("DB_CONNTIMEOUT")).intValue();
> double maxConnTime = new
> Double(getInitParameter("DB_MAXCONNTIME")).doubleValue();
> try
> {
> logMessage("Initializing DB connection pool.");
> ConnectionPool.initialize(dbDriver, dbName, dbUser, 
>dbPassword, logfile,
> initConn, maxConn, connTimeOut , 
>maxConnTime);
> logMessage("DB connection pool initialized.");
> }
> catch (Exception e)
> {
> logException(e, this);
> logMessage("ConnectionPool.init error:  " + e.toString());
> }
> }
>
> public class ConnectionPool extends Object
> {
> private static DbConnectionBroker myBroker = null;
> private static int connTimeOut = 0;
>
> public static void initialize(String DBDriver, String DBName, String
> DBUser, String DBPsWd,
>   String Logfile, int initConn, int maxConn, int 
>iConnTimeOut, double
> maxConnTime)
>   throws IOException
> {
> if (DBDriver != null && DBDriver.length() > 0)
> {
> myBroker = new DbConnectionBroker(DBDriver, DBName, DBUser, 
>DBPsWd,
> initConn,
>  maxConn, Logfile, 
>maxConnTime);
> connTimeOut = iConnTimeOut;
> }
> }
>
> public static synchronized DbConnectionBroker getBroker()
> {
> return myBroker;
> }
>
> public static synchronized void shutDown()
> {
> try
>             {
>     myBroker.destroy(connTimeOut);
> }
> catch(SQLException e){}
> }
> }
>
> Jim
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> > Of Lev Assinovsky
> > Sent: Tuesday, March 05, 2002 9:10 AM
> > To: Tomcat Users List
> > Subject: Re: Who uses connection pool?
> >
> >
> > Good! I just found out that  ConnectionPoolDataSource is not properly
> > implemented in tyrex stuff (Tyrex people acknowledged that).
> > Did  you hardcode pool instance creation or found a way when JNDI do that?
> >
> > Jim Urban wrote:
> >
> > > DBConnectionBroker
> > http://opensource.devdaily.com/ddConnectionBroker.shtml
> > >
> > > > -Original Message-
> > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> > > > Of Lev Assinovsky
> > > > Sent: Tuesday, March 05, 2002 7:47 AM
> > > > To: Tomcat Users List
> > > > Subject: Re: Who uses connection pool?
> > > >
> > > >
> > > > Which one?
> > > > Jim Urban wrote:
> > > >
> > > > > We do.
> > > > >
> > > > > Jim Urban
> > > > > Product Manager
> > > > > Netsteps Inc.
> > > > > Suite 505E
> > > > > 1 Pierce Pl.
> > > > > Itasca, IL  60143
> > > > > Voice:  (630) 250-3045 x2164
> > > > > Fax:  (630) 250-3046
> > > > >
> >

RE: Who uses connection pool?

2002-03-05 Thread Jim Urban 

We use DBConnectionBroker regardless of the database.  This way the its
easier to switch databases depending on which one a client chooses.

Jim

> -Original Message-
> From: Rich Sneiderman [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 05, 2002 1:27 PM
> To: Tomcat Users List
> Subject: RE: Who uses connection pool?
>
>
> Hi folks,
>
> Ok, I know we've beaten this to death today but all this discussion
> about DB Pooling got me thinking...
>
> Currently I'm using the Oracle thin client JDBC driver (class12.jar) to
> talk to a 9i database.  I'm currently using the connection
> pooling/caching support Oracle supplies (the OracleConnectionCacheImpl
> class). Have any of you used this?  How would you contrast it to say
> poolman, Bitmechanic's pool code, or DBConnectionBroker (I think that's
> all the ones that have been thrown around today)?  Would one of these be
> a better choice?  Based on today's discussion I won't even consider
> Tomcat's native pooling (tyrex).
>
> I'm still in development with my code and haven't put it under load so
> it would be nice to know if this is a good route to take before we get
> into production.
>
> Thanks in advance.
>
> - Rich
>
> --
> To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>
>
>


--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>

RE: Who uses connection pool?

2002-03-05 Thread Jim Urban 

We are database independent.  If you look at the
initializeDbConnectionBroker method you will see we load all that
information from the web.xml via servlet init parameters.  Our code can use
any database you have a driver for (granted it supports ANSI SQL)..

Jim

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> Of Lev Assinovsky
> Sent: Tuesday, March 05, 2002 1:42 PM
> To: Tomcat Users List
> Subject: Re: Who uses connection pool?
>
>
> Jim, that's fine!
> But how to provide the same through JNDI to be free of
> particular DB?
>
> Jim Urban wrote:
>
> > Here are some code fragments from our servlet (we use a single
> dispatcher
> > servlet):
> >
> > public void init(ServletConfig iConfig) throws ServletException
> > {
> > super.init(iConfig);
> > ...
> > initializeDbConnectionBroker(iConfig);
> > ...
> > }
> >
> > private void initializeDbConnectionBroker(ServletConfig iConfig)
> > {
> > String dbDriver = getInitParameter("DB_DRIVER");
> > String dbName = getInitParameter("DB_NAME");
> > String dbUser = getInitParameter("DB_USER");
> > String dbPassword = getInitParameter("DB_PSWD");
> > String logfile = getInitParameter("DB_LOG_FILE");
> > int initConn = new
> Integer(getInitParameter("DB_INITCONN")).intValue();
> > int maxConn = new
> Integer(getInitParameter(DB_"MAXCONN")).intValue();
> > int connTimeOut = new
> > Integer(getInitParameter("DB_CONNTIMEOUT")).intValue();
> > double maxConnTime = new
> > Double(getInitParameter("DB_MAXCONNTIME")).doubleValue();
> > try
> > {
> > logMessage("Initializing DB connection pool.");
> > ConnectionPool.initialize(dbDriver,
> dbName, dbUser, dbPassword, logfile,
> > initConn, maxConn,
> connTimeOut , maxConnTime);
> > logMessage("DB connection pool initialized.");
> > }
> > catch (Exception e)
> > {
> > logException(e, this);
> > logMessage("ConnectionPool.init error:
> " + e.toString());
> > }
> > }
> >
> > public class ConnectionPool extends Object
> > {
> > private static DbConnectionBroker myBroker = null;
> > private static int connTimeOut = 0;
> >
> > public static void initialize(String DBDriver, String
> DBName, String
> > DBUser, String DBPsWd,
> >   String Logfile, int initConn,
> int maxConn, int iConnTimeOut, double
> > maxConnTime)
> >   throws IOException
> > {
> > if (DBDriver != null && DBDriver.length() > 0)
> > {
> > myBroker = new
> DbConnectionBroker(DBDriver, DBName, DBUser, DBPsWd,
> > initConn,
> >
>  maxConn, Logfile, maxConnTime);
> > connTimeOut = iConnTimeOut;
> > }
> > }
> >
> > public static synchronized DbConnectionBroker getBroker()
> >     {
> > return myBroker;
> > }
> >
> > public static synchronized void shutDown()
> > {
> > try
> > {
> > myBroker.destroy(connTimeOut);
> > }
> > catch(SQLException e){}
> > }
> > }
> >
> > Jim
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
> > > Of Lev Assinovsky
> > > Sent: Tuesday, March 05, 2002 9:10 AM
> > > To: Tomcat Users List
> > > Subject: Re: Who uses connection pool?
> > >
> > >
> > > Good! I just found out that  ConnectionPoolDataSource is not properly
> > > implemented in tyrex stuff (Tyrex people acknowledged that).
> > > Did  you hardcode pool instance creation or found a way when
> JNDI do that?
> > >
> > > Jim Urban wrote:
> > >
> > > > DBConnectionBroker

Re: Who uses connection pool?

2002-03-05 Thread Remy Maucherat 

> Yes, you are partially right.
> The last post to their mailing list of one of the Tyrex developers was
around
> November, 20.

The HEAD branch of Tyrex is a very different TM than 0.9.7 was.
Unfortunately, Intalio has apparently no incentive to release an updated
version (can't really blame them).
The new Tyrex is a complex and complete TM, with support for branches and
JTS/OTS (unfortunately, it needs OpenORB to do most of its stuff, now, which
makes the whole thing even more complex).

4.1 (known at the moment as 4.0-HEAD) uses the commons-dbcp project as the
default connection pool provider.

Remy


--
To unsubscribe:   
For additional commands: 
Troubles with the list:

Re: Who uses connection pool?

2002-03-05 Thread Nikola Milutinovic 

> We are database independent.  If you look at the
> initializeDbConnectionBroker method you will see we load all that
> information from the web.xml via servlet init parameters.  Our code can use
> any database you have a driver for (granted it supports ANSI SQL)..

> > > private void initializeDbConnectionBroker(ServletConfig iConfig)
> > > {
> > > String dbDriver = getInitParameter("DB_DRIVER");
> > > String dbName = getInitParameter("DB_NAME");
> > > String dbUser = getInitParameter("DB_USER");
> > > String dbPassword = getInitParameter("DB_PSWD");
> > > String logfile = getInitParameter("DB_LOG_FILE");
> > > int initConn = new
> > Integer(getInitParameter("DB_INITCONN")).intValue();
> > > int maxConn = new
> > Integer(getInitParameter(DB_"MAXCONN")).intValue();
> > > int connTimeOut = new
> > > Integer(getInitParameter("DB_CONNTIMEOUT")).intValue();
> > > double maxConnTime = new
> > > Double(getInitParameter("DB_MAXCONNTIME")).doubleValue();

In other words, you're specifying raw connection parameters in the web.xml. I think 
most of us are interested in a full JNDI approach, where server.xml and web.xml 
cooperate, allowing server administrator to choose data source, while application 
deployer is concerned with other things. That is why they are bugging with JNDI. Can 
it be done with DBConnectionBroker?

Nix.

RE: Who uses connection pool?

2002-03-06 Thread Jim Urban 

Don't know.

Jim

> -Original Message-
> From: Nikola Milutinovic [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 06, 2002 1:17 AM
> To: Tomcat Users List
> Subject: Re: Who uses connection pool?
> 
> 
> > We are database independent.  If you look at the
> > initializeDbConnectionBroker method you will see we load all that
> > information from the web.xml via servlet init parameters.  Our 
> code can use
> > any database you have a driver for (granted it supports ANSI SQL)..
> 
> > > > private void 
> initializeDbConnectionBroker(ServletConfig iConfig)
> > > > {
> > > > String dbDriver = getInitParameter("DB_DRIVER");
> > > > String dbName = getInitParameter("DB_NAME");
> > > > String dbUser = getInitParameter("DB_USER");
> > > > String dbPassword = getInitParameter("DB_PSWD");
> > > > String logfile = getInitParameter("DB_LOG_FILE");
> > > > int initConn = new
> > > Integer(getInitParameter("DB_INITCONN")).intValue();
> > > > int maxConn = new
> > > Integer(getInitParameter(DB_"MAXCONN")).intValue();
> > > > int connTimeOut = new
> > > > Integer(getInitParameter("DB_CONNTIMEOUT")).intValue();
> > > > double maxConnTime = new
> > > > Double(getInitParameter("DB_MAXCONNTIME")).doubleValue();
> 
> In other words, you're specifying raw connection parameters in 
> the web.xml. I think most of us are interested in a full JNDI 
> approach, where server.xml and web.xml cooperate, allowing server 
> administrator to choose data source, while application deployer 
> is concerned with other things. That is why they are bugging with 
> JNDI. Can it be done with DBConnectionBroker?
> 
> Nix.
> 

--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>

Re: Who uses connection pool?

2002-03-06 Thread Eddie Bush 

Jim, I couldn't tell from the page - with you having some experience with
the DDConnectionBroker, I thought I'd shoot you a couple of questions:

Pool Instantiation
Do I need to create this pool in an initialization servlet and put an
instance of it in the servlet context?  It looks like it's possible that
using this 'pool' might result in a new pool for each servlet... which isn't
really going to solve any problems for me.  In practice, how have you
noticed it to act?

Connection Maintenance
The site has this to say:

In the future, the number of connections in the pool will vary from
minConnections to maxConnections; minConnections will be available during
slow times; maxConnections will be in the pool when busy. (This is not
currently implemented.)

What behavior have you observed?  Does it just keep the increased number of
connections?  That doesn't sound very good either.

Thanks so much!

Eddie

- Original Message -
From: "Jim Urban" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 3:31 PM
Subject: RE: Who uses connection pool?


> We use DBConnectionBroker regardless of the database.  This way the its
> easier to switch databases depending on which one a client chooses.
>
> Jim
>
> > -Original Message-
> > From: Rich Sneiderman [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, March 05, 2002 1:27 PM
> > To: Tomcat Users List
> > Subject: RE: Who uses connection pool?
> >
> >
> > Hi folks,
> >
> > Ok, I know we've beaten this to death today but all this discussion
> > about DB Pooling got me thinking...
> >
> > Currently I'm using the Oracle thin client JDBC driver (class12.jar) to
> > talk to a 9i database.  I'm currently using the connection
> > pooling/caching support Oracle supplies (the OracleConnectionCacheImpl
> > class). Have any of you used this?  How would you contrast it to say
> > poolman, Bitmechanic's pool code, or DBConnectionBroker (I think that's
> > all the ones that have been thrown around today)?  Would one of these be
> > a better choice?  Based on today's discussion I won't even consider
> > Tomcat's native pooling (tyrex).
> >
> > I'm still in development with my code and haven't put it under load so
> > it would be nice to know if this is a good route to take before we get
> > into production.
> >
> > Thanks in advance.
> >
> > - Rich
> >
> > --
> > To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> > For additional commands: <mailto:[EMAIL PROTECTED]>
> > Troubles with the list: <mailto:[EMAIL PROTECTED]>
> >
> >
>
>
> --
> To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>
>


--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>

RE: Who uses connection pool?

2002-03-06 Thread Jim Urban 

We have one servlet (our controller servlet) which we have tagged in our
web.xml as load on start up first.  This servlet initializes the connection
pool.  Our class which wraps the connection pool is a Singleton class which
has a public static member method to access the connection broker.  This way
all servlets and classes within the context share a single copy of the
connection broker.

As documented, the minimum number of connections is established when the
broker is initialized.  The number of connections grows as needed.  You will
notice a parameter "double maxConnTime".  This is a portion of a 24 hour
day.  That is 1.0 = 24 hours, 2.0 = 48 hours, .5 = 12 hours, .25 = 6 hours
etc.  Every this number hours the connections are closed and the minimum
number of connections are re-established.  This helps cut down on unused
open connections and replaces any connections which have been dropped for
whatever reason.  This is may not be the most efficient way of managing
connections, but it doesn't use much overhead either.

Over all we have been quite happy with DDConnectionBroker.  It seems quite
reliable (sometimes simple is better) and the price is right!  It also works
fine with the Oracle driver, MySQL driver and freetds (for MS SQL).

Jim

> -Original Message-
> From: Eddie Bush [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 06, 2002 9:25 AM
> To: Tomcat Users List
> Subject: Re: Who uses connection pool?
>
>
> Jim, I couldn't tell from the page - with you having some experience with
> the DDConnectionBroker, I thought I'd shoot you a couple of questions:
>
> Pool Instantiation
> Do I need to create this pool in an initialization servlet and put an
> instance of it in the servlet context?  It looks like it's possible that
> using this 'pool' might result in a new pool for each servlet...
> which isn't
> really going to solve any problems for me.  In practice, how have you
> noticed it to act?
>
> Connection Maintenance
> The site has this to say:
>
> In the future, the number of connections in the pool will vary from
> minConnections to maxConnections; minConnections will be available during
> slow times; maxConnections will be in the pool when busy. (This is not
> currently implemented.)
>
> What behavior have you observed?  Does it just keep the increased
> number of
> connections?  That doesn't sound very good either.
>
> Thanks so much!
>
> Eddie
>
> - Original Message -
> From: "Jim Urban" <[EMAIL PROTECTED]>
> To: "Tomcat Users List" <[EMAIL PROTECTED]>
> Sent: Tuesday, March 05, 2002 3:31 PM
> Subject: RE: Who uses connection pool?
>
>
> > We use DBConnectionBroker regardless of the database.  This way the its
> > easier to switch databases depending on which one a client chooses.
> >
> > Jim
> >
> > > -Original Message-
> > > From: Rich Sneiderman [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, March 05, 2002 1:27 PM
> > > To: Tomcat Users List
> > > Subject: RE: Who uses connection pool?
> > >
> > >
> > > Hi folks,
> > >
> > > Ok, I know we've beaten this to death today but all this discussion
> > > about DB Pooling got me thinking...
> > >
> > > Currently I'm using the Oracle thin client JDBC driver
> (class12.jar) to
> > > talk to a 9i database.  I'm currently using the connection
> > > pooling/caching support Oracle supplies (the OracleConnectionCacheImpl
> > > class). Have any of you used this?  How would you contrast it to say
> > > poolman, Bitmechanic's pool code, or DBConnectionBroker (I
> think that's
> > > all the ones that have been thrown around today)?  Would one
> of these be
> > > a better choice?  Based on today's discussion I won't even consider
> > > Tomcat's native pooling (tyrex).
> > >
> > > I'm still in development with my code and haven't put it under load so
> > > it would be nice to know if this is a good route to take before we get
> > > into production.
> > >
> > > Thanks in advance.
> > >
> > > - Rich
> > >
> > > --
> > > To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> > > For additional commands: <mailto:[EMAIL PROTECTED]>
> > > Troubles with the list: <mailto:[EMAIL PROTECTED]>
> > >
> > >
> >
> >
> > --
> > To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> > For additional commands: <mailto:[EMAIL PROTECTED]>
> > Troubles with the list: <mailto:[EMAIL PROTECTED]>
> >
>
>
> --
> To unsubscribe:   <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>
>
>


--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>

Re: Who uses connection pool?

2002-03-06 Thread Eddie Bush 

Sorry I missed that piece of the docs I guess.  Thanks again for your input!

Eddie

- Original Message -
From: "Jim Urban" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Wednesday, March 06, 2002 9:57 AM
Subject: RE: Who uses connection pool?


> We have one servlet (our controller servlet) which we have tagged in our
> web.xml as load on start up first.  This servlet initializes the
connection
> pool.  Our class which wraps the connection pool is a Singleton class
which
> has a public static member method to access the connection broker.  This
way
> all servlets and classes within the context share a single copy of the
> connection broker.
>
> As documented, the minimum number of connections is established when the
> broker is initialized.  The number of connections grows as needed.  You
will
> notice a parameter "double maxConnTime".  This is a portion of a 24 hour
> day.  That is 1.0 = 24 hours, 2.0 = 48 hours, .5 = 12 hours, .25 = 6 hours
> etc.  Every this number hours the connections are closed and the minimum
> number of connections are re-established.  This helps cut down on unused
> open connections and replaces any connections which have been dropped for
> whatever reason.  This is may not be the most efficient way of managing
> connections, but it doesn't use much overhead either.
>
> Over all we have been quite happy with DDConnectionBroker.  It seems quite
> reliable (sometimes simple is better) and the price is right!  It also
works
> fine with the Oracle driver, MySQL driver and freetds (for MS SQL).
>
> Jim
>
> > -Original Message-
> > From: Eddie Bush [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, March 06, 2002 9:25 AM
> > To: Tomcat Users List
> > Subject: Re: Who uses connection pool?
> >
> >
> > Jim, I couldn't tell from the page - with you having some experience
with
> > the DDConnectionBroker, I thought I'd shoot you a couple of questions:
> >
> > Pool Instantiation
> > Do I need to create this pool in an initialization servlet and put an
> > instance of it in the servlet context?  It looks like it's possible that
> > using this 'pool' might result in a new pool for each servlet...
> > which isn't
> > really going to solve any problems for me.  In practice, how have you
> > noticed it to act?
> >
> > Connection Maintenance
> > The site has this to say:
> >
> > In the future, the number of connections in the pool will vary from
> > minConnections to maxConnections; minConnections will be available
during
> > slow times; maxConnections will be in the pool when busy. (This is not
> > currently implemented.)
> >
> > What behavior have you observed?  Does it just keep the increased
> > number of
> > connections?  That doesn't sound very good either.
> >
> > Thanks so much!
> >
> > Eddie
> >
> > - Original Message -
> > From: "Jim Urban" <[EMAIL PROTECTED]>
> > To: "Tomcat Users List" <[EMAIL PROTECTED]>
> > Sent: Tuesday, March 05, 2002 3:31 PM
> > Subject: RE: Who uses connection pool?
> >
> >
> > > We use DBConnectionBroker regardless of the database.  This way the
its
> > > easier to switch databases depending on which one a client chooses.
> > >
> > > Jim
> > >
> > > > -Original Message-
> > > > From: Rich Sneiderman [mailto:[EMAIL PROTECTED]]
> > > > Sent: Tuesday, March 05, 2002 1:27 PM
> > > > To: Tomcat Users List
> > > > Subject: RE: Who uses connection pool?
> > > >
> > > >
> > > > Hi folks,
> > > >
> > > > Ok, I know we've beaten this to death today but all this discussion
> > > > about DB Pooling got me thinking...
> > > >
> > > > Currently I'm using the Oracle thin client JDBC driver
> > (class12.jar) to
> > > > talk to a 9i database.  I'm currently using the connection
> > > > pooling/caching support Oracle supplies (the
OracleConnectionCacheImpl
> > > > class). Have any of you used this?  How would you contrast it to say
> > > > poolman, Bitmechanic's pool code, or DBConnectionBroker (I
> > think that's
> > > > all the ones that have been thrown around today)?  Would one
> > of these be
> > > > a better choice?  Based on today's discussion I won't even consider
> > > > Tomcat's native pooling (tyrex).
> > > >
> > > > I'