aspose file tools*
The moose likes JDBC and the fly likes  nested exception is java.sql.SQLException: Invalid column index Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark " nested exception is java.sql.SQLException: Invalid column index" Watch " nested exception is java.sql.SQLException: Invalid column index" New topic
Author

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

Robinson Francis
Greenhorn

Joined: Aug 16, 2010
Posts: 22
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.


Thanking you all in advance,
ROBINSON
Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3829

Welcome to CodeRanch, Robinson Francis!

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


SCJP 5 | SCWCD 5
[How to ask questions] [Twitter]
Robinson Francis
Greenhorn

Joined: Aug 16, 2010
Posts: 22
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: nested exception is java.sql.SQLException: Invalid column index