Re: [HACKERS] Request for 7.0 JDBC status

Thomas Lockhart wrote:

Can you email me that java files that are produced by
the compile. I need the *.jar file, and the *.class files.

Do you still need them? I can send what I built, but I'm pretty sure
that Peter Mount has a fresh package built and available on some web
site of his...

If so, I need them (Java 1 and 2) for the RPM's. I don't do Java -- and
the RPM's have historically packaged the .jar files as pulled verbatim
from retep.org.uk. I haven't distributed RC2 RPM's yet for partially
that reason
-- the other part is the lack of an RC2-tested alpha patch.

NOTE:
I have gotten good response and patches to the RPM's from a number of
people this go around -- and it is ENCOURAGING!

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

I am unable to compile the java code with kaffe. Can anyone compile
jdbc under 7.0?

Yup. Seems some form of jdk-1.2 works for me. But my default
/usr/bin/javac (on an old RH5.2 system), something called "pizza",
does not.

Can you email me that java files that are produced by
the compile. I need the *.jar file, and the *.class files.

Do you still need them? I can send what I built, but I'm pretty sure
that Peter Mount has a fresh package built and available on some web
site of his...

I did get it working using Peter's 6.5.2 jar file. I was not setting
the CLASSPATH to be the full file path. I was setting it just to the
directory, which was my fault. Peter's FAQ for jdbc helped me get it
working.

Peter E. sent me a jar file, but it used postgresql as the domain unstead
of org.postgresql, so it seems that is the 6.5.2 version too. Peter's web
site does not have the 7.0 jar file there yet.

However, it seems kaffe can't compile self-referencing java files. I
don't know enough about java to know that is a problem or not.

I did get it working well enough to get my java book example working.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

If so, I need them (Java 1 and 2) for the RPM's. I don't do Java -- and
the RPM's have historically packaged the .jar files as pulled verbatim
from retep.org.uk. I haven't distributed RC2 RPM's yet for partially
that reason

"I don't do Java" can change fairly easily; just pick up the java
tarball from blackdown.org or sun.com, untar it into /usr/local, then
set your path via

set path=(/usr/local/jdk-xxx $path)

Go into src/interfaces/jdbc and type

make jdbc2

then grab the jar file(s).

otoh, how close are you Peter (hope you see this; I've blown away
enough email to have lost your address) to posting a built jar file or
whatever is usually provided? Should we post this somewhere on
postgresql.org to help out? Should I post my recently built stuff?

NOTE:
I have gotten good response and patches to the RPM's from a number of
people this go around -- and it is ENCOURAGING!

Great!

- Thomas

--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California

Today, in a message to Thomas Lockhart, Bruce Momjian wrote:

I am unable to compile the java code with kaffe. Can anyone compile
jdbc under 7.0?

However, it seems kaffe can't compile self-referencing java files. I
don't know enough about java to know that is a problem or not.

Have not tried with 7.0, but recent versions of Kaffe were definitely able
to compile the JDBC code that came with 6.5.3, but only after modifying
the version check in the makeVersion.java file in src/interfaces/jdbc (and
perhaps elsewhere where a versioon check occurs). The code checks for the
java version string and rejects everything that doesn't start with either
1.1 or 1.2. The problem was that Kaffe reports its own version, e.g. 1.02,
rather than the corresponding JDK version.

Joachim

