Well now I am truly embarrassed. I sent an email to our DBA to ask if
he had a current schema and he said he did generate one at one time but
gave up on it as there were no primary or foreign keys defined in the
system!??! What kind of database is that??
I suppose the next question is what is MS Accesses doing when it
decides that they're are primary keys. Nope, don't really care enough
to investigate that. Still, I some point I'll download the source. I
have a couple of ideas I'ld like to experiment with before proposing.
Thanks for your time,
Simon
------
Simon Grantham
Fleming College
Sys. Admin, H&OD
Ext. 1976
>>> Rob Manning <Rob...@co...> 1/10/2006 10:32 AM
>>>
Simon Grantham wrote:
>I was using the OCI version of JDBC in order to use tnsnames without
>specifying host name (e.g. URL=jdbc:oracle:oci:@<sid>).
>However, I tried the pure java driver
>(URL=jdbc:oracle:thin:@<host>:<port>:<sid>) with the same results.
That
>is, the "Primary Key" tab of the Objects display, only shows that
there
>are no primary keys and generates no errors to indicate what my be a
>cause. I guess I'll have to download the Squirrel source and try and
>debug.
>
>
Always good to have more eyes looking at the code ;)
Sounds like the driver is failing to give the primary key info for the
table you are inspecting.(Either
that or some exception is occuring) Are you using the latest 10g type4
driver (ojdbc14.jar) to access
your Oracle 9i server?
Rob
|
