Lesson - 27 : Hibernate - Built-in connection pooling in Hibernate
Hibernate – Built-in Connection Pooling in Hibernate: 1. If a java program wants to obtain a connection with a database then java API as provided or JDBC API as provided two ways. A) java.sql.DriverManager class B) javax.sql.DataSource interface 2. If a java program want to get direct connection with the database then we use DriverManager class. 3. The connection returned by DriverManager class is a nonreusable connection. The non reusable connections will increase the burden on a database. 4. To overcome the above problem we got connection pooling technique in java. 5. In connection pooling a group of reusable connections(pooled connections) are stored in a pool and the connections are provided to the clients whenever required. 6. To obtain a connection from a connection pool we use DataSource interface in a java program In hibernate connection pooling mechanism is divided into three types 1. Built-in connection pooling / jdbc connection pooling 2. Standalone connection pooing/Third party connection pooling 3. Server side connection pooling Built-in connection pooling / jdbc connection pooling : 1. Hibernate by default comes with automatic connection pool. This is also called jdbc connection pool. 2. As a programmer we are allowed to set the maximum pool size for hibernate built- in connection pool 3. If you want to set maximum pool size then we need to configure connection pool size property in hibernate.cfg.xml file 4. ＜property name=“hibernate.connection.pool_size”＞10＜/property＞ 5. The built- in connection pool of hibernate is only for testing purpose, but it should not be used in real time application (production.system) Configurations: ＜hibernate-configuration＞ ＜session-factory＞ ＜property name="hibernate.connection.driver_class"＞oracle.jdbc.driver.OracleDriver＜/property＞ ＜property name="hibernate.connection.url"＞jdbc:oracle:thin:@localhost:1521:xe＜/property＞ ＜property name="hibernate.connection.pool_size"＞50＜/property＞ ＜mapping resource="Payment.hbm.xml"/＞ ＜/session-factory＞ ＜/hibernate-configuration＞ Hibernate Examples Project Github Link : https://github.com/SadaLearningHub1/Hibernate-Projects
Hibernate – Built-in Connection Pooling in Hibernate: 1. If a java program wants to obtain a connection with a database then java API as provided or JDBC API as provided two ways. A) java.sql.DriverManager class B) javax.sql.DataSource interface 2. If a java program want to get direct connection with the database then we use DriverManager class. 3. The connection returned by DriverManager class is a nonreusable connection. The non reusable connections will increase the burden on a database. 4. To overcome the above problem we got connection pooling technique in java. 5. In connection pooling a group of reusable connections(pooled connections) are stored in a pool and the connections are provided to the clients whenever required. 6. To obtain a connection from a connection pool we use DataSource interface in a java program In hibernate connection pooling mechanism is divided into three types 1. Built-in connection pooling / jdbc connection pooling 2. Standalone connection pooing/Third party connection pooling 3. Server side connection pooling Built-in connection pooling / jdbc connection pooling : 1. Hibernate by default comes with automatic connection pool. This is also called jdbc connection pool. 2. As a programmer we are allowed to set the maximum pool size for hibernate built- in connection pool 3. If you want to set maximum pool size then we need to configure connection pool size property in hibernate.cfg.xml file 4. ＜property name=“hibernate.connection.pool_size”＞10＜/property＞ 5. The built- in connection pool of hibernate is only for testing purpose, but it should not be used in real time application (production.system) Configurations: ＜hibernate-configuration＞ ＜session-factory＞ ＜property name="hibernate.connection.driver_class"＞oracle.jdbc.driver.OracleDriver＜/property＞ ＜property name="hibernate.connection.url"＞jdbc:oracle:thin:@localhost:1521:xe＜/property＞ ＜property name="hibernate.connection.pool_size"＞50＜/property＞ ＜mapping resource="Payment.hbm.xml"/＞ ＜/session-factory＞ ＜/hibernate-configuration＞ Hibernate Examples Project Github Link : https://github.com/SadaLearningHub1/Hibernate-Projects