I know that this seems to be a common question in this forum. But all the answers to previous queries seem not to answer my predicament. I am trying to build a EAI application, where the Query is sent in a embedded in an XML. Like this,
However when it reaches the target system. The query doesn't seem to work. The error message given out:
org.springframework.jdbc.InvalidResultSetAccessException: PreparedStatementCallback; invalid ResultSet access for SQL [SELECT STATUS_CD FROM SIEBEL.S_ORDER WHERE ROW_ID = 'order_no']; nested exception is java.sql.SQLException: Invalid column index
Can some one tell me what does this error mean and how do I go about pinpointing the error. Please let me know if I need to add more info.
I am not sure myself, the system has been configured to take the <Param>1-2I55JK</Param> data, and replace it in the ROW_ID. I am yet see the other parts of the code that actually does the Composition.