hibernate grails database-connection connection-pooling c3p0

Change connection pooling type in grails

I need to change the connection pooling type in my grails application to c3p0. I have searched through the net and also into stack overflow but could not find adequate resources.

I know that I need to create a new datasouce in resources.groovy and override the existing datasource. But I am now aware exactly how I am supposed to do it.

Can anyone help me out with it. It is a kind request to please provide me step by step guidance for this rather that providing some link which I can refer. I have already referred number of links and have been unable to makeout anything from it.

Solution

Try theese solutions, has samples and a step by step guidance in a blog.

How do I configure c3p0 for a grails 2.X application with multiple datasources?

Configuring Grails to use own DataSource implementation or to proxy the standard DataSource

Converting Lazy Loaded object to JSON in spring boot jpa
Cache all queries by default using hibernate/ehcache?
Paging implimentation using Hibernate with Struts2
Hibernate @One mapping: NullPointer leading to SingleTableEntityPersister exception
Hibernate: page results AND know the result size
How to prevent Spring Boot/Hibernate from converting entity column names from PascalCase to snake_case?
Error executing DDL "create table in Spring Data JPA?
Implementing result paging in hibernate (getting total number of rows)
Projection fails with InstantiationException after Hibernate 6 migration
Bean injection into Hibernate BeforeExecutionGenerator
How to get distinct results in hibernate with joins and row-based limiting (paging)?
What is the need for many-to-one mapping in hibernate?
Postgres / hibernate operator does not exist: text = bytea
Is it good idea to use the DAO design pattern with spring Boot, instead of using repository design pattern provided by spring data jpa?
How to get subquery values when using Hibernate Criteria API
How to select from subclass entity property using Spring Data / JPQL?
org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set
Hibernate(?) quotes datatype when created database
Bake every table in CakePHP?
hibernate.jdbc.time_zone property of spring boot config does not work in spring version 3.2.1
Using the new type() for UUIDGenerator instead of strategy?
Hibernate validation annotation - validate that at least one field is not null
Hibernate StatelessSession.upsert() based on @NaturalId
When to use EntityManager.find() vs EntityManager.getReference() with JPA
org.hibernate.LazyInitializationException (no session) despite annotation org.springframework.transaction.annotation.Transactional
Error creating entityManagerFactory.Unable building Hibernate SessionF.SchemaManagementException:Export identifier[new_user]encountered more than once
Hibernate: Could not deserialize - invalid stream header
How to log SQL parameters binding in JPA queries with Spring Boot 3?
How to log SQL statements with query param values in Spring Boot 3/Hibernate 6
Behaviour of persisting the object in hibernate