Thread: Continuing problems with using OIDs via JDBC

Continuing problems with using OIDs via JDBC

From
"M. A. Sridhar"
Date:
Hello folks,

I would greatly appreciate some help with using large objects in PostgreSQL
via JDBC. I need to create a JDBC-compliant database application tha
supports multiple database vendors, so using any PostgreSQL-specific
extensions is difficult. I am trying to replace my current Oracle-on-Linux
setup with PostgreSQL, and not having much luck.

My setup is Red Hat Linux 7.1 (or 7.2) running the IBM JDK 1.3. I have
installed the PostgreSQL version distributed via the stock Red Hat RPMs for
that OS version.

Also, I am a relative newbie to PostgreSQL, although I have worked with
other databases (Oracle and Pointbase in particular). So please forgive any
errors/omissions on my part.

I need to store and retrieve large binary objects. To this end, I have
followed the directions in the JDBC documentation distributed with the
PostgreSQL package. Specifically I use the oid data type wherever a large
object is needed, and the ResultSet's setBinaryStream/getBinaryStream
methods to store and retrieve data.

When I try this setup using the JDBC 7.1-1.2 drivers, the problem that
arises is the driver's inability to handle null values:

FastPath call returned ERROR:  inv_open: large object 0 not found

I would expect that, if the value is null, the driver would return null
instead of throwing an exception.

I found reports of this bug on Google and the PostgreSQL mailing list, and
the recommendation was to use the newer drivers. Well, that doesn't work
either: both the 7.1-1.2 and 7.1-1.3 drivers (which I downloaded from
jdbc.fastcrypt.com) fail with an error like

java.sql.SQLException: ERROR:  oidin: error in "..."

when I try to insert a record containing a blob.

And yes, I do use setAutoCommit to ensure that retrievals/updates happen
within a transaction, as described in the JDBC documentation.

So I am now unable to use PostgreSQL. Any help is greatly appreciated. I
will be glad to give more details (e.g., source code snippets) to clarify
if needed.

Thanks in advance.



=====
Sridhar
---
M. A. Sridhar
m_a_sridhar@yahoo.com

__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com

Re: Continuing problems with using OIDs via JDBC

From
"Oliver Friedrich"
Date:
What version of PostgreSQL you are using? A Pre-7.1.x version?

A few days ago i have some problems like yours with large object support. I
have updated my postgres to 7.1.3 and now it works great with PostgreSQL
JDBC driver 7.2b3

Oliver



-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of M. A. Sridhar
Sent: Saturday, January 26, 2002 11:05 PM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] Continuing problems with using OIDs via JDBC


Hello folks,

I would greatly appreciate some help with using large objects in PostgreSQL
via JDBC. I need to create a JDBC-compliant database application tha
supports multiple database vendors, so using any PostgreSQL-specific
extensions is difficult. I am trying to replace my current Oracle-on-Linux
setup with PostgreSQL, and not having much luck.

My setup is Red Hat Linux 7.1 (or 7.2) running the IBM JDK 1.3. I have
installed the PostgreSQL version distributed via the stock Red Hat RPMs for
that OS version.

Also, I am a relative newbie to PostgreSQL, although I have worked with
other databases (Oracle and Pointbase in particular). So please forgive any
errors/omissions on my part.

I need to store and retrieve large binary objects. To this end, I have
followed the directions in the JDBC documentation distributed with the
PostgreSQL package. Specifically I use the oid data type wherever a large
object is needed, and the ResultSet's setBinaryStream/getBinaryStream
methods to store and retrieve data.

When I try this setup using the JDBC 7.1-1.2 drivers, the problem that
arises is the driver's inability to handle null values:

FastPath call returned ERROR:  inv_open: large object 0 not found

I would expect that, if the value is null, the driver would return null
instead of throwing an exception.

I found reports of this bug on Google and the PostgreSQL mailing list, and
the recommendation was to use the newer drivers. Well, that doesn't work
either: both the 7.1-1.2 and 7.1-1.3 drivers (which I downloaded from
jdbc.fastcrypt.com) fail with an error like

java.sql.SQLException: ERROR:  oidin: error in "..."

when I try to insert a record containing a blob.

And yes, I do use setAutoCommit to ensure that retrievals/updates happen
within a transaction, as described in the JDBC documentation.

