Le 07/04/11 10:37, amine amine a écrit : Hi Amine,
I downloaded and installed the XTuple software. It sets up a postgresql server on a Unix socket, with a default db called demo and User/PWD admin/admin. I then downloaded the JDBC3 driver for postgres 8.4. Started LibO, and indicated in the Java settings (Add archive) where it could find the driver. Shut down LibO and restarted it. I then chose Create New DB, the DB creation wizard started. I told it to connect to an existing database via JDBC, entered the connection and driver parameters : Connection jdbc:postgresql://localhost/demo Driver org.postgresql.Driver Tested the driver. Then carried on through the wizard with the defaults, saving as XTuple_demo.odb When I click on the "Tables" icon, it asks me for the user and pwd combination, I enter "admin" and "admin", the connection works and displays a list of dbs with their associated tables or views. If I click on a table, I can edit the data in that table, update it, create new entries, etc, and they are saved (providing I validate the entry by either moving from one tuple to another or by clicking the appropriate disk icon. None of the Views are editable. So my guess is, you are either working with Views, which do not appear to be updateable, or Queries across multiple tables which AFAIK are also not updateable, or you have something special else in your user rights or table definitions that prevents the driver from changing the data via LibO. Alex -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
