Support for multiple jOOQ datasources

See original GitHub issue

I’m configuring a Spring Boot application that needs access to two separate jOOQ datasources (well, DSLContexts). The autoconfiguration does not support this (and it probably shouldn’t), but could make this much easier if it would expose the SpringTransactionProvider and JooqExceptionTranslator classes; these are now package-private. Can we make these public, so they can be re-used in a multi-datasource setup?

Issue Analytics

  • State:closed
  • Created 6 years ago
  • Comments:10 (5 by maintainers)

github_iconTop GitHub Comments

1reaction
ursjosscommented, Dec 13, 2017

@snicoll Yes, I copied those classes this afternoon, after having read this thread up to and including your comment from 6 hours ago…

1reaction
snicollcommented, Dec 13, 2017

IIRC this had something to do with the fact that the Hikari datasource has a jdbcUrl property instead of url.

Not really. As soon as you configure more than one DataSource you have to configure them since the auto-config backs off. There are a few samples in the documentation

Read more comments on GitHub >

github_iconTop Results From Across the Web

Best practices on configuring 2 DataSource with Jooq
We are splitting read and write side of our DB queries. Achieved that as mentioned jooQ spring boot Multiple Schema(Read Write Split).
Read more >
How To Configure Multiple DataSource Using SpringBoot And ...
In prod we have read replica for the same DB and i wanted to setup multiple datasources using Jooq and SpringBoot So that...
Read more >
Connection vs. DataSource - jOOQ
Interact with JDBC Connections. While you can use jOOQ for SQL building only, you can also run queries against a JDBC java.sql.Connection ....
Read more >
JOOQ, Transactions, Two DataSources, Kotlin, Spring Boot ...
JOOQ, Two DataSources, Kotlin, Spring Boot, Gradle. let's set up project, that works with two separate databasesGitHub ...
Read more >
Re: DAOs, Datasources and transaction management
Yes, if you pass a DataSource to the Factory constructor. The intent ... transaction support might align well with the many changes in...
Read more >

github_iconTop Related Medium Post

No results found

github_iconTop Related StackOverflow Question

No results found

github_iconTroubleshoot Live Code

Lightrun enables developers to add logs, metrics and snapshots to live code - no restarts or redeploys required.
Start Free

github_iconTop Related Reddit Thread

No results found

github_iconTop Related Hackernoon Post

No results found

github_iconTop Related Tweet

No results found

github_iconTop Related Dev.to Post

No results found

github_iconTop Related Hashnode Post

No results found