JBuilder QueryDataSet: Can't browse tables in Query Editor
От | Pierre Habraken |
---|---|
Тема | JBuilder QueryDataSet: Can't browse tables in Query Editor |
Дата | |
Msg-id | 3518C6F6.70C6DE85@ujf-grenoble.fr обсуждение исходный текст |
Список | 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 ________________________________________________________________________
В списке pgsql-interfaces по дате отправления: