https://camel.apache.org/security/CVE-2024-22369.html: CVE-2024-22369: Apache Camel: Camel-SQL: Unsafe Deserialization from JDBCAggregationRepository

Severity: important Affected versions: - Apache Camel 3.0.0 before 3.21.4 - Apache Camel 3.22.0 before 3.22.1 - Apache Camel 4.0.0 before 4.0.4 - Apache Camel 4.1.0 before 4.4.0 Description: Deserialization of Untrusted Data vulnerability in Apache Camel SQL ComponentThis issue affects Apache

Re: Camel sql component with classpath script

Hello. Thanks for your answer. I'm a bit disappointed : I can prototype as simple blueprints, without packaging, almost all my Camel routes, except the sql component. Could you please explain why the sql URI including the "classpath" is not interpreted the same way when running from a jar bun

Re: Camel sql component with classpath script

Hi That is not possible. You cannot drop a .sql file into the deploy folder of karaf, and assume it knows how to deploy that. You need to put the sql script somewhere in the file system, and use file: to refer to the file. Or bundle it together with your camel app. Or bundle it in another .jar (m

Camel sql component with classpath script

Hello. I've already used the sql component using the a "classpath" external script in blueprint. For example : Now I'm trying the same, but instead of a packaged jar bundle, I'd like to test from a xml blueprint directly put in the deploy folder of my servicemix. The "classpath" keywork see

Re: PostgreSQL insert with returning clause with Camel sql component

t; Gerald >> Von meinem iPhone gesendet >> >>>> Am 12.07.2021 um 14:33 schrieb Zuzana Krenkova : >>> >>> Is it possible to use PostgreSQL insert with returning clause with Camel >>> sql component? This insert statement works fine on its own (insert

Re: PostgreSQL insert with returning clause with Camel sql component

ith your Jdbc drivers do not handle this in a correct way! > > Greetings > > Gerald > Von meinem iPhone gesendet > > > Am 12.07.2021 um 14:33 schrieb Zuzana Krenkova : > > > > Is it possible to use PostgreSQL insert with returning clause with Camel > &

Re: PostgreSQL insert with returning clause with Camel sql component

amel.apache.org/components/latest/sql-component.html#_generated_keys > > zoran > > On Mon, Jul 12, 2021 at 2:33 PM Zuzana Krenkova > wrote: > > > > Is it possible to use PostgreSQL insert with returning clause with Camel > > sql component? This insert statemen

Re: PostgreSQL insert with returning clause with Camel sql component

t with returning clause with Camel sql > component? This insert statement works fine on its own (inserting and also > returning id and token), but when used in a Camel route, the insert gets > processed but exchange body is returned empty. Why? > > INSERT INTO my_table(token) val

Re: PostgreSQL insert with returning clause with Camel sql component

gt;> >>>> Am 12.07.2021 um 14:33 schrieb Zuzana Krenkova : >>> >>> Is it possible to use PostgreSQL insert with returning clause with Camel >>> sql component? This insert statement works fine on its own (inserting and >>> also returning id

Re: PostgreSQL insert with returning clause with Camel sql component

hrieb Zuzana Krenkova : > > > > Is it possible to use PostgreSQL insert with returning clause with Camel > > sql component? This insert statement works fine on its own (inserting and > > also returning id and token), but when used in a Camel route, the insert > > gets pro

Re: PostgreSQL insert with returning clause with Camel sql component

Am 12.07.2021 um 14:33 schrieb Zuzana Krenkova : > > Is it possible to use PostgreSQL insert with returning clause with Camel sql > component? This insert statement works fine on its own (inserting and also > returning id and token), but when used in a Camel route, the insert gets

PostgreSQL insert with returning clause with Camel sql component

Is it possible to use PostgreSQL insert with returning clause with Camel sql component? This insert statement works fine on its own (inserting and also returning id and token), but when used in a Camel route, the insert gets processed but exchange body is returned empty. Why? INSERT INTO

camel-sql | sql-stored component queryTimeout option not present

Hi Team How to setQueryTimeout while calling stored procedure using sql-stored component ? Please help. Regards Anand Kumar

Re: camel sql-stored component queryTimeout option not present

Hi Claus Thanks for replying. I have raised JIRA : CAMEL-16405 Thanks and Regards Anand Kumar On Thu, Mar 25, 2021, 20:10 Claus Ibsen wrote: > Hi > > This is not possible, this requires to implement an improvement to the > camel-sql component. > You are welcome to create a

Re: camel sql-stored component queryTimeout option not present

Hi This is not possible, this requires to implement an improvement to the camel-sql component. You are welcome to create a JIRA asking for this On Thu, Mar 25, 2021 at 3:06 PM Anand Kumar wrote: > > Hi Team > > How to setQueryTimeout while calling stored procedure using sql-stored

camel sql-stored component queryTimeout option not present

Hi Team How to setQueryTimeout while calling stored procedure using sql-stored component ? Please help. Regards Anand Kumar

Re: Rép. : Re: Can I call a PostgreSQL function from Camel-sql

... > > > > > ... > ... > ... > > > ... > .. > > > > > Daniel Langevin > > > >>> > De :Babak Vahdat > À : > Date : 2021-03-02 05:12 > Objet : Re: Can I call a PostgreSQL function fr

Rép. : Re: Can I call a PostgreSQL function from Camel-sql

dat À : Date : 2021-03-02 05:12 Objet : Re: Can I call a PostgreSQL function from Camel-sql Hi There’s documentation about the IN, OUT and INOUT parameters for that: https://camel.apache.org/components/latest/sql-stored-component.html#_in_parameters <https://camel.apac

Re: Can I call a PostgreSQL function from Camel-sql

IKANT MVS wrote: > > Hi Team, > I would like to call a DB function in PostgreSQL database using the > camel-sql component. There are around 20-30 inParams that I would like to > pass in a hashmap and get a single value in the outParams. > > I am unable to find any examples for

Can I call a PostgreSQL function from Camel-sql

Hi Team, I would like to call a DB function in PostgreSQL database using the camel-sql component. There are around 20-30 inParams that I would like to pass in a hashmap and get a single value in the outParams. I am unable to find any examples for the same. Additionally, I have to make this call

Re: Poor Performance of Camel-Sql Batch insertions with Oracle DB

ssues with Oracle_Jdbc drivers 12c and > > above. > > If any one using Camel-sql or any other Camel database components with > > Oracle_jdbc drivers (12c and latest) will see very slow performance issue > > with batch insert/update/delete with very big records(like a record wi

Re: Poor Performance of Camel-Sql Batch insertions with Oracle DB

s with Oracle_Jdbc drivers 12c and > above. > If any one using Camel-sql or any other Camel database components with > Oracle_jdbc drivers (12c and latest) will see very slow performance issue > with batch insert/update/delete with very big records(like a record with 90 > columns). > Oracl

Re: Poor Performance of Camel-Sql Batch insertions with Oracle DB

This issue is resolved. My post might help others. Batch Update/Insert/Delete has issues with Oracle_Jdbc drivers 12c and above. If any one using Camel-sql or any other Camel database components with Oracle_jdbc drivers (12c and latest) will see very slow performance issue with batch insert/update

Re: Poor Performance of Camel-Sql Batch insertions with Oracle DB

strongly recommends that you use the standard JDBC batching if you are using the Oracle Database 12c Release 2 (12.2) JDBC driver. *Question*: As per the above description, It is recommended to set Batch Size. But i don't see BatchSize property for Camel-SQL document. I tried *template.batchSize=50

Re: Poor Performance of Camel-Sql Batch insertions with Oracle DB

http://camel.apache.org/schema/blueprint";> On Fri, Apr 12, 2019 at 11:42 AM Saiteja Parna wrote: > Fuse: 6.3.0.redhat-317 R10 > My Route in blueprint: Timer to SqlSelect to SqlInsert(batch=true) > Camel-sql retrieves 4000 records and does

Re: Poor Performance of Camel-Sql Batch insertions with Oracle DB

kely cause. So, either trying to narrow down the root cause or contacting support for the products you're using should be your priorities, zoran On Fri, Apr 12, 2019 at 8:42 PM Saiteja Parna wrote: > > Fuse: 6.3.0.redhat-317 R10 > My Route in blueprint: Timer to SqlSelect to SqlI

Poor Performance of Camel-Sql Batch insertions with Oracle DB

Fuse: 6.3.0.redhat-317 R10 My Route in blueprint: Timer to SqlSelect to SqlInsert(batch=true) Camel-sql retrieves 4000 records and does batch insertion to Oracle db. Camel-sql is taking 30 mins to insert 4000 records to Oracle database(remote) 12.2.0.1. Each record has 90 columns with no indexes

Re: Camel sql Component should retrieve data when the particular column is null using select query

Thank you for response. regards Darwin -- View this message in context: http://camel.465427.n5.nabble.com/Camel-sql-Component-should-retrieve-data-when-the-particular-column-is-null-using-select-query-tp5799613p5800760.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Oracle Function Calls with Camel-sql 2.19.0

ts > > https://github.com/quephird/camel-stored-procedure > > It would be nice to have this support out of box in SQL or JDBC Component. > > Regards > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/Oracle-Function-Calls-with-Camel-s

Re: Oracle Function Calls with Camel-sql 2.19.0

://camel.465427.n5.nabble.com/Oracle-Function-Calls-with-Camel-sql-2-19-0-tp5800096p5800253.html Sent from the Camel - Users mailing list archive at Nabble.com.

Oracle Function Calls with Camel-sql 2.19.0

Hi, Can we call Oracle Function with camel-sql? its working fine for Store Procedure but throwing error for functions Exhausted after delivery attempt: 1 caught: org.springframework.jdb c.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call GET_PREPOST_STATUS

Re: Camel-SQL 2.18.2 problem with MongoDbBasicConverters

.n5.nabble.com/Camel-SQL-2-18-2-problem-with-MongoDbBasicConverters-tp5799167p5799788.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Camel sql Component should retrieve data when the particular column is null using select query

: org.apache.camel.language.simple.types.SimpleIllegalSyntaxException: expected symbol whiteSpace but was nullValue at location 19 ${bodyAs(String)}!=null Can any one help -- View this message in context: http://camel.465427.n5.nabble.com/Camel-sql-Component-should-retrieve-data-when-the-particular-column-is-null-using-select-query-tp5799613p5799769

Re: Camel sql Component should retrieve data when the particular column is null using select query

Change from: ${body[CDR_JSON_FORM]}!= null Change TO: ${body[CDR_JSON_FORM]} != null -- View this message in context: http://camel.465427.n5.nabble.com/Camel-sql-Component-should-retrieve-data-when-the-particular-column-is-null-using-select-query-tp5799613p5799771.html Sent from the

Re: Camel-SQL 2.18.2 problem with MongoDbBasicConverters

http://camel.465427.n5.nabble.com/Camel-SQL-2-18-2-problem-with-MongoDbBasicConverters-tp5799167p5799699.html Sent from the Camel - Users mailing list archive at Nabble.com.

Camel sql Component should retrieve data when the particular column is null using select query

one set of operations and if it is not null then i would have to perform another set of operations. I want to know if there is any other i can implement this in a single route. regards Darwin -- View this message in context: http://camel.465427.n5.nabble.com/Camel-sql-Component-should

Re: Camel-SQL 2.18.2 problem with MongoDbBasicConverters

.to("log:row"); > > and I got this error > > java.lang.NoClassDefFoundError: Could not initialize class > org.apache.camel.component.mongodb.converters.MongoDbBasicConverters > > am I doing something wrong with dependencies? > > > > > > > -- > View this message in context: > http://camel.465427.n5.n

Camel-SQL 2.18.2 problem with MongoDbBasicConverters

org.apache.camel.component.mongodb.converters.MongoDbBasicConverters am I doing something wrong with dependencies? -- View this message in context: http://camel.465427.n5.nabble.com/Camel-SQL-2-18-2-problem-with-MongoDbBasicConverters-tp5799167.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Camel-SQL more than one IN clauses in SQL throws Exception

It might also work on the latest 2.17.x release in case you want to stay on that release branch. On Tue, Apr 18, 2017 at 5:37 PM, akpcnu wrote: > Thanks Clause, It worked on 2.18.3 > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/Camel-SQL-mor

Re: Camel-SQL more than one IN clauses in SQL throws Exception

Thanks Clause, It worked on 2.18.3 -- View this message in context: http://camel.465427.n5.nabble.com/Camel-SQL-more-than-one-IN-clauses-in-SQL-throws-Exception-tp5797818p5797826.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Camel-SQL more than one IN clauses in SQL throws Exception

? if yes, any alternative? > > ex: > > SELECT column1, column2... > FROM < >> > WHERE column1 IN (:#in:<>) > column2 IN (:#in:<>) > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/Camel-SQL-more-than-one-IN-clauses

Camel-SQL more than one IN clauses in SQL throws Exception

;) -- View this message in context: http://camel.465427.n5.nabble.com/Camel-SQL-more-than-one-IN-clauses-in-SQL-throws-Exception-tp5797818.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: camel sql insert clear body with CamelSqlRetrieveGeneratedKeys and MariaDB

t; Product Owner Integrations / Integrations Manager > Prince II certified – ITIL certified > Tel: +32-3-326.50.75 > > -Original Message- > From: Zoran Regvart [mailto:zo...@regvart.com] > Sent: vrijdag 31 maart 2017 12:14 > To: users@camel.apache.org > Subject: Re: c

RE: camel sql insert clear body with CamelSqlRetrieveGeneratedKeys and MariaDB

rince II certified – ITIL certified Tel: +32-3-326.50.75 -Original Message- From: Zoran Regvart [mailto:zo...@regvart.com] Sent: vrijdag 31 maart 2017 12:14 To: users@camel.apache.org Subject: Re: camel sql insert clear body with CamelSqlRetrieveGeneratedKeys and MariaDB Hi Ronny, from w

Re: camel sql insert clear body with CamelSqlRetrieveGeneratedKeys and MariaDB

list EIP[2]? zoran [1] https://github.com/apache/camel/blob/master/components/camel-sql/src/main/java/org/apache/camel/component/sql/SqlProducer.java#L161 [2] https://camel.apache.org/recipient-list.html On Fri, Mar 31, 2017 at 10:56 AM, Ronny Aerts wrote: > Hello integrations community, >

camel sql insert clear body with CamelSqlRetrieveGeneratedKeys and MariaDB

Hello integrations community, I have a route (camel 2.17.6) where I need to insert a record into a MariaDB database and I need to capture the generated id of the record. I therefore set the CamelSqlRetrieveGeneratedKeys header to true. The record is inserted correctly and the id generated BUT t

Re: Bug in camel-sql IN Clause - 2.18.0

"AND c_id IN( :#in:campId ) ?dataSource=#oracleDS¶metersCount=4") -- View this message in context: http://camel.465427.n5.nabble.com/Bug-in-camel-sql-IN-Clause-2-18-0-tp5790243p5794151.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Bug in camel-sql IN Clause - 2.18.0

SF", "XXX", "YYY"}); -- View this message in context: http://camel.465427.n5.nabble.com/Bug-in-camel-sql-IN-Clause-2-18-0-tp5790243p5794148.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Bug in camel-sql IN Clause - 2.18.0

rg.apache.camel.processor.SendDynamicProcessor.process(SendDynamicProcessor.java:119) at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77) at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:542) -- View this message in context: http://camel.465427.n5.nabble.com/Bug-in-camel-sql-IN-Clause-2-18-0-tp5790243p5794135.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Bug in camel-sql IN Clause - 2.18.0

umentationProcessor.process(InstrumentationProcessor.java:77) at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:542) -- View this message in context: http://camel.465427.n5.nabble.com/Bug-in-camel-sql-IN-Clause-2-18-0-tp5790243p5794135.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Camel SQL as delta consumer

