Issue 83047

Summary:	Cannot use views with Oracle
Product:	Base	Reporter:	cianoz <luczani>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues, mechtilde
Version:	OOo 2.3
Target Milestone:	---
Hardware:	PC
OS:	Windows XP
URL:	http://
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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

Set target.