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
Index Corrupt
Oscar San Martin
2011-04-02 13:32:52.0
Sometimes, under many transactions.....HXTT service under SCO Unix collapses and return index error like :


02-04-2011 12:30:48 >> grabarTrxFox2() 1 : UPDATE movimien SET valepreven = ndoc, refe = '186', refe1 = '186', llave = '02/04/2011186', clave = '9 1862186', nlocal = 2 WHERE ndoc = '8559491' AND tpref = '9' AND valepreven = '' AND preventa = 'S'
02-04-2011 12:30:49 >> Error ejecutaQuery : Failed to update Record 116322 because of corrupted index file. For more information, please use SQLException.getNextException().
02-04-2011 12:30:49 >> com.hxtt.global.SQLState.SQLException(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.dbf.i.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.cq.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.ej.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.ej.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.df.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.bn.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.ah.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.ah.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.CallInterface.response(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.server.c.a(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.server.c.for(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.sql.server.c.run(Unknown Source)
02-04-2011 12:30:49 >> com.hxtt.global.b.run(Unknown Source)

How can I determine why occurs this error ??, how can I prevent ??

How tablas are fox for unix with idx index....

Thanks in advance....
Re:Index Corrupt
HXTT Support
2011-04-02 15:59:44.0
>How can I determine why occurs this error ?
For older version, you should use SQLException.getNextException() to know. For new versio, you can see detailed message directly.

>how can I prevent ?
What's your JDBC url? You can use "reindex all on movimien" once to reindex it.
Re:Re:Index Corrupt
Oscar San Martin
2011-04-02 20:21:29.0
JDBC url (client): "jdbc:dbf://200.100.200.2:4444//u/gestion";

JDBC url (server): "server=jdbc\:dbf\://200.100.200.2\:4444//u/gestion?lockType\=FOXPRO4UNIX"

We use foxpro tool in order to reindex movimien table.....this table have many records and all clients must wait a long time while this operation ends

Re:Re:Re:Index Corrupt
HXTT Support
2011-04-03 04:18:38.0
>>How can I determine why occurs this error ?
>For older version, you should use SQLException.getNextException() to know. For >new versio, you can see detailed message directly.
How to know the detailed version information of HXTT DBF package?
1st way: "java com.hxtt.sql.dbf.DBFDriver" will print that information.
2nd way: check that MANIFEST.MF file in jar file.
The latest version is v4.2.212.
A code for order version or simple latest message prompt can help locating what's the issue.

>We use foxpro tool in order to reindex movimien table
"Reindex all on movimien" through server console, remote server control, or client code, can reindex it too.

>this table have many records and all clients must wait a long time
>while this operation ends
Yeah. REINDEX need exclusive use
Re:Re:Re:Re:Index Corrupt
Oscar San Martin
2011-04-04 06:35:45.0
Ok, this is my MANIFEST.MF file in jar :

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: 4.2.058 on May 06, 2009
Specification-Vendor: Hongxin Technology & Trade Ltd.
Comment: JDBC 3.0 Package for Xbase database
Implementation-Version: 4.2.058 on May 06, 2009
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 May 06, 2009
Comment: HXTT Database Admin
Implementation-Version: 0.5 on May 06, 2009
Implementation-Vendor: Hongxin Technology & Trade Ltd.
Implementation-URL: http://www.hxtt.com/dbf/dbadmin.html
Re:Re:Re:Re:Re:Index Corrupt
HXTT Support
2011-04-04 07:11:37.0
It seems that you're using a very old version. Please consider renewing your license so that we can provide support based on latest version.
Re:Re:Re:Re:Re:Re:Index Corrupt
Oscar San Martin
2011-04-04 07:14:41.0
Ok, but what mean "Please consider renewing your license" in order to receive support ??

Thanks,
Re:Re:Re:Re:Re:Re:Re:Index Corrupt
HXTT Support
2011-04-04 23:56:08.0
HXTT promise one year free version upgrade and technical support. You should login hxtt site, and order Renew license/support through a link at download page. We can't solve your issue through latest version.
Re:Re:Re:Re:Re:Re:Re:Re:Index Corrupt
Oscar San Martin
2011-04-05 08:13:43.0
Ok, but, new version give support to JDBC30..., we have SCO JVM 1.4 and cannot upgrade to JVM 1.6.....
Re:Re:Re:Re:Re:Re:Re:Re:Index Corrupt
HXTT Support
2011-04-05 08:23:45.0
>new version give support to JDBC30
>SCO JVM 1.4 and cannot upgrade to JVM 1.6.....
HXTT DBF v5.0 support JVM1.1, JVM1.2, JVM1.3, JVM1.4, JVM1.5, and JVM1.6 . You can use JDBC3.0 package of v5.0 .

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