Thread: AGAIN: still no answer ... peter, or anybody knowledgeable, please ....

dear all,

unfortunately the jdbc1 driver can't be compiled.
there are several errors popping up when compiling --with-java and also
when i try to compile the jdbc interface individually:

i already figured out two mistypings in the Statement.java file in
src/interfaces/jdbc/org/postgresql/jdbc1/Statement.java

1. in the first line peter wrote 'nackage' instead of 'package'
2. on line 291 peter wrote
if (result != null && ((org.postgresql.ResultSet)result.reallyResultSet())
instead of
if (result != null && ((org.postgresql.ResultSet)result).reallyResultSet())

but after correcting these misspellings i still got error messages that
i couldn't correct any more with my limited knowledge of java:

/prog/ant/bin/ant -buildfile ../../../build.xml -Dmajor=7 -Dminor=1
-Dfullversion=7.1 -Ddef_pgport=5432
Buildfile: ../../../build.xml

jar:

call:

prepare:

check_versions:

driver:
      [echo] Configured build for the JDBC1 edition driver.

compile:
      [copy] Copying 4 files to
/disk/raid2/SRC/postgresql-7.1/src/interfaces/jdbc/build

examples:
     [javac] Compiling 1 source file to
/disk/raid2/SRC/postgresql-7.1/src/interfaces/jdbc/build
     [javac]
/disk/raid2/SRC/postgresql-7.1/src/interfaces/jdbc/example/blobtest.java:189:
Class example.Blob not found in type declaration.
     [javac]             Blob b = rs.getBlob("a");
     [javac]             ^
     [javac]
/disk/raid2/SRC/postgresql-7.1/src/interfaces/jdbc/example/blobtest.java:189:
Method getBlob(java.lang.String) not found in interface java.sql.ResultSet.
     [javac]             Blob b = rs.getBlob("a");
     [javac]                                ^
     [javac] 2 errors

BUILD FAILED

/disk/raid2/SRC/postgresql-7.1/src/interfaces/jdbc/build.xml:120:
Compile failed, messages should have been provided.

Total time: 2 seconds
gmake[3]: *** [all] Error 1
gmake[3]: Leaving directory
`/disk/raid2/SRC/postgresql-7.1/src/interfaces/jdbc'
gmake[2]: *** [all] Error 2
gmake[2]: Leaving directory `/disk/raid2/SRC/postgresql-7.1/src/interfaces'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `/disk/raid2/SRC/postgresql-7.1/src'
gmake: *** [all] Error 2

can anybody help me along, or could peter put the jar package of the
jdbc1 on his web-site, please.

if someone would send me the jar-package by mail, i would be happy also
[:-)]

thanks for your help,

mark rosa

ps: btw. i tried this both on redhat-linux7.1 (java version "1.1.8") and
irix6.5.9m (java version "3.2 (Sun 1.1.8)")

--
-------------------------------------------------------------
Mark Rosa - Dipl. Arch. ETH
Etekt Inc.                                co-create your home
phone: ++41-1-4462-406              www: http://www.etekt.com
mobile: ++41-76-390 06 37           fax: ++49-89-244 35 64 08
email: rosa@etekt.com       www: http://www.yourcell.net/rosa
-------------------------------------------------------------

The information transmitted is intended only for the person
or entity to which it is addressed and may contain confi-
dential and/or privileged material. Any review, retrans-
mission, dissemination or other use of, or taking of any
action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited.
If you received this in error, please contact the sender and
delete the material from any computer.


On 08 May 2001 09:52:47 +0200, Mark Rosa wrote:

> ps: btw. i tried this both on redhat-linux7.1 (java version "1.1.8") and
> irix6.5.9m (java version "3.2 (Sun 1.1.8)")

Can youn upgrade to JDK1.3.0_2?

I can send you a .jar file but it will be for that JDK

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html


Re: AGAIN: still no answer ... peter, or anybody knowledgeable, please ....

From
Bruce Momjian
Date:
> dear all,
>
> unfortunately the jdbc1 driver can't be compiled.
> there are several errors popping up when compiling --with-java and also
> when i try to compile the jdbc interface individually:
>
> i already figured out two mistypings in the Statement.java file in
> src/interfaces/jdbc/org/postgresql/jdbc1/Statement.java
>
> 1. in the first line peter wrote 'nackage' instead of 'package'

I don't see that error in the current sources.

