Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT ACCESS
java.lang.ArrayIndexOutOfBoundsException creting a table
Francisco Casanova
2007-06-01 13:00:03
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?
Re:java.lang.ArrayIndexOutOfBoundsException creting a table
HXTT Support
2007-06-02 02:05:00
Fixed. Thanks for your response. Please download the latest package.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Refund | Sitemap