--
private: joachim@kraut.bc.ca (http://www.kraut.bc.ca)
work: joachim@mercury.bc.ca (http://www.mercury.bc.ca)

otoh, how close are you Peter (hope you see this; I've blown away
enough email to have lost your address) to posting a built jar file or
whatever is usually provided? Should we post this somewhere on
postgresql.org to help out? Should I post my recently built stuff?

Ah, found Peter's e-mail address in an obvious place (the jdbc source
tree).

Another question for Peter: would it be possible to update the README
file in the source tree, and other ancillary files? I know you've been
very busy, but even a brief fixup to adjust dates and version numbers
would be helpful for 7.0.

- Thomas

--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California

Sorry for the late reply, but lately I've had little time to sort things
out.

I know that under JDK1.2, it compiles fine. For some reason my JDK-1.1.7
has trashed itself, and I've been trying to get that working again.

I think Kaffe is based around 1.1.x, but I'm not sure. I was thinking of
installing it as well to see how it goes.

I've also got some misplaced patches to find.

Hopefully things will be quiet tonight for me to get things sorted :-(

Peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.

-----Original Message-----
From: Thomas Lockhart [mailto:lockhart@alumni.caltech.edu]
Sent: Tuesday, May 02, 2000 3:00 AM
To: Bruce Momjian
Cc: PostgreSQL-development; PostgreSQL-interfaces
Subject: Re: [HACKERS] Request for 7.0 JDBC status

I am unable to compile the java code with kaffe. Can anyone compile
jdbc under 7.0?

Yup. Seems some form of jdk-1.2 works for me. But my default
/usr/bin/javac (on an old RH5.2 system), something called "pizza",
does not.

Can you email me that java files that are produced by
the compile. I need the *.jar file, and the *.class files.

Do you still need them? I can send what I built, but I'm pretty sure
that Peter Mount has a fresh package built and available on some web
site of his...

- Thomas

--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California

As 1.2 seems to be working, I'll put a 1.2 jar file on the site asap. I
may try to sneek a compile during the day (depending when a big delivery
arrives).

Peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.

-----Original Message-----
From: Lamar Owen [mailto:lamar.owen@wgcr.org]
Sent: Tuesday, May 02, 2000 3:30 AM
To: Thomas Lockhart
Cc: Bruce Momjian; PostgreSQL-development; PostgreSQL-interfaces
Subject: Re: [HACKERS] Request for 7.0 JDBC status

Thomas Lockhart wrote:

Can you email me that java files that are produced by
the compile. I need the *.jar file, and the *.class files.

Do you still need them? I can send what I built, but I'm pretty sure
that Peter Mount has a fresh package built and available on some web
site of his...

If so, I need them (Java 1 and 2) for the RPM's. I don't do Java -- and
the RPM's have historically packaged the .jar files as pulled verbatim
from retep.org.uk. I haven't distributed RC2 RPM's yet for partially
that reason
-- the other part is the lack of an RC2-tested alpha patch.

NOTE:
I have gotten good response and patches to the RPM's from a number of
people this go around -- and it is ENCOURAGING!

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

The jar file isn't built automatically in 7.0. You'll have to use:

make jdbc2 jar

The reason for this is partly on how make works, and partly because of
the kludge we have for handling the different API versions (like
JDBC1.1, JDBC2 etc)

Peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.

-----Original Message-----
From: Thomas Lockhart [mailto:lockhart@alumni.caltech.edu]
Sent: Tuesday, May 02, 2000 4:27 AM
To: Lamar Owen
Cc: Bruce Momjian; PostgreSQL-development; PostgreSQL-interfaces
Subject: Re: [HACKERS] Request for 7.0 JDBC status

If so, I need them (Java 1 and 2) for the RPM's. I don't do Java --

and

the RPM's have historically packaged the .jar files as pulled verbatim
from retep.org.uk. I haven't distributed RC2 RPM's yet for partially
that reason

"I don't do Java" can change fairly easily; just pick up the java
tarball from blackdown.org or sun.com, untar it into /usr/local, then
set your path via

set path=(/usr/local/jdk-xxx $path)

Go into src/interfaces/jdbc and type

make jdbc2

then grab the jar file(s).

otoh, how close are you Peter (hope you see this; I've blown away
enough email to have lost your address) to posting a built jar file or
whatever is usually provided? Should we post this somewhere on
postgresql.org to help out? Should I post my recently built stuff?

NOTE:
I have gotten good response and patches to the RPM's from a number of
people this go around -- and it is ENCOURAGING!

Great!

- Thomas

--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California

Yes, the README does need updating. CHANGELOG should be up to date. If
not, I'll have to re-commit it.

I'm hoping to have the next three evenings free...

Peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.

-----Original Message-----
From: Thomas Lockhart [mailto:lockhart@alumni.caltech.edu]
Sent: Tuesday, May 02, 2000 6:16 AM
To: Lamar Owen; Bruce Momjian; PostgreSQL-development;
PostgreSQL-interfaces; peter@retep.org.uk
Subject: Re: [HACKERS] Request for 7.0 JDBC status

otoh, how close are you Peter (hope you see this; I've blown away
enough email to have lost your address) to posting a built jar file or
whatever is usually provided? Should we post this somewhere on
postgresql.org to help out? Should I post my recently built stuff?

Ah, found Peter's e-mail address in an obvious place (the jdbc source
tree).

Another question for Peter: would it be possible to update the README
file in the source tree, and other ancillary files? I know you've been
very busy, but even a brief fixup to adjust dates and version numbers
would be helpful for 7.0.

- Thomas

--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California

Today, in a message to Thomas Lockhart, Bruce Momjian wrote:

I am unable to compile the java code with kaffe. Can anyone compile
jdbc under 7.0?

However, it seems kaffe can't compile self-referencing java files. I
don't know enough about java to know that is a problem or not.

Have not tried with 7.0, but recent versions of Kaffe were definitely able
to compile the JDBC code that came with 6.5.3, but only after modifying
the version check in the makeVersion.java file in src/interfaces/jdbc (and
perhaps elsewhere where a versioon check occurs). The code checks for the
java version string and rejects everything that doesn't start with either
1.1 or 1.2. The problem was that Kaffe reports its own version, e.g. 1.02,
rather than the corresponding JDK version.

Interesting. It does compile under kaffe 1.05, but the mutually
dependent java files cause a compile error. Seems 6.5.3 had the same
problem, so I am not sure why it would have worked then.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

The jar file isn't built automatically in 7.0. You'll have to use:

make jdbc2 jar

The reason for this is partly on how make works, and partly because of
the kludge we have for handling the different API versions (like
JDBC1.1, JDBC2 etc)

Oops, my book says it will generate a postgresql.jar file. If it isn't
going to that, I will have to change my book.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Yes, the README does need updating. CHANGELOG should be up to date. If
not, I'll have to re-commit it.

I'm hoping to have the next three evenings free...

Not to bug you Peter, but 7.0 may not wait three days before release.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

The jar file isn't built automatically in 7.0. You'll have to use:
make jdbc2 jar

?? From fresh sources afaik:

[postgres@golem jdbc]$ make jdbc2 jar
(echo "package org.postgresql;" ;\
echo "public class DriverClass {" ;\
echo "public static String
connectClass=\"org.postgresql.jdbc2.Connection\";" ;\
echo "}" \
) >org/postgresql/DriverClass.java
make[1]: Entering directory `/opt/postgres/pgsql/src/interfaces/jdbc'
javac -g org/postgresql/DriverClass.java
...
javac -g org/postgresql/jdbc2/CallableStatement.java
Note: org/postgresql/jdbc2/CallableStatement.java uses or overrides a
deprecated API. Recompile with "-deprecation" for details.
1 warning
jar -c0f postgresql.jar `find org/postgresql -name "*.class" -print` \
org/postgresql/errors.properties
org/postgresql/errors_fr.properties
org/postgresql/errors_nl.properties
------------------------------------------------------------
The JDBC driver has now been built. To make it available to
...
To build the CORBA example (requires Java2):
make corba
------------------------------------------------------------

make[1]: Leaving directory `/opt/postgres/pgsql/src/interfaces/jdbc'
make: *** No rule to make target `jar'. Stop.

Seems a jar file does get built with "make jdbc2", but I'm not sure it
is the right one (being *much* more advanced than Lamar in the Java
world, I *make* Java, but don't actually *use* Java :)) ;)

As an aside, I thought Peter might find it interesting that we do have
a fairly large Java app at my work (JPL) to manage and build
configurations for a fancy hard real-time system for astronomical
optical interferometers. The app happens to use Postgres as a backend
for most deliveries ;) Keck Observatory will need it working with
Sybase since they long ago standardized on that...

- Thomas

--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California

Not to bug you Peter, but 7.0 may not wait three days before release.

I would vote that this is important enough that it should wait, but no
one has raised the issue until now so we haven't discussed it. The
docs may or may not be completed within the next day (still jet-lagged
from vacation, but waking up at 3am does leave some extra time in the
morning, eh?), and if they stretch an extra day which is certainly
possible then we are only talking about an extra day for this. No big
deal in the grand scheme of things...

Peter, is there some testing that could/should be done with the new
driver (by others) in the meantime, or is it pretty likely to be
reasonably hashed out?

- Thomas

--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California

I could get make jdbc2 to build the jar file, as it involves simply
changing the rules.

ie, currently we have the following:

jdbc2: ...rule...
action...

I would have to change it to something like:

jdbc2: realjdbc2 jar

realjdbc2: ...rule...
action...

Peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.

-----Original Message-----
From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
Sent: Tuesday, May 02, 2000 12:01 PM
To: Peter Mount
Cc: 'Thomas Lockhart'; Lamar Owen; PostgreSQL-development;
PostgreSQL-interfaces
Subject: Re: [HACKERS] Request for 7.0 JDBC status

The jar file isn't built automatically in 7.0. You'll have to use:

make jdbc2 jar

The reason for this is partly on how make works, and partly because of
the kludge we have for handling the different API versions (like
JDBC1.1, JDBC2 etc)

Oops, my book says it will generate a postgresql.jar file. If it isn't
going to that, I will have to change my book.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania
19026

Hmmm, I'll double check. The last time I built the jar file (about a
week ago) I used the jar rule.

My memory's not that good at the moment, so perhaps I had fixed it since
:-)

Peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.

-----Original Message-----
From: Thomas Lockhart [mailto:lockhart@alumni.caltech.edu]
Sent: Tuesday, May 02, 2000 12:08 PM
To: Peter Mount
Cc: Lamar Owen; Bruce Momjian; PostgreSQL-development;
PostgreSQL-interfaces
Subject: Re: [HACKERS] Request for 7.0 JDBC status

The jar file isn't built automatically in 7.0. You'll have to use:
make jdbc2 jar

?? From fresh sources afaik:

[postgres@golem jdbc]$ make jdbc2 jar
(echo "package org.postgresql;" ;\
echo "public class DriverClass {" ;\
echo "public static String
connectClass=\"org.postgresql.jdbc2.Connection\";" ;\
echo "}" \
) >org/postgresql/DriverClass.java
make[1]: Entering directory `/opt/postgres/pgsql/src/interfaces/jdbc'
javac -g org/postgresql/DriverClass.java
...
javac -g org/postgresql/jdbc2/CallableStatement.java
Note: org/postgresql/jdbc2/CallableStatement.java uses or overrides a
deprecated API. Recompile with "-deprecation" for details.
1 warning
jar -c0f postgresql.jar `find org/postgresql -name "*.class" -print` \
org/postgresql/errors.properties
org/postgresql/errors_fr.properties
org/postgresql/errors_nl.properties
------------------------------------------------------------
The JDBC driver has now been built. To make it available to
...
To build the CORBA example (requires Java2):
make corba
------------------------------------------------------------

make[1]: Leaving directory `/opt/postgres/pgsql/src/interfaces/jdbc'
make: *** No rule to make target `jar'. Stop.

Seems a jar file does get built with "make jdbc2", but I'm not sure it
is the right one (being *much* more advanced than Lamar in the Java
world, I *make* Java, but don't actually *use* Java :)) ;)

As an aside, I thought Peter might find it interesting that we do have
a fairly large Java app at my work (JPL) to manage and build
configurations for a fancy hard real-time system for astronomical
optical interferometers. The app happens to use Postgres as a backend
for most deliveries ;) Keck Observatory will need it working with
Sybase since they long ago standardized on that...

- Thomas

--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California

Not to bug you Peter, but 7.0 may not wait three days before release.

I would vote that this is important enough that it should wait, but no
one has raised the issue until now so we haven't discussed it. The
docs may or may not be completed within the next day (still jet-lagged
from vacation, but waking up at 3am does leave some extra time in the
morning, eh?), and if they stretch an extra day which is certainly
possible then we are only talking about an extra day for this. No big
deal in the grand scheme of things...

Peter, is there some testing that could/should be done with the new
driver (by others) in the meantime, or is it pretty likely to be
reasonably hashed out?

Just to add to my earlier report, here is the kaffe 1.05 compile
failure. What strikes me as odd is that Connection.java complains
because it can't find org/postgresql/Field, but if I try to compile
Field.java complains it can't find Connection.java.

Now, having the 6.5.3 JAR file, I can compile the 6.5.3 postgresql java
driver because I have the jar file to back up the unreferenced symbols.
The 7.0 driver uses org.postgresql, which is not in the 6.5.3 JAR file,
so it fails.

The java IRC channel says kaffe isn't very good, so maybe I shouldn't be
worried about it. They also said mutually-referencing java files are
not a good either.

Seems I may be able to modify the import lines in the java file to use
the 6.5.3 JAR file to get enough files compiled to compile the rest,
then recompile the entire thing.

Using the jar file compiled with Sun java works fine. I can connect to
the database and run my program.

---------------------------------------------------------------------------

#$ gmake jdbc2
(echo "package org.postgresql;" ;\
echo "public class DriverClass {" ;\
echo "public static String connectClass=\"org.postgresql.jdbc2.Connection\";" ;\
echo "}" \
) >org/postgresql/DriverClass.java
gmake[1]: Entering directory `/var/local/src/pgsql/CURRENT/pgsql/src/interfaces/jdbc'
javac -g org/postgresql/DriverClass.java
javac -g org/postgresql/Connection.java
org/postgresql/Connection.java:1: Can''t find class "org/postgresql/Field" ���8
org/postgresql/Connection.java:529: Can''t find class "Fastpath" ���8
gmake[1]: *** [org/postgresql/Connection.class] Error 1
gmake[1]: Leaving directory `/var/local/src/pgsql/CURRENT/pgsql/src/interfaces/jdbc'
gmake: *** [jdbc2] Error 2

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

I could get make jdbc2 to build the jar file, as it involves simply
changing the rules.

ie, currently we have the following:

jdbc2: ...rule...
action...

I would have to change it to something like:

jdbc2: realjdbc2 jar

realjdbc2: ...rule...
action...

Seems a JAR file is better than copying the class files. The README has
to be updated though. Also, your web page should be more prominent.
People may prefer downloading the JAR file themselves rather than do the
compile if they have kaffe.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

As usual when replying from here, replies prefixed with PM:

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.

[snip]

Just to add to my earlier report, here is the kaffe 1.05 compile
failure. What strikes me as odd is that Connection.java complains
because it can't find org/postgresql/Field, but if I try to compile
Field.java complains it can't find Connection.java.

Now, having the 6.5.3 JAR file, I can compile the 6.5.3 postgresql java
driver because I have the jar file to back up the unreferenced
symbols.=20
The 7.0 driver uses org.postgresql, which is not in the 6.5.3 JAR file,
so it fails.

PM: That's odd. Perhaps kaffe lacks this ability.

The java IRC channel says kaffe isn't very good, so maybe I shouldn't be
worried about it. They also said mutually-referencing java files are
not a good either.

PM: This is strange, because mutually referenced java files are quite
common. In fact, some of the javax.swing classes do this, and I've been
doing it since 1.0.2 :-) Anyhow, kaffe was taken over by M$ a few months
ago...

Seems I may be able to modify the import lines in the java file to use
the 6.5.3 JAR file to get enough files compiled to compile the rest,
then recompile the entire thing.

Using the jar file compiled with Sun java works fine. I can connect to
the database and run my program.

PM: I stayed away from Kaffe because when I first started with Java, I
had so much trouble compiling examples with it, I switched to the Sun
JVM.

[snip]