This goodie contains a minimal framework for database connection pooling using VisualWorks.

It provides a LogicalConnection class which can be used as a connection pool. For example,

	basicConnection = PostgreSQLEXDIConnection new
		username 'username';
		password 'password';	
		environment 'host5432_dbname'.
	connection = LogicalConnection new basicConnection.
	connection maxSessions 10.
	connection connectionTimeout 15 * 60.

We can connect this sesssion.

	connection connect.

get a session to execute database commands

	connection getSession.

and eventually disconnect

	connection disconnect.

Note that this currently only handles pooling of connections for read. For write acess you will need to obtain a connection with its own non-shared transactional context.