> 2. on line 291 peter wrote
> if (result != null && ((org.postgresql.ResultSet)result.reallyResultSet())
> instead of
> if (result != null && ((org.postgresql.ResultSet)result).reallyResultSet())

The current CVS sources look wrong to me.  It has:

  if (result != null) && ((org.postgresql.ResultSet)result.reallyResultSet())

Shouldn't this be:

  if (result != null && ((org.postgresql.ResultSet)result.reallyResultSet()))

Not sure if the extra parens are needed for:

  if (result != null && ((org.postgresql.ResultSet)result).reallyResultSet())

Comments?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  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

Re: AGAIN: still no answer ... peter, or anybody knowledgeable,please ....

From
Palle Girgensohn
Date:
The enclosed patches are from the postgresql7 port for FreeBSD.
They fix makefile problems (and a syntax bug fix for
Statement.java) for java 1.1.x.

/Palle

Bruce Momjian wrote:
>
> > dear all,
> >
> > unfortunately the jdbc1 driver can't be compiled.
> > there are several errors popping up when compiling --with-java and also
> > when i try to compile the jdbc interface individually:
> >
> > i already figured out two mistypings in the Statement.java file in
> > src/interfaces/jdbc/org/postgresql/jdbc1/Statement.java
> >
> > 1. in the first line peter wrote 'nackage' instead of 'package'
>
> I don't see that error in the current sources.
>
> > 2. on line 291 peter wrote
> > if (result != null && ((org.postgresql.ResultSet)result.reallyResultSet())
> > instead of
> > if (result != null && ((org.postgresql.ResultSet)result).reallyResultSet())
>
> The current CVS sources look wrong to me.  It has:
>
>   if (result != null) && ((org.postgresql.ResultSet)result.reallyResultSet())
>
> Shouldn't this be:
>
>   if (result != null && ((org.postgresql.ResultSet)result.reallyResultSet()))
>
> Not sure if the extra parens are needed for:
>
>   if (result != null && ((org.postgresql.ResultSet)result).reallyResultSet())
>
> Comments?
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

--
         Partitur Informationsteknik AB
Wenner-Gren Center             +46 8 566 280 02
113 46 Stockholm           +46 70 785 86 02
Sweden                   girgen@partitur.se

Attachment

Re: AGAIN: still no answer ... peter, or anybody knowledgeable,please ....

From
Bruce Momjian
Date:
OK, I have added this to the unapplied patches page at:

    http://candle.pha.pa.us/cgi-bin/pgpatches

As you can see, I am loaded with Java patches to add to 7.2.  I will get
them into CVS as soon as I can.  I will need Java developers and Peter
to comment on which ones are valuable.


> The enclosed patches are from the postgresql7 port for FreeBSD.
> They fix makefile problems (and a syntax bug fix for
> Statement.java) for java 1.1.x.
>
> /Palle
>
> Bruce Momjian wrote:
> >
> > > dear all,
> > >
> > > unfortunately the jdbc1 driver can't be compiled.
> > > there are several errors popping up when compiling --with-java and also
> > > when i try to compile the jdbc interface individually:
> > >
> > > i already figured out two mistypings in the Statement.java file in
> > > src/interfaces/jdbc/org/postgresql/jdbc1/Statement.java
> > >
> > > 1. in the first line peter wrote 'nackage' instead of 'package'
> >
> > I don't see that error in the current sources.
> >
> > > 2. on line 291 peter wrote
> > > if (result != null && ((org.postgresql.ResultSet)result.reallyResultSet())
> > > instead of
> > > if (result != null && ((org.postgresql.ResultSet)result).reallyResultSet())
> >
> > The current CVS sources look wrong to me.  It has:
> >
> >   if (result != null) && ((org.postgresql.ResultSet)result.reallyResultSet())
> >
> > Shouldn't this be:
> >
> >   if (result != null && ((org.postgresql.ResultSet)result.reallyResultSet()))
> >
> > Not sure if the extra parens are needed for:
> >
> >   if (result != null && ((org.postgresql.ResultSet)result).reallyResultSet())
> >
> > Comments?
> >
> > --
> >   Bruce Momjian                        |  http://candle.pha.pa.us
> >   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
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
>
> --
>          Partitur Informationsteknik AB
> Wenner-Gren Center             +46 8 566 280 02
> 113 46 Stockholm           +46 70 785 86 02
> Sweden                   girgen@partitur.se

[ Attachment, skipping... ]

[ Attachment, skipping... ]

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  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

Re: AGAIN: still no answer ... peter, or anybody knowledgeable, please ....

From
Michael Stephenson
Date:
> The current CVS sources look wrong to me.  It has:
>
>   if (result != null) && ((org.postgresql.ResultSet)result.reallyResultSet())
>
> Shouldn't this be:
>
>   if (result != null && ((org.postgresql.ResultSet)result.reallyResultSet()))
>
> Not sure if the extra parens are needed for:
>
>   if (result != null && ((org.postgresql.ResultSet)result).reallyResultSet())
>
> Comments?

The extra parenthesis are required (since java.sql.ResultSet doesn't
have a method 'reallyResultSet()' which returns an object which can be
succesfully cast as a 'org.postgresql.ResultSet), but I think it would be
cleaner just to declare 'result' as 'org.postgresql.ResultSet' on line 27,
that way none of the messy casts (of which there are 11) would be
required..

Michael xxx


> > Comments?
>
> The extra parenthesis are required (since java.sql.ResultSet doesn't
> have a method 'reallyResultSet()' which returns an object which can be
> succesfully cast as a 'org.postgresql.ResultSet), but I think it would be
> cleaner just to declare 'result' as 'org.postgresql.ResultSet' on line 27,
> that way none of the messy casts (of which there are 11) would be
> required..

I can apply a patch, but it is beyond my ability to code that.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  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

Bruce,

You should be able to remove this item from your patches list.  You
applied a patch that fixed the root problem today.  That patch to
org/postgresql/jdbc1/Statement.java added a missing parenthesis.  That
fixes the bug.  The further sugestion in the below mail note (to declare
the object as a org.postgresql.ResultSet instead of the 11 casts) is a
different way to fix the same problem.  But since the bug is fixed I
don't see a reason to keep this item on the patches list.

thanks,
--Barry

Bruce Momjian wrote:

>>> Comments?
>>
>> The extra parenthesis are required (since java.sql.ResultSet doesn't
>> have a method 'reallyResultSet()' which returns an object which can be
>> succesfully cast as a 'org.postgresql.ResultSet), but I think it would be
>> cleaner just to declare 'result' as 'org.postgresql.ResultSet' on line 27,
>> that way none of the messy casts (of which there are 11) would be
>> required..
>
>
> I can apply a patch, but it is beyond my ability to code that.
>


Re: AGAIN: still no answer ... peter, or anybody knowledgeable, please ....

From
Bruce Momjian
Date:
Yes, got it.

> Bruce,
>
> You should be able to remove this item from your patches list.  You
> applied a patch that fixed the root problem today.  That patch to
> org/postgresql/jdbc1/Statement.java added a missing parenthesis.  That
> fixes the bug.  The further sugestion in the below mail note (to declare
> the object as a org.postgresql.ResultSet instead of the 11 casts) is a
> different way to fix the same problem.  But since the bug is fixed I
> don't see a reason to keep this item on the patches list.
>
> thanks,
> --Barry
>
> Bruce Momjian wrote:
>
> >>> Comments?
> >>
> >> The extra parenthesis are required (since java.sql.ResultSet doesn't
> >> have a method 'reallyResultSet()' which returns an object which can be
> >> succesfully cast as a 'org.postgresql.ResultSet), but I think it would be
> >> cleaner just to declare 'result' as 'org.postgresql.ResultSet' on line 27,
> >> that way none of the messy casts (of which there are 11) would be
> >> required..
> >
> >
> > I can apply a patch, but it is beyond my ability to code that.
> >
>
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  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

Re: AGAIN: still no answer ... peter, or anybody knowledgeable, please ....

From
Bruce Momjian
Date:
> 2. on line 291 peter wrote
> if (result != null && ((org.postgresql.ResultSet)result.reallyResultSet())
> instead of
> if (result != null && ((org.postgresql.ResultSet)result).reallyResultSet())

This fix will appear in 7.1.2 when it is released.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  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

Re: AGAIN: still no answer ... peter, or anybody knowledgeable,please ....

From
Bruce Momjian
Date:
Actually, all these patches have been applied, except for the XML
/contrib/retep patch, which I just applied.  Thanks.


> The enclosed patches are from the postgresql7 port for FreeBSD.
> They fix makefile problems (and a syntax bug fix for
> Statement.java) for java 1.1.x.
>
> /Palle
>
> Bruce Momjian wrote:
> >
> > > dear all,
> > >
> > > unfortunately the jdbc1 driver can't be compiled.
> > > there are several errors popping up when compiling --with-java and also
> > > when i try to compile the jdbc interface individually:
> > >
> > > i already figured out two mistypings in the Statement.java file in
> > > src/interfaces/jdbc/org/postgresql/jdbc1/Statement.java
> > >
> > > 1. in the first line peter wrote 'nackage' instead of 'package'
> >
> > I don't see that error in the current sources.
> >
> > > 2. on line 291 peter wrote
> > > if (result != null && ((org.postgresql.ResultSet)result.reallyResultSet())
> > > instead of
> > > if (result != null && ((org.postgresql.ResultSet)result).reallyResultSet())
> >
> > The current CVS sources look wrong to me.  It has:
> >
> >   if (result != null) && ((org.postgresql.ResultSet)result.reallyResultSet())
> >
> > Shouldn't this be:
> >
> >   if (result != null && ((org.postgresql.ResultSet)result.reallyResultSet()))
> >
> > Not sure if the extra parens are needed for:
> >
> >   if (result != null && ((org.postgresql.ResultSet)result).reallyResultSet())
> >
> > Comments?
> >
> > --
> >   Bruce Momjian                        |  http://candle.pha.pa.us
> >   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
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
>
> --
>          Partitur Informationsteknik AB
> Wenner-Gren Center             +46 8 566 280 02
> 113 46 Stockholm           +46 70 785 86 02
> Sweden                   girgen@partitur.se

[ Attachment, skipping... ]

[ Attachment, skipping... ]

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  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