You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@camel.apache.org by bharathkmr <bh...@gmail.com> on 2015/10/08 16:31:07 UTC
SQLexception while using PreparedStatement in Camel route
Using Camel 2.13.1 with Spring 2.7.11 and receiving an SQL exception while
trying to run a update query using sql component. Below is how my update
query is added to the route and I'm passing the input parameter values to
this the statement using a java.util.Map in the body.
<route id="ABC" >
<from uri="direct:sqlInsert" />
<process ref="sqlProcessor" />
<to uri="sql:UPDATE myTable set key1=:#value1, key2=:#value2, key3=:#value3
where req1=:#reqValue1" />
</route>
This is the SQL exception I see all the time..
Execution of JMS message listener failed. Caused by:
[org.apache.camel.RuntimeCamelException -
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback;
bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException:
ORA-00942: table or view does not exist
]: *org.apache.camel.RuntimeCamelException*:
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback;
bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException:
ORA-00942: *table or view does not exist*
--
View this message in context: http://camel.465427.n5.nabble.com/SQLexception-while-using-PreparedStatement-in-Camel-route-tp5772433.html
Sent from the Camel - Users mailing list archive at Nabble.com.
Re: SQLexception while using PreparedStatement in Camel route
Posted by Sashika <sa...@gmail.com>.
ORA-00942: *table or view does not exist*
Are you sure the table name "myTable" is correct and exists in your
connected schema?
On Thu, Oct 8, 2015 at 8:01 PM, bharathkmr <bh...@gmail.com> wrote:
> Using Camel 2.13.1 with Spring 2.7.11 and receiving an SQL exception while
> trying to run a update query using sql component. Below is how my update
> query is added to the route and I'm passing the input parameter values to
> this the statement using a java.util.Map in the body.
>
> <route id="ABC" >
>
> <from uri="direct:sqlInsert" />
> <process ref="sqlProcessor" />
>
> <to uri="sql:UPDATE myTable set key1=:#value1, key2=:#value2, key3=:#value3
> where req1=:#reqValue1" />
>
> </route>
>
> This is the SQL exception I see all the time..
>
> Execution of JMS message listener failed. Caused by:
> [org.apache.camel.RuntimeCamelException -
> org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback;
> bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException:
> ORA-00942: table or view does not exist
> ]: *org.apache.camel.RuntimeCamelException*:
> org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback;
> bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException:
> ORA-00942: *table or view does not exist*
>
>
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/SQLexception-while-using-PreparedStatement-in-Camel-route-tp5772433.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>