Grokbase Groups Camel users May 2016
FAQ
Hi

I wonder if its the Oracle JDBC driver issue, that it does not return
correct value for number of parameters in the prepared statement.

There is an option parametersCount you can use to set a fixed value if
the JDBC driver cannot return correct data. See its documentation
http://camel.apache.org/sql-component.html

However that value is fixed, and if you use a dynamic IN list then you
would need to use <toD> to make the uri dynamic. (less good but
possible). But at least maybe try to set that value = 1000 as you use
in your example, and see if that at least work.
On Tue, May 31, 2016 at 6:09 PM, yogu13 wrote:
i see unit tests written for supporting in clause not sure how r they
passing

regards,
-Yogesh

On Tuesday 31 May 2016, imranrazakhan [via Camel] <
ml-node+s465427n5783319h18@n5.nabble.com> wrote:
Hi Yogesh,

it look like there is issue in Using IN queries with dynamic values, as
its working for 1 value but not for multiple values, if here is issue in
datasource parameter then it should not work for 1 value too.


As mentioned earlier is expecting 1 value, below error clearly indicating

org.springframework.jdbc.UncategorizedSQLException:
PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state
[null]; error code [0];
Number of parameters mismatch. Expected: 1, was: 5; nested 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.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), click here
<http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5783264&code=eW9ndTEzQGdtYWlsLmNvbXw1NzgzMjY0fC04ODQzODQxMjM=>
.
NAML
<http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>



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


--
Claus Ibsen
-----------------
http://davsclaus.com @davsclaus
Camel in Action 2: https://www.manning.com/ibsen2

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 17 of 18 | next ›
Discussion Overview
groupusers @
categoriescamel
postedMay 30, '16 at 8:09p
activeJun 1, '16 at 12:06p
posts18
users3
websitecamel.apache.org

People

Translate

site design / logo © 2017 Grokbase