Liferay DXP Checklist, c3p0 or HikariCP?

[Denis Signoretto, modificado hace 6 años.]

Hi,

I was reading Liferay DXP Deployment Checklist document and I've surprisingly seen that it still suggest to use c3p0 as Database connection pool with Tomcat. If I'm not wrong Liferay DXP bundle use HikariCP by default.

Is it a misprint or still do you suggest c3p0 for produciont ready environment? Which one do you suggest for a production clustered environment?

Thanks,
Denis.

[David H Nebinger, modificado hace 6 años.]

Go with Hikari.

The reality is that any connection pool implementation will work, and folks often have different levels of trust for different projects.

Personally, although I use and trust Hikari, it is tough pointing someone to the github project page and say that this thing is ready for prime time use, they just don't have that level of trust in an individual user's github project.







Come meet me at Devcon 2017 or 2017 LSNA!

[Jorge Díaz, modificado hace 6 años.]

Hi Denis,

In "Database Connection Pool" section there is no special suggestion about any connection pool:

You may choose from a variety of database connection pool providers, including DBCP, C3P0, HikariCP
and Tomcat. You may also choose to configure the Liferay JDBC settings in your portal.properties.

About HikariCP it is only used in case of configuring Liferay JDBC settings in your portal.properties

[Denis Signoretto, modificado hace 6 años.]

Hi guys,

thanks for your clarifications.

@Jorge I'd like to know whether Liferay Engineering scalability team use c3p0 or Hikari to perform their tests.

[David H Nebinger, modificado hace 6 años.]

Jorge Díaz:

About HikariCP it is only used in case of configuring Liferay JDBC settings in your portal.properties

I have a blog post up showing how you can use Hikari for your tomcat JNDI connection pool too, especially useful since the default tomcat connection pool is not well regarded.

https://web.liferay.com/web/user.26526/blog/-/blogs/tomcat-hikaricp








Come meet me at Devcon 2017 or 2017 LSNA!