I am trying to run the following query using a PrepareStatement:
SELECT t1.Name FROM table1 t1, table2 t2 WHERE t1.Id = t2.Id AND t2.t2name = ?
The result is the following:
java.lang.ArrayIndexOutOfBoundsException: -2147483546
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.dg.executeQuery(Unknown Source)
at Example1.executeQuery(Example1.java:36)
at Example1.main(Example1.java:11)
The database script is:
create table "table1"(
"Id" INTEGER,
"Name" VARCHAR(128)
);
create index "idx_table1_id" on "table1"("Id");
create table "table2"(
"id" INTEGER,
"t2name" VARCHAR(64)
);
create unique index "idx_table2" on "table2"("id","t2name");
Any ideas what the problem is?
|
create unique index "idx_table2" on "table2"("id","t2name");
should fail.
Passed test with the latest package:
create table "table1"("Id" INTEGER,"Name" VARCHAR(128));
create index "idx_table1_id" on "table1"("Id");
create table "table2"("id" INTEGER,"t2name" VARCHAR(64));
create unique index "idx_table2","idx_name" on "table2"("id","t2name");
insert into table1 values (1,'a');
insert into table1 values (2,'abc');
insert into table1 values (3,'abc');
insert into table2 values (3,'abc');
insert into table2 values (3,'a');
insert into table2 values (1,'a');
*SELECT t1.Name FROM table1 t1, table2 t2 WHERE t1.Id = t2.Id AND t2.t2name = ?
SELECT t1.Name FROM table1 t1, table2 t2 WHERE t1.Id = t2.Id AND t2.t2name = 'a'
|
Thanks. Recurred with create unique index "idx_table2" on "table2"(("id","t2name"));
You can download a fixed package AFTER 8 hours.
|
Is this now fixed? How do we get the fixed version if we already purchased the product?
|
Fixed. You can download it through here.
|