Apache OpenOffice (AOO) Bugzilla – Issue 83047
Cannot use views with Oracle
Last modified: 2013-08-07 15:45:09 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?
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?
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.
Any new about this issue? At least do some checks to change status to "confirmed"
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!
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".
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.
as discussed with oracelix on IRC
clu->oj:may you have a looh at this thx
Set target.