Hi Sébastien,
Cayenne works with any DataSource, including HikariCP.
Some environments support it out of the box. E.g. Bootique [1], where you'd
drop "bootique-jdbc-hikarcp" in your POM [2], and configure the connection info
in the YAML [3], and off you go.
In the most general case, you create an instance of
com.zaxxer.hikari.HikariDataSource on your own, and pass it over to Cayenne
runtime builder:
HikariDataSource ds = new HikariDataSource();
ds.setJdbcUrl("jdbc:mysql://localhost:3306/db");
ds.setUsername("u");
ds.setPassword("p");
ServerRuntime cayenne = ServerRuntime.builder().dataSource(ds).build()
Andrus
[1] https://github.com/bootique-examples/bootique-cayenne-demo
[2]
https://github.com/bootique-examples/bootique-cayenne-demo/blob/master/pom.xml#L56
[3]
https://github.com/bootique-examples/bootique-cayenne-demo/blob/master/src/main/resources/config.yml#L2
> On Feb 7, 2019, at 5:32 PM, Sébastien Pérès-Labourdette
> <[email protected]> wrote:
>
> Hi all.
>
> I wish i could delegate connection pooling to this guy.
> Anybody did this before ?
>
> Any howto to achieve that ?
>
> - Sébastien
>