In Hibernate Configuring Proxool connection Pool
1: Configure sessionfactory in applicationcontext. xml
Org. hibernate. dialect. oracle9dialect True Conf/proxool. Properties
Hibernate-Oracle
2: Configure proxool (CONF/proxool. properties)
# Jdbc-0.proxool.alias = MySQL
# Jdbc-0.proxool.driver-class = org. gjt. Mm. MySQL. Driver
# Jdbc-0.proxool.driver-url = JDBC: mysql: // localhost: 3306/contestdb? User = root & Password = 1234 & useunicode = true & characterencoding = utf8
# Jdbc-0.user = root
# Jdbc-0.password = 1234
Jdbc-0.proxool.alias = hibernatea-Oracle
Jdbc-0.proxool.driver-class = oracle. JDBC. Driver. oracledriver
Jdbc-0.proxool.driver-url = JDBC: oracle: thin: @ 172.16.2.6: 1521: dbname
Jdbc-0.user = Username
Jdbc-0.password = Username
Jdbc-0.proxool.maximum-connection-count = 20
Jdbc-0.proxool.house-keeping-test-sql = select sysdate from dual;
# Debug, info, warn, error, fatal.
Jdbc-0.proxool.statistics-log-level = Error