Hi Lukas, Can you elaborate why we should use a third party library instead of PGConnectionPoolDataSource ? Are they used for different purposes? I have heard nice things about HikariCP and I have used it before. But I am still unable to enumerate the answers for this valid question. I know PGPoolingDataSource (not PGConnectionPoolDataSource) is deprecated, and I have seen its short argument in pgjdbc. But, does that also apply to PGConnectionPoolDataSource?
Vahid On Thursday, August 25, 2022 at 8:57:00 AM UTC+2 Lukas Eder wrote: > Of course, you could also just use a third party, such as Hikari, to > handle the pooling for you, rather than using the JDBC driver's: > https://github.com/brettwooldridge/HikariCP > > On Thu, Aug 25, 2022 at 8:52 AM Lukas Eder <[email protected]> wrote: > >> Hi Chris, >> >> Thanks for your message. Indeed, we could support that out of the box. We >> don't yet. I've created a feature request for this: >> https://github.com/jOOQ/jOOQ/issues/13920 >> >> It's not really too hard to support it on your end, by implementing a >> ConnectionProvider and supplying jOOQ's DefaultConfiguration with that. >> Just correctly implement the acquire()/release() lifecycle, and you're all >> set. >> >> I hope this helps, >> Lukas >> >> On Wed, Aug 24, 2022 at 6:29 PM Chris A <[email protected]> wrote: >> >>> For reference, MysqlConnectionPoolDataSource works with DSL.using() but >>> PGConnectionPoolDataSource does not. >>> >>> A quick look seems like MysqlConnectionPoolDataSource inherits from >>> DataSource and CommonDataSource and PGConnectionPoolDataSource only from >>> CommonDataSource. >>> >>> Maybe DSL.using() should accept CommonDataSource instead of DataSource? >>> >>> >>> In either case, is there a good way to use the 3 argument DSL.using() >>> that accepts Settings with PGConnectionPoolDataSource? >>> >>> >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "jOOQ User Group" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/jooq-user/99855e4d-8a02-4265-af36-f38bd71d3dcdn%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/jooq-user/99855e4d-8a02-4265-af36-f38bd71d3dcdn%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/a8bc099a-3cf5-40b1-ba5e-1c39772789f1n%40googlegroups.com.
