Thread: Re: [Squirrel-sql-users] AS400 Object Tree problem
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Harris, B. W <bh...@we...> - 2006-11-28 22:59:20
|
Hello, 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? Bernard Harris Project Manager Weather Shield Mfg., Inc. bh...@we... -----Original Message----- From: squ...@li... [mailto:squ...@li...] On Behalf Of Robert Manning Sent: Tuesday, October 31, 2006 5:09 PM To: Gupta, Abhishek Cc: squ...@li... Subject: Re: [Squirrel-sql-users] AS400 Object Tree problem On 10/31/06, Gupta, Abhishek <abh...@gs...> wrote: > > > > > Hi, > > > > I am using squirrel with an AS400 system with AS400 toolbox jdbc driver. > > The problem I am facing is that the object tree does not display all the > tables for all the schemas. > > After some investigation I found that the driver does not return all the > tables from the metadata if the schema name is not supplied. > Abhishek, Colin Bell has just fixed the same issue with code only slightly different than yours. I've put a new snapshot out on SF that you can download here: http://sourceforge.net/project/showfiles.php?group_id=3D28383&package_id=3D= 1 58128&release_id=3D459981 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. Rob ------------------------------------------------------------------------ - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D= 121642 _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
From: Colin B. <co...@ba...> - 2006-11-29 04:16:10
|
On Tue, Nov 28, 2006 at 08:46:31AM -0600, Harris, Bernard W wrote: > Hello, > > 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. -- Colin Bell |