ce - Apache Camel & > Jboss Fuse ESB | Mule ESB ) > LinkedIn - http://in.linkedin.com/pub/reji-mathews/31/9a2/40a > Twitter - reji_mathews > -- > View this message in context: > http://camel.465427.n5.nabble.com/Camel-SQL-as-delta-consumer-tp5791166.html > Sent from

Camel SQL as delta consumer

/ SOA ( Open Source - Apache Camel & Jboss Fuse ESB | Mule ESB ) LinkedIn - http://in.linkedin.com/pub/reji-mathews/31/9a2/40a Twitter - reji_mathews -- View this message in context: http://camel.465427.n5.nabble.com/Camel-SQL-as-delta-consumer-tp5791166.html Sent from the Camel - Users mai

Re: Bug in camel-sql IN Clause - 2.18.0

Hi, Verified and filed a JIRA. https://issues.apache.org/jira/browse/CAMEL-10499 Thanks, Tomo On 11/20/2016 08:50 PM, imranrazakhan wrote: Hi, One observation regarding camel-sql(2.18.0) IN query , if we have one dynamic IN it works fine but if we have two dynamic IN it throws error, i

Bug in camel-sql IN Clause - 2.18.0

Hi, One observation regarding camel-sql(2.18.0) IN query , if we have one dynamic IN it works fine but if we have two dynamic IN it throws error, i replaced msisdn with static value and it works fine, select * from subscriber s where status NOTIN(7,8) AND s.msisdn IN( :#in:msisdns ) AND

Re: R: Re: camel-sql IN query number of parameters mismatch(2.18.0)

Hi Julian, One observation regarding camel-sql(2.18.0) IN query , if we have one dynamic IN it works fine but if we have two dynamic IN it throws error, if i replace msisdn with static value it works fine, i tested with 2.18.0 select * from subscriber s where status NOTIN(7,8) AND s.msisdn

Camel SQL

the body and use it as following for conditional routing, count(*)>=1 Thanks, P -- View this message in context: http://camel.465427.n5.nabble.com/Camel-SQL-tp5788710.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Camel SQL

If you execute your query using alias (count(*) as c) you can use simple EL. http://camel.apache.org/simple.html The query result is into body input message For example: *${body[c]}*. It is a list of hashmap object. -- View this message in context: http://camel.465427.n5.nabble.com/Camel

Re: Installing Camel-SQL - Unable to resolve javax.mail

I wanted to give an update to this issue in case it might help someone else. I was able to resolve this issue thanks to Ranx. I upgraded to Camel 2.17.3 and the problem was resolved. Cheers -- View this message in context: http://camel.465427.n5.nabble.com/Installing-Camel-SQL-Unable-to

Re: Installing Camel-SQL - Unable to resolve javax.mail

.17.1/apache-camel-2.17.1-features.xml > > It appears that 2.17.1 requires javax.mail 1.5.5. Is that what your > understanding is? > > Could I somehow upgrade the javax.mail feature? Do I need to downgrade to > an older version of Camel? What are my options? > > > >

Re: Installing Camel-SQL - Unable to resolve javax.mail

ge in context: http://camel.465427.n5.nabble.com/Installing-Camel-SQL-Unable-to-resolve-javax-mail-tp5786203p5786211.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Installing Camel-SQL - Unable to resolve javax.mail

gt;> javax.mail.search | >> 1.5.0| 89 | com.sun.mail.javax.mail >> javax.mail.util | >> 1.5.0| 89 | com.sun.mail.javax.mail >> javax

Re: Installing Camel-SQL - Unable to resolve javax.mail

| > 1.5.0| 89 | com.sun.mail.javax.mail > javax.mail | > 1.5.0| 89 | com.sun.mail.javax.mail > > > > > > -- > View this message in context:

Re: camel sql insert ouput

el as in newer versions the body is preserved for SQL INSERT statements in camel-sql. However attachments is not preserved, I logged a ticket about that. https://issues.apache.org/jira/browse/CAMEL-10228 On Tue, Aug 9, 2016 at 3:41 PM, Ronny Aerts wrote: > Hello Claus, > > I use version 2.1

Re: Installing Camel-SQL - Unable to resolve javax.mail

vax.mail | 1.5.0| 89 | com.sun.mail.javax.mail -- View this message in context: http://camel.465427.n5.nabble.com/Installing-Camel-SQL-Unable-to-resolve-javax-mail-tp5786203p5786207.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: camel sql insert ouput

You likely need to upgrade Camel as in newer versions the body is preserved for SQL INSERT statements in camel-sql. However attachments is not preserved, I logged a ticket about that. https://issues.apache.org/jira/browse/CAMEL-10228 On Tue, Aug 9, 2016 at 3:41 PM, Ronny Aerts wrote: > He

Re: Installing Camel-SQL - Unable to resolve javax.mail

Apparently the Camel-SQL feature has a dependency on javax.mail which is not installed in your karaf. On Tue, Aug 9, 2016 at 9:12 AM, Vince Iglehart < vince.igleh...@kniferiver.com> wrote: > Hello, > I am using Karaf 4.0.5. I am attempting to install feature camel-sql. > When

Installing Camel-SQL - Unable to resolve javax.mail

Hello, I am using Karaf 4.0.5. I am attempting to install feature camel-sql. When I attempt the install I receive the following error message: Error executing command: Unable to resolve javax.mail/1.4.5: missing requirement [javax.mail/1.4.5] osgi.wiring.package; filter

RE: camel sql insert ouput

.com] Sent: dinsdag 9 augustus 2016 15:38 To: users@camel.apache.org Subject: Re: camel sql insert ouput What Camel version and which camel component do you use for SQL? On Tue, Aug 9, 2016 at 3:13 PM, Ronny Aerts wrote: > Hallo camel community, > > I'm doing a normal sql insert

