[opencms-dev] Using Oracle 10g

[Jonathan Woods]

Oran - there were certainly posts on this list in the last month or two
about this issue, with some direct input from guys at Alkacon - try
searching the list for 'UK_BACKUP_PROPERTIES', because that rings a bell.

Jon 

-----Original Message-----
From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Oran Kelly
Sent: 30 May 2006 16:15
To: opencms-dev at opencms.org
Subject: [opencms-dev] Using Oracle 10g

I have been trying to install OpenCms 6.2.1 with Oracle 10g
(10.1.0.3.0) and the setup procedure fails. It is violating the constraint
UK_BACKUP_PROPERTIES many times during the module import phase. Upon
completion of the import, the welcome page is displayed but it is not
possible to access the workspace (just get a blank page, no errors in any
logs). I have tested with both vanilla Tomcat 5.5.17 and JBoss 4.0.4.

Since it works in MySQL (I used mysql 4.1.19), I have compared the two
schema and I notice that the equivalent constraints for both
UK_BACKUP_CONTENTS and UK_BACKUP_PROPERTIES do not exist in the MySQL schema
(though non-unique indices are created). In a cleanly imported MySQL schema
I executed the following:

select propertydef_id,count(property_mapping_id)
from CMS_BACKUP_PROPERTIES
group by propertydef_id
having count(property_mapping_id) > 1

and received many results (some of which returned a count in excess of
2000!)

If I manually set up the database in Oracle, then drop the above-mentioned
constraints and go through the setup wizard (skipping the 'create user' and
'create tables' actions), the import runs successfully and the workspace is
accessible at the end. So I'm thinking that these are invalid constraints in
the Oracle DDL.

(Incidentally, attempting to create the Oracle DB from scratch using the
setup wizard always fails too, but I think I spotted an open bugzilla issue
reporting this.)

 oran


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com 

_______________________________________________
This mail is sent to you from the opencms-dev mailing list To change your
list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev