How to configure Oracle 10g DB in Gatein

[meghaattcs]

Hi,

I am using Oracle 10g DB to connect to Jboss server 6.x packaged with Gatein. (trying to create tables while first time server startup)

Here is how my configuration.properties looks like. (please see the JCR part)

My DB name is 'ucportal'. I have also made sure the user "<username>" as sufficient privileges.

#

gatein.conf.dir=${jboss.server.home.dir}/conf/gatein

gatein.data.dir=${jboss.server.data.dir}/gatein

# DB

gatein.db.data.dir=${gatein.data.dir}/db

# JCR

gatein.jcr.config.type=local

gatein.jcr.datasource.name=java:jdbcjcr

gatein.jcr.datasource.dialect=auto

gatein.jcr.datasource.driver=oracle.jdbc.driver.OracleDriver

gatein.jcr.datasource.url=jdbc:oracle:thin@<ip addr of my DB>:ucportal

gatein.jcr.datasource.username=<username>

gatein.jcr.datasource.password=<password>

gatein.jcr.data.dir=${gatein.data.dir}/jcr

gatein.jcr.storage.data.dir=${gatein.jcr.data.dir}/values

gatein.jcr.cache.config=classpath:/conf/jcr/jbosscache/${gatein.jcr.config.type}/config.xml

gatein.jcr.lock.cache.config=classpath:/conf/jcr/jbosscache/${gatein.jcr.config.type}/lock-config.xml

gatein.jcr.index.data.dir=${gatein.jcr.data.dir}/lucene

gatein.jcr.index.changefilterclass=org.exoplatform.services.jcr.impl.core.query.DefaultChangesFilter

gatein.jcr.index.cache.config=classpath:/conf/jcr/jbosscache/cluster/indexer-config.xml

gatein.jcr.jgroups.config=classpath:/conf/jcr/jbosscache/cluster/udp-mux.xml

# IDM

gatein.idm.datasource.name=java:jdbcidm

gatein.idm.datasource.driver=org.hsqldb.jdbcDriver

gatein.idm.datasource.url=jdbc:hsqldb:file:${gatein.db.data.dir}/data/jdbcidm_${name}

gatein.idm.datasource.username=sa

gatein.idm.datasource.password=

# EMail

gatein.email.smtp.username=

gatein.email.smtp.password=

gatein.email.smtp.host=smtp.gmail.com

gatein.email.smtp.port=465

gatein.email.smtp.starttls.enable=true

gatein.email.smtp.auth=true

gatein.email.smtp.socketFactory.port=465

gatein.email.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory

# Global portlet.xml

gatein.portlet.config=${gatein.conf.dir}/portlet.xml

# Web

gatein.web.compressor.js.level=simple

This is the only file I have made changes to.

My issue is when I start JBoss server (6.x) I get errors like (sample file attached. see 'server.log' attached)

07:42:29,415 ERROR [JDBCWorkspaceDataContainer] Error of init db org.exoplatform.services.jcr.impl.util.jdbc.DBInitializerException: Could not create db schema of DataSource: 'system'. Reason: ORA-01031: insufficient privileges

; . Last command: CREATE OR REPLACE trigger BI_JCR_SVALUE    before insert on JCR_SVALUE    for each row  begin    SELECT JCR_SVALUE_SEQ.nextval INTO :NEW.ID FROM dual;  end;: org.exoplatform.services.jcr.impl.util.jdbc.DBInitializerException: Could not create db schema of DataSource: 'system'. Reason: ORA-01031: insufficient privileges

; . Last command: CREATE OR REPLACE trigger BI_JCR_SVALUE    before insert on JCR_SVALUE    for each row  begin    SELECT JCR_SVALUE_SEQ.nextval INTO :NEW.ID FROM dual;  end;

        at org.exoplatform.services.jcr.impl.util.jdbc.DBInitializer.init(DBInitializer.java:476) [:1.14.0-CR1]

        at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.CQJDBCWorkspaceDataContainer.initDatabase(CQJDBCWorkspaceDataContainer.java:338) [:1.14.0-CR1]

        at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCWorkspaceDataContainer.<init>(JDBCWorkspaceDataContainer.java:455) [:1.14.0-CR1]

        at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.CQJDBCWorkspaceDataContainer.<init>(CQJDBCWorkspaceDataContainer.java:78) [:1.14.0-CR1]

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [:1.6.0_21]

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) [:1.6.0_21]

My question is is there any other configuration that needs to be done? I have heard about oracle-ds.xml file? Is this required to be configured under /deploy directory?