Re: Version 2.1/Oracle 9i/OCI Driver/Display problem/ can anyone help

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 <Robert.Manning@xxxxxxxxxxxxxxxxx> 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



-------------------------------------------------------
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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click