[libreoffice-users] Re: Postgresql with LibO-3.3.2 BASE

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+help@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