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
HXTT Paradox Driver Index Questi
Paul
2009-02-26 13:16:05.0
Hi, I'm using HXTT paradox with BDE(Borland Database Engine).

When I perform insert/delete on table using BDE :

for example : insert into mytable (id,name) values(6,'empty')

HXTT Paradox doesn't see this row during 5-10 seconds:

select * from mytable where id =6 returns none, but
select * from mytable where cint(id) =6 returns OK

It seems that it uses cached indexes.


If i perform update on table using bde->HXTT works perfectly and sees recent changes.


To force index reload i execute the following fake query in HXTT:

update mytable set id=cint(id) where cint(id)=6


But it works too slow. Is there any easy way to force table index reload?
Re:HXTT Paradox Driver Index Questi
Paul
2009-02-26 13:40:21.0
one thing more:
I can't use reindex all on mytable because it breaks secondary desc indexes(they becomes asc) and corel paradox reports that table is required rebuild. ParadoxRuntime Environment 10 reports that the index is out of date.
So i use bde for writing and hxtt for reading in order not to corrupt indexes.
How to notify paradox driver that the table index was changed by another application?
Re:Re:HXTT Paradox Driver Index Questi
HXTT Support
2009-02-26 17:30:38.0
>It seems that it uses cached indexes.
Try lockTimeout=-1 connection property.
Re:Re:Re:HXTT Paradox Driver Index Questi
Paul
2009-02-27 00:31:50.0
Thanks :)
Works, but with delayedClose

jdbc:paradox:///c:/cpt/bc_data?delayedClose=0;lockTimeout=-1;

If i remove delayedClose or lockTimeout -> it does not see record


Re:Re:Re:Re:HXTT Paradox Driver Index Questi
HXTT Support
2009-02-27 02:39:03.0
>I can't use reindex all on mytable because it breaks secondary desc indexes(they becomes asc)
v4.2.050 supports secondary DESC indexes.
Re:Re:Re:Re:HXTT Paradox Driver Index Questi
HXTT Support
2009-02-27 02:48:10.0
>If i remove delayedClose or lockTimeout -> it does not see record
Same table format. But HXTT Paradox and BDE can't see each other. If you use HXTT Paradox for read purpose, and BDE to write, you can mixture them through lockTimeout and delayedClose connection property.

If you wish to use BDE and HXTT Paradox do concurrent modification at the same time, the best solution should be using free jdbc-odbc bridge driver. The file PDOXUSRS.NET is the network file that Paradox uses to keep track of who's in which areas of the database files. A experimental NETDIR connection property can be used to do that in HXTT Paradox, but we haven't done more support for this. It's unstable.
Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
Paul
2009-02-27 03:21:51.0
->v4.2.050 supports secondary DESC indexes.

I have just downloaded 4.2.05

before reindex all:

http://www.uploadhouse.com/viewfile.php?id=3529664

after reindex all:
http://www.uploadhouse.com/viewfile.php?id=3529663
Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
Paul
2009-02-27 03:22:46.0
Sorry :)

BEFORE:
http://www.uploadhouse.com/viewfile.php?id=3529663


after:
http://www.uploadhouse.com/viewfile.php?id=3529664
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
HXTT Support
2009-02-27 03:30:19.0
>I have just downloaded 4.2.05
It's upload before about 1 hour. Please check your version.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
Paul
2009-03-03 05:05:48.0
-> It's upload before about 1 hour. Please check your version.

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

Name: com/hxtt/sql/paradox/
Specification-Title: HXTT Paradox JDBC 3.0 Package For Evaluation Purp
ose
Implementation-Title: com.hxtt.sql.paradox
Specification-Version: 4.2.050 on February 27, 2009
Specification-Vendor: Hongxin Technology & Trade Ltd.
Comment: JDBC 3.0 Package for Corel Paradox
Implementation-Version: 4.2.050 on February 27, 2009
Implementation-Vendor: Hongxin Technology & Trade Ltd.
Implementation-URL: http://www.hxtt.com/paradox.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 February 27, 2009
Comment: HXTT Database Admin
Implementation-Version: 0.5 on February 27, 2009
Implementation-Vendor: Hongxin Technology & Trade Ltd.
Implementation-URL: http://www.hxtt.com/paradox/dbadmin.html


----
I have another problem . I have attached two sample tables: before pack table and after pack table.
Two records were added to this table using BDE. Paradox Driver does no see them at all. Only after pack table is performed in corel paradox.
Moreover, if i do insert using HXTT -> Corel Paradox and BDE reports that the index is corrupted. Plz help :)

