Tuesday, November 27, 2007

ArrayIndexOutOfBoundsException with CFMX and oracle thin jdbc

I hit the error below in my ongoing saga with switching over to use the Oracle Thin driver with CF8.

There are a few references to this error around the web, with some notes on metalink about websphere and the IBM JDK. Oracle calls this a vendor issue.

The statement is an insert with 19 parameters, including a spatial sdo_geometry column via CFQUERY. I am using oracle (+ October patch) and ojdbc6.jar.

Removing some extraneous new lines from the query resolved the issue.

java.lang.ArrayIndexOutOfBoundsException: 19
at oracle.jdbc.driver.OracleSql.computeBasicInfo(OracleSql.java:950)
at oracle.jdbc.driver.OracleSql.getSqlKind(OracleSql.java:623)
at oracle.jdbc.driver.OraclePreparedStatement.(OraclePreparedStatement.java:1212)
at oracle.jdbc.driver.T4CPreparedStatement.(T4CPreparedStatement.java:28)
at oracle.jdbc.driver.T4CDriverExtension.allocatePreparedStatement(T4CDriverExtension.java:68)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3059)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:2961)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:5808)
at coldfusion.server.j2ee.sql.JRunConnection.prepareStatement(JRunConnection.java:786)


Prabhagar D said...

Are you really saying the issue got resolved by 'Removing some extraneous new lines from the query'?

If yes, please tell us what was issue in your query, and how did you come out of this issue.

I am not finding any resoultion for the same since longtime.


Zac Spitzer / Fastmovingtarget said...

r u running the latest cf hotfixes?