Connection Pooling in client server setup

[simmi iyer <si...@yahoo.com>]

Derby docs show that in 10.0 connection pooling is
supported only in embedded Derby driver. 

Support for connection pooling in client server setup
is there in 10.1

But not much info is there in the docs. Like how to
set minimum or maximum connections to be opened in the
pool? Any other properties that Derby supports for
connection pool in client server setup.


thx

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Re: Connection Pooling in client server setup

[Daniel John Debrunner <dj...@debrunners.com>]

simmi iyer wrote:

> Derby docs show that in 10.0 connection pooling is
> supported only in embedded Derby driver. 
> 
> Support for connection pooling in client server setup
> is there in 10.1
> 
> But not much info is there in the docs. Like how to
> set minimum or maximum connections to be opened in the
> pool? Any other properties that Derby supports for
> connection pool in client server setup.

Derby only provides an implementation of ConnectionPoolDataSource, it
does not provide a connection pool manager. An application server such
as WebSphere or Geronimo provides a connection pool manager which
handles the actual pooling on top of Derby's ConnectionPoolDataSource.
Thus the application server documents how to configure the pool.

Derby follows the model described in Chapter 11 of JDBC 3.0 spec and
shown well in figure 11.1.

Dan.