http://rapidshare.com/files/204786261/paradox-index.rar.html

Re:Re:Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
Paul
2009-03-03 05:10:00.0
Query to test:
select count(*) from kontpers where (Relaties_nummer)=180 returns less than
select count(*) from kontpers where cint(Relaties_nummer)=180

after pack table all queries returns the same result.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
HXTT Support
2009-03-03 16:47:27.0
It seems I can't download your paradox-index.rar file. You can email it to support@hxtt.com
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
HXTT Support
2009-03-09 06:23:35.0
>Two records were added to this table using BDE. Paradox Driver does no see them at all.
>Only after pack table is performed in corel paradox.
It was resulted by Corel Paradox won't maintain kontpers.XG0(kontpers.YG0) and kontpers.XG1(kontpers.YG1) in time, but HXTT Paradox will utilize those XG(YG) index information. HXTT Paradox supports smart utilzing one part of an index expression to quicken query. The latest packages will utilize PX index first. It'll be availabe after about 1 hour.

>Moreover, if i do insert using HXTT -> Corel Paradox and BDE reports
> that the index is corrupted. Plz help :)
If you wish BDE and HXTT Paradox to do concurrent insert, you should use NETDIR connection property. The experimental NETDIR connection property can be used to do that in HXTT Paradox, but we haven't done more support for this. It's unstable, and unadvised.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
Paul
2009-03-09 06:26:55.0
>If you wish BDE and HXTT Paradox to do concurrent insert, you should use >NETDIR connection property. The experimental NETDIR connection property can be >used to do that in HXTT Paradox, but we haven't done more support for this. >It's unstable, and unadvised.

Not concurrent. BDE writes record->BDE is stopped->Paradox driver is started->Driver does not understand indexes updated by BDE and does not see inserted by BDE record
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
HXTT Support
2009-03-09 06:34:00.0
>Not concurrent. BDE writes record->BDE is stopped->Paradox driver is
>started->Driver does not understand indexes updated by BDE and does not
> see inserted by BDE record
But BDE doesn't update XG*(YG*) files in time for speed consideration. The latest HXTT Paradox will utilize PX file first.

>Moreover, if i do insert using HXTT -> Corel Paradox and BDE reports
> that the index is corrupted. Plz help :)
Tried "reindex all on kontpers;" and hasn't seen error report from BDE.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
Paul
2009-03-09 07:05:53.0
>Tried "reindex all on kontpers;" and hasn't seen error report from BDE.
I have just sent to support@hxtt.com the smallest full database i have(about 3mb) and 3 screenshots made in Corel paradox.
The third screenshot is related to the big DB(2GB size) which i can't directly send to you :). So in that base table kontpers contains more than 26000 records. You may see that corel writes "record 881 is not in sort order" after "reindex all".
But after repair table in corel paradox, HXTT driver cannot access about 500 records by direct composite id.
I think the problem is in composite primary key.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
HXTT Support
2009-03-11 23:35:13.0
Please download the latest package. Checked. Your issue was resulted by index support for European accented characters.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
Paul
2009-03-12 00:32:30.0
Seems to be ok now :) All records are seen in kontpers and berirela tables.
Thanks for help :)
I'll test it more harder later.

Some problems still exist after reindex all(but they are not important to me):
1)still breaks desc index to asc (for example bericht table)
2)mysterious "record is not in set order" still appears in the big database on table kontpers

If you interesting in point 2), i may send you big database in archive(76mb).
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
HXTT Support
2009-03-12 01:11:48.0
You can continue reporting your issue.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
Paul
2009-03-13 00:01:30.0
->You can continue reporting your issue.
I can't send 76mb by email. Do you accept any external file storage?
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
HXTT Support
2009-03-13 00:20:32.0
Try webmaster.hxtt@gmail.com
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
Paul
2009-03-13 01:05:17.0
->Try webmaster.hxtt@gmail.com
GMail supports maximum 25mb file attachment
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
HXTT Support
2009-03-13 01:25:23.0
You can choose ftp method too:
ftp site: ftp.hxtt.com
ftp user: anonymous@hxtt.com
ftp password: (empty)
login mode: normal (not anonymous)
ftp port:21
upload directory: incoming
After upload, you can't(HXTT can) see that upload file, but it has been upload.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Paradox Driver Index Questi
Paul
2009-03-13 02:15:47.0
Uploaded reindex-bigdatabase.rar

For
->1)still breaks desc index to asc (for example bericht table)
Please see database that i have sent you before

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