Apache OpenOffice (AOO) Bugzilla – Issue 86045
[Informix] Views are not updateable
Last modified: 2017-05-20 09:36:02 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");
do you have the possibility to use an other driver?
Tested it today with the latest Informix JDBC Driver 3.5. Still no luck!
clu->all: can anybody confirm this problem (unfortunately i have no informix database in use) thx
change owner
@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.
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.