Re: getExportedKeys/getImportedKeys

Patrik,

Can you try Barry's suggestion before I dig into it.

Dave
On Wed, 2003-03-12 at 10:16, Barry Lind wrote:
> Patrik,
>
> Another thing you mention you are using 7.2. Are you using 7.2 for both
> the driver and the server? If so have you tried using the 7.3 driver
> against the 7.2 server? This is a supported setup and the 7.3 driver
> has a significant number of fixes in this area.
>
> thanks,
> --Barry
>
>
> Patrik Lundgren wrote:
> > Well, that is one ting we can rule out. I've made sure that the table
> > name is correct. I've tested lower case, upper case and everything in
> > between. Does anyone have any experience with using this function with
> > 7.2? Again my problem is that getExportedKeys/getImportedKeys returns an
> > empty ResultSet.
> >
> > Regards,
> > Patrik Lundgren
> > -----Ursprungligt meddelande-----
> > *Från:* pgsql-jdbc-owner(at)postgresql(dot)org
> > [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] *För *Carl Olivier
> > *Skickat:* Wednesday, March 12, 2003 1:13 PM
> > *Till:* Patrik Lundgren; pgsql-jdbc(at)postgresql(dot)org
> > *Ämne:* Re: [JDBC] getExportedKeys/getImportedKeys
> >
> > Hi.
> > PostGreSql is CASE SESITIVE - for creating foreign keys etc. This
> > seems to hold true for meta data retrieval etc (I admit to having
> > somne trouble with this).
> >
> > So, if you are passing the table pattern through - ensure that it is
> > LOWER CASE ( *I think* ).
> >
> > One other thing that I found funny with the JDBC implementation is this.
> >
> > Data Type TEXT - when you get the meta data back for a column of
> > type TEXT, the data type int (as specified in
> > java.sql.Types.LONGVARCHAR) - wich is what TEXT is - return 12 -
> > this si incorrect according to java.sql.Types - it should be
> > returning -1, as 12 is the VARCHAR java.sql.Types datatype id.
> >
> > I am using version 7.3, not 7.2 so not sure if this was a bug back
> > and has been fixed...
> >
> > Best regards,
> >
> > Carl
> >
> > -----Original Message-----
> > *From:* pgsql-jdbc-owner(at)postgresql(dot)org
> > [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]*On Behalf Of *Patrik
> > Lundgren
> > *Sent:* 12 March 2003 01:41 PM
> > *To:* pgsql-jdbc(at)postgresql(dot)org
> > *Subject:* [JDBC] getExportedKeys/getImportedKeys
> >
> > I'm having real problems with getting the foreign keys from my
> > db. In fact I'm not getting it to work at all. I'm running
> > postgresql 7.2 and I noticed that the code for getting the keys
> > is different for 7.2 and 7.3 in
> > AbstractJdbc1DatabaseMetaData.java. I've tested all different
> > parameters I can think of but still not getting any results.
> > I've made sure that the table parameter is correct and passed
> > null for catalog and schema. Is the method not working or what
> > can I be doing wrong?
> >
> > Desperate... Thanks in advance for any help! Btw I'm making a
> > database admin tool for multiple databases so I really need this
> > to work or my diagrams won't look so good.
> >
> > Regards,
> > Patrik Lundgren
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Dave Cramer <Dave(at)micro-automation(dot)net>