java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 10] with positional parameters

Technote (troubleshooting)


Problem

You are using the SQL Call builder with Oracle to do an INSERT with 7 or more positional parameters. The execution results in the following exception:
Caused by: com.bowstreet.webapp.engine.actions.MethodExecutionException: Error in method xxx_InsertInvoke. Error in method xxx_InsertInvokeBase. Array index out of range: 10 [Root exception is java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 10]

This exception only appears when the INSERT is being executed on an Oracle database. Other databases work as expected. The INSERT against Oracle also works fine if the parameters are hard coded.


Symptom

The INSERT fails and the log shows:

Caused by: com.bowstreet.webapp.engine.actions.MethodExecutionException: Error in method xxx_InsertInvoke. Error in method xxx_InsertInvokeBase. Array index out of range: 10 [Root exception is java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 10]

Cause

There is a bug in the Oracle JDBC driver related to declaring positional parameters in a SQL statement.

Resolving the problem

Contact Oracle support to obtain the latest JDBC driver for you version of Oracle.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Web Experience Factory
Back End - Oracle

Software version:

6.1.5, 7.0, 7.0.1, 8.0

Operating system(s):

Linux, Windows

Software edition:

Deployment, Designer

Reference #:

1650140

Modified date:

2013-09-24

Translate my page

Machine Translation

Content navigation