Thread: Postgresql 7.1.2 and StarOffice 5.2
Hello, I haven't managed to access POstgresql 7.1.2 databases using StarOffice 5.2 using jdbc or odbc. I read quite a good number of posts on the subject, and it appearts that nobody managed to do it using jdbc, but some managed with odbc. Using Debian package for Postgres 7.1.2 and Debian jdbc Driver, i managed to connect to the database but the list of tables is empty ! I have exactly the same problem with odbc (using Debian unixodbc). I just need a (reliable) read access to my table, i hope it will be possible... Thank you for your help, Best regards, Arnaud Espanel.
On Wed, 15 Aug 2001 12:16:40 +0200 (MET DST), you wrote: >Using Debian package for Postgres 7.1.2 and Debian >jdbc Driver, i managed to connect to the database >but the list of tables is empty ! I'm afraid you'll have to be more specific. What functionality in what piece of software are you using to retrieve a list of tables? How is this software configured to use JDBC? Are there any error messages interactively, or in a log file? Does it work with other databases? Regards, René Pijlman
Hi All,
This is due to the current incompleteness of the jdbc driver;
specifically the metadata functionality.
Rene; a better piece of software to test for completeness is druid,
which is a database design tool; it makes heavy use of the metadata
features
Dave
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Rene Pijlman
Sent: August 15, 2001 6:30 AM
To: Arnaud ESPANEL
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Postgresql 7.1.2 and StarOffice 5.2
On Wed, 15 Aug 2001 12:16:40 +0200 (MET DST), you wrote:
>Using Debian package for Postgres 7.1.2 and Debian
>jdbc Driver, i managed to connect to the database
>but the list of tables is empty !
I'm afraid you'll have to be more specific. What functionality in what
piece of software are you using to retrieve a list of tables?
How is this software configured to use JDBC?
Are there any error messages interactively, or in a log file?
Does it work with other databases?
Regards,
René Pijlman
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> On Wed, 15 Aug 2001 12:16:40 +0200 (MET DST), you wrote: > >Using Debian package for Postgres 7.1.2 and Debian > >jdbc Driver, i managed to connect to the database > >but the list of tables is empty ! > > I'm afraid you'll have to be more specific. What functionality > in what piece of software are you using to retrieve a list of > tables? When using StarOffice to create a new database access, you have to decide how to acces it (odbc or jdbc for instance), and give him either the url of BD (in the jdbc case) or the data source object (in the odbc case). Then StarOffice tries to connect the specified database and retreives the list of tables of this base. > > How is this software configured to use JDBC? StarOffice has a specific tool to connect databases. In the JDBC case, It prompts the user for a JDBC driver. I used the last Postgresql debian packaged driver for that. > > Are there any error messages interactively, or in a log file? I'm afraid i can't find any log file. There is no error messages : the list of tables are just empty, but my database has at about 30 tables. > > Does it work with other databases? It dosn't work with other Postgres databases, but it has worked with mysql databases. Regards, Arnaud Espanel.
> On Wed, 15 Aug 2001 12:16:40 +0200 (MET DST), you wrote: > >Using Debian package for Postgres 7.1.2 and Debian > >jdbc Driver, i managed to connect to the database > >but the list of tables is empty ! > > I'm afraid you'll have to be more specific. What functionality > in what piece of software are you using to retrieve a list of > tables? When using StarOffice to create a new database access, you have to decide how to acces it (odbc or jdbc for instance), and give him either the url of BD (in the jdbc case) or the data source object (in the odbc case). Then StarOffice tries to connect the specified database and retreives the list of tables of this base. > > How is this software configured to use JDBC? StarOffice has a specific tool to connect databases. In the JDBC case, It prompts the user for a JDBC driver. I used the last Postgresql debian packaged driver for that. > > Are there any error messages interactively, or in a log file? I'm afraid i can't find any log file. There is no error messages : the list of tables are just empty, but my database has at about 30 tables. > > Does it work with other databases? It dosn't work with other Postgres databases, but it has worked with mysql databases. Regards, Arnaud Espanel.
Hi Rene. Hi Dave. (No, you don't know me :)
I use Druid to design my PG database.
I never got the jdbc driver to work.
Have you?
I'm using this URL
jdbc:postgresql://<server>:<port>/<database>
then I get this message
Trying to connect...
Raised SQL Exception:
Message: postgresql.stat.maxfieldsize
Code : 0
State : null
Any idea of what's going on?
Thanks
--
Dado Feigenblatt Wild Brain, Inc.
Technical Director (415) 216-2053
dado@wildbrain.com San Francisco, CA.
Dave Cramer wrote:
>Hi All,
>
>This is due to the current incompleteness of the jdbc driver;
>specifically the metadata functionality.
>
>Rene; a better piece of software to test for completeness is druid,
>which is a database design tool; it makes heavy use of the metadata
>features
>
>Dave
>
>-----Original Message-----
>From: pgsql-jdbc-owner@postgresql.org
>[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Rene Pijlman
>Sent: August 15, 2001 6:30 AM
>To: Arnaud ESPANEL
>Cc: pgsql-jdbc@postgresql.org
>Subject: Re: [JDBC] Postgresql 7.1.2 and StarOffice 5.2
>
>
>On Wed, 15 Aug 2001 12:16:40 +0200 (MET DST), you wrote:
>
>>Using Debian package for Postgres 7.1.2 and Debian
>>jdbc Driver, i managed to connect to the database
>>but the list of tables is empty !
>>
>
>I'm afraid you'll have to be more specific. What functionality in what
>piece of software are you using to retrieve a list of tables?
>
>How is this software configured to use JDBC?
>
>Are there any error messages interactively, or in a log file?
>
>Does it work with other databases?
>
>Regards,
>René Pijlman
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
It is a problem with some of the metadata calls, I am looking into it
-----Original Message-----
From: Dado Feigenblatt [mailto:dado@wildbrain.com]
Sent: October 26, 2001 1:30 PM
To: Dave@micro-automation.net; pgsql-jdbc; rpijlman@wanadoo.nl
Subject: PostgreSQL, JDBC, and Druid
Hi Rene. Hi Dave. (No, you don't know me :)
I use Druid to design my PG database.
I never got the jdbc driver to work.
Have you?
I'm using this URL
jdbc:postgresql://<server>:<port>/<database>
then I get this message
Trying to connect...
Raised SQL Exception:
Message: postgresql.stat.maxfieldsize
Code : 0
State : null
Any idea of what's going on?
Thanks
--
Dado Feigenblatt Wild Brain, Inc.
Technical Director (415) 216-2053
dado@wildbrain.com San Francisco, CA.
Dave Cramer wrote:
>Hi All,
>
>This is due to the current incompleteness of the jdbc driver;
>specifically the metadata functionality.
>
>Rene; a better piece of software to test for completeness is druid,
>which is a database design tool; it makes heavy use of the metadata
>features
>
>Dave
>
>-----Original Message-----
>From: pgsql-jdbc-owner@postgresql.org
>[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Rene Pijlman
>Sent: August 15, 2001 6:30 AM
>To: Arnaud ESPANEL
>Cc: pgsql-jdbc@postgresql.org
>Subject: Re: [JDBC] Postgresql 7.1.2 and StarOffice 5.2
>
>
>On Wed, 15 Aug 2001 12:16:40 +0200 (MET DST), you wrote:
>
>>Using Debian package for Postgres 7.1.2 and Debian
>>jdbc Driver, i managed to connect to the database
>>but the list of tables is empty !
>>
>
>I'm afraid you'll have to be more specific. What functionality in what
>piece of software are you using to retrieve a list of tables?
>
>How is this software configured to use JDBC?
>
>Are there any error messages interactively, or in a log file?
>
>Does it work with other databases?
>
>Regards,
>René Pijlman
>
>---------------------------(end of
>broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)
>
>
>
>---------------------------(end of
>broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
On Fri, 26 Oct 2001 10:30:25 -0700, you wrote: >I use Druid to design my PG database. >I never got the jdbc driver to work. >Any idea of what's going on? It seems that the PostgreSQL JDBC driver doesn't work with various applications (Druid, StarOffice, DbVisualizer,...) because it does not yet properly implement all of the metadata methods. Fixing this would be a lofty goal for 7.3 I think. Regards, René Pijlman <rene@lab.applinet.nl>