Re: MetaData Bug

I forgot a couple of things:

a) Put the devpgjdbc2.jar in middlegen/samples/lib (The driver isn't in my
CVS).
b) Edit middlegen/samples/config/database/postgresql.xml so that this driver
is used in stead of the jxDBCon driver (which has another, but related bug):
http://sourceforge.net/tracker/index.php?func=detail&aid=576654&group_id=258
45&atid=385447

Now which one of you will be the first to fix this ? ;-)

Cheers,
Aslak

> -----Original Message-----
> From: Aslak Hellesøy [mailto:aslak(dot)hellesoy(at)netcom(dot)no]
> Sent: 9. juli 2002 04:01
> To: pgsql-jdbc(at)postgresql(dot)org
> Cc: Dave Cramer [Dave(at)micro-automation(dot)net]
> Subject: MetaData Bug
>
>
> Hi!
>
> I finally got PostgreSQL running on my box to verify this
> metadata bug myself. (It was mentioned yesterday).
>
> My environment:
>
> Win2k
> Cygwin Setup.exe Version 2.249.2.5
> PostgreSQL 7.2.1 on i686-pc-cygwin, compiled by GCC 2.95.3-5
> PostgreSQL JDBC 7.3dev (built 2002-06-23) (devpgjdbc2.jar from
> http://jdbc.postgresql.org/download.html)
> j2sdk1.4.0_01
>
> The bug appears for relationships involving more than one column.
> See the definition of the VV and WW tables:
> http://cvs.middlegen.sourceforge.net/cgi-bin/viewcvs.cgi/middlegen
> /middlegen/src/sql/relations.sql?rev=1.1&content-type=text/vnd.vie
> wcvs-markup
>
> A call to DatabaseMetaData.getCrossReference(...) using these two
> tables returns a resultset with one row. When I ask for the
> PKCOLUMN_NAME column of that resultset I get "a,b". This is
> obviously wrong. The correct behaviour would be to return a
> resultset with two rows, returning "a" the first time and "b" the
> second time.
>
> This can be observed by following these 11 steps:
>
> --- GET AND BUILD MIDDLEGEN ---
> 0) Download Jakarta Ant 1.5.
> 1) Download Middlegen CVS version:
http://sourceforge.net/cvs/?group_id=36044
2) cd middlegen
3) ant

--- RUN THE MIDDLEGEN SAMPLE WITH POSTGRESQL ---
4) Edit line 17 in middlegen/samples/build.xml and replace hsqldb with
postgresql (don't worry about weblogic even if you don't have it).
5) Uncomment line 11 in middlegen/samples/build.properties.
6) Edit user/password info in
middlegen/samples/config/database/postgresql.xml at lines 25 and 26.
7) Edit line 31 in middlegen/samples/log4j.properties and set the debug
level to debug in stead of warn.
8) createdb airline (create a test database).
9) ant create-database (inserts test tables VV and WW and others in the
airline test database).
10) ant

This will fire up Middlegen which will connect to the database and read the
metadata - and throw an exception because of the bug described above.

I hope this is enough info for you to fix this little bug.

Cheers,
Aslak