RE: Connection Pooling in Orion

[Andre Vanha]

Adrian,
Use orion's admin.jar to get connection pool info.  On my machine, I can
type this to get stats:
java -jar admin.jar ormi://localhost admin password -application default
-dataSourceInfo

The output looks like this:
DataSource info:
jdbc/xa/HypersonicXADS - cached: 0 used: 0 total: 0
jdbc/HypersonicDS - cached: 0 used: 0 total: 0
jdbc/xa/EMD/MainXADS - cached: 2 used: 0 total: 2
jdbc/EDM/MainDS - cached: 2 used: 0 total: 2

-Original Message-
From: Adrian Yau [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 7:43 PM
To: Orion-Interest
Subject: Connection Pooling in Orion


I think I've correctly set up database connection pooling for my enterprise
app. But how do I confirm that Orion is actually doing connection pooling
for
me?

Thanks.


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

Re: Connection Pooling in Orion

[Robert Krueger]

At 18:43 04.05.2001 , you wrote:
>I think I've correctly set up database connection pooling for my enterprise
>app. But how do I confirm that Orion is actually doing connection pooling for
>me?

- look at your dbms logs (if your dbms provides such facilities)
- enable tracing in your jdbc driver (again, if your jdbc driver provides 
something like that)
- just rely on it because it does work ;-)

HTH

robert

>Thanks.
>
>
>__
>Do You Yahoo!?
>Yahoo! Auctions - buy the things you want at great prices
>http://auctions.yahoo.com/

(-) Robert Krüger
(-) SIGNAL 7 Gesellschaft für Informationstechnologie mbH
(-) Brüder-Knauß-Str. 79 - 64285 Darmstadt,
(-) Tel: 06151 665401, Fax: 06151 665373
(-) [EMAIL PROTECTED], www.signal7.de

Connection Pooling in Orion

[Adrian Yau]

I think I've correctly set up database connection pooling for my enterprise
app. But how do I confirm that Orion is actually doing connection pooling for
me?

Thanks.


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

RE: Database connection Pooling in Orion

[Vimal Kansal]

That answers only a part of question. Where do I
specify the minimum number of connections in the pool.
Typically the way a connection pool works is like this

At the startup(i.e when the application server is
started), a few number of connections are
established(specified by some kind of parameter). This
is called the low water mark. After this point
onwards, as the requests are coming in, the pool keeps
growing and shrinking in size but within min and max. 

Vimal
--- Rick Bos <[EMAIL PROTECTED]> wrote:
> There is a max-connections attribute to the
> data-source in:
> 
> http://www.orionserver.com/dtds/data-sources.dtd
> 
> > -Original Message-
> > From:   Vimal Kansal [SMTP:[EMAIL PROTECTED]]
> > Sent:   September 6, 2000 12:50 PM
> > To: Orion-Interest
> > Subject:Database connection Pooling in Orion
> > 
> > Hi,
> > 
> > Can somebody explain to me how does Database
> > connection pooling stuff work in Orion. I don't
> see
> > any parameters in datasources.xml file where I can
> > specify things like min connections, max
> connections
> > etc.
> > 
> > Vimal
> > 
> > __
> > Do You Yahoo!?
> > Yahoo! Mail - Free email you can access from
> anywhere!
> > http://mail.yahoo.com/
> 


__
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/

RE: Database connection Pooling in Orion

[Rick Bos]

There is a max-connections attribute to the data-source in:

http://www.orionserver.com/dtds/data-sources.dtd

> -Original Message-
> From: Vimal Kansal [SMTP:[EMAIL PROTECTED]]
> Sent: September 6, 2000 12:50 PM
> To:   Orion-Interest
> Subject:  Database connection Pooling in Orion
> 
> Hi,
> 
> Can somebody explain to me how does Database
> connection pooling stuff work in Orion. I don't see
> any parameters in datasources.xml file where I can
> specify things like min connections, max connections
> etc.
> 
> Vimal
> 
> __
> Do You Yahoo!?
> Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/

Database connection Pooling in Orion

[Vimal Kansal]

Hi,

Can somebody explain to me how does Database
connection pooling stuff work in Orion. I don't see
any parameters in datasources.xml file where I can
specify things like min connections, max connections
etc.

Vimal

__
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/