So I am now unable to use PostgreSQL. Any help is greatly appreciated. I
will be glad to give more details (e.g., source code snippets) to clarify
if needed.

Thanks in advance.



=====
Sridhar
---
M. A. Sridhar
m_a_sridhar@yahoo.com

__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


Re: Continuing problems with using OIDs via JDBC

From
"M. A. Sridhar"
Date:
Nick,

Thanks for the quick response. No joy, though -- I get the same oidin error
with this driver.

Sridhar

--- Nick Fankhauser <nickf@ontko.com> wrote:
> Sridhar-
>
> There is a newer driver than the two you listed. Try:
>
> http://jdbc.postgresql.org/download/jdbc7.2dev-1.2.jar
>
> Although listed as development, this is pretty stable and will work with
> postgresql 7.1.
>
> I haven't tried using it for large objects, so I can't say for sure it
> will
> help, but it's worth trying while you wait for other responses from the
> list.
>
> -Nick
>
>
--------------------------------------------------------------------------
> Nick Fankhauser  nickf@ontko.com  Phone 1.765.935.4283  Fax
> 1.765.962.9788
> Ray Ontko & Co.     Software Consulting Services
> http://www.ontko.com/
>
> > -----Original Message-----
> > From: pgsql-jdbc-owner@postgresql.org
> > [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of M. A. Sridhar
> > Sent: Saturday, January 26, 2002 5:05 PM
> > To: pgsql-jdbc@postgresql.org
> > Subject: [JDBC] Continuing problems with using OIDs via JDBC
> >
> >
> > Hello folks,
> >
> > I would greatly appreciate some help with using large objects in
> > PostgreSQL
> > via JDBC. I need to create a JDBC-compliant database application tha
> > supports multiple database vendors, so using any PostgreSQL-specific
> > extensions is difficult. I am trying to replace my current
> Oracle-on-Linux
> > setup with PostgreSQL, and not having much luck.
> >
> > My setup is Red Hat Linux 7.1 (or 7.2) running the IBM JDK 1.3. I have
> > installed the PostgreSQL version distributed via the stock Red
> > Hat RPMs for
> > that OS version.
> >
> > Also, I am a relative newbie to PostgreSQL, although I have worked with
> > other databases (Oracle and Pointbase in particular). So please
> > forgive any
> > errors/omissions on my part.
> >
> > I need to store and retrieve large binary objects. To this end, I have
> > followed the directions in the JDBC documentation distributed with the
> > PostgreSQL package. Specifically I use the oid data type wherever a
> large
> > object is needed, and the ResultSet's setBinaryStream/getBinaryStream
> > methods to store and retrieve data.
> >
> > When I try this setup using the JDBC 7.1-1.2 drivers, the problem that
> > arises is the driver's inability to handle null values:
> >
> > FastPath call returned ERROR:  inv_open: large object 0 not found
> >
> > I would expect that, if the value is null, the driver would return null
> > instead of throwing an exception.
> >
> > I found reports of this bug on Google and the PostgreSQL mailing list,
> and
> > the recommendation was to use the newer drivers. Well, that doesn't
> work
> > either: both the 7.1-1.2 and 7.1-1.3 drivers (which I downloaded from
> > jdbc.fastcrypt.com) fail with an error like
> >
> > java.sql.SQLException: ERROR:  oidin: error in "..."
> >
> > when I try to insert a record containing a blob.
> >
> > And yes, I do use setAutoCommit to ensure that retrievals/updates
> happen
> > within a transaction, as described in the JDBC documentation.
> >
> > So I am now unable to use PostgreSQL. Any help is greatly appreciated.
> I
> > will be glad to give more details (e.g., source code snippets) to
> clarify
> > if needed.
> >
> > Thanks in advance.
> >
> >
> >
> > =====
> > Sridhar
> > ---
> > M. A. Sridhar
> > m_a_sridhar@yahoo.com
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Great stuff seeking new owners in Yahoo! Auctions!
> > http://auctions.yahoo.com
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
> >
>


__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com

Re: Continuing problems with using OIDs via JDBC

From
"Nick Fankhauser"
Date:
Sridhar-

There is a newer driver than the two you listed. Try:

http://jdbc.postgresql.org/download/jdbc7.2dev-1.2.jar

Although listed as development, this is pretty stable and will work with
postgresql 7.1.

I haven't tried using it for large objects, so I can't say for sure it will
help, but it's worth trying while you wait for other responses from the
list.

-Nick

--------------------------------------------------------------------------
Nick Fankhauser  nickf@ontko.com  Phone 1.765.935.4283  Fax 1.765.962.9788
Ray Ontko & Co.     Software Consulting Services     http://www.ontko.com/

> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of M. A. Sridhar
> Sent: Saturday, January 26, 2002 5:05 PM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] Continuing problems with using OIDs via JDBC
>
>
> Hello folks,
>
> I would greatly appreciate some help with using large objects in
> PostgreSQL
> via JDBC. I need to create a JDBC-compliant database application tha
> supports multiple database vendors, so using any PostgreSQL-specific
> extensions is difficult. I am trying to replace my current Oracle-on-Linux
> setup with PostgreSQL, and not having much luck.
>
> My setup is Red Hat Linux 7.1 (or 7.2) running the IBM JDK 1.3. I have
> installed the PostgreSQL version distributed via the stock Red
> Hat RPMs for
> that OS version.
>
> Also, I am a relative newbie to PostgreSQL, although I have worked with
> other databases (Oracle and Pointbase in particular). So please
> forgive any
> errors/omissions on my part.
>
> I need to store and retrieve large binary objects. To this end, I have
> followed the directions in the JDBC documentation distributed with the
> PostgreSQL package. Specifically I use the oid data type wherever a large
> object is needed, and the ResultSet's setBinaryStream/getBinaryStream
> methods to store and retrieve data.
>
> When I try this setup using the JDBC 7.1-1.2 drivers, the problem that
> arises is the driver's inability to handle null values:
>
> FastPath call returned ERROR:  inv_open: large object 0 not found
>
> I would expect that, if the value is null, the driver would return null
> instead of throwing an exception.
>
> I found reports of this bug on Google and the PostgreSQL mailing list, and
> the recommendation was to use the newer drivers. Well, that doesn't work
> either: both the 7.1-1.2 and 7.1-1.3 drivers (which I downloaded from
> jdbc.fastcrypt.com) fail with an error like
>
> java.sql.SQLException: ERROR:  oidin: error in "..."
>
> when I try to insert a record containing a blob.
>
> And yes, I do use setAutoCommit to ensure that retrievals/updates happen
> within a transaction, as described in the JDBC documentation.
>
> So I am now unable to use PostgreSQL. Any help is greatly appreciated. I
> will be glad to give more details (e.g., source code snippets) to clarify
> if needed.
>
> Thanks in advance.
>
>
>
> =====
> Sridhar
> ---
> M. A. Sridhar
> m_a_sridhar@yahoo.com
>
> __________________________________________________
> Do You Yahoo!?
> Great stuff seeking new owners in Yahoo! Auctions!
> http://auctions.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>


