From: Harris, Bernard W <bharris@we...> - 2006-11-28 22:59:20
I downloaded/installed 2.3.1 and it appears this fix is there for the
IBM iSeries (AS/400) but not for MS SQL Server. I can correctly see the
schema list of tables on the iSeries but when I click on the Tables tree
element for any database within SQL server it shows nothing. Did this
fix get into 2.3.1?
Weather Shield Mfg., Inc.
[mailto:squirrel-sql-users-bounces@...] On Behalf Of
Sent: Tuesday, October 31, 2006 5:09 PM
To: Gupta, Abhishek
Subject: Re: [Squirrel-sql-users] AS400 Object Tree problem
On 10/31/06, Gupta, Abhishek <abhishek.gupta@...> wrote:
> I am using squirrel with an AS400 system with AS400 toolbox jdbc
> The problem I am facing is that the object tree does not display all
> tables for all the schemas.
> After some investigation I found that the driver does not return all
> tables from the metadata if the schema name is not supplied.
Colin Bell has just fixed the same issue with code only slightly
than yours. I've put a new snapshot out on SF that you can download
Please try it out and let us know if it addresses the issue that you are
seeing. The source for the snapshot is also available at the above
location if you want to know what fix was applied.
Using Tomcat but need to do more? Need to support web services,
Get stuff done quickly with pre-integrated technology to make your job
Download IBM WebSphere Application Server v.1.0.1 based on Apache
Squirrel-sql-users mailing list
From: Colin Bell <col@ba...> - 2006-11-29 04:16:10
On Tue, Nov 28, 2006 at 08:46:31AM -0600, Harris, Bernard W wrote:
> I downloaded/installed 2.3.1 and it appears this fix is there for the
> IBM iSeries (AS/400) but not for MS SQL Server. I can correctly see the
> schema list of tables on the iSeries but when I click on the Tables tree
> element for any database within SQL server it shows nothing. Did this
> fix get into 2.3.1?
The problem with MS SQL (and with MySQL) is a different one. With the
ISeries not all schemas were loaded, depending on the job description
associated with the user connecting.
With MS SQL only objects for the current catalog are loaded. You can
change the current catalog through the Catalog drop down on the toolbar
in the session window. This is a known bug and will be fixed.