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
Ntx corrupted index problem
Leszek
2012-09-10 08:17:44.0

i'm using: HXTT DBF Version 4.2
my connection string is:
jdbc:dbf:////?versionNumber=03;Default Index Suffix=NTX;DefaultExtension=DBF;OtherExtensions = true;charSet=Cp850;lockType=CLIPPER;

when i use query:

update gt_lmta
SET LMT_INDW='rne'
where LMT_GNIAZD = 'A00102'

at first time it works and I can see changes with select query.
Second time with different LMT_INDW parameter it gives me:

Error code 143360, SQL state 23000: Failed to update Record 1 because of corrupted index file. For more information, please use SQLException.getNextException().
Error code 143360, SQL state 23000: Please reindex index expression LMT_INDW+LMT_GNIAZD: Failed to find a child node at:0 in his parent node.
Line 1, column 1

I have .cgp file with:
GT_LMTA1.NTX
GT_LMTA2.NTX
GT_LMTA3.NTX
GT_LMTA4.NTX
GT_LMTA5.NTX

and it seems like gt_lmta3.ntx gets corrupted all the time. After using reindex on this table, select queries will work, until i'll try to update something.
Other tables with single field in index, seems to work
Re:Ntx corrupted index problem
Leszek
2012-09-10 23:53:19.0
It seems that above is happening when in table, there is empty field "lmt_indw". If I remove all of those, indexing seems to work. But for me it's a problem.

There's also another error with query using "like" for example:

select * from GT_LMTA
where LMT_INDW like 'w%'

gives me:
Error code 393216, SQL state 60000: java.lang.ClassCastException: [[C cannot be cast to [C
at com.hxtt.d.i.a(Unknown Source)
at com.hxtt.sql.a0.a(Unknown Source)
at com.hxtt.sql.ck.a(Unknown Source)
at com.hxtt.sql.ax.a(Unknown Source)
at com.hxtt.sql.di.a(Unknown Source)
at com.hxtt.sql.di.a(Unknown Source)
at com.hxtt.sql.c0.e(Unknown Source)
at com.hxtt.sql.di.a(Unknown Source)
at com.hxtt.sql.bq.a(Unknown Source)
at com.hxtt.sql.ah.a(Unknown Source)
at com.hxtt.sql.ah.a(Unknown Source)
at com.hxtt.sql.ah.execute(Unknown Source)
at org.netbeans.modules.db.dataview.output.SQLExecutionHelper.executeSQLStatement(SQLExecutionHelper.java:607)
at org.netbeans.modules.db.dataview.output.SQLExecutionHelper.initialDataLoad(SQLExecutionHelper.java:114)
at org.netbeans.modules.db.dataview.output.DataView.create(DataView.java:105)
at org.netbeans.modules.db.dataview.api.DataView.create(DataView.java:74)
at org.netbeans.modules.db.sql.execute.SQLExecuteHelper.execute(SQLExecuteHelper.java:116)
at org.netbeans.modules.db.sql.loader.SQLEditorSupport$SQLExecutor.run(SQLEditorSupport.java:564)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1452)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:2032)
Re:Re:Ntx corrupted index problem
HXTT Support
2012-09-11 05:09:16.0
You should upgrade it to the latest version v5.1, because v4.2 is a too old version in 2008.
Re:Re:Re:Ntx corrupted index problem
Leszek
2012-09-11 05:31:30.0
Checked with: HXTT DBF Version 5.1 For Evaluation Purpose
and the first problem with updating is still happening (at second or sometimes third update.
Second problem with ClassCastException exception appears to be fixed.
Re:Re:Re:Re:Ntx corrupted index problem
HXTT Support
2012-09-12 04:38:24.0
You can email your issue sample, then it will be supported soon.
Re:Re:Re:Re:Re:Ntx corrupted index problem
HXTT Support
2012-09-12 05:18:06.0
Failed to recur your issue through the following sample sql:
update gt_lmta SET LMT_INDW='rne' where LMT_GNIAZD = 'A00102';
update gt_lmta SET LMT_INDW='laaa' where LMT_GNIAZD = 'A00102';
update gt_lmta SET LMT_INDW='aaa' where LMT_GNIAZD = 'A00102';
Re:Re:Re:Re:Re:Re:Ntx corrupted index problem
HXTT Support
2012-09-12 07:42:20.0
Supported in the latest version now.
Re:Re:Re:Re:Re:Re:Re:Ntx corrupted index problem
Leszek
2012-09-12 07:55:08.0
seems to be working now
thx.

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