ArrayIndexOutOfBoundsException in JDBC Batch update for BW 5.11 .

ArrayIndexOutOfBoundsException in JDBC Batch update for BW 5.11 .

book

Article ID: KB0085634

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Description:
ArrayIndexOutOfBoundsException in JDBC Batch update for BW 5.11 .
Symptoms:
BW throws the following error when using the Oracle Thin Driver, when updated batches with records greater than 500:


JDBC error reported: (SQLState = ) - java.lang.ArrayIndexOutOfBoundsException: -32693"
        at com.tibco.plugin.jdbc.JDBCActivity.eval(Unknown Source)
        ......
        ......
        ......
caused by: java.lang.ArrayIndexOutOfBoundsException: -32693
        at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2673)
        ......
        ......


Cause:
Bug reported for the Thin Driver: BUG-6396242. There is a fix for version 11.1.0.7.0.

Resolution

1). Use the Oracle Thin Driver with a newer implementation (later than version 11.1.0.7.0)
2). Check the classpath of BW and make sure there is no driver version older than 11.1.0.7.0.

Issue/Introduction

ArrayIndexOutOfBoundsException in JDBC Batch update for BW 5.11 .

Additional Information

Oracle JDBC Drivers release 11.1.0.7.0 - Production README. http://www.oracle.com/technetwork/database/enterprise-edition/111070-readme-083278.html