Thread: JBuilder QueryDataSet: Can't browse tables in Query Editor

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
________________________________________________________________________

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
________________________________________________________________________

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

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
________________________________________________________________________