db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Arthur Doler (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4594) ArrayIndexOutOfBoundsException thrown in PreparedStatement execution
Date Wed, 24 Mar 2010 16:11:30 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4594?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Arthur Doler updated DERBY-4594:
--------------------------------

    Attachment: script.sql

Attached an sql script to create the test DB, create the tables, add the data, and run the
failing query. Script does not disconnect or exit ij.

> ArrayIndexOutOfBoundsException thrown in PreparedStatement execution
> --------------------------------------------------------------------
>
>                 Key: DERBY-4594
>                 URL: https://issues.apache.org/jira/browse/DERBY-4594
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.3.0
>         Environment: Derby 1.5.3.0_1
> Windows XP SP3
>            Reporter: Arthur Doler
>         Attachments: script.sql
>
>
> I am encountering the following exception when trying to execute a PreparedStatement:
> Exception in thread "main" java.sql.SQLException: The exception 'java.lang.ArrayIndexOutOfBoundsException:
-1' was thrown while evaluating an expression.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> 	...
> Caused by: java.lang.ArrayIndexOutOfBoundsException: -1
> 	at org.apache.derby.impl.sql.execute.BaseActivation.getColumnFromRow(Unknown Source)
> 	at org.apache.derby.exe.ac80220011x0127x90baxe992x000075337d882.g0(Unknown Source)
> 	at org.apache.derby.exe.ac80220011x0127x90baxe992x000075337d882.e1(Unknown Source)
> 	at org.apache.derby.impl.services.reflect.DirectCall.invoke(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown
Source)
> 	at org.apache.derby.impl.sql.execute.JoinResultSet.openCore(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
> 	... 5 more
> The query I am executing is:
> SELECT R.report_id, ER.entity_id FROM reports AS R 
>    LEFT JOIN entity_reports AS ER ON R.report_id = ER.report_id 
> WHERE R.details LIKE ? 
>    AND COALESCE(ER.entity_id, 0) != ? 
> The table 'reports' can be prepared with the following SQL:
> ij> CREATE TABLE reports (report_id bigint PRIMARY KEY, document_num varchar(50),
status varchar(100), type varchar(100) NOT NULL, specific varchar(100), owner varchar(100),
summary clob, details clob, closing_remarks clob, occurred date, opened date, closed date,
reference_guid varchar(50) NOT NULL);
> ij> INSERT INTO reports (report_id, type, summary, details, reference_guid) VALUES
(1, 'Type 1', 'Summary 1', 'Details 1', 'guid 1');
> The table "entity_reports" can be prepared with:
> ij> CREATE TABLE entity_reports (report_id bigint, entity_id bigint, primary key (report_id,
entity_id));
> The error happens regardless of whether this table has rows in it or not. Technically
both report_id and entity_id are foreign keys but that doesn't seem to make a difference.
> Executing the above SQL on a new derby database and then running the query, whether it's
via JDBC from Java or directly through ij, causes the problem to occur. 
> Here is a copy of the query suitable for execution in ij (i.e., the values are filled
out):
> SELECT R.report_id, ER.entity_id FROM reports AS R 
>    LEFT JOIN entity_reports AS ER ON R.report_id = ER.report_id 
> WHERE R.details LIKE '%Details%' 
>    AND COALESCE(ER.entity_id, 0) != 1;
> I'm open to the idea that I'm doing something wrong, but the same code works against
our test MSSQL db.
> Thank you for your time.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message