Обсуждение: RE: [INTERFACES] JBuilder QueryDataSet: Can't browse tables in Query Editor

Which version of postgresql are you using?

There were some fixes in 6.3.2 related to JBuilder.

Were still getting the odd patch for the jdbc driver to get JBuilder to
work, and it's hampered by the fact that I don't have JBuilder here to test
it against, so I have to rely on those who do have it to test the fixes.

--
Peter T Mount, peter@maidstone.gov.uk, pmount@retep.org.uk
Please note that this is from my works email. If you reply, please cc my
home address.


-----Original Message-----
From: owner-pgsql-interfaces@hub.org
[mailto:owner-pgsql-interfaces@hub.org]On Behalf Of Pierre Habraken
Sent: Thursday, April 23, 1998 1:34 PM
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] JBuilder QueryDataSet: Can't browse tables in
Query Editor


Pierre Habraken wrote:
>
> Playing with the JBuilder GUI, I am trying to set up an instance of the
> QueryDataSet component using the Query Editor.
> [...]
> - Then, manually entering a query, say: "select * from bar", and pushing
>   down the button 'Test query' is successfully acknowledged, though the
>   server reacts by logging the message:
>        ERROR:  t: Table does not exist.

I have just installed the release 1.01 (french) and now querying the
metadata from the query editor works fine !
--
________________________________________________________________________
Pierre HABRAKEN - mailto:Pierre.Habraken@ujf-grenoble.fr
Tl: 04 76 51 48 87 - Fax: 04 76 51 45 63
Universit Joseph Fourier - Dpartement Scientifique Universitaire
Adresse postale : CAFIM/DSU BP53 38041 Grenoble Cedex 9
________________________________________________________________________

I have not yet installed the release 6.3.2. I failed to install the
release 6.3.1 on HPUX (just a makefile to fix but no time for doing it)
so I am now still working with a 6.3 server. However, I tested both JDBC
drivers 6.3 and 6.3.1.

My conclusion is that the query editor fails with both drivers 6.3 or
6.3.1 when using JBuilder 1.0 french), but works fine with both drivers
when using JBuilder 1.01 (french) !

In any case, I did not have to add any authentication parameters (such
as ?user=someone&password=somepasswd&auth=password) to the database URL.
Also I did not have to uncheck the RowID field in the editor for the
metaDataUpdate property, as was suggested some time ago by Patrick S.
Pierce: Binding a control choice component to a column in a dataset is
now straightforward...

Pierre


Peter Mount wrote:
>
> Which version of postgresql are you using?
>
> There were some fixes in 6.3.2 related to JBuilder.
>
> Were still getting the odd patch for the jdbc driver to get JBuilder to
> work, and it's hampered by the fact that I don't have JBuilder here to test
> it against, so I have to rely on those who do have it to test the fixes.
>
> --
> Peter T Mount, peter@maidstone.gov.uk, pmount@retep.org.uk
> Please note that this is from my works email. If you reply, please cc my
> home address.
>
> -----Original Message-----
> From: owner-pgsql-interfaces@hub.org
> [mailto:owner-pgsql-interfaces@hub.org]On Behalf Of Pierre Habraken
> Sent: Thursday, April 23, 1998 1:34 PM
> To: pgsql-interfaces@postgreSQL.org
> Subject: Re: [INTERFACES] JBuilder QueryDataSet: Can't browse tables in
> Query Editor
>
> Pierre Habraken wrote:
> >
> > Playing with the JBuilder GUI, I am trying to set up an instance of the
> > QueryDataSet component using the Query Editor.
> > [...]
> > - Then, manually entering a query, say: "select * from bar", and pushing
> >   down the button 'Test query' is successfully acknowledged, though the
> >   server reacts by logging the message:
> >        ERROR:  t: Table does not exist.
>
> I have just installed the release 1.01 (french) and now querying the
> metadata from the query editor works fine !
> --
> ________________________________________________________________________
> Pierre HABRAKEN - mailto:Pierre.Habraken@ujf-grenoble.fr
> Tl: 04 76 51 48 87 - Fax: 04 76 51 45 63
> Universit Joseph Fourier - Dpartement Scientifique Universitaire
> Adresse postale : CAFIM/DSU BP53 38041 Grenoble Cedex 9
> ________________________________________________________________________

--
________________________________________________________________________
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
________________________________________________________________________