Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.0
  HXTT Cobol v4.0
  HXTT DBF v7.0
  HXTT Excel v6.0
  HXTT Paradox v7.0
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT PDF v1.1
  HXTT Text(CSV) v7.0
  HXTT Word v1.0
  HXTT XML v3.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 Paradox
Query error in Paradox
Diana Pulido
2013-01-29 14:54:28.0
Hi, I have a table in Paradox CHOLDERS, by making the query takes a long time and generates the following error:

Caused by: java.sql.SQLException: Failed to go Rowid 43324D303130543538000B00A3 of table CHOLDERS: Failed to access file CHOLDERS.db for it has been closed.
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.paradox.m.a(Unknown Source)
at com.hxtt.sql.r.a(Unknown Source)
at com.hxtt.sql.z.a(Unknown Source)
at com.hxtt.sql.cb.if(Unknown Source)
at com.hxtt.sql.cb.a(Unknown Source)
at com.hxtt.sql.dz.a(Unknown Source)
at com.hxtt.sql.dz.if(Unknown Source)
at com.hxtt.sql.dz.a(Unknown Source)
at com.hxtt.sql.dz.a(Unknown Source)
at com.hxtt.sql.dz.a(Unknown Source)
at com.hxtt.sql.bx.a(Unknown Source)
at com.hxtt.sql.bx.a(Unknown Source)
at com.hxtt.sql.bx.a(Unknown Source)
at com.hxtt.sql.am.a(Unknown Source)
at com.hxtt.sql.d1.executeQuery(Unknown Source)
Re:Query error in Paradox
HXTT Support
2013-01-29 18:18:00.0
First, what's the file size of CHOLDERS table?
Secondly, what's your sql?
Thirdly, whether you have used Statement.setQueryTimeout?
Last, please download the latest version.

Re:Re:Query error in Paradox
Diana Pulido
2013-01-30 06:05:54.0
Table CHOLDERS are using it two times

1. Information table:
Number of fields: 18
Primary Keys: 3
Location REALTIME:
Size: 354KB
Number of records: 3492
Location MAESTROS:
Size: 642KB
Number of records: 4118

2. SQLs:
SELECT c.fechaaltacuenta, h.liquidador, h.miembro, h.titular, c.subcuenta,
h.descripcion, h.NumIdentif, c.estado, h.tipoPersona
FROM "/REALTIME/CACCOUNTS" c
INNER JOIN "/REALTIME/CHOLDERS" h
ON (c.miembro=h.miembro AND c.titular=h.titular AND c.camara=h.camara)
WHERE h.camara = 'C2' and ( h.miembro = ? OR h.liquidador= ? )
ORDER BY c.fechaaltacuenta DESC


SELECT c.fechaaltacuenta, h.liquidador, h.miembro, h.titular, c.subcuenta,
h.descripcion, h.NumIdentif, c.estado, h.tipoPersona
FROM "/HISTORICOS/MAESTROS/CACCOUNTS" c
INNER JOIN "/HISTORICOS/MAESTROS/CHOLDERS" h
ON (c.miembro=h.miembro AND c.titular=h.titular AND c.camara=h.camara)
WHERE h.camara = 'C2' and ( h.miembro = ? OR h.liquidador= ? )
ORDER BY c.fechaaltacuenta DESC

3. I have not used Statement.setQueryTimeout

4. We are working with HXTT_Common_JDBC40.jar and Paradox_JDBC40.jar, review the latest version

Thanks
Re:Re:Re:Query error in Paradox
HXTT Support
2013-01-31 00:44:37.0
>4. We are working with HXTT_Common_JDBC40.jar and Paradox_JDBC40.jar, review the latest version
Use only Paradox_JDBC40.jar is enough.

Backup your database file, then run once "reindex all on CHOLDERS", to see whether your issue disappear. If not, please email us a sample so that we can recur your issue.


Re:Re:Re:Re:Query error in Paradox
Diana Pulido
2013-02-04 08:30:06.0
Hi, we created two indices using the program Database Desktop think four files (CHOLDERS.XG0, CHOLDERS.YG0, CHOLDERS.XG1 and CHOLDERS.YG1). But the result is the same.



Re:Re:Re:Re:Re:Query error in Paradox
Diana Pulido
2013-02-04 08:57:10.0
The paradox tables were sent to the email.
Re:Re:Re:Re:Re:Re:Query error in Paradox
HXTT Support
2013-02-04 23:02:55.0
>Hi, I have a table in Paradox CHOLDERS, by making the query takes a long time and generates the following error:
Thanks for your sample, but that sample return result very fast.

>4. We are working with HXTT_Common_JDBC40.jar and Paradox_JDBC40.jar, review the latest version
The latest version is 2012-12-11 v5.1.090 provides SPLIT(expression,delimeter) function.

>Hi, we created two indices using the program Database Desktop think four files (CHOLDERS.XG0, CHOLDERS.YG0, CHOLDERS.XG1 and CHOLDERS.YG1). But the result is the same.
Failed to recur your issue. If possible, please provide a simple Java code sample.




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