Re: newbie: what should I use for connection pooling?

[FractalizeR]

>
> @Vladislav: That's a nice Stack Overflow question with good research.
> I would probably have recommended c3p0, I wasn't aware that it has
> gotten somewhat outdated. Good to know. Do you have working examples
> with BoneCP and jOOQ? That might be something interesting for the jOOQ
> manual...
>

I think connection pooling isn't related to Jooq because connection pool 
just gives you connections from pool. My code looks like this

            ServerConfiguration configuration = 
ServerConfiguration.getInstance();
            JDBCConnectionPool connectionPool = 
configuration.getConnectionPool();
            connection = connectionPool.getConnection();

            if 
(Distribucalc.DISTRIBUCALC.getName().equals(configuration.getDatabaseName())) 
{
                sqlFactory = new Factory(connection, 
configuration.getJooqFactoryName());
            } else {
                SchemaMapping mapping = new SchemaMapping();
                mapping.add(Distribucalc.DISTRIBUCALC, 
configuration.getDatabaseName());
                sqlFactory = new Factory(connection, 
configuration.getJooqFactoryName(), mapping);
            }