Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
  Buy Now
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.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)

SquirrelSQL 2.3 DatabaseMetaData
Joe Gooch
2006-11-10 14:49:51
It seems that as of SquirrelSQL 2.3 final the schema enumeration no longer works with HXTT DBF 3.0.024. In SquirrelSQL 2.1 it works fine. In SquirrelSQL 2.3 it gives me catalogs and schema entries but no tables underneath. SquirrelSQL is free and available at Any ideas?
Re:SquirrelSQL 2.3 DatabaseMetaData
HXTT Support
2006-11-10 23:52:53
Recurred, and dug out the issue in SquirrelSQL 2.3.1. I will write a patch and contact with the author of SquirrelSQL, and wish he can accept my suggestion.
Re:Re:SquirrelSQL 2.3 DatabaseMetaData
HXTT Support
2006-11-12 03:02:02
I have notified one of SquirrelSQL's developers. Before they accept HXTT's modifications, you can download Fixed squirrel-sql.jar, and replace the squirrel-sql.jar file in your SquirrelSQL directory. BTW, it's for SquirrelSQL 2.3.1, but it should work for your SquirrelSQL 2.3 too.
Re:SquirrelSQL 2.3 DatabaseMetaData
Joe Gooch
2006-11-12 05:39:33
Yep, that fixes it. Could you also post a unified diff of the source changes?

Re:Re:Re:Re:SquirrelSQL 2.3 DatabaseMetaData
HXTT Support
2006-11-12 05:56:25
I sent one of SquirrelSQL's developers those modifications. You can download it from default_drivers.xml,, and One new schema cache in SquirrelSQL 2.3 resulted that issue, but it shouldn't consider as a bug of SquirrelSQL or HXTT. Because Database Pilot, DBVisualizer, iSQL-Viewer, AquaDataStudio, SQuirreL SQL Client, and DbEdit Database Utilites, are expecting differect things for a JDBC driver, and HXTT has to do some balance strategy to let it can work normally with them at full steam.
Re:SquirrelSQL 2.3 DatabaseMetaData
Joe Gooch
2006-11-12 06:15:36
I was looking to see what changed so I can be sure in my application (where I'm using databasemetadata calls) I'm using methods that will work in my environment.

I generated a patch from the source you posted.
Thanks again!
Re:Re:Re:Re:Re:Re:SquirrelSQL 2.3 DatabaseMetaData
HXTT Support
2006-11-12 15:42:46
It should work in your application.

First, let me introduce the special catalog name, ".", in HXTT's
drivers. Those drivers supports to use subdirectory path as catalog
name, and "." is used as the toppest catalog name, because null can't
be used as formal catalog name. I have to modify the line 912 of

Secondly, null as catalog name is only allowed to fetches tables in
the toppsest directory. I have to add the following code into the line
1070 of

I modified also default_drivers.xml to add six type 4 JDBC drivers' information.

Re:Re:Re:Re:Re:Re:Re:SquirrelSQL 2.3 DatabaseMetaData
HXTT Support
2006-11-14 19:50:24
Two developers of SquirrelSQL has contacted with HXTT, and are adjusting/testing SquirrelSQL's code to avoid the similar issue:)

Search Key   Search by Last 50 Questions


Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap