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.
