Re: AS400 Object Tree problem

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.
bharris@xxxxxxxxxxxxxxxxx


-----Original Message-----
From: squirrel-sql-users-bounces@xxxxxxxxxxxxxxxxxxxxx
[mailto:squirrel-sql-users-bounces@xxxxxxxxxxxxxxxxxxxxx] On Behalf Of
Robert Manning
Sent: Tuesday, October 31, 2006 5:09 PM
To: Gupta, Abhishek
Cc: squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
Subject: Re: [Squirrel-sql-users] AS400 Object Tree problem

On 10/31/06, Gupta, Abhishek <abhishek.gupta@xxxxxx> 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=28383&package_id=1
58128&release_id=459981

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=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV