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]