Re: camel sql insert ouput

What Camel version and which camel component do you use for SQL? On Tue, Aug 9, 2016 at 3:13 PM, Ronny Aerts wrote: > Hallo camel community, > > I'm doing a normal sql insert into an sql server database and it seems that > after the insert, my exchange in body and all my attachments are gone. Is

camel sql insert ouput

Hallo camel community, I'm doing a normal sql insert into an sql server database and it seems that after the insert, my exchange in body and all my attachments are gone. Is this normal behavior? In a certain case I really need to keep my attachments. -- vriendelijke groeten, Ronny Aerts

RE: camel sql joined query with parameters won't run on sql server

it works fine: .to("sql:select t.event from events t where t.id= '1234' ") This seems specific to sql server driver, it works when using the jTDS driver. -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-joined-query-with-parameters-won-t-run-on-sql-server-tp5784402p5785280.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: R: Re: camel-sql IN query number of parameters mismatch

Thanks, Claus. I was about to start on doing that now. I you haven't gone too far, I still volunteer to work on it. Cheers. -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-IN-query-number-of-parameters-mismatch-tp5785054p5785175.html Sent from the Camel -

Re: R: Re: camel-sql IN query number of parameters mismatch

I have already >> done? >> >> Thanks! >> >> >> >> -- >> View this message in context: >> http://camel.465427.n5.nabble.com/camel-sql-IN-query-number-of-parameters-mismatch-tp5785054p5785088.html >> Sent from the Camel - Users mailing list ar

