|
From: Rob M. <Rob...@co...> - 2006-01-10 15:33:11
|
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 |
