Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
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
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT Paradox
Index files
Bjarne Pedersen
2006-11-15 02:54:30.0
Hi,

I have some big problem with a paradox database. Im pretty sure my problem is that there is a corrupt index file (its normally the problem), but how can i see which file i need to do a "reindex" on ?

My problem come when i fire this SQL:
SELECT * FROM Gemtofh WHERE "DebKre nummer" = '0461999027' AND "Art (F,K,T,O,L)"='A' AND "Dato" ='20061114'

If i dont use the "AND "Dato" ='20061114'" part then it do return a lot of rows that contains ""Dato" ='20061114'", but when i use the part in my sql it return nothing.

Is there somehow where i can see which file to reindex ??

Bjarne
Re:Index files
HXTT Support
2006-11-15 03:15:06.0
>but how can i see which file i need to do a "reindex" on ?
>Is there somehow where i can see which file to reindex ??
You can know all index expressions in those index files through most of JDBC tools, for instance, DbVisualizer, AquaDataStudio, Database Pilot, SQuirreL SQL Client, and so on.
But the simplest way is to run once "reindex all on Gemtofh;", and you can use java -Xmx256m ... if your Gemtofh table has a large number of data rows.

Re:Re:Index files
Bjarne Pedersen
2006-11-15 04:38:31.0
When i try "reindex all on Gemtofh" i this exception:


java.sql.SQLException: Failed to reindex file for Timeout Interrupted Exception: beyond 1000 msecs. to acquire table Gemtofh
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.bl.a(Unknown Source)
at com.hxtt.sql.bl.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.execute(Unknown Source)
at com.hxtt.sql.admin.i.byte(Unknown Source)
at com.hxtt.sql.admin.i.access$000(Unknown Source)
at com.hxtt.sql.admin.i$1.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Re:Re:Re:Index files
Bjarne Pedersen
2006-11-15 04:44:19.0
My fault, sorry!
I forget the -Xmx256m.

It is now working.

Thank you for your help!

Bjarne
Re:Re:Re:Re:Index files
HXTT Support
2006-11-15 06:11:52.0
>java.sql.SQLException: Failed to reindex file for Timeout Interrupted
> Exception: beyond 1000 msecs. to acquire table Gemtofh
It hasn't relation with -Xmx256m. Because reindex need to open Gemtofh table exclusively, and Timeout exception means that Gemtofh table is holding by other objects:) After you restart Admin, it can hold Gemtofh exclusively.

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap