6 Replies Latest reply on Feb 24, 2011 3:13 PM by Peter Touny

    Gatein tables are not created on Oracle10g DB

    Peter Touny Newbie

      I am trying to configure GateIn to work over Oracle 10g DB as following in default/conf/gatein/configuration.properties

       

      # Data

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

       

       

      # DB

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

       

       

      # JCR

      gat ein.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:@localhost:1521:orcl

      gatein.jcr.datasource.username=jdbcjcr_portal

      gatein.jcr.datasource.password=jdbcjcr_portal

       

       

      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=oracle.jdbc.driver.OracleDriver

      gatein.idm.datasource.url=jdbc:oracle:thin:@localhost:1521:orcl

      gatein.idm.datasource.username=jdbcidm_portal

      gatein.idm.datasource.password=jdbcidm_portal

       

       

      when I start Gatein server I get errors like

       

      Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

       

       

              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

              at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)

              at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:925)

              at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1132)

              at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:977)

              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)

              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3500)

              at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3545)

              at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)

              at org.exoplatform.services.jcr.impl.config.JDBCConfigurationPersister.hasConfig(JDBCConfigurationPersister.java:236)

       

      attached is a complete log file

       

      When I check both schemas jdbcjcr_portal jdbc and jdbcidm_portal no tables are created

       

      Any idea what I did wrong?


        • 1. Gatein tables are not created on Oracle10g DB
          Michal Vanco Newbie

          Hi Peter,

           

          can you verify that your oracle DB instance do not contain any tables with jcr?

          (for example you already run GateIn before on the same database with different tablespaces)

           

          If yes, delete them all and start again.

           

          Or you can try to create new context for tablespaces. (right now you have context 'orcl')

           

          Regards,

          Michal Vanco

          1 of 1 people found this helpful
          • 2. Gatein tables are not created on Oracle10g DB
            Peter Touny Newbie

            Thanks Michal,

             

             

            Yes that helped there is a progress, tables are created in both schemas jdbcjcr_portal jdbc and jdbcidm_portal

             

             

             

             

            but now I have another error in the attachment error2.log somthing like

             

            Caused by: javax.jcr.RepositoryException: Repository 'repository' not found.

                      at org.exoplatform.services.jcr.impl.RepositoryServiceImpl.getRepository(RepositoryServiceImpl.java:219)

                      at org.exoplatform.services.jcr.impl.RepositoryServiceImpl.getDefaultRepository(RepositoryServiceImpl.java:200)

                      at org.exoplatform.services.jcr.impl.RepositoryServiceImpl.getCurrentRepository(RepositoryServiceImpl.java:194)

                      at org.exoplatform.commons.chromattic.AbstractContext.openSession(AbstractContext.java:103)

                      at org.exoplatform.commons.chromattic.Synchronization.doLogin(Synchronization.java:98)

                      at org.exoplatform.commons.chromattic.SynchronizedContext.doLogin(SynchronizedContext.java:46)

                      at org.exoplatform.commons.chromattic.ChromatticLifeCycle.doLogin(ChromatticLifeCycle.java:328)

                      at org.exoplatform.commons.chromattic.PortalSessionLifeCycle.login(PortalSessionLifeCycle.java:51)

                      at org.chromattic.core.api.ChromatticImpl.openSession(ChromatticImpl.java:55)

            • 3. Gatein tables are not created on Oracle10g DB
              Michal Vanco Newbie

              I can see that you have attached another error

               

              If you're getting 'repository' not found, please try to delete folders:

              data, work, log, tmp in your $GATEIN_HOME/server/default

               

              (it will make GateIn instance to be completely clean - some files was already created at your data folder before).

              + start with clean oracle instance again

               

              Michal

              • 4. Gatein tables are not created on Oracle10g DB
                Peter Touny Newbie

                Not yet there

                 

                I did delete those 4 folders and started with clean schemas jdbcjcr_portal jdbc and jdbcidm_portal

                 

                please check error3.log

                 

                Peter

                • 5. Gatein tables are not created on Oracle10g DB
                  Michal Vanco Newbie

                  Peter, you should have a look at this thread: http://community.jboss.org/message/585598

                   

                  What should definitely work: remove gatein-sample-portal.ear (extension), delete folder /profile/data and start with clean DB.

                   

                  Michal

                  • 6. Gatein tables are not created on Oracle10g DB
                    Peter Touny Newbie

                    thnx Michal

                     

                    this solved the issue

                     

                    have a nice day

                     

                    Peter