Setting up Oracle Database and Orbeon

[leomachado666]

Hello !,

i am trying to set up the database for orbeon usage , i would like someone
to review the tutorial because i believe there is a mistake in the oracle
part.

Even if you create the orbeon user and grant the privileges, upon executing
the script to create the orbeon tables, it will NOT create the tables in the
correct schema (each user is an schema in Oracle, right?), it will create it
as SYS or something like that.

I managed to create some tables with "orbeon.orbeon_form_definition( etc...)
Placing the "orbeon." (i guess) tells Oracle to create it in the orbeon
user.


im using oracle 11r2 with SUSE 11 enterprise and Orbeon Forms PE 4.10.

if someone could review and test the oracle tutorial i would appreciate it!!
:)

--
View this message in context: http://discuss.orbeon.com/Setting-up-Oracle-Database-and-Orbeon-tp4660644.html
Sent from the Orbeon Forms community mailing list mailing list archive at Nabble.com.

[Alessandro Vernet]

Hi Leo,

You are referring to these instructions linked below, correct?

http://doc.orbeon.com/form-runner/persistence/relational-db.html#oracle

If I understand you, you are saying that the instructions should state more
clearly that one should connect with the orbeon user before running the DDL
that creates the tables, indexes, and triggers?

Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
View this message in context: http://discuss.orbeon.com/Setting-up-Oracle-Database-and-Orbeon-tp4660644p4660649.html

[leomachado666]

Hello again,

i am following these instructions:
https://github.com/orbeon/orbeon-forms/wiki/Installation-~-Relational-Database-Setup
I am now trying to make a connection with Jboss and Oracle, i managed to
create the datasource and test it correctly, so far so good, the jboss is
recognizing the oracle DB.

Now to configure orbeon and oracle

--
View this message in context: http://discuss.orbeon.com/Setting-up-Oracle-Database-and-Orbeon-tp4660644p4660650.html

[Alessandro Vernet]

Leo,

I'm glad you made some good progress with the database setup.

For the install on JBoss, maybe this can help:
http://doc.orbeon.com/install/jboss.html.

For the properties, whatever you app server is, you can get started by
renaming the properties-local.xml.template to properties-local.xml. For some
background on this, see:
http://doc.orbeon.com/setup/properties/index.html#setting-and-overriding-properties.

Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet

--
View this message in context: http://discuss.orbeon.com/Setting-up-Oracle-Database-and-Orbeon-tp4660644p4660652.html

[leomachado666]

Hello, Orbeon is running, but the problem is the script that appears here:
https://github.com/orbeon/orbeon-forms/blob/master/src/resources/apps/fr/persistence/relational/ddl/oracle-4_10.sql

Does not work for oracle,
ie.
This does not work:
CREATE OR REPLACE TRIGGER ORBEON.orbeon_form_data_xml BEFORE INSERT ON
ORBEON.orbeon_form_data FOR EACH ROW BEGIN IF :new.xml_clob IS NOT NULL THEN
:new.xml := XMLType
(
:new.xml_clob
)

(i placed ORBEON. first because its a reference to the schema).


this does not work either:
--CREATE INDEX ORBEON.orbeon_form_definition_x ON
ORBEON.orbeon_form_definition
--(
-- xml -- does not work
--)
--INDEXTYPE IS ctxsys.context PARAMETERS ('sync (on commit)') -- does not
work
--;
--CREATE INDEX ORBEON.orbeon_form_data_x ON ORBEON.orbeon_form_data
--(
-- xml
--)

neither will this line work:
--XMLTYPE COLUMN xml STORE AS BASICFILE CLOB

Configuring orbeon and jboss is another issue, there are still some small
errors that might be related to not having the tables created...
in MySQL (when i used tomcat before), Orbeon worked correctly, i mean, the
sql command for creating the triggers and form definitions worked correctly,
but oracle is another world!

--
View this message in context: http://discuss.orbeon.com/Setting-up-Oracle-Database-and-Orbeon-tp4660644p4660666.html

[Alessandro Vernet]

Hi Leo,

So you're saying you're seeing that error when creating the trigger. What
error message are getting from Oracle? And on what version of Oracle is
this?

Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet

--
View this message in context: http://discuss.orbeon.com/Setting-up-Oracle-Database-and-Orbeon-tp4660644p4660746.html