Forum Stats

  • 3,837,096 Users
  • 2,262,225 Discussions
  • 7,900,202 Comments

Discussions

Categories

java.lang.ArrayIndexOutOfBoundsException: -32503

KeithWilliams
KeithWilliams Member Posts: 133
edited Nov 13, 2009 2:47AM in Java Database Connectivity (JDBC)
I am getting this error in setupBindBuffers() when I issue an executeBatch() using the JDBC 11.1.0.6.0 driver. This code works fine with all of the 10.x drivers.

Here is the stack trace:

java.lang.ArrayIndexOutOfBoundsException: -32503
at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2677)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9255)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:210)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
at com.troux.servercommon.db.BulkTableAdder.flushToDatabase(BulkTableAdder.java:242)
at com.troux.tux.TUXManagerImpl.flushToDatabase(TUXManagerImpl.java:156)
at com.troux.tux.TUXManagerFactory.updateBatches(TUXManagerFactory.java:184)
at com.troux.tux.TUXManagerFactory.commitBatches(TUXManagerFactory.java:189)
at com.troux.tux.stage.StageAPIImpl.processCounters(StageAPIImpl.java:201)
at com.troux.tux.stage.StageAPIImpl.saveObject(StageAPIImpl.java:165)
at com.troux.tux.processor.extract.sax.ComponentHandler.verifyAndSave(ComponentHandler.java:674)
at com.troux.tux.processor.extract.sax.ComponentHandler.endElement(ComponentHandler.java:319)
at com.troux.tux.processor.extract.sax.SaxElementProcessor.endElement(SaxElementProcessor.java:232)
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at com.troux.tux.processor.extract.steps.ExtractProcessingStep.runStep(ExtractProcessingStep.java:123)
at com.troux.tux.processor.TUXJobProcessorImpl.runAllSteps(TUXJobProcessorImpl.java:88)
at com.troux.tux.processor.extract.ExtractProcessorImpl.doRunJobWork(ExtractProcessorImpl.java:191)
at com.troux.tux.processor.JobProcessorImpl.runJob(JobProcessorImpl.java:80)
at com.troux.tux.jobmanager.jobrunners.TUXJobRunner.doRunJob(TUXJobRunner.java:110)
at com.troux.tux.jobmanager.jobrunners.TUXJobRunner$1.doWork(TUXJobRunner.java:36)
at com.troux.tux.jobmanager.jobrunners.TUXJobRunner.impersonateJobUser(TUXJobRunner.java:91)
at com.troux.tux.jobmanager.jobrunners.TUXJobRunner.runJob(TUXJobRunner.java:51)
at com.troux.tux.jobmanager.jobrunners.TUXSimpleJobRunnerThread.processObject(TUXSimpleJobRunnerThread.java:29)
at com.troux.common.ThreadPool$PooledThread.run(ThreadPool.java:211)
at java.lang.Thread.run(Thread.java:595)
· Share on TwitterShare on Facebook
«1

Comments

  • dsurber-Oracle
    dsurber-Oracle Member Posts: 195
    Turn on logging at Level.FINE and get a trace of the exact JDBC methods called. Then see if you can create a pure JDBC test case. That will make it much easier to figure out what is going on. There's a JDBC logging white paper on the OTN JDBC/SQLJ home page.

    Douglas
    · Share on TwitterShare on Facebook
  • KeithWilliams
    KeithWilliams Member Posts: 133
    So this happened yesterday. All I did was start up tomcat and then try to execute this process and I got these errors. So today, for some unknown reason to me, I decided to repeat my steps. It worked today. Nothing has changed except the weather. So until I get a reproducible case I am going to move on.
    · Share on TwitterShare on Facebook
  • 14736
    14736 Member Posts: 85
    I've encountered the same issue with the 11g driver. It turned out the bug is a function of the size of the batch and the number of rows in the table being inserted into. A patch can be found in metalink with the id of 6396242.

    -Mark
    · Share on TwitterShare on Facebook
  • KeithWilliams
    KeithWilliams Member Posts: 133
    Yes, Oracle support just sent me the patch information on MetaLink.

    Thanks, all.
    · Share on TwitterShare on Facebook
  • KeithWilliams
    KeithWilliams Member Posts: 133
    I get the following error when applying the patch. Anyone know what causes this?

    11:56:22.51>opatch apply
    File Not Found
    Invoking OPatch 11.1.0.6.0

    Oracle Interim Patch Installer version 11.1.0.6.0
    Copyright (c) 2007, Oracle Corporation. All rights reserved.


    Oracle Home : F:\oracle\product\11.1.0\db_1
    Central Inventory : C:\Program Files\Oracle\Inventory
    from : n/a
    OPatch version : 11.1.0.6.0
    OUI version : 11.1.0.6.0
    OUI location : F:\oracle\product\11.1.0\db_1\oui
    Log file location : F:\oracle\product\11.1.0\db_1\cfgtoollogs\opatch\opatch2007-12-18_11-57-21AM.log

    ApplySession applying interim patch '6396242' to OH 'F:\oracle\product\11.1.0\db_1'

    Running prerequisite checks...
    Prerequisite check "CheckActiveFilesAndExecutables" failed.
    The details are:

    Following files are active :
    F:\oracle\product\11.1.0\db_1\jdbc\lib\ojdbc5.jar
    F:\oracle\product\11.1.0\db_1\jdbc\lib\ojdbc5.jar
    ApplySession failed during prerequisite checks: Prerequisite check "CheckActiveFilesAndExecutables" failed.
    System intact, OPatch will not attempt to restore the system

    OPatch failed with error code = 74
    · Share on TwitterShare on Facebook
  • 14736
    14736 Member Posts: 85
    Not sure if this is supported but you could just unpack the ojdbc5.jar and replace the class files with those that are included in the patch and then package it back up. I did it this way since I was patching the jar on a host that didn't have opatch/db installed.

    Good luck,

    -Mark
    · Share on TwitterShare on Facebook
  • KeithWilliams
    KeithWilliams Member Posts: 133
    Lol, that's what I ended up doing also. :-)
    · Share on TwitterShare on Facebook
  • 199713
    199713 Member Posts: 6
    I can't get access to metalink.

    Is a fixed version not available for download?

    Thanks.
    · Share on TwitterShare on Facebook
  • 586088
    586088 Member Posts: 15
    I hit this same error when using the 11g jdbc driver against a 10g or 11g database.
    If I use a 10g jdbc driver I don't get the error.

    If I search the patch number, there is a patch supplied for the database server side.

    Why isn't the patch for the jdbc driver that would be deployed at the client?
    · Share on TwitterShare on Facebook
  • 585768
    585768 Member Posts: 4
    Is there any way to get the patch if I do not have any account at MetaLink?
    · Share on TwitterShare on Facebook
This discussion has been closed.