Hello:
I am testing the evaluation version of HXTT Access and i had this error:
java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: 4109
at com.hxtt.b.q.if(Unknown Source)
at com.hxtt.sql.access.u.a(Unknown Source)
at com.hxtt.sql.access.u.a(Unknown Source)
at com.hxtt.sql.access.g.a(Unknown Source)
at com.hxtt.sql.access.n.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.executeUpdate(Unknown Source)
at com.hxtt.sql.access.g.a(Unknown Source)
at com.hxtt.sql.access.n.a(Unknown Source)
at com.hxtt.sql.dc.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.de.char(Unknown Source)
at com.hxtt.sql.de.executeUpdate(Unknown Source)
I think that it can be related to the length of the create table. Here you have an example where i was able to reproduce it. I had to give some fake names to the columns to be able to reproduce the problem.
Create table example (conf001 VARCHAR(100), conf002 VARCHAR(100), Column_1_00000000000 DOUBLE,Column_2_0000000000000000 DOUBLE,Column_3_000000000000000000000 DOUBLE DEFAULT -89.0,Column_4_000000000000 DOUBLE DEFAULT -90.0,Column_5_00000000000000000000 INTEGER,Column_6_0000000000 DOUBLE DEFAULT -8.0,Column_7_0000000000 INTEGER DEFAULT 0,Column_8_000000000000000 DOUBLE DEFAULT -90.0,Column_9_000000000000 DOUBLE DEFAULT 100.0,Column_10_00000000000000000 DOUBLE DEFAULT 0.0,Column_11_00000000 DOUBLE,Column_12_00000000000 DOUBLE,Column_13_00000000 INTEGER DEFAULT 5,Column_14_0000000 DOUBLE,Column_15_00000000000 DOUBLE DEFAULT 0.0,Column_16_00000000000000000000 DOUBLE,Column_17_000000000000 INTEGER DEFAULT 10,Column_18_0000000 VARCHAR(100) DEFAULT 'VEH_A',Column_19_00000000000000 DOUBLE,Column_20_000000000000000 INTEGER DEFAULT 200,Column_21_00000000 DOUBLE,Column_22_0000000000 INTEGER DEFAULT 32,Column_23_000000000 DOUBLE DEFAULT 0.0,Column_24_0000000 DOUBLE,Column_25_00000000 INTEGER DEFAULT 20,Column_26_00000000000000000 DOUBLE,Column_27_0000000000 INTEGER DEFAULT 15,Column_28_000000000000000 DOUBLE DEFAULT 3.0,Column_29_00000000000000000 DOUBLE,Column_30_00000000000000000000 DOUBLE DEFAULT 3.0,Column_31_000000000 DOUBLE DEFAULT 200.0,Column_32_0000000000000000000 DOUBLE,Column_33_0000000000000000000 DOUBLE DEFAULT -18.0,Column_34_00000000000000000000 DOUBLE DEFAULT -6.0,Column_35_00000000000000000000 DOUBLE DEFAULT 200.0,Column_36_ DOUBLE DEFAULT 15.0,Column_37_0000000000000000 DOUBLE DEFAULT 40.0,Column_38_00000000000 DOUBLE,Column_39_0000000000000000000 BIT,Column_40_000000000000000 INTEGER DEFAULT 16,Column_41_00000000000000000 DOUBLE DEFAULT 100.0,Column_42_0000000000000000 DOUBLE DEFAULT -3.0,Column_43_0000000 DOUBLE,Column_44_0000000000000000000 INTEGER DEFAULT 3,Column_45_00000000000000 DOUBLE DEFAULT 200.0,Column_46_0000000000000000 VARCHAR(100) DEFAULT 'AAAAAA',Column_47_0000000000000000 INTEGER DEFAULT 1,Column_48_000000000000000 BIT,Column_49_00000000000 DOUBLE,Column_50_000000000 DOUBLE,Column_51_00000000000 DOUBLE,Column_52_000000000000 DOUBLE,Column_53_0000000000000000000 DOUBLE, PRIMARY KEY(conf001, conf002));
The java code is to execute:
PreparedStatement stm = conn.prepareStatement(createTable);
stm.executeUpdate();
am i doing anything wrong?
|
Fixed. Thanks for your response. Please download the latest package.
|