Hi,

I want to configure connection pooling with Hibernate. Which are the options available? How to configure?

Thanks.

use c3po. a simple to use mechanism
put lines like below in hibernate.cfg.xml and put the .jar and its done
following is a typical line of code.

hibernate.connection.driver_class = org.postgresql.Driver
hibernate.connection.url = jdbc:postgresql://localhost/mydatabase
hibernate.connection.username = myuser
hibernate.connection.password = secret
hibernate.c3p0.min_size=5
hibernate.c3p0.max_size=20
hibernate.c3p0.timeout=1800
hibernate.c3p0.max_statements=50
hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect

if it helps, dont forget to rate!

I am using Weblogic, so do i need to create a connection pool in weblogic and add those properties in Hibernate.cfg.xml? or i need to simply add the JDBC properties?

Thanks.

You will need to set hibernate.connection.datasource property. For further reference look at hibernate documentation section 3.3. JDBC connections.