Connection Pooling


Connection pooling, but what it is and what it do ?

 It is set of database connections that can be used in future.  This connection can be used across many sessions, once execution completes, it returns connection to connection pool.
 

Source: docs.oracle.com


It will boost performance, because creating connection for every-user and action it will degrade performance, So how can we add connection pooling in java.

Hibernate configuration using c3p0

 
 hibernate.connection.driver_class=com.mysql.jdbc.Driver  
 hibernate.connection.url=jdbc:mysql://localhost/connectionpool  
 hibernate.connection.username=root  
 hibernate.connection.password=<password>  
 hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect  
 hibernate.show_sql=false  
 hibernate.c3p0.max_size=1  
 hibernate.c3p0.min_size=0  
 hibernate.c3p0.timeout=5000  
 hibernate.c3p0.max_statements=100  
 hibernate.c3p0.idle_test_period=300  
 hibernate.c3p0.acquire_increment=2

For more information, check Documentation

Another connection pooling implementation using Apache DBCP

Happy Connection pooling.

Comments

Post a Comment

Popular posts from this blog

Create BeanShell Script to Make Database call

BeanShell Script BeanShell is a small, free, embeddable Java source interpreter with object scripting language features, written in Java. BeanShell dynamically executes standard Java syntax and extends it with common scripting conveniences such as loose types, commands, and method closures like those in Perl and JavaScript. Following script make database connection and every iteration it takes 50 records from database and populate them in hashmap. This has been created to use with jmeter using beanshell sampler. import com.postgresql.jdbc.Driver; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.HashMap; import java.util.Map; System.out.println("Postgres Connect Example."); Connection conn = null; Statement stmt = null; ResultSet rs = null; String url = "jdbc:postgresql://192.168.3.99:5432/"; String dbName = "DB"; ...
Read more

JAX-WS - SOAP Handlers

What is SOAP Handlers ? SOAP Handlers are interceptor to do additional processing of incoming and outgoing message at Client as well as Server level. For example, to check properties in handler, to audit req/response or to do any filtering. SOAP message contains three parts as below:- SOAP Header [Optional] SOAP Body Attachments [Optional] JAX-WS 2.0 defines 2 types of Handlers - Logical and Message Handler. Logical Handlers operates on message context properties and message payload only. Logical handlers are handlers that implements - javax.xml.ws.handler.LogicalHandler Message Handlers operates all parts of SOAP, i.e. SOAP Header, Body and attachments. it implements - javax.xml.ws.handler.soap.SOAPHandler There are three methods of handlers as follows:- handleMessage() - This method is called for both incoming and outgoing message for any additional processing handleFault() - This handles any fault generated by service implementation or exception generated f...
Read more