Re: Continuing problems with using OIDs via JDBC

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