3 Replies Latest reply on Aug 18, 2010 3:31 PM by satish1982

    how use GateIn on Oracle database?

    fernando2010
    fernando2010 Aug 3, 2010 10:16 AM

      Hi all,


      I have a Oracle 9i database mounted on "192.168.0.1", exist a scheme called "PRO". so, I modify the "configuration.properties" file follow the Gatein forum's examples:

       

      # Data
      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.OracleDriver
      gatein.jcr.datasource.url=jdbc:oracle:thin:@192.168.0.1:1521:PRO
      gatein.jcr.datasource.username=myuser
      gatein.jcr.datasource.password=mypass

       

      gatein.jcr.data.dir=${gatein.data.dir}/jcr
      gatein.jcr.storage.data.dir=${gatein.jcr.data.dir}/values
      gatein.jcr.index.data.dir=${gatein.jcr.data.dir}/lucene
      gatein.jcr.index.changefilterclass=org.exoplatform.services.jcr.impl.core.query.DefaultChangesFilter

       

      # IDM
      gatein.idm.datasource.name=java:jdbcidm
      gatein.idm.datasource.driver=oracle.jdbc.OracleDriver
      gatein.idm.datasource.url=jdbc:oracle:thin:@192.168.0.1:1521:PRO
      gatein.idm.datasource.username=myuser
      gatein.idm.datasource.password=mypass

       

      later start the portal server with "run.bat", but it stop later in this point:

       

      etc....exoplatform.services.jcr.impl.proccess] <IMPORT-ALL>NON_EMPTY}}


              at org.jboss.classloader.spi.base.BaseClassLoader.loadClass(BaseClassLoader.java:448)
              at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
              at java.lang.Class.forName0(Native Method)
              at java.lang.Class.forName(Class.java:169)
              at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:760)
              ... 91 more
       
      and my portal (http://127.0.0.1:8080/portal) doesn't show nothing. where is my fail?

       

      Regards.