Issue 90393 - Updateable MySQL views cannot be updated via OOBase
Summary: Updateable MySQL views cannot be updated via OOBase
Status: UNCONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.0 Beta
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-06-05 12:28 UTC by tony_52
Modified: 2013-02-07 22:38 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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