Re: Bug in metadata retrieval

On 1/19/07, Ben Burch <Ben.Burch@xxxxxxxxxxxxxxxxxxx> wrote:
> All,
>  there seems to be an issue when using squirrel-sql on windows with SQL
> Server 2000.
>
> Steps to reproduce error as follows:
> - Connect to a SQL Server 2000 instance
> - Click a table in the database explorer
> - Click the 'info' pane to view metadata
> - The 'remarks' property has a corresponding null value
>
> Having run SQL Profiler, it seems as though the information for this
> pane is fed by a call to a stored procedure called
>
> 'sp_tables'
>
> This procedure is a Microsoft one and will never return a value as
> defined online at:
>
> http://msdn2.microsoft.com/en-us/library/ms186250.aspx
>
> We would like to use Squirrel in our organisation and this error is
> causing us problems as there seems to be no other way to view the
> metadata for a table.
>
> Any ideas how to quickly correct this?
Ben,

SQuirreL uses JDBC metadata (DatabaseMetaData.getTables(...)) to
retrieve this information.  We have no control over how the driver
implements this interface internally.  I suppose this is where the
call to sp_tables is being made.  That said, maybe the driver has some
property that will "turn on" the remarks for table objects.  I know
that Oracle has this same default behavior (not populating the remarks
field of the ResultSet returned from getTables(...))  and there is
property (remarksReporting) that when set to true will cause this
field to be populated.  Oracle does this for performance reasons as
the system catalog join required is expensive for instances with many
objects.  If you come across something that tells you how to get the
remarks using code (not a driver property) please let us know.  That
may be useful information in the future for the plugin.

Rob

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