Re: R: Re: camel-sql IN query number of parameters mismatch

tests available in a > different way other than by publishing through a branch like I have already > done? > > Thanks! > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/camel-sql-IN-query-number-of-parameters-mismatch-tp5785054p5785088.htm

Re: R: Re: camel-sql IN query number of parameters mismatch

make this tests available in a different way other than by publishing through a branch like I have already done? Thanks! -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-IN-query-number-of-parameters-mismatch-tp5785054p5785088.html Sent from the Camel - Users mailing

R: Re: camel-sql IN query number of parameters mismatch

y found the source of the problem in that class highlighted in my previous post. Again, If you guys find this is a bug I'd be happy to report and fix it. Thanks. -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-IN-query-number-of-parameters-mismatch-tp5785054p57

Re: camel-sql IN query number of parameters mismatch

find this is a bug I'd be happy to report and fix it. Thanks. -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-IN-query-number-of-parameters-mismatch-tp5785054p5785067.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: camel-sql IN query number of parameters mismatch

Hi, Looks like the same issue was discussed in this ML a month ago :-) http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-td5783264.html Isn't it the same as yours? For convenience, Claus suggested the following solution in that thread: > I wonder if its the Ora

camel-sql IN query number of parameters mismatch

port and submit a pull request with the fix. I suspect the problem is around org.apache.camel.component.sql.DefaultSqlPrepareStatementStrategy.NamedQueryParser in the next() method. Please let me know how I can help. I'd love to contribute. Thanks. -- View this message in context: http:/

