Hi,
I am using camel 2.13.0 and try to run this query via Spring DSL. its not
working while comparing two tables with same field. for example ID field is
available in both tables ,
Query :
select * from table1 a, table2 b where a.ID = b.ID;
Am getting following exception :
com.microsoft.sqlserver.jdbc.SQLServerException: The value is not set for
the parameter number 1.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.buildParamTypeDefinitions(SQLServerPreparedStatement.java:260)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.buildPreparedStrings(SQLServerPreparedStatement.java:219)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doPrepExec(SQLServerPreparedStatement.java:612)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:400)
But instead of above query, if i use below query it is working.
select * from table1 a, table2 b where XX = YY;
XX >> field in table1, YY >> field in table2
My question is how to compare two different tables with common field ?
Thanks
Thomas
--
View this message in context:
http://camel.465427.n5.nabble.com/Query-is-not-working-via-camel-jdbc-component-tp5755692.html
Sent from the Camel Development mailing list archive at Nabble.com.
