Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.150
  HXTT Cobol 5.0.150
  HXTT DBF 7.1.151
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel 6.1.154
  HXTT Json 1.0.122
  HXTT Paradox 7.1.150
  HXTT PDF 2.0.150
  HXTT Text(CSV) 7.1.150
  HXTT Word 1.1.150
  HXTT XML 4.0.151
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




excluding zip files from hxtt dbf directory discovery
Chris McGuinness
2021-01-07 11:30:54.0
Is there a way to tell the hxtt dbf drivers to ignore any zip files within directories containing both dbf and zip files?

Thank you for your help.

Regards
Re:excluding zip files from hxtt dbf directory discovery
HXTT Support
2021-01-08 06:06:58.0
Has disable that feature now, and provide an ignoreCompressionFile connection property to open it.


ignoreCompressionFile Indicates whether can list alll tables in compression file. You can use null, true, false
true
Re:Re:excluding zip files from hxtt dbf directory discovery
Chris McGuinness
2021-01-08 14:19:32.0
Thank you for your answer.

Our initial testing of our connection strings from the client side show this setting to be effective and will be helpful.

We where hoping for a setting that changes the hxtt service behavior as we are connecting to remote hxtt dbf services.

Is there a way in the urlconfig.properties file to prevent the hxtt service from trying to catalog zip files?

When we have to restart the service, and there has been an addition to the urlconfig.properties file, the service takes over ten minutes to become active. An analysis of the processes during this time indicates that the service may be cataloging the contents of zip files.

Is this theory correct?
Re:Re:Re:excluding zip files from hxtt dbf directory discovery
HXTT Support
2021-01-08 15:39:13.0
>We where hoping for a setting that changes the hxtt service behavior as we are connecting to remote hxtt dbf services.

Upgrade the server service version too, since default value ignoreCompressionFile=true now. Otherwise the server version can't know what's ignoreCompressionFile switch.

>An analysis of the processes during this time indicates that the service may be cataloging the contents of zip files.
Haven't met. Maybe, if it used getCatalogs function.
excluding zip files from hxtt dbf directory discovery
Chris McGuinness
2021-01-11 13:26:48.0
Hello,

Thank you for your replies.

We updated from the 3/17/2020 .jar files to the 10/12/2020 .jar files.
We downloaded DBF_JDBC43.jar and DBF_Remote_Access_JDBC43.jar.

We need the DBF_Remote_Access_JDBC43.jar file as we use the HXTT JDBC drivers in remote mode.

When trying to use the new .jar files to access local .dbf files, we are able to see schemas and data.

When trying to use the new .jar files to access remote .dbf files, we are able to see schemas, but when we try to access data, we get:

"Error: java.io.InvalidClassException: com.hxtt.sql.common.j; local class incompatible: stream classdesc serialVersionUID = 7383398038347354018, local class serialVersionUID = -9162517473762516818 while reading serialized object
SQLState: 60000
ErrorCode: 393216"

We get the same result when testing with squirrelSQL, Jaspersoft, and Servoy.

Hopefully, this is just a versioning issue with the DBF_Remote_Access_JDBC43.jar file.

Please let us know if you need any additional information.

Regards,

Chris McGuinness
excluding zip files from hxtt dbf directory discovery
Chris McGuinness
2021-01-11 13:34:33.0
Additional note:

I copied DBF_Remote_Access_JDBC43.jar from: http://www.hxtt.com/downloadagent.jsp?product=DBF_JDBC43.jar

I copied DBF_Remote_Access_JDBC43.jar from: http://www.hxtt.com/downloadagent.jsp?product=DBF_Remote_Access_JDBC43.jar

Regards, Chris
Re:Re:Re:Re:Re:Re:excluding zip files from hxtt dbf directory discovery
HXTT Support
2021-01-16 05:04:02.0
Please redownload the latest package. In my test, it haven't that issue.

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