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
SquirrelSQL 2.3 DatabaseMetaData
Joe Gooch
2006-11-10 14:49:51.0
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 www.squirrelsql.org. Any ideas?
Re:SquirrelSQL 2.3 DatabaseMetaData
HXTT Support
2006-11-10 23:52:53.0
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.0
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.0
Yep, that fixes it. Could you also post a unified diff of the source changes?

Thanks!
Re:Re:Re:Re:SquirrelSQL 2.3 DatabaseMetaData
HXTT Support
2006-11-12 05:56:25.0
I sent one of SquirrelSQL's developers those modifications. You can download it from default_drivers.xml, SchemaInfo.java, and SQLDatabaseMetaData.java. 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.0
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.0
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
SchemaInfo.java(squirrel-sql-2.3.1-src.zip).

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 SQLDatabaseMetaData.java.

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.0
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




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