Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Cannot use views with Oracle|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description cianoz 2007-10-28 02:35:13 UTC
Hello I created a connection to an Oracle db with OOo 2.3.0 because I need a form for data insert and update. I see that everything works fine if I try to insert records straight to the tables, but I can't do anything if I try to work with views. This appears as a limit of Base. Can you confirm it? Does it exist any workaround to use views for data insert instead of tables?
Comment 1 Mechtilde 2007-10-28 08:22:39 UTC
need more information Which connector do you use? Does the database management system Oracle support views? Does the connector support views? Does the view contain the primary key?
Comment 2 cianoz 2007-10-28 11:31:55 UTC
I used both an ODBC connection with the Merant drivers v.3.70, that is what we regularly use for our ERP, and a JDBC connection using the ojdbc14.jar driver. Both drivers seem to works, only, the JDBC driver is much slower than the ODBC. The DBMS supports views, absolutely! I didn't check if the JDBC connector support views, in effect... I have to give a look. Anyway, the Merant ODBC driver has full support for views. All the views contains the primary key, this is OK.
Comment 3 cianoz 2007-11-05 07:52:43 UTC
Any new about this issue? At least do some checks to change status to "confirmed"
Comment 4 expuetti 2008-01-08 12:04:54 UTC
i can confirm this issue,too. Using: oo 2.3.1 on xp, JDBC connection with ojdbc14.jar driver, Oracle XE database. Testcase: calc-datapilot on registered oracle-xe-database. Views should be listed under type="query", not under table - but they aren't. No problems with materialized views. they are listed under type="table" Yes, connector supports views!
Comment 5 expuetti 2008-01-08 16:06:38 UTC
different behaviour detected: oracle views can be seen in calc via "datasource" (F4) and in base - here as tables. ojdbc14.jar driver used for these testcases. error seems to be in code of program module "calc-datapilot".
Comment 6 oracelix 2008-01-24 15:04:42 UTC
I'm able to confirm this issue. Testszenario: OS: openSuse 10.3 and WinXP SP2 OOo: 2.3.1 (on WinXP vanilla-version) Oracle: 10gR1 jdbc-driver: ojdbc14.jar I've created a view with these options - only one table is attached by this view - all primary key fields are in it - all not nullable fields are in it - based table is able to be edited In Base the edit button is not active after opening this view. I'm not able to add new records or modify existing records. To verify the jdbc-driver is able to modify or add records I've tried to add a new record by using SQL-Developer with same jdbc-driver. The jdbc-driver works correct.
Comment 7 Mechtilde 2008-03-17 22:47:21 UTC
as discussed with oracelix on IRC
Comment 8 christoph.lukasiak 2008-06-18 13:02:26 UTC
clu->oj:may you have a looh at this thx
Comment 9 ocke.janssen 2008-12-10 07:49:46 UTC