0 Replies Latest reply on Jun 21, 2011 1:45 AM by Megha Shah

    How to configure Oracle 10g DB in Gatein

    Megha Shah Newbie

      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?