[RANGER-2895] Replace c3p0 connection pool with HikariCP, upgrading MySQL connector

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: admin, Ranger
• Assignee: Pradeep Agrawal
• Reporter: RickyMa
• Created: 05/Jul/20 18:45
• Updated: 21/Jun/23 13:24
• Resolved: 21/Jun/23 13:24

Description

We should replace c3p0 with [HikariCP|https://github.com/brettwooldridge/HikariCP]. HikariCP is much faster and less error prone. HikariCP is more popular with 13.2k+ stars on its github. There were no more new commits since Nov 18, 2019 in [c3p0|https://github.com/swaldman/c3p0/commits/master].

[MySQL connector|https://github.com/mysql/mysql-connector-j] should be upgraded to the latest stable versions as well to include many essential bugfixes.

Issue Links

• links to: Review request
• links to: Review request new