Issue 86045 - [Informix] Views are not updateable
Summary: [Informix] Views are not updateable
Status: CLOSED OBSOLETE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.3
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needhelp, needmoreinfo
Depends on:
Blocks:
 
Reported: 2008-02-12 14:55 UTC by bdonauba
Modified: 2017-05-20 09:36 UTC (History)
3 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description bdonauba 2008-02-12 14:55:40 UTC
I have some views in my Informix DB - connected via JDBC - that contain a 
primary key and are updateable with informix tools. But when I access those 
views via OO I can not update them.

Example of my Informix DB
 19 create database direct in dbspace06 with buffered log;
 20
 21 --BD Rechte
 22 grant dba to "informix";
 23 grant dba to "public";
 24
 25 create table yucatan.inetplzzo (
 26     inpz_id integer not null ,
 27     inpz_lake_id char(12) not null ,
 28     inpz_plz_inte_von char(10) not null ,
 29     inpz_plz_inte_bis char(10) not null ,
 30     inpz_kund_id integer,
 31     inpz_aumi_id char(12),
 32     primary key(inpz_id)
 33 );
 34 revoke all on inetplzzo from public;
 35 grant select on "yucatan".inetplzzo to "public" as "yucatan";
 36 grant update on "yucatan".inetplzzo to "public" as "yucatan";
 37 grant insert on "yucatan".inetplzzo to "public" as "yucatan";
 38 grant delete on "yucatan".inetplzzo to "public" as "yucatan";
 39 grant index on "yucatan".inetplzzo to "public" as "yucatan";
 40
 41 insert into inetplzzo values (0,"D", "0000", "9999", 1, "1");
 42
 43 create view ip (
 44     inpz_id,
 45     inpz_lake_id,
 46     inpz_plz_inte_von,
 47     inpz_plz_inte_bis,
 48     inpz_kund_id,
 49     inpz_aumi_id
 50 ) as
 51 select
 52     inpz_id,
 53     inpz_lake_id,
 54     inpz_plz_inte_von,
 55     inpz_plz_inte_bis,
 56     inpz_kund_id,
 57     inpz_aumi_id
 58 from inetplzzo;
 59 grant select,insert,update,delete on ip to dpauli,bdonauba,mstockin;
 60
 61 insert into inetplzzo values (1,"D", "0000", "9999", 1, "1");
Comment 1 christoph.lukasiak 2008-06-18 14:46:16 UTC
do you have the possibility to use an other driver?
Comment 2 bdonauba 2008-06-23 08:59:08 UTC
Tested it today with the latest Informix JDBC Driver 3.5. Still no luck!
Comment 3 christoph.lukasiak 2008-09-15 12:25:35 UTC
clu->all: can anybody confirm this problem (unfortunately i have no informix
database in use)

thx
Comment 4 christoph.lukasiak 2008-09-24 12:46:01 UTC
change owner
Comment 5 Rainer Bielefeld 2013-10-08 15:22:47 UTC
@bdonauba
If this is still a problem for you, we will need a test kit (database) and a detailled instruction how to reproduce the problem.
Comment 6 Rainer Bielefeld 2013-10-25 09:39:37 UTC
Closing issue due to reporter's inactivity.

@reporter:
Please feel free to reopen this issue if you find out that the problem still exists in the latest public release of AOO and if you can provide requested additional information.