RE: camel sql joined query with parameters won't run on sql server

Sent: zaterdag 25 juni 2016 23:04 To: users@camel.apache.org Subject: Re: camel sql joined query with parameters won't run on sql server Hi Ronny, I had the same kind of problem recently and it turned out to be something to do with the driver not correctly returning the number of parameters. I

Re: camel sql joined query with parameters won't run on sql server

= l.SITENO -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-joined-query-with-parameters-won-t-run-on-sql-server-tp5784402p5784410.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: camel sql joined query with parameters won't run on sql server

Hi Ronny, I had the same kind of problem recently and it turned out to be something to do with the driver not correctly returning the number of parameters. I ended up needing to use the parametersCount option. It is described at http://camel.apache.org/sql-component.html Regards, -John Ronny A

camel sql joined query with parameters won't run on sql server

Hello camel user community, I have strange problem with a Microsoft sql server database joined query where I would like to have some advice. I have 2 spring dsl steps in a route: The siteno and locationno are in a header. Both steps run perfectly good in a firebird database and produce follow

Re: Updating datasource at runtime with camel-sql

http://camel.465427.n5.nabble.com/Updating-datasource-at-runtime-with-camel-sql-td5783374.html Thank you for all your kind support. I confirmed that the following method worked fine for me and I decided to use it. > you can think of wrapping your datasource which would contain the tog

