6 Replies Latest reply: Apr 17, 2013 2:21 AM by PhHein RSS

    PreparedStatement with 56cols in batch giving ArrayIndexOutOfBoundException

    Amit Piplani

      Hello All,

      PreparedStatement trying to do bath update/inserts in table with 56 columns is giving ArrayIndexOutOfBoundException sporadically with 11.2.0.3 driver. Is it related to Bug 6396242,which was supposed fix in 11.1.0.7.0?

      Here is the stackTrace:


      EXCEPTION ENCOUNTERED:
      java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 4
      at oracle.jdbc.driver.VarnumBinder.big5pow(OraclePreparedStatement.java:15348)
      at oracle.jdbc.driver.VarnumBinder.constructPow52(OraclePreparedStatement.java:15420)
      at oracle.jdbc.driver.VarnumBinder.dtoa(OraclePreparedStatement.java:15884)
      at oracle.jdbc.driver.DoubleBinder.bind(OraclePreparedStatement.java:17239)
      at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:3137)
      at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:2355)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3579)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)