nested exception is java.sql.SQLException: Invalid column index

[Robinson Francis]

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,


<?xml version="1.0" encoding="UTF-8"?> <EAIDatabaseSender> <SQLStatement> <![CDATA[SELECT STATUS_CD FROM SIEBEL.S_ORDER WHERE ROW_ID = 'order_no']]> </SQLStatement> <Type>SELECT</Type> <InputParameters> <Param>1-2I55JK</Param> </InputParameters> </EAIDatabaseSender>

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.


Thanking you all in advance,
ROBINSON

[Vijitha Kumara]

Welcome to CodeRanch, Robinson Francis!

What database do you use? And how you replace the value to 'order_no'?

[Robinson Francis]

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.