Thread: Re: pg703: support for Large objects via JDBC PreparedStatement.setBi naryStream()

I do not understand when people say that pg7.03 is out and some are talking
about 7.1. What is the difference anyway? As far as I know 7.03 is the
latest. What about 7.1? I am new to postgreSQL. Can someone please clarify
me? And added to that, if 7.03 is out, does the jdbc support calling stored
procedures? cause when I used Calllable Statments in 7.02, there was an
exception that it was not supported. Please clarify me.

Regards,

Selvam





                    Peter T Mount
                    <peter@retep.org.uk>         To:     Julian Richardson
                    Sent by:                     <JRichardson@softwright.co.uk>
                    pgsql-jdbc-owner@post        cc:     "'pgsql-jdbc@postgresql.org'"
                    gresql.org                   <pgsql-jdbc@postgresql.org>
                                                 Subject:     Re: [JDBC] pg703: support for Large
                                                 objects via JDBC PreparedStatement.setBi
                    20/03/2001 11:10 PM          naryStream()






Quoting Julian Richardson <JRichardson@softwright.co.uk>:

> I didn't study the code in detail but it looked like there's stuff
> missing
> in the Large Objects API too, so it may not even be possible to use that
> as
> an alternative (I'd rather not anyway, but may have been able to make
> the
> setBinaryStream method call into it behind the scenes to do the work)
>
> Is there a workaround for this (or preferably a fix for the drivers!!) -
> or
> does it work in pg6.5 as downgrading may be an option?

No, proper stream support was only introduced in 7.1 :-)

> ps. posted a variation on this to the pgsql-bugs list the other day but
> don't know if it got through - hopefully this one will.

I've been ofline for a couple of weeks so I've got a few K of emails to
catch
up with :-(

Peter

--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

Quoting selvam@gelife.com.my:

>
> I do not understand when people say that pg7.03 is out and some are
> talking
> about 7.1. What is the difference anyway? As far as I know 7.03 is the
> latest. What about 7.1? I am new to postgreSQL. Can someone please
> clarify me?

The latest released version is 7.0.3. However, 7.1 is on it's way (Release
Candidate 1 aka RC1 should have been released last night).

> And added to that, if 7.03 is out, does the jdbc support calling
> stored procedures? cause when I used Calllable Statments in 7.02, there was an
> exception that it was not supported. Please clarify me.

CallableStatement is still not supported. A group of students are working on
it. However the behaviour of throwing an exception is correct.

A workaround is to use PreparedStatement (as in postgres prodecures are
implemented as functions) and use select.

Peter


>
> Regards,
>
> Selvam
>
>
>
>
>
>
>                     Peter T Mount
>
>                     <peter@retep.org.uk>         To:     Julian
> Richardson
>                     Sent by:
> <JRichardson@softwright.co.uk>
>                     pgsql-jdbc-owner@post        cc:
> "'pgsql-jdbc@postgresql.org'"
>                     gresql.org
> <pgsql-jdbc@postgresql.org>
>                                                  Subject:     Re: [JDBC]
> pg703: support for Large
>                                                  objects via JDBC
> PreparedStatement.setBi
>                     20/03/2001 11:10 PM          naryStream()
>
>
>
>
>
>
>
>
>
> Quoting Julian Richardson <JRichardson@softwright.co.uk>:
>
> > I didn't study the code in detail but it looked like there's stuff
> > missing
> > in the Large Objects API too, so it may not even be possible to use
> that
> > as
> > an alternative (I'd rather not anyway, but may have been able to make
> > the
> > setBinaryStream method call into it behind the scenes to do the work)
> >
> > Is there a workaround for this (or preferably a fix for the drivers!!)
> -
> > or
> > does it work in pg6.5 as downgrading may be an option?
>
> No, proper stream support was only introduced in 7.1 :-)
>
> > ps. posted a variation on this to the pgsql-bugs list the other day
> but
> > don't know if it got through - hopefully this one will.
>
> I've been ofline for a couple of weeks so I've got a few K of emails to
> catch
> up with :-(
>
> Peter
>
> --
> Peter Mount peter@retep.org.uk
> PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
> RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>
>
>
>



--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/