Results 1 to 2 of 2

Thread: jdbcTemplate batchUpdate Invalid Column Index

Hybrid View

  1. #1
    Join Date
    Dec 2005
    Posts
    8

    Default 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. #2
    Join Date
    Dec 2005
    Posts
    8

    Default 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •