Thread: Re: [Middlegen-user] Try other one of Postgresql JDBC Driver (no NPE)

Re: [Middlegen-user] Try other one of Postgresql JDBC Driver (no NPE)

From

Aslak Hellesoy

Date:

03 July 2002, 04:01:31

(This is cross-posted to the postgresql JDBC list). Postgres guys, please
see my last comment.

> -----Original Message-----
> From: middlegen-user-admin@lists.sourceforge.net
> [mailto:middlegen-user-admin@lists.sourceforge.net]On Behalf Of Marco
> Papini
> Sent: 1. juli 2002 09:47
> To: Gordon Luk
> Cc: Aslak Hellesoy; middlegen-user@lists.sourceforge.net
> Subject: Re: [Middlegen-user] Try other one of Postgresql JDBC Driver
> (no NPE)
>
>
> I've made some tests. The driver jxDBCon-jdbc3-0.9z.jar works fine with
> normal relation, but seems not ok with relation on multiple column

The jxDBCon-jdbc3-0.9z.jar driver is obviously buggy with respect to
relations with multiple columns. MetaData isn't the most heavily used part
of the JDBC API, so they are probably unaware of it.

See my other mail on the same subject:
http://sourceforge.net/mailarchive/message.php?msg_id=1756797

A bug report has been filed with the jxdbcon project:
http://sourceforge.net/tracker/index.php?func=detail&aid=576654&group_id=258
45&atid=385447

> (Middlegen displays no relation at all). With the developer driver from
> postgresql site doesn't display any relation. With the latest stable

