Announcement Announcement Module
Collapse
No announcement yet.
jdbcTemplate batchUpdate Invalid Column Index Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • jdbcTemplate batchUpdate Invalid Column Index

    I get the following SQL exception when using jdbcTemplate.batchUpdate:

    Code:
    org.springframework.jdbc.InvalidResultSetAccessException: PreparedStatementCallback; 
    invalid ResultSet access for SQL [INSERT INTO CMOWNER.TAB_ENVIRONMENT_CONFIGURATION (ENVIRONMENT_LABEL, CONFIGURATION_LABEL) VALUES(?, ?)]; 
    nested exception is java.sql.SQLException: Invalid column index
    I am not sure what the nested 'Invalid Column Index' is refering to. Can somebody shed some light on this?

    Simon

  • #2
    Decided not to use batchUpdate

    I decided not to use the batch update as performance is not an issue with the small application that we are developing, however I would like to know for furture reference whether the batchUpdate should work.

    BTW I am using oracle jdbc driover ojdbc14.jar with springframework 1.2.6

    Comment

    Working...
    X