Re: Updating datasource at runtime with camel-sql

/Updating-datasource-at-runtime-with-camel-sql-tp5783374p5783527.html Sent from the Camel - Users mailing list archive at Nabble.com.

RE: Updating datasource at runtime with camel-sql

am looking forward to your future support as well. > -Original Message- > From: Quinn Stevenson [mailto:qu...@pronoia-solutions.com] > Sent: Friday, June 03, 2016 12:12 AM > To: users@camel.apache.org > Cc: 福田　奏 > Subject: Re: Updating datasource at runtime with camel-sql

RE: Updating datasource at runtime with camel-sql

t; To: users@camel.apache.org > Cc: 福田　奏 > Subject: Re: Updating datasource at runtime with camel-sql > > If you’re willing to use camel-scr or camel-blueprint, you can make this > happen pretty easily. > > You’d expose the data source as a service, and then inject it into the

Re: Updating datasource at runtime with camel-sql

If you’re willing to use camel-scr or camel-blueprint, you can make this happen pretty easily. You’d expose the data source as a service, and then inject it into the route - the exact method would change based on whether you’re using camel-scr or camel-blueprint. If you’re using camel-scr, whe

Updating datasource at runtime with camel-sql

Hi, Is it possible to update datasource that SqlComponent refers to at runtime? The datasource I want to update is bound to "TestDB" by registry in CamelContext as follows: BasicDataSource datasource = new BasicDataSource(); datasource.setUrl("jdbc:mysql://hostname/dbname?user=user&password=pas

Re: camel-sql - SQL IN Query issue (2.17.1)

HI Claus, thanks our suggestions worked perfect, i am currently using ojdbc6 version 12.1.0.2, will verify if its fixed in any other driver. Regards, -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783350.html Sent from the

Re: camel-sql - SQL IN Query issue (2.17.1)

sted exception is >> java.sql.SQLException: Number of parameters mismatch. Expected: 1, was: 5 >> >> >> Regards >> >> ---------- >> If you reply to this email, your message will be added to the discussion >> below: >> >> http://camel.

Re: camel-sql - SQL IN Query issue (2.17.1)

gt; -- > If you reply to this email, your message will be added to the discussion > below: > > http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783319.html > To unsubscribe from camel-sql - SQL IN Query issue (2.17.1),

Re: camel-sql - SQL IN Query issue (2.17.1)

Regards -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783319.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: camel-sql - SQL IN Query issue (2.17.1)

: java.lang.IllegalArgumentException: DataSource must be >> configured >> >> >> -- >> If you reply to this email, your message will be added to the discussion >> below: >> >> http://camel.465427.n5.nabble.com/camel-sql-S

Re: camel-sql - SQL IN Query issue (2.17.1)

> -- > If you reply to this email, your message will be added to the discussion > below: > > http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783303.html > To unsubscribe from camel-sql - SQL IN Query issue (2.17.1), cl

Re: camel-sql - SQL IN Query issue (2.17.1)

gured -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783303.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: camel-sql - SQL IN Query issue (2.17.1)

in context: http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783298.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: camel-sql - SQL IN Query issue (2.17.1)

instead of simple("12345,56789") can you try new String[]{"12345", "56789"} Regards, -Yogesh -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783293.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: camel-sql - SQL IN Query issue (2.17.1)

. Expected: 1, was: 2 Regards -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783294.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: camel-sql - SQL IN Query issue (2.17.1)

ber where mobilenumber in (:#in:mobilenumbers)?dataSource=#oracleDS") -- View this message in context: http://camel.465427.n5.nabble.com/camel-sql-SQL-IN-Query-issue-2-17-1-tp5783264p5783279.html Sent from the Camel - Users mailing list archive at Nabble.com.

  1   2   3   >