Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v4.2
  HXTT Paradox v5.2
  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 DBF
Query timeout issue
Ralph Etienne
2010-10-14 13:13:43.0
Dear support,
I am writing a java application that at one point attempts to query an ISAM flat file database using you DBF v3.0. Due to the size of the file the query takes some time and I get the following timeout error:

java.sql.SQLException: Timeout Interrupted Exception: beyond 30000 msecs to get result for a remote request, but that request should have been executed by remote server.
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.remote.a.a(Unknown Source)
at com.hxtt.sql.remote.l.a(Unknown Source)
at com.hxtt.sql.remote.u.do(Unknown Source)
at com.hxtt.sql.remote.y.a(Unknown Source)
at com.hxtt.sql.remote.y.executeQuery(Unknown Source)

To combat the timeout I tried extending the time of my timeout by resetting the property of my statement. Unfortunately this does not help at all as I get the same error. So even if i set the timeout to 60000 ms from the default of 30000ms the error I get still references 30000 ms.

My question to you is whether this is a bug that has been resolved or am I just doing something incorrectly. Please let me know if you need more information to determine what is happening.

Thank you for your help.
Re:Query timeout issue
HXTT Support
2010-10-15 00:07:26.0
>My question to you is whether this is a bug that has been resolved
Yeah. If you have used ResulteSet.updateRow method, it's a fixed bug. You can trye the latest pacakage to see whether your issue disappear.

>I am writing a java application that at one point attempts to query an ISAM flat
>file database using you DBF v3.0. Due to the size of the file the query takes
>some time and I get the following timeout error:
What's your jdbc url setting? What's your sql?
Re:Re:Query timeout issue
Ralph Etienne
2010-10-15 14:27:09.0
My URL looks like this:
jdbc:dbf://localhost:2010/c:/Progra~1/application/DB/utils

I tried seetting the lockout property but this did not seem to work. On a side not I initailly had a bug in my code where I was not closing the connection and if I ran the query 2x in a row the second time it would actually run.

The query looks like this:
SELECT DISTINT element1, element2, element3 FROM RegFile

I will admint the file is quite large but I upped the lockout time to 10 minutes and it still did not run.
Re:Re:Re:Query timeout issue
HXTT Support
2010-10-16 01:38:15.0
>I will admint the file is quite large but I upped the lockout time to 10 minutes
> and it still did not run.
In my memory, client/server mode will limit too long lockout setting.

You can use "create index abc on RegFile (element1+element2+element3 UNIQUE);", then "SELECT DISTINCT on (element1+element2+element3) element1, element2, element3 FROM RegFile" won't use such a long time to query your database.

Re:Re:Re:Re:Query timeout issue
Ralph Etienne
2010-10-18 08:08:28.0
Hi Support,

Thank you very much for the suggestiong I will try it. Forgive my lack of experience with indexing a flat file database but I just want to be sure that indexing the file will not change anything in it so the application that deals with it won't return an error at a later time.

In short my questions in this:

Will indexing the file modify any data in it?
Re:Re:Re:Re:Re:Query timeout issue
Ralph Etienne
2010-10-18 09:26:55.0
Also, if I wanted to drop the index and recreate it every time the program is run what would be the syntax for dropping it?

DROP INDEX abc? Or is it different?
Re:Re:Re:Re:Re:Query timeout issue
Ralph Etienne
2010-10-18 14:37:32.0
Maybe I am doing something wrong but it seems that I get the same error when creating the index. If I create the index on one element there is not issue, but for my query I need an index on 7 elements.
Re:Re:Re:Re:Re:Re:Re:Query timeout issue
HXTT Support
2010-10-21 20:06:58.0
Sorry. Omitted to reply that post:(
>that indexing the file will not change anything in it
>Will indexing the file modify any data in it?
Index won't modify original data rows.

>Also, if I wanted to drop the index and recreate it every time the program
> is run what would be the syntax for dropping it?
Run once create index sql, than it will be maintained automatically.

>DROP INDEX abc? Or is it different?
DROP INDEX [IF EXISTS] {ALL | indexName[,...]} [of indexFileName] ON table_name For instance, DROP INDEX ALL OF 'abc.idx' on tset

>If I create the index on one element there is not issue, but for my query I
> need an index on 7 elements.
Yeah. Because XBase index has some limitationa on index name, index expression, and index key length.


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