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
Import Notes
Reference msg id not found: 200004290435.AAA22410@candle.pha.pa.us
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
Import Notes
Reference msg id not found: 200004290435.AAA22410@candle.pha.pa.us
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 19026If 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
Import Notes
Reference msg id not found: 200004290435.AAA22410@candle.pha.pa.us
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
Import Notes
Reference msg id not found: 200004290435.AAA22410@candle.pha.pa.us
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
Import Notes
Resolved by subject fallback
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
Import Notes
Resolved by subject fallback
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
Import Notes
Resolved by subject fallback
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
Import Notes
Resolved by subject fallback
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 19026The 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 19026Yes, 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 19026The 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
19026Import Notes
Resolved by subject fallback
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
Import Notes
Resolved by subject fallback
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 19026I 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 19026As 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]
Import Notes
Resolved by subject fallback
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.
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.
PM: Yes, apart from special cases (mainly with applets) it's easier as
it's not just .class files that go into the .jar file.
PM: As for my site, I want to update the site but I've tried to put the
coding as a higher priority. If I can get this lot sorted, then I'll
switch to the site contents.
--
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
19026Import Notes
Resolved by subject fallback
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...
Oh, OK, so I will not worry about the self-referencing issue. BSD/OS
has a java beta out, but I am too busy on the book to upgrade. I will
not worry about it. Seems kaffe can run the jdbc classes just fine.
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.
Oh, that is fine. I just needed to know the code was OK. Kaffe people
can download the JAR file. The great part is that they work on any
platform.
--
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 19026Thinking about it, what's the date on the Makefile? I wasn't sure if the
Makefile committed last time (I accidentally overwote the one in
src/interfaces).
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
Import Notes
Resolved by subject fallback
Thinking about it, what's the date on the Makefile? I wasn't sure if the
Makefile committed last time (I accidentally overwote the one in
src/interfaces).
Jan put the old one back, and I got your out of CVS and moved it to
jdbc. It should be the one you committed.
--
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 19026The 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'vebeen
doing it since 1.0.2 :-) Anyhow, kaffe was taken over by M$ a few
months
ago...
Oh, OK, so I will not worry about the self-referencing issue. BSD/OS
has a java beta out, but I am too busy on the book to upgrade. I will
not worry about it. Seems kaffe can run the jdbc classes just fine.PM: I wonder if someone has told the kaffe team about it? If it runs the
classes, then it must be their javac that has the bug.
Their site is pretty sparse. I will send it in.
--
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 19026Import Notes
Reply to msg id not found: 1B3D5E532D18D311861A00600865478C70C54E@exchange1.nt.maidstone.gov.uk | Resolved by subject fallback
Thinking about it, what's the date on the Makefile? I wasn't sure if the
Makefile committed last time (I accidentally overwote the one in
src/interfaces).Jan put the old one back, and I got your out of CVS and moved it to
jdbc. It should be the one you committed.Just guessing: it is reverted to a slightly older version. As I
showed, it has no rule for making jar files, though it *does* make a
jar file automagically :(
I got the file that Jan overwrote to fix Peter's overwrite and installed
that in the jdbc directory.
--
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 19026Import Notes
Reply to msg id not found: 390ED14D.2BB81FD8@alumni.caltech.edu | Resolved by subject fallback
Thinking about it, what's the date on the Makefile? I wasn't sure if the
Makefile committed last time (I accidentally overwote the one in
src/interfaces).Jan put the old one back, and I got your out of CVS and moved it to
jdbc. It should be the one you committed.
Just guessing: it is reverted to a slightly older version. As I
showed, it has no rule for making jar files, though it *does* make a
jar file automagically :(
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
I got the file that Jan overwrote to fix Peter's overwrite and installed
that in the jdbc directory.
Yeah, I understood that. Peter will speak up soon, but he indicated
that he wasn't sure that his new Makefile ever made it into CVS in the
first place, if I read his mail correctly.
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
By the sounds of it, it did get in (because the earlier one wouldn't
have known about the org change).
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 2:15 PM
To: Bruce Momjian
Cc: Peter Mount; Lamar Owen; PostgreSQL-development;
PostgreSQL-interfaces
Subject: Re: [HACKERS] Request for 7.0 JDBC status
I got the file that Jan overwrote to fix Peter's overwrite and
installed
that in the jdbc directory.
Yeah, I understood that. Peter will speak up soon, but he indicated
that he wasn't sure that his new Makefile ever made it into CVS in the
first place, if I read his mail correctly.
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
Import Notes
Resolved by subject fallback
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
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.
My two cents: I wouldn't object to postponing release a day or so for
it, *but* if what we're getting is an un-beta-tested driver then my
level of enthusiasm drops considerably. I'd rather say "it'll get
fixed in 7.0.1, after a decent testing interval for the new driver".
Relevant question: how well does the JDBC code that's in CVS now
work with 7.0? If the answer is "hardly at all" then a new driver
is probably better even if it has lurking bugs. If the answer is
"pretty well" then again I'd be inclined to ship what we've got.
regards, tom lane
At 12:02 PM 5/2/00 -0400, Tom Lane wrote:
Relevant question: how well does the JDBC code that's in CVS now
work with 7.0? If the answer is "hardly at all" then a new driver
is probably better even if it has lurking bugs. If the answer is
"pretty well" then again I'd be inclined to ship what we've got.
One of our OpenACS (until recently ACS/pg) crew has gotten the
ArsDigita webmail software running with PG7.0 and JDBC, apparently
without problems.
I don't know which beta he's running, though...
- Don Baccus, Portland OR <dhogaza@pacifier.com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
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.My two cents: I wouldn't object to postponing release a day or so for
it, *but* if what we're getting is an un-beta-tested driver then my
level of enthusiasm drops considerably. I'd rather say "it'll get
fixed in 7.0.1, after a decent testing interval for the new driver".Relevant question: how well does the JDBC code that's in CVS now
work with 7.0? If the answer is "hardly at all" then a new driver
is probably better even if it has lurking bugs. If the answer is
"pretty well" then again I'd be inclined to ship what we've got.
As far as I know, no one has it yet, except Thomas. The driver must
have a domain of org.postgresql or it is the old version. Only since I
installed Peter's Makefile last week did it become install-able.
--
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 19026Bruce Momjian <pgman@candle.pha.pa.us> writes:
Relevant question: how well does the JDBC code that's in CVS now
work with 7.0? If the answer is "hardly at all" then a new driver
is probably better even if it has lurking bugs. If the answer is
"pretty well" then again I'd be inclined to ship what we've got.
As far as I know, no one has it yet, except Thomas. The driver must
have a domain of org.postgresql or it is the old version. Only since I
installed Peter's Makefile last week did it become install-able.
So the version currently in CVS has seen hardly any testing either?
Man, you really know how to make a guy feel comfortable :-(
Given that, we might as well let Peter have the extra day or two
to bring the CVS version to the best state he can.
regards, tom lane
Bruce Momjian <pgman@candle.pha.pa.us> writes:
Relevant question: how well does the JDBC code that's in CVS now
work with 7.0? If the answer is "hardly at all" then a new driver
is probably better even if it has lurking bugs. If the answer is
"pretty well" then again I'd be inclined to ship what we've got.As far as I know, no one has it yet, except Thomas. The driver must
have a domain of org.postgresql or it is the old version. Only since I
installed Peter's Makefile last week did it become install-able.So the version currently in CVS has seen hardly any testing either?
Man, you really know how to make a guy feel comfortable :-(
Up to then, it was using the code in postgresql. Now it is using
org/postgresql directory, and they are different. postgresql is the
6.5.* driver, and org/postgresql is the 7.0 driver.
Given that, we might as well let Peter have the extra day or two
to bring the CVS version to the best state he can.
Yea, it had that effect on me too.
--
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 19026Today, Bruce Momjian wrote in an email addressed to Joachim Achtzehnter:
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.
Well, it is conceivable that I was actually compiling it with jikes, and
only used Kaffe to run it. In fact, now that I think of it, this is most
likely what I did. Even then, with some version of the driver I had to
patch a runtime version check to make it behave as if Kaffe was a 1.1 JVM.
It is true that Kaffe has a number of problems. Nevertheless, given that
it is licensed under the GPL some people prefer it over the alternatives
even if it has some drawbacks.
Joachim
--
joachim@kraut.bc.ca (http://www.kraut.bc.ca)
joachim@mercury.bc.ca (http://www.mercury.bc.ca)
Today, Bruce Momjian wrote in an email addressed to Joachim Achtzehnter:
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.Well, it is conceivable that I was actually compiling it with jikes, and
only used Kaffe to run it. In fact, now that I think of it, this is most
likely what I did. Even then, with some version of the driver I had to
patch a runtime version check to make it behave as if Kaffe was a 1.1 JVM.It is true that Kaffe has a number of problems. Nevertheless, given that
it is licensed under the GPL some people prefer it over the alternatives
even if it has some drawbacks.
Starting the kaffe 1.05, they now use KOPI as their java compiler. I
have contacted them about the problem to see if they can help.
This is clearly a kaffe-related problem, and not a problem with our
jdbc, which is good news.
--
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 19026My two cents: I wouldn't object to postponing release a day or so for
it, *but* if what we're getting is an un-beta-tested driver then my
level of enthusiasm drops considerably. I'd rather say "it'll get
fixed in 7.0.1, after a decent testing interval for the new driver".
Both versions of JDBC are in the Postgres source code tree. The newer
version has more standard conventions for Java namespaces (right
term??) and improvements in conformance to later versions of the JDBC
spec.
Basically the stuff is there already, and we just have a few file
updates to get it finalized. I'd be suprised if it is not ready by the
weekend, so it shouldn't be much of an issue.
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
He's probably using the 6.5.3 driver.
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
-----Original Message-----
From: Don Baccus [mailto:dhogaza@pacifier.com]
Sent: Tuesday, May 02, 2000 5:23 PM
To: Tom Lane; Thomas Lockhart
Cc: Bruce Momjian; Peter Mount; Lamar Owen; PostgreSQL-development;
PostgreSQL-interfaces; Peter Mount (Home)
Subject: Re: [HACKERS] Request for 7.0 JDBC status
At 12:02 PM 5/2/00 -0400, Tom Lane wrote:
Relevant question: how well does the JDBC code that's in CVS now
work with 7.0? If the answer is "hardly at all" then a new driver
is probably better even if it has lurking bugs. If the answer is
"pretty well" then again I'd be inclined to ship what we've got.
One of our OpenACS (until recently ACS/pg) crew has gotten the
ArsDigita webmail software running with PG7.0 and JDBC, apparently
without problems.
I don't know which beta he's running, though...
- Don Baccus, Portland OR <dhogaza@pacifier.com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
Import Notes
Resolved by subject fallback
At 07:36 AM 5/3/00 +0100, Peter Mount wrote:
He's probably using the 6.5.3 driver.
Yes, I think so, I gathered that from the following posts.
The notion of a new driver slipping into the release, with little
testing, after beta makes me a bit nervous. Where are we on this?
I might be able to get the person who's porting the Oracle-based
webmail app to Postgres to give the new driver a whirl if it's
still in the latest snapshot. At least that would give one more
test point.
I have no idea what his schedule is, though, he may only be able
to work on open source stuff on weekends. I know that's when he
gets most of his work done on our project.
- Don Baccus, Portland OR <dhogaza@pacifier.com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
PM: I'm actually sneeking one day time here (shouldn't but will) so
things should be better by the end of today. I'm about to get a JDK
installed under NT, just to give an extra platform to test under.
I talked to the Kaffe folks and compiling mutually dependent java files
must be done by compiling them all at the same time:
java a.java b.java
Seems it is a kaffe limitation/bug.
--
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 19026Import Notes
Reply to msg id not found: 1B3D5E532D18D311861A00600865478C70C55C@exchange1.nt.maidstone.gov.uk | Resolved by subject fallback
PM: I'm actually sneeking one day time here (shouldn't but will) so
things should be better by the end of today. I'm about to get a JDK
installed under NT, just to give an extra platform to test under.
Sorry, I should have said:
javac a.java b.java
--
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 19026Import Notes
Reply to msg id not found: 1B3D5E532D18D311861A00600865478C70C55C@exchange1.nt.maidstone.gov.uk | Resolved by subject fallback
Hmmm, I could add a rule just for Kaffe that does include all of them.
I'd prefer keeping the existing rule for most cases (as it prevents
every file being compiled every time), but it should only be 3 lines...
Peter
-----Original Message-----
From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
Sent: Wednesday, May 03, 2000 2:13 PM
To: Peter Mount
Cc: 'Thomas Lockhart'; Tom Lane; Lamar Owen; PostgreSQL-development;
PostgreSQL-interfaces; Peter Mount (Home)
Subject: Re: [HACKERS] Request for 7.0 JDBC status
PM: I'm actually sneeking one day time here (shouldn't but will) so
things should be better by the end of today. I'm about to get a JDK
installed under NT, just to give an extra platform to test under.
I talked to the Kaffe folks and compiling mutually dependent java files
must be done by compiling them all at the same time:
java a.java b.java
Seems it is a kaffe limitation/bug.
--
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
19026Import Notes
Resolved by subject fallback
Ok, I've just committed some fixes.
The README should now say things about 7.0, the org.postgresql change,
and the proper build instructions.
make jdbc1 & make jdbc2 now force the postgresql.jar to be rebuilt.
I've fixed a couple of problems with the examples. Mainly, the
threadsafe test wouldn't run here. It seems that on this machine thread2
overtook thread1, and things got messy.
Bruce, do you want an extra rule added for kaffe? I could add it, but I
currently have no way of testing it.
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
-----Original Message-----
From: Peter Mount [mailto:petermount@it.maidstone.gov.uk]
Sent: Wednesday, May 03, 2000 2:39 PM
To: 'Bruce Momjian'; Peter Mount
Cc: 'Thomas Lockhart'; Tom Lane; Lamar Owen; PostgreSQL-development;
PostgreSQL-interfaces; Peter Mount (Home)
Subject: [INTERFACES] RE: [HACKERS] Request for 7.0 JDBC status
Hmmm, I could add a rule just for Kaffe that does include all of them.
I'd prefer keeping the existing rule for most cases (as it prevents
every file being compiled every time), but it should only be 3 lines...
Peter
-----Original Message-----
From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
Sent: Wednesday, May 03, 2000 2:13 PM
To: Peter Mount
Cc: 'Thomas Lockhart'; Tom Lane; Lamar Owen; PostgreSQL-development;
PostgreSQL-interfaces; Peter Mount (Home)
Subject: Re: [HACKERS] Request for 7.0 JDBC status
PM: I'm actually sneeking one day time here (shouldn't but will) so
things should be better by the end of today. I'm about to get a JDK
installed under NT, just to give an extra platform to test under.
I talked to the Kaffe folks and compiling mutually dependent java files
must be done by compiling them all at the same time:
java a.java b.java
Seems it is a kaffe limitation/bug.
--
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
19026Import Notes
Resolved by subject fallback
Hmmm, I could add a rule just for Kaffe that does include all of them.
I'd prefer keeping the existing rule for most cases (as it prevents
every file being compiled every time), but it should only be 3 lines...
It then fails with a missing java.sql.Blob, so it seems the java
sql libraries are not fully implemented. I would forget about it for
now. Thanks.
--
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 19026Ok, I've just committed some fixes.
The README should now say things about 7.0, the org.postgresql change,
and the proper build instructions.make jdbc1 & make jdbc2 now force the postgresql.jar to be rebuilt.
I've fixed a couple of problems with the examples. Mainly, the
threadsafe test wouldn't run here. It seems that on this machine thread2
overtook thread1, and things got messy.Bruce, do you want an extra rule added for kaffe? I could add it, but I
currently have no way of testing it.
Again, don't worry. There is a java sql library Blob method missing, so
it doesn't compile. I will let you know if that is ever fixed in kaffe.
The fact the java libraries run fine on other computers really makes
this a non-issue as long as the JAR file is available for download.
--
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