How to configure Oracle 10g DB in Gatein
meghaattcs Jun 21, 2011 1:45 AMHi,
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=
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?
-
server.log.zip 27.5 KB