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

[Claus Ibsen <cl...@gmail.com>]

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 <yo...@gmail.com> 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

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

[imranrazakhan <im...@gmail.com>]

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 Camel - Users mailing list archive at Nabble.com.