Re: Continuing problems with using OIDs via JDBC

From
Barry Lind
Date:
Sridhar,

If you use the 7.2 jdbc driver (which is compatible with a 7.1 database)
you should look at the latest documentation for jdbc from 7.2.  The blob
support in the jdbc driver has changed significantly in the 7.2 version
of the driver and the doc should explain the differences.  You can
access the 7.2 documentation at
http://candle.pha.pa.us/main/writings/pgsql/sgml/jdbc.html

If you still are having problems please post a test case that exhibits
the problem to the maillist.

thanks,
--Barry


M. A. Sridhar wrote:

> Nick,
>
> Thanks for the quick response. No joy, though -- I get the same oidin error
> with this driver.
>
> Sridhar
>
> --- Nick Fankhauser <nickf@ontko.com> wrote:
>
>>Sridhar-
>>
>>There is a newer driver than the two you listed. Try:
>>
>>http://jdbc.postgresql.org/download/jdbc7.2dev-1.2.jar
>>
>>Although listed as development, this is pretty stable and will work with
>>postgresql 7.1.
>>
>>I haven't tried using it for large objects, so I can't say for sure it
>>will
>>help, but it's worth trying while you wait for other responses from the
>>list.
>>
>>-Nick
>>
>>
>>
> --------------------------------------------------------------------------
>
>>Nick Fankhauser  nickf@ontko.com  Phone 1.765.935.4283  Fax
>>1.765.962.9788
>>Ray Ontko & Co.     Software Consulting Services
>>http://www.ontko.com/
>>
>>
>>>-----Original Message-----
>>>From: pgsql-jdbc-owner@postgresql.org
>>>[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of M. A. Sridhar
>>>Sent: Saturday, January 26, 2002 5:05 PM
>>>To: pgsql-jdbc@postgresql.org
>>>Subject: [JDBC] Continuing problems with using OIDs via JDBC
>>>
>>>
>>>Hello folks,
>>>
>>>I would greatly appreciate some help with using large objects in
>>>PostgreSQL
>>>via JDBC. I need to create a JDBC-compliant database application tha
>>>supports multiple database vendors, so using any PostgreSQL-specific
>>>extensions is difficult. I am trying to replace my current
>>>
>>Oracle-on-Linux
>>
>>>setup with PostgreSQL, and not having much luck.
>>>
>>>My setup is Red Hat Linux 7.1 (or 7.2) running the IBM JDK 1.3. I have
>>>installed the PostgreSQL version distributed via the stock Red
>>>Hat RPMs for
>>>that OS version.
>>>
>>>Also, I am a relative newbie to PostgreSQL, although I have worked with
>>>other databases (Oracle and Pointbase in particular). So please
>>>forgive any
>>>errors/omissions on my part.
>>>
>>>I need to store and retrieve large binary objects. To this end, I have
>>>followed the directions in the JDBC documentation distributed with the
>>>PostgreSQL package. Specifically I use the oid data type wherever a
>>>
>>large
>>
>>>object is needed, and the ResultSet's setBinaryStream/getBinaryStream
>>>methods to store and retrieve data.
>>>
>>>When I try this setup using the JDBC 7.1-1.2 drivers, the problem that
>>>arises is the driver's inability to handle null values:
>>>
>>>FastPath call returned ERROR:  inv_open: large object 0 not found
>>>
>>>I would expect that, if the value is null, the driver would return null
>>>instead of throwing an exception.
>>>
>>>I found reports of this bug on Google and the PostgreSQL mailing list,
>>>
>>and
>>
>>>the recommendation was to use the newer drivers. Well, that doesn't
>>>
>>work
>>
>>>either: both the 7.1-1.2 and 7.1-1.3 drivers (which I downloaded from
>>>jdbc.fastcrypt.com) fail with an error like
>>>
>>>java.sql.SQLException: ERROR:  oidin: error in "..."
>>>
>>>when I try to insert a record containing a blob.
>>>
>>>And yes, I do use setAutoCommit to ensure that retrievals/updates
>>>
>>happen
>>
>>>within a transaction, as described in the JDBC documentation.
>>>
>>>So I am now unable to use PostgreSQL. Any help is greatly appreciated.
>>>
>>I
>>
>>>will be glad to give more details (e.g., source code snippets) to
>>>
>>clarify
>>
>>>if needed.
>>>
>>>Thanks in advance.
>>>
>>>
>>>
>>>=====
>>>Sridhar
>>>---
>>>M. A. Sridhar
>>>m_a_sridhar@yahoo.com
>>>
>>>__________________________________________________
>>>Do You Yahoo!?
>>>Great stuff seeking new owners in Yahoo! Auctions!
>>>http://auctions.yahoo.com
>>>
>>>---------------------------(end of
>>>
>>broadcast)---------------------------
>>
>>>TIP 2: you can get off all lists at once with the unregister command
>>>    (send "unregister YourEmailAddressHere" to
>>>
>>majordomo@postgresql.org)
>>
>
>
> __________________________________________________
> Do You Yahoo!?
> Great stuff seeking new owners in Yahoo! Auctions!
> http://auctions.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>



Re: Continuing problems with using OIDs via JDBC

From
"M. A. Sridhar"
Date:
Both the postmaster and psql programs report themselves as version 7.1.3:


bash-2.04$ psql -V
psql (PostgreSQL) 7.1.3
contains readline, history, multibyte support
Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
Portions Copyright (c) 1996 Regents of the University of California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.
bash-2.04$ which postmaster
/usr/bin/postmaster
bash-2.04$ postmaster -V
postmaster (PostgreSQL) 7.1.3
bash-2.04$
bash-2.04$


Sridhar

--- Oliver Friedrich <oliver@familie-friedrich.de> wrote:
> What version of PostgreSQL you are using? A Pre-7.1.x version?
>
> A few days ago i have some problems like yours with large object support.
> I
> have updated my postgres to 7.1.3 and now it works great with PostgreSQL
> JDBC driver 7.2b3
>
> Oliver
>
>
>
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of M. A. Sridhar
> Sent: Saturday, January 26, 2002 11:05 PM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] Continuing problems with using OIDs via JDBC
>
>
> Hello folks,
>
> I would greatly appreciate some help with using large objects in
> PostgreSQL
> via JDBC. I need to create a JDBC-compliant database application tha
> supports multiple database vendors, so using any PostgreSQL-specific
> extensions is difficult. I am trying to replace my current
> Oracle-on-Linux
> setup with PostgreSQL, and not having much luck.
>
> My setup is Red Hat Linux 7.1 (or 7.2) running the IBM JDK 1.3. I have
> installed the PostgreSQL version distributed via the stock Red Hat RPMs
> for
> that OS version.
>
> Also, I am a relative newbie to PostgreSQL, although I have worked with
> other databases (Oracle and Pointbase in particular). So please forgive
> any
> errors/omissions on my part.
>
> I need to store and retrieve large binary objects. To this end, I have
> followed the directions in the JDBC documentation distributed with the
> PostgreSQL package. Specifically I use the oid data type wherever a large
> object is needed, and the ResultSet's setBinaryStream/getBinaryStream
> methods to store and retrieve data.
>
> When I try this setup using the JDBC 7.1-1.2 drivers, the problem that
> arises is the driver's inability to handle null values:
>
> FastPath call returned ERROR:  inv_open: large object 0 not found
>
> I would expect that, if the value is null, the driver would return null
> instead of throwing an exception.
>
> I found reports of this bug on Google and the PostgreSQL mailing list,
> and
> the recommendation was to use the newer drivers. Well, that doesn't work
> either: both the 7.1-1.2 and 7.1-1.3 drivers (which I downloaded from
> jdbc.fastcrypt.com) fail with an error like
>
> java.sql.SQLException: ERROR:  oidin: error in "..."
>
> when I try to insert a record containing a blob.
>
> And yes, I do use setAutoCommit to ensure that retrievals/updates happen
> within a transaction, as described in the JDBC documentation.
>
> So I am now unable to use PostgreSQL. Any help is greatly appreciated. I
> will be glad to give more details (e.g., source code snippets) to clarify
> if needed.
>
> Thanks in advance.
>
>
>
> =====
> Sridhar
> ---
> M. A. Sridhar
> m_a_sridhar@yahoo.com
>
> __________________________________________________
> Do You Yahoo!?
> Great stuff seeking new owners in Yahoo! Auctions!
> http://auctions.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
> ---------------------------(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


__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com

Re: Continuing problems with using OIDs via JDBC (solved)

From
"M. A. Sridhar"
Date:
Thanks, Barry! That did the  trick. So the magic potion was to use bytea as
the blob representation, in  conjunction with the new 7.2 JDBC drivers.

Thanks again to you and everyone else who responded.

Sridhar

--- Barry Lind <barry@xythos.com> wrote:
> Sridhar,
>
> If you use the 7.2 jdbc driver (which is compatible with a 7.1 database)
> you should look at the latest documentation for jdbc from 7.2.  The blob
> support in the jdbc driver has changed significantly in the 7.2 version
> of the driver and the doc should explain the differences.  You can
> access the 7.2 documentation at
> http://candle.pha.pa.us/main/writings/pgsql/sgml/jdbc.html
>
> If you still are having problems please post a test case that exhibits
> the problem to the maillist.
>
> thanks,
> --Barry
>
>
> M. A. Sridhar wrote:
>
> > Nick,
> >
> > Thanks for the quick response. No joy, though -- I get the same oidin
> error
> > with this driver.
> >
> > Sridhar
> >
> > --- Nick Fankhauser <nickf@ontko.com> wrote:
> >
> >>Sridhar-
> >>
> >>There is a newer driver than the two you listed. Try:
> >>
> >>http://jdbc.postgresql.org/download/jdbc7.2dev-1.2.jar
> >>
> >>Although listed as development, this is pretty stable and will work
> with
> >>postgresql 7.1.
> >>
> >>I haven't tried using it for large objects, so I can't say for sure it
> >>will
> >>help, but it's worth trying while you wait for other responses from the
> >>list.
> >>
> >>-Nick
> >>
> >>
> >>
> >
>
--------------------------------------------------------------------------
> >
> >>Nick Fankhauser  nickf@ontko.com  Phone 1.765.935.4283  Fax
> >>1.765.962.9788
> >>Ray Ontko & Co.     Software Consulting Services
> >>http://www.ontko.com/
> >>
> >>
> >>>-----Original Message-----
> >>>From: pgsql-jdbc-owner@postgresql.org
> >>>[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of M. A. Sridhar
> >>>Sent: Saturday, January 26, 2002 5:05 PM
> >>>To: pgsql-jdbc@postgresql.org
> >>>Subject: [JDBC] Continuing problems with using OIDs via JDBC
> >>>
> >>>
> >>>Hello folks,
> >>>
> >>>I would greatly appreciate some help with using large objects in
> >>>PostgreSQL
> >>>via JDBC. I need to create a JDBC-compliant database application tha
> >>>supports multiple database vendors, so using any PostgreSQL-specific
> >>>extensions is difficult. I am trying to replace my current
> >>>
> >>Oracle-on-Linux
> >>
> >>>setup with PostgreSQL, and not having much luck.
> >>>
> >>>My setup is Red Hat Linux 7.1 (or 7.2) running the IBM JDK 1.3. I have
> >>>installed the PostgreSQL version distributed via the stock Red
> >>>Hat RPMs for
> >>>that OS version.
> >>>
> >>>Also, I am a relative newbie to PostgreSQL, although I have worked
> with
> >>>other databases (Oracle and Pointbase in particular). So please
> >>>forgive any
> >>>errors/omissions on my part.
> >>>
> >>>I need to store and retrieve large binary objects. To this end, I have
> >>>followed the directions in the JDBC documentation distributed with the
> >>>PostgreSQL package. Specifically I use the oid data type wherever a
> >>>
> >>large
> >>
> >>>object is needed, and the ResultSet's setBinaryStream/getBinaryStream
> >>>methods to store and retrieve data.
> >>>
> >>>When I try this setup using the JDBC 7.1-1.2 drivers, the problem that
> >>>arises is the driver's inability to handle null values:
> >>>
> >>>FastPath call returned ERROR:  inv_open: large object 0 not found
> >>>
> >>>I would expect that, if the value is null, the driver would return
> null
> >>>instead of throwing an exception.
> >>>
> >>>I found reports of this bug on Google and the PostgreSQL mailing list,
> >>>
> >>and
> >>
> >>>the recommendation was to use the newer drivers. Well, that doesn't
> >>>
> >>work
> >>
> >>>either: both the 7.1-1.2 and 7.1-1.3 drivers (which I downloaded from
> >>>jdbc.fastcrypt.com) fail with an error like
> >>>
> >>>java.sql.SQLException: ERROR:  oidin: error in "..."
> >>>
> >>>when I try to insert a record containing a blob.
> >>>
> >>>And yes, I do use setAutoCommit to ensure that retrievals/updates
> >>>
> >>happen
> >>
> >>>within a transaction, as described in the JDBC documentation.
> >>>
> >>>So I am now unable to use PostgreSQL. Any help is greatly appreciated.
> >>>
> >>I
> >>
> >>>will be glad to give more details (e.g., source code snippets) to
> >>>
> >>clarify
> >>
> >>>if needed.
> >>>
> >>>Thanks in advance.
> >>>
> >>>
> >>>
> >>>=====
> >>>Sridhar
> >>>---
> >>>M. A. Sridhar
> >>>m_a_sridhar@yahoo.com
> >>>
> >>>__________________________________________________
> >>>Do You Yahoo!?
> >>>Great stuff seeking new owners in Yahoo! Auctions!
> >>>http://auctions.yahoo.com
> >>>
> >>>---------------------------(end of
> >>>
> >>broadcast)---------------------------
> >>
> >>>TIP 2: you can get off all lists at once with the unregister command
> >>>    (send "unregister YourEmailAddressHere" to
> >>>
> >>majordomo@postgresql.org)
> >>
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Great stuff seeking new owners in Yahoo! Auctions!
> > http://auctions.yahoo.com
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
> >
> >
>
>
>
> ---------------------------(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


__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com