Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v6.1
  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 DBF
java.lang.ArrayIndexOutOfBoundsException: 500
Oscar San Martin
2011-05-17 06:58:38.0
Yesterday, when my application try to update table :

UPDATE movimien SET valepreven = ndoc, refe = '11669', refe1 = '11669', llave = '14/05/201111669', clave = '9 11669211669', nlocal = 1 WHERE ndoc = '8723881' AND tpref = '9' AND fmov = '2011/05/14' AND valepreven = '' AND preventa = 'S'

I receive this error from server :

14-05-2011 13:07:54 >> Error ejecutaQuery : java.lang.ArrayIndexOutOfBoundsException: 500
at com.hxtt.global.x.a(Unknown Source)
at com.hxtt.sql.dbf.s.for(Unknown Source)
at com.hxtt.sql.dbf.s.for(Unknown Source)
at com.hxtt.sql.dbf.s.for(Unknown Source)
at com.hxtt.sql.dbf.s.for(Unknown Source)
at com.hxtt.sql.dbf.s.for(Unknown Source)
at com.hxtt.sql.dbf.s.for(Unknown Source)
at com.hxtt.sql.dbf.s.new(Unknown Source)
at com.hxtt.sql.dbf.w.for(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.if(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.if(Unknown Source)
at com.hxtt.sql.dbf.j.a(Unknown Source)
at com.hxtt.sql.cx.a(Unknown Source)
at com.hxtt.sql.ev.a(Unknown Source)
at com.hxtt.sql.ev.a(Unknown Source)
at com.hxtt.sql.dn.a(Unknown Source)
at com.hxtt.sql.bs.a(Unknown Source)
at com.hxtt.sql.aj.a(Unknown Source)
at com.hxtt.sql.aj.a(Unknown Source)
at com.hxtt.sql.CallInterface.response(Unknown Source)
at com.hxtt.sql.server.c.a(Unknown Source)
at com.hxtt.sql.server.c.for(Unknown Source)
at com.hxtt.sql.server.c.run(Unknown Source)
at com.hxtt.global.b.run(Unknown Source)

14-05-2011 13:07:54 >> com.hxtt.global.SQLState.SQLException(Unknown Source)
14-05-2011 13:07:54 >> com.hxtt.sql.bs.a(Unknown Source)
14-05-2011 13:07:54 >> com.hxtt.sql.aj.a(Unknown Source)
14-05-2011 13:07:54 >> com.hxtt.sql.aj.a(Unknown Source)
14-05-2011 13:07:54 >> com.hxtt.sql.CallInterface.response(Unknown Source)
14-05-2011 13:07:54 >> com.hxtt.sql.server.c.a(Unknown Source)
14-05-2011 13:07:54 >> com.hxtt.sql.server.c.for(Unknown Source)
14-05-2011 13:07:54 >> com.hxtt.sql.server.c.run(Unknown Source)
14-05-2011 13:07:54 >> com.hxtt.global.b.run(Unknown Source)
14-05-2011 13:07:54 >> SQLE getNextException() : java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: 500
at com.hxtt.global.x.a(Unknown Source)

.....
.....
.....

Server service run on SCO Unix,

My manifest file :


Manifest-Version: 1.0
Created-By: HXTT Version Robot
Main-Class: com.hxtt.sql.admin.Admin

Name: com/hxtt/sql/dbf/
Specification-Title: HXTT DBF JDBC 3.0 Package
Implementation-Title: com.hxtt.sql.dbf
Specification-Version: 5.0.002 on April 12, 2011
Specification-Vendor: Hongxin Technology & Trade Ltd.
Comment: JDBC 3.0 Package for Xbase database
Implementation-Version: 5.0.002 on April 12, 2011
Implementation-Vendor: Hongxin Technology & Trade Ltd.
Implementation-URL: http://www.hxtt.com/dbf.html

Name: com/hxtt/sql/admin/
Specification-Title: HXTT Database Admin
Implementation-Title: com.hxtt.sql.admin
Specification-Vendor: Hongxin Technology & Trade Ltd.
Specification-Version: 0.5 on April 12, 2011
Comment: HXTT Database Admin
Implementation-Version: 0.5 on April 12, 2011
Implementation-Vendor: Hongxin Technology & Trade Ltd.
Implementation-URL: http://www.hxtt.com/dbf/dbadmin.html


Thanks in advance...
Re:java.lang.ArrayIndexOutOfBoundsException: 500
HXTT Support
2011-05-17 09:08:09.0
>java.lang.ArrayIndexOutOfBoundsException: 500
Try run once "reindex all on movimien". It seems be an index issue. BTW, please consider renewing your license for upgrade/support.
Re:Re:java.lang.ArrayIndexOutOfBoundsException: 500
Oscar San Martin
2011-05-17 09:33:16.0
We just renewing our licence.....
Re:Re:Re:java.lang.ArrayIndexOutOfBoundsException: 500
Oscar San Martin
2011-05-17 16:33:26.0
So, how can I to prevent this exception...??.. this exception occurs generaly when high number of transactions are in execution....and obviously when in the store are many customer....

At run reindex all, it stops all process in our front-end...

Thanks...
Re:Re:Re:Re:java.lang.ArrayIndexOutOfBoundsException: 500
HXTT Support
2011-05-17 22:11:07.0
>So, how can I to prevent this exception...??
It seems that you're using the old uncompress IDX format index file, and SCO Foxpro for UNIX? Please download the latest version, which has changed lock position mechanism for it.
Re:Re:Re:Re:Re:java.lang.ArrayIndexOutOfBoundsException: 500
Oscar San Martin
2011-05-25 08:29:53.0
We downloaded last package and now server is more stable, however the original applications that run on Fox, sometimes required reindex table because a record is not found....a record that has been updated under java using HXTT DBF driver....

Thanks,
Re:Re:Re:Re:Re:Re:java.lang.ArrayIndexOutOfBoundsException: 500
HXTT Support
2011-05-25 14:21:37.0
>however the original applications that run on Fox, sometimes required reindex
>table because a record is not found....a record that has been updated under
>java using HXTT DBF driver....
Let's narrow that issue.
1st. Copy that .dbf and .idx to another directory.
2nd. Use foxpro to recur that "a record is not found" issue, if recur, then that index file should contain invalid information.
3rd. Whether are you using SAMBA share?
Re:Re:Re:Re:Re:Re:Re:java.lang.ArrayIndexOutOfBoundsException: 500
Oscar San Martin
2011-05-25 14:33:14.0
We are not using SAMBA, HXTT service run on SCO Unix, java app are running in linux or win OS

Fox app in SCO are executed as terminal from PCs with telnet.....
Re:Re:Re:Re:Re:Re:Re:Re:java.lang.ArrayIndexOutOfBoundsException: 500
HXTT Support
2011-05-27 02:40:49.0
The latest package will lock the total uncompress IDX format index file when update.
Re:Re:Re:Re:Re:Re:Re:Re:java.lang.ArrayIndexOutOfBoundsException: 500
Oscar San Martin
2011-06-08 18:07:33.0
I was download latest package, but I was uninstall it because the SELECT statement found in a random search keys in my production environment....one yes one not....

may be that the driver can not update all indexes on very large tables?

Thanks in advance...
Re:Re:Re:Re:Re:Re:Re:Re:java.lang.ArrayIndexOutOfBoundsException: 500
HXTT Support
2011-06-08 18:13:00.0
>because the SELECT statement found in a random search keys in my production
> environment...
HXTT DBF failed to SELECT or your Foxpro application failed?
Re:Re:Re:Re:Re:Re:Re:Re:java.lang.ArrayIndexOutOfBoundsException: 500
Oscar San Martin
2011-06-08 18:41:37.0
HXTT DBF failed random.....
Re:Re:Re:Re:Re:Re:Re:Re:java.lang.ArrayIndexOutOfBoundsException: 500
Oscar San Martin
2011-06-09 06:40:39.0
Additional info :

When SELECT fail, both sides fail, Foxplus and HXTT, then we restore to previous HXTT DBF on server side (only), and now SELECT work fine in java app without re-index tables....but some indexes are not updated and Foxplus fail constantly until it re-indexed all tables...

Thanks,

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 | Sitemap