Re: getExportedKeys/getImportedKeys - Mailing list pgsql-jdbc

Sounds great, thanks a lot.

/Patrik

-----Ursprungligt meddelande-----
Från: Dave Cramer [mailto:davec@fastcrypt.com]
Skickat: Wednesday, March 12, 2003 7:48 PM
Till: Patrik Lundgren
Kopia: pgsql-jdbc@postgresql.org
Ämne: Re: [JDBC] getExportedKeys/getImportedKeys


Ok, I have confirmed that it isn't working with a 7.3 driver and a 7.2
db so now I'll have a crack at fixing it.

Dave
On Wed, 2003-03-12 at 10:54, Patrik Lundgren wrote:
> I've tried using the latest stable JDBC3 driver (the one for 7.3), and

> I also just tested the latest development build. Sadly no difference.
> The thing is that when looking at the CVS I see that this is handled
> differently in 7.3 since the system tables have changed but it's not
> like itäs not supported in earlier versions.
>
> I haven't had time to upgrade postgresql to 7.3 yet so I don't know if

> I'll get the same problem there. Most likely I will not since there
> are not so many different parameters to call getExportedKeys with. If
> catalog and schema is set to null and the table name is correct then
> there should be no problem. Unfortunately I don't have access to any
> 7.3 servers so I can't test this at the moment. This is going to be a
> smaller and smaller problem if it works with 7.3 since people are
> starting to upgrade. It would be nice though if it worked with 7.2.
>
> Thanks everyone who answered so far.
>
> Regards,
> Patrik
>
> -------------------------------
>
>
> 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@postgresql.org
> > > [mailto:pgsql-jdbc-owner@postgresql.org] *För *Carl Olivier
> > > *Skickat:* Wednesday, March 12, 2003 1:13 PM
> > > *Till:* Patrik Lundgren; pgsql-jdbc@postgresql.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@postgresql.org
> > >         [mailto:pgsql-jdbc-owner@postgresql.org]*On Behalf Of
> *Patrik
> > >         Lundgren
> > >         *Sent:* 12 March 2003 01:41 PM
> > >         *To:* pgsql-jdbc@postgresql.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 <davec@fastcrypt.com>
Cramer Consulting