Apache OpenOffice (AOO) Bugzilla – Issue 64408
Can't set primary keys for derby/java db databases
Last modified: 2013-02-07 22:33:57 UTC
I created a table in a embedded derby database. I opened the contextual pop-up menu to set the primary key, and there was nothing. The docs say that when that menu item doesn't appear, then the db doesn't support primary keys. But you know that derby supports them.
clu->cbulcu: both is right - when oo connect to a foreign datasource, it asks your driver (odbc/jdbc/ado) if the connected database support primary keys: if the driver give back a 'no' then this option is not available over the ui, doesen't matter if the database itselve support primary keys - maybe with an other driver or next version of your driver this will work as expected clu->protocol: this is on of many databases/driver combination that partly does not work as expected with oo because of partly ignoring standards - like with mysql this can be trick out internaly => send to: requirements
clu->cbulcu: may you add the version number of the database that you connect and for the used driver thx
Apache Derby 10.1.2.1 Release