File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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: 3775

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
 
Similar Threads
problem with max function (very urgent)
load: GetMenuGui.class is not public or has no public constructor.
Problem with JPA Embeddable class field in Embedded
Oracle error on jsp page, but the sql runs fine in Oracle tool
JDBC Newbie