Announcement Announcement Module
No announcement yet.
InvalidResultSetAccessException Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • InvalidResultSetAccessException

    I'm using Spring's jdbcTemplate.query method with RowCallbackHandler to query and map the result set. However, I'm getting InvalidResultSetAccessException seemingly randomly. Here is the SQL query against Oracle 10g databse that is being executed:

    org.springframework.jdbc.InvalidResultSetAccessExc eption: PreparedStatementCallback; invalid ResultSet access for SQL

    [SELECT inst_id "INST_ID", audit_type "AUDIT_TYPE", business_date "BUSINESS_DATE", audit_text "AUDIT_TEXT", branch_num "BRANCH_NUM", short_name "SHORT_NAME", teller_num "TELLER_NUM", check_num "CHECK_NUM", check_amount "CHECK_AMOUNT", acct_num "ACCT_NUM", acct_sfx "ACCT_SFX" FROM AS_CHECK_IMAGE_VW WHERE inst_id = ? AND audit_type in ('CHECK_IMAGE_VIEW', 'CHECK_IMAGE_PRINT') AND business_date >= to_date('07/01/2009','MM-DD-RRRR') AND business_date <= to_date('07/03/2009', 'MM-DD-RRRR') ORDER BY BUSINESS_DATE ASC]

    nested exception is java.sql.SQLException: Invalid column index; nested exception is: com.eplinc.persistence.session.SessionException:

    Can someone point me in the right direction in troubleshooting this issue?

    Also is it true jdbcTemplate.queryForList will throw an exception if the result is empty?