7 Replies Latest reply on Mar 18, 2011 10:41 AM by rraposa

    Gatein GateIn-3.1.0 Problems With Oracle

    lmono1982

      Hi everybody

       

      I configured Gatein with postgresql without problems , but with oracle [11g or 10 Express] don`t work.

       

       

       

      Here's my configuration :

       

      File: configuration.properties

      --------------------------------------------------------------------

       

      # 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.driver.OracleDriver

      gatein.jcr.datasource.url=jdbc:oracle:thin:@untitled:1521:XE

      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:@untitled:1521:XE

      gatein.idm.datasource.username=jdbcidm_portal

      gatein.idm.datasource.password=jdbcidm_portal

       

      # 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

      --------------------------------------

       

      The jar file is in

      /usr/local/gatein/server/default/lib "ojdbc14.jar"

       

      Before start,  Remove:

      gatein-sample-extension.ear gatein-sample-portal.ear gatein-sample-skin.war

       

       

      When try again start , first remove

      data work log tmp

       

       

       

      But does not start

       

      Error:

      17:15:05,703 WARN  [RootContainer] The portal container 'portal' doesn't not exist or it has not yet been registered, please check your PortalContainerDefinitions and the loading order.

       

       

      Other errors

      17:14:48,221 ERROR [STDERR] javax.jcr.RepositoryException: Repository 'repository' not found.

      17:14:48,221 ERROR [STDERR]     at org.exoplatform.services.jcr.impl.RepositoryServiceImpl.getRepository(RepositoryServiceImpl.java:219)

      17:14:48,221 ERROR [STDERR]     at org.exoplatform.services.jcr.ext.hierarchy.impl.NodeHierarchyCreatorImpl.processAddPathPlugin(NodeHierarchyCreatorImpl.java:158)

      17:14:48,221 ERROR [STDERR]     at org.exoplatform.services.jcr.ext.hierarchy.impl.NodeHierarchyCreatorImpl.start(NodeHierarchyCreatorImpl.java:76)

      17:14:48,221 ERROR [STDERR]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

       

       

      log attached "logGatein.log"

       

      ---------------------------------

      Note:

      Fedora 14

      java-1.6.0-openjdk-1.6.0.0-52.1.9.7.fc14.i686

       

      cat /root/.bash_profile

      # .bash_profile

       

      # Get the aliases and functions

      if [ -f ~/.bashrc ]; then

          . ~/.bashrc

      fi

       

      # User specific environment and startup programs

       

      PATH=$PATH:$HOME/bin

       

      export PATH

       

      LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib/

      ORACLE_HOME=/home/oracle/

      TNSNAMES=/home/oracle/network/admin/tnsnames.ora

       

      export LD_LIBRARY_PATH ORACLE_HOME TNSNAMES

       

      ---------------------

       

       

       

       

      Thanks for your help.

       


        • 1. Gatein GateIn-3.1.0 Problems With Oracle
          rraposa

          Try deleting the /data folder in your profile directory (e.g. /server/default/data), then startup GateIn and see what happens.

          • 2. Re: Gatein GateIn-3.1.0 Problems With Oracle
            lmono1982

            Hi Rich

             

            1.- I delete the data folder and drop/create database again

             

            with the next errors in the startup. (Attachments: /tmp/seconderror.tar.gz)

             

            Caused by: javax.jcr.RepositoryException: Invalid Internal QName 'T 

                                                                                    �����   [http://www.�.���  �:' Should start of '[': Invalid Internal QName 'T 

                                                                                                                                                                      �����   [http://www.�.���  �:' Should start of '['

                at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.CQJDBCStorageConnection.loadNodeRecord(CQJDBCStorageConnection.java:589)

                at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.CQJDBCStorageConnection.loadNodeFromTemporaryNodeData(CQJDBCStorageConnection.java:442)

                at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.CQJDBCStorageConnection.getChildNodesData(CQJDBCStorageConnection.java:212)

                at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager.getChildNodesData(WorkspacePersistentDataManager.java:468)

                at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.getChildNodesData(CacheableWorkspaceDataManager.java:566)

                at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.getChildNodesData(CacheableWorkspaceDataManager.java:359)

                at org.exoplatform.services.jcr.impl.core.query.lucene.MultiIndex.createIndex(MultiIndex.java:1322)

                at org.exoplatform.services.jcr.impl.core.query.lucene.MultiIndex.createInitialIndex(MultiIndex.java:378)

                ... 116 more

            Caused by: org.exoplatform.services.jcr.datamodel.IllegalNameException: Invalid Internal QName 'T 

                                                                                                                  �����   [http://www.�.���  �:' Should start of '['

                at org.exoplatform.services.jcr.datamodel.InternalQName.parse(InternalQName.java:60)

                at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.CQJDBCStorageConnection.loadNodeRecord(CQJDBCStorageConnection.java:490)

             

            2.-After i try again delete the data folder without drop the dabase.

             

            with the next errors in the startup. (Attachments: /tmp/3error.tar.gz)

             

            Caused by: java.sql.SQLException: ORA-00001: unique constraint (JDBCJCR_PORTAL.JCR_PK_SITEM) violated

             

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

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

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

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

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

                at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:630)

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

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

                at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2977)

                at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)

                at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.db.SingleDbJDBCConnection.addNodeRecord(SingleDbJDBCConnection.java:209)

                at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.add(JDBCStorageConnection.java:588)

                ... 103 more

            10:32:43,666 ERROR [STDERR] javax.jcr.RepositoryException: Repository 'repository' not found.

             

            Thanks for your help.

            • 3. Gatein GateIn-3.1.0 Problems With Oracle
              rraposa

              Imono, two questions:

               

              1. Is this a clean install of GateIn?

              2. Are you trying to use the exact same datasource for both the JCR and the IDM? If you are, try it again using different datasources.

               

              -Rich

              • 4. Gatein GateIn-3.1.0 Problems With Oracle
                lmono1982

                Hi Rich.

                 

                1-Yes.

                2.-I have  two datasource (JCR y IDM ).

                 

                 

                I will install another server with gatein to see if i had something wrong with the first instalation.

                I will comment the results of installation.

                 

                Thanks for your time.

                • 5. Gatein GateIn-3.1.0 Problems With Oracle
                  rraposa

                  Make sure your JCR and IDM are two different datasources, and let us know if you get it to work.

                  • 6. Re: Gatein GateIn-3.1.0 Problems With Oracle
                    zsv

                    I'm using GateIn with oracle 10gR2.

                    Here my configuration.properties:

                     

                    # Datagatein.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=jdbcjcr
                    gatein.jcr.datasource.dialect=auto
                    gatein.jcr.datasource.driver=oracle.jdbc.driver.OracleDriver
                    gatein.jcr.datasource.url=jdbc:oracle:thin:@172.16.1.30:1521:dev
                    gatein.jcr.datasource.username=gatein_portal
                    gatein.jcr.datasource.password=gatein_portal
                    
                    gatein.jcr.data.dir=${gatein.data.dir}/jcrgatein.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=jdbcidm
                    
                    gatein.idm.datasource.driver=oracle.jdbc.driver.OracleDriver
                    gatein.idm.datasource.url=jdbc:oracle:thin:@172.16.1.30:1521:dev
                    gatein.idm.datasource.username=gatein_portal
                    gatein.idm.datasource.password=gatein_portal
                    
                    
                    # 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
                    
                    
                    • 7. Re: Gatein GateIn-3.1.0 Problems With Oracle
                      rraposa

                      What language and charset is your JCR database using? After looking at your log file, the error is definitely a problem with your JCR database. Maybe try changing it to latin1 in your DB, drop all the tables, delete the /data folder, and start up GateIn again.