camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From imranrazakhan <imranrazak...@gmail.com>
Subject Bug in camel-sql IN Clause - 2.18.0
Date Sun, 20 Nov 2016 11:50:18 GMT
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 NOT    IN(7,8)
AND s.msisdn IN( :#in:msisdns )
AND s.campaign_id   IN( :#in:campId )

Suspected Issue: 

I enabled trace and verify resulted Query and found that campaign_id should
have 3 placeholder but it has two like msisdn, which mean prepareQuery
method of DefaultSqlPrepareStatementStrategy.java is setting placeholder
like msisdn

TRACE DefaultSqlPrepareStatementStrategy:88 - Prepared query: select * from
subscriber s
where status NOT    IN(7,8)
AND s.msisdn IN( ?,? )
AND s.campaign_id   IN( ?,? )


Stacktrace
---------------------------------------------------------------------------------------------------------------------------------------
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback;
bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException:
ORA-00942: table or view does not exist

        at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
        at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
        at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649)
        at
org.apache.camel.component.sql.SqlProducer.process(SqlProducer.java:116) 



--
View this message in context: http://camel.465427.n5.nabble.com/Bug-in-camel-sql-IN-Clause-2-18-0-tp5790243.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Mime
View raw message