Issue 90393

Summary: Updateable MySQL views cannot be updated via OOBase
Product: Base Reporter: tony_52 <tony.smith>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: drewjensen.inbox, issues
Version: OOo 3.0 Beta   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description tony_52 2008-06-05 12:28:00 UTC
Hi All

Seeing as though the multiple datasource ability is still not a working feature,
I decide to try using updateable views in the My SQL database.

So, taking the example of 2 MySQL databases.

I have a table in Database 2, that I would normlly have as an additional data
source in OOBase(if it was possible), as I currently do when using MS Access.

An alternative idea I thought, was to create an updateable View on the table in
DB2, in DB1.

From withing MySQL I can update, amend this view, as if it was a local table on DB1.

In OOBase, this view, in DB1, appears in the list of tables in DB1, however, in
OOBase this view is read only, and not updateable.

Oh well....

Cheers
Comment 1 drewjensen.inbox 2008-06-09 04:57:21 UTC
Would you pass on which version of MySQL you are using and which type/version of
a connector?
Comment 2 tony_52 2008-06-10 16:02:29 UTC
Hi There

MySQL version 5.0.24a-standard

And connector

mysql-connector-java-3.1.12-bin.jar

Thanks

Tony
Comment 3 christoph.lukasiak 2008-09-23 15:43:35 UTC
change owner
Comment 4 christoph.lukasiak 2008-11-18 14:24:50 UTC
this is not supported => change in feature enhancement and send further to the
requirements team

p.s. views cannot be updated, because they have no primary key
Comment 5 tony_52 2009-01-02 17:23:45 UTC
Hi there,

Any update on this, is it in the pipeline for a future release? Whilst views
don't have primary keys, it should not prevent them from being updated,
afterall, that is why you can create updatable views in, not just MySQL, but
Oracle and Postgres at least. Of course, the requirements for the views could be
reduced, if tables from multiple sources can be linked into the single OODb file.

Cheers