From: Pierre Habraken <Pierre.Habraken@ujf-grenoble.fr>
To: Aaron Dunlop <dunlopa@adscomputers.com>
Cc: pgsql-questions@postgreSQL.org
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [QUESTIONS] Accessing Postgresfrom JBuilder using JDBC
Date: Fri, 20 Mar 1998 14:45:27 +0100
Message-ID: <351272F7.E4F4082A@ujf-grenoble.fr> (raw)
References: <35117123.C361DA04@adscomputers.com>
Aaron Dunlop wrote:
>
> I've gotten JDBC connections from JBuilder, but only queries - no
> updates.
>
> To get the connection to work from within the IDE (e.g. when the
> application is not actually running) you have to add the path to
> postgresql.jar to the IDEClassPath entry in JBuilder.ini
> (C:\JBuilder\bin\JBuilder.ini) on my system.
>
> My entry reads
> IDEClassPath=..\lib\jbuilder.zip;..\lib\jbcl.zip;..\lib\jgl.zip;..\java\lib\classes.zip;..\java\lib\postgresql.jar
I checked this: the entry for postgresql.jar is already present in
JBuilder.ini.
> Then you'll have to apply a patch to the Postgresql JDBC driver. I don't
> have the changes in patch form handy, but I think they came out over the
> patches mailing list recently, so you can probably get them from the
> archive.
> It's just changing the default response of two functions in
> ResultSetMetaData.java
> to "return 0" instead of throwing an exception.
Do you know where I can get this patch ?
The site ftp://ftp.postgresql.org has been unreachable since yesterday
evening, at least from where I reside (France). I tried to browse mirror
sites but I did not find there anything such as a jdbc patch related to
Jbuilder.
> After that, I'm still at a loss as to why the update queries I send are
> never
> actually updated in the DB.
As for me, this will be the next step...
> Hope that helps a bit,
It does help, because I know at present (1) that it is possible to
connect the Jbuilder environment and Postgres and (2) that I am not
alone on the earth trying to do that !
Anyway, thanks for your reply.
Pierre
--
________________________________________________________________________
Pierre HABRAKEN - mailto:Pierre.Habraken@ujf-grenoble.fr
Tél: 04 76 51 48 87 - Fax: 04 76 51 45 63
Université Joseph Fourier - Département Scientifique Universitaire
Adresse postale : CAFIM/DSU BP53 38041 Grenoble Cedex 9
________________________________________________________________________
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: Pierre.Habraken@ujf-grenoble.fr, dunlopa@adscomputers.com, pgsql-questions@postgreSQL.org
Subject: Re: [QUESTIONS] Accessing Postgresfrom JBuilder using JDBC
In-Reply-To: <351272F7.E4F4082A@ujf-grenoble.fr>
* 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