Well, the pgjdbc2.jar driver (http://jdbc.postgresql.org/download.html)
seems to be buggy too. I couldn't find a bug tracker for it, so the bug
report for you guys is this mail and this link (again).

> version of the driver I get the no-column problem reading tables.
> That's after CVS update on friday.
>
> I've also tested with Oracle: no problem after CVS update, everything
> seems to be ok.
>
> Marco
>
> Gordon Luk wrote:
> > Hi  Middlegen User,
> >
> >    If you using postgresql , and found NPE problem, take a try
> other one
> > of postgrsql JDBC.
> > URL is http://jxdbcon.sourceforge.net/
> >
> >
> > Gordon
> >
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> middlegen-user mailing list
> middlegen-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/middlegen-user

Re: [Middlegen-user] Try other one of Postgresql JDBC Driver

From

Dave Cramer

Date:

08 July 2002, 12:03:27

Aslak,

Did you get this sorted out, I have done quite a bit of work on the
databasemetadata.

Dave
On Tue, 2002-07-02 at 19:19, Aslak Hellesoy wrote:
> (This is cross-posted to the postgresql JDBC list). Postgres guys, please
> see my last comment.
>
> > -----Original Message-----
> > From: middlegen-user-admin@lists.sourceforge.net
> > [mailto:middlegen-user-admin@lists.sourceforge.net]On Behalf Of Marco
> > Papini
> > Sent: 1. juli 2002 09:47
> > To: Gordon Luk
> > Cc: Aslak Hellesoy; middlegen-user@lists.sourceforge.net
> > Subject: Re: [Middlegen-user] Try other one of Postgresql JDBC Driver
> > (no NPE)
> >
> >
> > I've made some tests. The driver jxDBCon-jdbc3-0.9z.jar works fine with
> > normal relation, but seems not ok with relation on multiple column
>
> The jxDBCon-jdbc3-0.9z.jar driver is obviously buggy with respect to
> relations with multiple columns. MetaData isn't the most heavily used part
> of the JDBC API, so they are probably unaware of it.
>
> See my other mail on the same subject:
> http://sourceforge.net/mailarchive/message.php?msg_id=1756797
>
> A bug report has been filed with the jxdbcon project:
> http://sourceforge.net/tracker/index.php?func=detail&aid=576654&group_id=258
> 45&atid=385447
>
> > (Middlegen displays no relation at all). With the developer driver from
> > postgresql site doesn't display any relation. With the latest stable
>
> Well, the pgjdbc2.jar driver (http://jdbc.postgresql.org/download.html)
> seems to be buggy too. I couldn't find a bug tracker for it, so the bug
> report for you guys is this mail and this link (again).
>
> > version of the driver I get the no-column problem reading tables.
> > That's after CVS update on friday.
> >
> > I've also tested with Oracle: no problem after CVS update, everything
> > seems to be ok.
> >
> > Marco
> >
> > Gordon Luk wrote:
> > > Hi  Middlegen User,
> > >
> > >    If you using postgresql , and found NPE problem, take a try
> > other one
> > > of postgrsql JDBC.
> > > URL is http://jxdbcon.sourceforge.net/
> > >
> > >
> > > Gordon
> > >
> >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > middlegen-user mailing list
> > middlegen-user@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/middlegen-user
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>

Re: [Middlegen-user] Try other one of Postgresql JDBC Driver

From

Aslak Hellesøy

Date:

08 July 2002, 15:36:17

Hi Dave,

I reported this issue on behalf of some of the Middlegen users, and I
haven't tried PostgreSQL/pgjdbc2.jar myself yet. I have downloaded them, and
I'll go through some manuals and hopefully give you feedback in a day or
two.

Thanks,
Aslak

> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Dave Cramer
> Sent: 8. juli 2002 15:01
> To: Aslak Hellesoy
> Cc: Marco Papini; Gordon Luk; middlegen-user@lists.sourceforge.net;
> pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] [Middlegen-user] Try other one of Postgresql JDBC
> Driver
>
>
> Aslak,
>
> Did you get this sorted out, I have done quite a bit of work on the
> databasemetadata.
>
> Dave
> On Tue, 2002-07-02 at 19:19, Aslak Hellesoy wrote:
> > (This is cross-posted to the postgresql JDBC list). Postgres
> guys, please
> > see my last comment.
> >
> > > -----Original Message-----
> > > From: middlegen-user-admin@lists.sourceforge.net
> > > [mailto:middlegen-user-admin@lists.sourceforge.net]On Behalf Of Marco
> > > Papini
> > > Sent: 1. juli 2002 09:47
> > > To: Gordon Luk
> > > Cc: Aslak Hellesoy; middlegen-user@lists.sourceforge.net
> > > Subject: Re: [Middlegen-user] Try other one of Postgresql JDBC Driver
> > > (no NPE)
> > >
> > >
> > > I've made some tests. The driver jxDBCon-jdbc3-0.9z.jar works
> fine with
> > > normal relation, but seems not ok with relation on multiple column
> >
> > The jxDBCon-jdbc3-0.9z.jar driver is obviously buggy with respect to
> > relations with multiple columns. MetaData isn't the most
> heavily used part
> > of the JDBC API, so they are probably unaware of it.
> >
> > See my other mail on the same subject:
> > http://sourceforge.net/mailarchive/message.php?msg_id=1756797
> >
> > A bug report has been filed with the jxdbcon project:
> >
> http://sourceforge.net/tracker/index.php?func=detail&aid=576654&gr
> oup_id=258
> > 45&atid=385447
> >
> > > (Middlegen displays no relation at all). With the developer
> driver from
> > > postgresql site doesn't display any relation. With the latest stable
> >
> > Well, the pgjdbc2.jar driver (http://jdbc.postgresql.org/download.html)
> > seems to be buggy too. I couldn't find a bug tracker for it, so the bug
> > report for you guys is this mail and this link (again).
> >
> > > version of the driver I get the no-column problem reading tables.
> > > That's after CVS update on friday.
> > >
> > > I've also tested with Oracle: no problem after CVS update, everything
> > > seems to be ok.
> > >
> > > Marco
> > >
> > > Gordon Luk wrote:
> > > > Hi  Middlegen User,
> > > >
> > > >    If you using postgresql , and found NPE problem, take a try
> > > other one
> > > > of postgrsql JDBC.
> > > > URL is http://jxdbcon.sourceforge.net/
> > > >
> > > >
> > > > Gordon
> > > >
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This sf.net email is sponsored by:ThinkGeek
> > > Welcome to geek heaven.
> > > http://thinkgeek.com/sf
> > > _______________________________________________
> > > middlegen-user mailing list
> > > middlegen-user@lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/middlegen-user
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
> >
> >
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>