pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedJBuilder QueryDataSet: Can't browse tables in Query Editor
7+ messages / 3 participants
[nested] [flat]
* JBuilder QueryDataSet: Can't browse tables in Query Editor
@ 1998-03-25 08:57 Pierre Habraken <Pierre.Habraken@ujf-grenoble.fr>
0 siblings, 2 replies; 7+ messages in thread
From: Pierre Habraken @ 1998-03-25 08:57 UTC (permalink / raw)
To: pgsql-interfaces
Playing with the JBuilder GUI, I am trying to set up an instance of the
QueryDataSet component using the Query Editor.
The targetted table resides within a remote PostgreSql database which
JBuilder is connected to through the Postgres JDBC driver.
Connecting the JBuilder IDE to the database using the Connection Editor
was successful.
Within the Query Editor, I performed the following steps:
- bind the query to the relevant Database component: OK
- push down the button 'Browse tables': this causes the message:
ERROR: parser: parse error at or near ""
to be displayed.
This message is apparently reported by the JDBC driver. The PostgreSql
server log file logs the same error message.
- 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.
Any idea ?
Thanks in advance (again) for any help.
--
________________________________________________________________________
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
________________________________________________________________________
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] JBuilder QueryDataSet: Can't browse tables in Query Editor
@ 1998-04-02 15:07 Pierre Habraken <Pierre.Habraken@ujf-grenoble.fr>
parent: Pierre Habraken <Pierre.Habraken@ujf-grenoble.fr>
1 sibling, 1 reply; 7+ messages in thread
From: Pierre Habraken @ 1998-04-02 15:07 UTC (permalink / raw)
To: pgsql-interfaces
I tried again with the JDBC driver which comes with the release 6.3.1,
but the behavior described below is the same as with release 6.3.
BTW: With example/psql, I can create a new table, select columns in an
existing table, but I can not insert new tuples, where I can do it with
the regular psql interactive interface to PostgreSql on host 'host':
local psql:
----------
$ psql foo
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: foo
foo=> select * from bar;
chaine|entier
------+------
toto | 10
(1 row)
foo=> insert into bar values('titi', 99);
INSERT 18304 1
foo=> select * from bar;
chaine|entier
------+------
toto | 10
titi | 99
(2 rows)
foo=>
remote jdbc example/psql:
------------------------
$ java example/psql jdbc:postgresql://host/foo postgres postgres
PostgreSQL psql example v6.3 rev 1
Connecting to Database URL = jdbc:postgresql://host/foo
Connected to PostgreSQL 6.3
[1] select * from bar;
chaine entier
toto 10
titi 99
[2] [2] insert into bar values('tata', 100);
[2] ERROR: parser: parse error at or near ""
[2] [2] ERROR: parser: parse error at or near ","
[2] [2]
!!!???
Pierre Habraken wrote:
>
> Playing with the JBuilder GUI, I am trying to set up an instance of the
> QueryDataSet component using the Query Editor.
> The targetted table resides within a remote PostgreSql database which
> JBuilder is connected to through the Postgres JDBC driver.
> Connecting the JBuilder IDE to the database using the Connection Editor
> was successful.
>
> Within the Query Editor, I performed the following steps:
> - bind the query to the relevant Database component: OK
> - push down the button 'Browse tables': this causes the message:
> ERROR: parser: parse error at or near ""
> to be displayed.
> This message is apparently reported by the JDBC driver. The PostgreSql
> server log file logs the same error message.
> - 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.
>
> Any idea ?
> Thanks in advance (again) for any help.
> --
> ________________________________________________________________________
> 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
> ________________________________________________________________________
--
________________________________________________________________________
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
________________________________________________________________________
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] JBuilder QueryDataSet: Can't browse tables in Query Editor
@ 1998-04-02 17:31 Peter T Mount <pgint@maidast.demon.co.uk>
parent: Pierre Habraken <Pierre.Habraken@ujf-grenoble.fr>
0 siblings, 0 replies; 7+ messages in thread
From: Peter T Mount @ 1998-04-02 17:31 UTC (permalink / raw)
To: Pierre Habraken <Pierre.Habraken@ujf-grenoble.fr>; +Cc: pgsql-interfaces
On Thu, 2 Apr 1998, Pierre Habraken wrote:
> foo=> select * from bar;
> chaine|entier
> ------+------
> toto | 10
> (1 row)
>
> foo=> insert into bar values('titi', 99);
> INSERT 18304 1
> foo=> select * from bar;
> chaine|entier
> ------+------
> toto | 10
> titi | 99
> (2 rows)
>
> foo=>
>
> remote jdbc example/psql:
> ------------------------
> $ java example/psql jdbc:postgresql://host/foo postgres postgres
> PostgreSQL psql example v6.3 rev 1
>
> Connecting to Database URL = jdbc:postgresql://host/foo
> Connected to PostgreSQL 6.3
>
> [1] select * from bar;
> chaine entier
> toto 10
> titi 99
> [2] [2] insert into bar values('tata', 100);
> [2] ERROR: parser: parse error at or near ""
>
> [2] [2] ERROR: parser: parse error at or near ","
>
> [2] [2]
>
> !!!???
Yep, I'm now getting this also. I'll look into this.
--
Peter T Mount petermount@earthling.net or pmount@maidast.demon.co.uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] JBuilder QueryDataSet: Can't browse tables in Query Editor
@ 1998-04-23 12:34 Pierre Habraken <Pierre.Habraken@ujf-grenoble.fr>
parent: Pierre Habraken <Pierre.Habraken@ujf-grenoble.fr>
1 sibling, 0 replies; 7+ messages in thread
From: Pierre Habraken @ 1998-04-23 12:34 UTC (permalink / raw)
To: pgsql-interfaces
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
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
________________________________________________________________________
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: [INTERFACES] JBuilder QueryDataSet: Can't browse tables in Query Editor
@ 1998-04-23 13:33 Peter Mount <peter@maidstone.gov.uk>
0 siblings, 1 reply; 7+ messages in thread
From: Peter Mount @ 1998-04-23 13:33 UTC (permalink / raw)
To: 'Pierre Habraken' <Pierre.Habraken@ujf-grenoble.fr>; pgsql-interfaces
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
________________________________________________________________________
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] JBuilder QueryDataSet: Can't browse tables in Query Editor
@ 1998-04-23 14:17 Pierre Habraken <Pierre.Habraken@ujf-grenoble.fr>
parent: Peter Mount <peter@maidstone.gov.uk>
0 siblings, 0 replies; 7+ messages in thread
From: Pierre Habraken @ 1998-04-23 14:17 UTC (permalink / raw)
To: Peter Mount <peter@maidstone.gov.uk>; +Cc: pgsql-interfaces@postgreSQL.org, Patrick Scott Pierce <pspierce@mindspring.net>
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
________________________________________________________________________
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: [INTERFACES] JBuilder QueryDataSet: Can't browse tables in Query Editor
@ 1998-04-23 15:32 Peter Mount <peter@maidstone.gov.uk>
0 siblings, 0 replies; 7+ messages in thread
From: Peter Mount @ 1998-04-23 15:32 UTC (permalink / raw)
To: 'Pierre Habraken' <Pierre.Habraken@ujf-grenoble.fr>; 'Peter Mount' <peter@maidstone.gov.uk>; +Cc: pgsql-interfaces; 'Patrick Scott Pierce' <pspierce@mindspring.net>; 'Peter at home' <peter@retep.org.uk>
You could try just the 6.3.2 driver as it will work with the 6.3 server.
It's interesting that 1.0 doesn't work, but 1.01 does.
Also, the auth= parameter is obsolete. Since 6.3, it's not even looked for.
--
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: Pierre Habraken [mailto:Pierre.Habraken@ujf-grenoble.fr]
Sent: Thursday, April 23, 1998 3:35 PM
To: Peter Mount
Cc: pgsql-interfaces@postgreSQL.org; Patrick Scott Pierce
Subject: Re: [INTERFACES] JBuilder QueryDataSet: Can't browse tables in
Query Editor
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
________________________________________________________________________
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~1998-04-23 15:32 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-03-25 08:57 JBuilder QueryDataSet: Can't browse tables in Query Editor Pierre Habraken <Pierre.Habraken@ujf-grenoble.fr>
1998-04-02 15:07 ` Pierre Habraken <Pierre.Habraken@ujf-grenoble.fr>
1998-04-02 17:31 ` Peter T Mount <pgint@maidast.demon.co.uk>
1998-04-23 12:34 ` Pierre Habraken <Pierre.Habraken@ujf-grenoble.fr>
1998-04-23 13:33 RE: [INTERFACES] JBuilder QueryDataSet: Can't browse tables in Query Editor Peter Mount <peter@maidstone.gov.uk>
1998-04-23 14:17 ` Pierre Habraken <Pierre.Habraken@ujf-grenoble.fr>
1998-04-23 15:32 RE: [INTERFACES] JBuilder QueryDataSet: Can't browse tables in Query Editor Peter Mount <peter@maidstone.gov.uk>
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