To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=57377
--- Additional comments from [EMAIL PROTECTED] Sat Feb 18 12:00:10 -0800
2006 ---
I have tried again to recreate this issue but it now seems different. I can read
my postgres database through the JDBC driver. I can also add columns to tables.
But I cannot edit any column, irrespective of data type. I'm using openoffice
2.0.1 under Linux.
Step by step is as follows:
1. From a working postgres installation run the following SQL e.g. from psql to
create and populate a test table
create table transtable (
id bigint,
description varchar(50),
value numeric(20,2)
);
insert into transtable values (1, 'The first transaction', 200.54);
insert into transtable values (2, 'The second transaction', 153.48);
2. Download the jdbc driver from jdbc.postgresql.org/download.html I used the
8.1-405.jdbc3.jar file to match my Postgres 8.1.2 installation
3. Add the postgres-jdbc driver jar file to openoffice in
Tools-options-java-Classpath-Add Archive
4. Restart openoffice for the JDBC driver to be recognised
5. Use create a new database wizard, connect to an existing JDBC database
Datasource URL: jdbc:postgresql://127.0.0.1:5432/testdb (in my case)
user, enter username known to postgres with sufficient permissions e.g.
postgres.
JDBC driver class: org.postgresql.Driver
6. Click Test Class - Should report that driver loaded successfully
7. Click test connection - Ensure connection is established correctly before
proceeding.
8. Next click on Tables and double click on transtable. The two rows inserted
above should be returned.
9. Try to edit one of the fields
I am aware that there is a postgres SDBC driver project, but JDBC should work!
Also as I had the same problem with MSSQL and the Microsoft JDBC driver this
suggests a wider issue with JDBC and OpenOffice than one driver not following
the JDBC standards. The postgres driver I used is the 'official' one and does
work when accessed through Java. I don't know enough about JDBC to know how
closely it follows the JDBC standard.
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
