OK, I have tested this out both in my app and in a clone of yours and we have a different approach.
I'm using a Hibernate with Panache for my reactive datasource but Camel uses JDBC. According to my findings they cannot coexist, one of them has to go. I reckon I have to ditch the Camel stuff since my app is heavily invested in Reactive atm. https://github.com/quarkusio/quarkus/issues/13425 Thx for your input, much appreciated! /M ------- Original Message ------- On Friday, March 17th, 2023 at 14:10, James Netherton <jamesnether...@gmail.com> wrote: > Is this what you are trying to achieve? > > https://github.com/jamesnetherton/sql-reactive-imperitive > > On Fri, 17 Mar 2023 at 09:50, Mikael Andersson Wigander > mikael.andersson.wigan...@pm.me.invalid wrote: > > > Well it seems impossible to have both JDBC and Reactive datasources in > > Quarkus simultaneously when using Camel, when both sources connect to the > > same database. > > > > Even with different DS in the properties file declared it will not work. > > > > > > /M > > > > ------- Original Message ------- > > On Thursday, March 16th, 2023 at 08:46, James Netherton < > > jamesnether...@gmail.com> wrote: > > > > > Hi, > > > > > > I don't think it is possible. > > > > > > The SQL component expects a JDBC datasource, so you'll need to add the > > > appropriate Quarkus JDBC driver extension + configuration. > > > > > > I think you should be able to keep most of the datasource configuration > > > the > > > same as the reactive DS config and add the JDBC specific bits like > > > quarkus.datasource.jdbc.url etc. > > > > > > -- > > > James > > > > > > On Wed, 15 Mar 2023 at 14:50, Mikael Andersson Wigander > > > mikael.andersson.wigan...@pm.me.invalid wrote: > > > > > > > I have an application where I'd like to combine Quarkus Reactive > > > > Database > > > > client and also using Camel SQL component to query same PostgreSQL > > > > database. > > > > > > > > I can't find any documentation where it states how I should define my > > > > datasource(s). > > > > > > > > Normally with only JDBC it works using the "default" datasource but in > > > > this case I mix JDBC and Reactive interfaces and turning of JDBC is not > > > > working > > > > > > > > quarkus.datasource.jdbc = false > > > > > > > > I have also tried to Inject AgroalDatasource and use that as the > > > > pointer > > > > to SQL component but it doesn't work. > > > > > > > > It seems that Camel is hard-wired using a JDBC connection but if I > > > > define > > > > it I will break my Reactive connection it seems. > > > > > > > > "Caused by: io.quarkus.runtime.configuration.ConfigurationException: > > > > Unable to find a JDBC driver corresponding to the database kind > > > > 'postgresql' for the default datasource. Either provide a suitable JDBC > > > > driver extension, define the driver manually, or disable the JDBC > > > > datasource by adding 'quarkus.datasource.jdbc=false' to your > > > > configuration > > > > if you don't need it." > > > > > > > > Any clues? > > > > M
