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 <bharath...@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. >
