squirrel-sql-users

[Squirrel-sql-users] PKs, FKs and graphs in SQuirreL

[Mateus F. R. <mat...@ya...>]

Hello!

I'm using SQuirreL to access a remote DB2 database
using an JDBC-ODBC bridge driver. I have 2 questions
and would be very grateful if you could answer them:

1) I'm able to see the PKs and FKs for some tables of
some squemas... but for the majority of tables
SQuirreL simply doesn't show any PK or FK... Do you
know the reason? Is there anything to do with the
JDBC-ODBC driver?

2) I've added some tables to a new graph, but the
operations like "add all related tables" simply don't
work. The "PK" and "FK" symbols also don't appear,
even if I click in the option to do so... I also don't
know how to connect manually the tables (in the worst
case) and if is there possible to generate a graph
from an particular schema (ideal scenario)...

Thank you,

Mateus Ribeiro

P.S.: I'm using a jdbc-odbc bridge driver because I
couldn't establish a connection with my JDBC driver.
The database is in a mainframe.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Re: [Squirrel-sql-users] PKs, FKs and graphs in SQuirreL

[Gerd W. <bir...@t-...>]

Mateus F. Ribeiro wrote:
> Hello!
> 
> I'm using SQuirreL to access a remote DB2 database
> using an JDBC-ODBC bridge driver. I have 2 questions
> and would be very grateful if you could answer them:
> 
> 1) I'm able to see the PKs and FKs for some tables of
> some squemas... but for the majority of tables
> SQuirreL simply doesn't show any PK or FK... Do you
> know the reason? Is there anything to do with the
> JDBC-ODBC driver?
> 
> 2) I've added some tables to a new graph, but the
> operations like "add all related tables" simply don't
> work. The "PK" and "FK" symbols also don't appear,
> even if I click in the option to do so... I also don't
> know how to connect manually the tables (in the worst
> case) and if is there possible to generate a graph
> from an particular schema (ideal scenario)...
I'm pretty sure that your problems are caused by the JDBC-ODBC bridge. 
It has quite some limitation especially with respect to meta data and 
the Graph plugin does a lot of meta data accesses.


> 
> Thank you,
> 
> Mateus Ribeiro
> 
> P.S.: I'm using a jdbc-odbc bridge driver because I
> couldn't establish a connection with my JDBC driver.
> The database is in a mainframe.
Perhaps this link may help you:
http://www-03.ibm.com/servers/eserver/iseries/toolbox/

> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

Re: [Squirrel-sql-users] PKs, FKs and graphs in SQuirreL

[Rob M. <Rob...@co...>]

Gerd Wagner wrote:
> Mateus F. Ribeiro wrote:
>> Hello!
>>
>> I'm using SQuirreL to access a remote DB2 database
>> using an JDBC-ODBC bridge driver. I have 2 questions
>> and would be very grateful if you could answer them:
>>
> I'm pretty sure that your problems are caused by the JDBC-ODBC bridge. 
> It has quite some limitation especially with respect to meta data and 
> the Graph plugin does a lot of meta data accesses.

Mateus,

I have to agree with Gerd on this.  I've used the JDBC-ODBC bridge to 
connect to MS-Access
and many of the metadata-related methods (for PK, FK, etc) throw 
exceptions claiming no
support.  Even Sun acknowledges that this is a temporary solution, 
should be regarded as experimental
and should only be used when no JDBC driver is available.  I'd recommend 
that you give the IBM DB2
Universal JDBC driver a try.

Rob