From: David Huttleston Jr <dhjr@hddesign.com>
To: Gabriel Lopez <gabilm@dif.um.es>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: wrong documentation and others .....
Date: Mon, 16 Oct 2000 15:20:24 -0500
Message-ID: <200010162020.PAA16531@proxy.hddesign.com> (raw)
In-Reply-To: <39EB2FE8.43259D92@dif.um.es>
Peter Mount's JDBC driver translates the query results from the postgresql
process to Java via the JDBC standard. As I see it, the source of your problem
can be at several levels.
1) A bug in the program
2) A bug in the Solaris JVM
3) A problem with the JDBC driver
4) A problem with your postgresql config on the solaris
#1 seems unlikely since your program and mine work on linux but not on solaris
#2 seems unlikely since Solaris is the flagship for Sun's Java efforts
#3 is possible, but our programs _and_ JDBC work fine under linux
#4 is the only possibility we have not discussed.
The first way to test if the solaris configuration of postgresql is the problem
is to test a query using an interface which is _not_ JDBC. The simpliest, is
psql. Test the large-object support using lo_import and lo_export from within
psql. In the documentation, section IV (Interfaces)-- chapter 51 (Large Objects)
has a page called 'Built in registered functions'. This page shows an example of how
to 'manually' store and retrieve a large-object which can be typed into the psql
interface and tested.
If lo_import and lo_export work, but JDBC does _not_ work. We should get Peter
Mount's direct attention. I don't know if he's familiar with solaris, but might be
able to point you toward a solution based on your stack trace.
Buena Suerte,
Dave
On Mon, 16 Oct 2000 18:42:17 +0200, you wrote:
> David Huttleston Jr escribió:
>
> > Hey Gabi,
> > Have you manually tested this query in using the pqsl interface? Perhaps
> > it is the backend having problems and not JDBC.
> >
> > Dave
> >
>
> What do you want to say?
> I run your program. The problem in the postgresql?
>
>
>
> --
> Gabriel López Millán
> Facultad de Informática -Universidad de Murcia
> 30001 Murcia - España (Spain)
> Telf: +34-968-364644 E-mail: gabilm@dif.um.es
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: dhjr@hddesign.com, gabilm@dif.um.es
Subject: Re: wrong documentation and others .....
In-Reply-To: <200010162020.PAA16531@proxy.hddesign.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox