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.
Thanks
Simon
------
Simon Grantham
Fleming College
Sys. Admin, H&OD
Ext. 1976
>>> Rob Manning <Rob...@co...> 1/9/2006 5:53 PM
>>>
Simon Grantham wrote:
>I just installed 2.1 and it looks to be a great tool. However, after
>connecting to an Oracle 9i database using the OCI driver, I can look
at
>things with the exception of Primary/Imported/Exported keys. I don't
>get privilege violations and in fact, if I link the various tables to
an
>MS Access database through ODBC, MS Access shows the primary keys.
>
>
Simon,
I would hazard to guess that not many use an Oracle OCI driver with
SQuirreL.(I've never tried the
OCI driver - does it use SQL*Net and tnsnames.ora?) Perhaps you can
give the Type-4 JDBC
driver a try? If memory serves me correctly, I believe Oracle
recommends the pure-Java driver
anyway. I use it, and can access the information you are looking for.
Rob Manning
|
