Re: [INTERFACES] JBuilder QueryDataSet: Can't browse tables in Query Editor - Mailing list pgsql-interfaces

From Pierre Habraken
Subject Re: [INTERFACES] JBuilder QueryDataSet: Can't browse tables in Query Editor
Date
Msg-id 353F4D8B.99F8F1F@ujf-grenoble.fr
Whole thread Raw
In response to RE: [INTERFACES] JBuilder QueryDataSet: Can't browse tables in Query Editor  (Peter Mount <peter@maidstone.gov.uk>)
List pgsql-interfaces
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
________________________________________________________________________

pgsql-interfaces by date:

Previous
From: Peter Mount
Date:
Subject: RE: [INTERFACES] JBuilder QueryDataSet: Can't browse tables in Query Editor
Next
From: Byron Nikolaidis
Date:
Subject: retrieving varchar size