I am creating a web portal with online transaction facility. I am not familiar with database connection pooling. Also, I don't have idea with EJB.
I want to know how I can implement connection pooling without EJB and want a simple code which details me about the connection pooling and its usage in application.
I have heard that we can use JNDI resources for connection pooling but not much idea about that.
Please give me a clear and simple example.
Also, I read that using the default connection pooling mechanism provided by hibernate is not advisable in production and they recommend some third party connection pooling mechanism like c3p0.
I need to know how to use c3p0 connection pooling in hibernate.