8 Replies Latest reply on Dec 14, 2011 2:14 AM by sushalendra Joshi

    GateIn on Oracle DataBase 10 g xe : page managment down

    pascal dev Newbie

      Hello,

       

      i am working on GateIn 3.0 final,

                              JBoss 5.1.0 (jdk 6),

                              Oracle Database 10 g Express Edition.

       

      i can launch the portal gatein with the classic site. We can create a new site, user, group, role. We can import portlet.

      But the page management is empty and we can not add a new page.

       

      this is the server/default/con/gatein/ configuration.properties file :

       

      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:@localhost: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.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:@localhost: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

       

      thank for your help.

        • 1. Re: GateIn on Oracle DataBase 10 g xe : page managment down
          Thomas Heute Master

          Any stacktrace ?

           

          I know we test against Oracle 10 and 11 (full versions though)

          • 2. Re: GateIn on Oracle DataBase 10 g xe : page managment down
            pascal dev Newbie

            Hello Thomas,

             

            there are no exception in the trace.

             

            I can not use the page management to create a page. The page managment is still empty after the creation process of page. The search of page does not working. But if i try to create an other page with the same id, a message say a page with the same id already exist.

             

            To create a page i use the button on the node edition. After, i use the page editor, and we can view this page. But the page managment is again empty.

             

            I give you the server log.

            • 3. Re: GateIn on Oracle DataBase 10 g xe : page managment down
              pascal dev Newbie

              Hello,

               

              I have installed a Oracle 9i database full version. I can do a connection to gateIn. The portal is working, but hte page managment is still empty. Where are the page data in tables of the database, in the jcr or idm database ?

               

              In the gateIn reference Guide, it is said we have to modify the $JBOSS_HOME/server/default/conf/gatein/configuration.properties file. But with the MySQL example, we modify directly gatein.ear/02portal.war/WEB-INF/conf/jcr/jcr-configuration file, why ?

               

              Thank for your help.

              • 4. Re: GateIn on Oracle DataBase 10 g xe : page managment down
                Antoine Herzog Master

                Hello,

                Where are the page data in tables of the database, in the jcr or idm database ?

                 

                In the gateIn reference Guide, it is said we have to modify the $JBOSS_HOME/server/default/conf/gatein/configuration.properties file.

                 

                But with the MySQL example, we modify directly gatein.ear/02portal.war/WEB-INF/conf/jcr/jcr-configuration file, why ?

                I am also intersted in the anwers of these two question...

                 

                anyone has an explaination ?

                 

                thanks,

                Antoine

                • 5. Re: GateIn on Oracle DataBase 10 g xe : page managment down
                  sushalendra Joshi Newbie

                  HI,

                   

                  Even I am facing same issue with mysql. If you resolve the issue. Please let me know the solution.

                  • 6. Re: GateIn on Oracle DataBase 10 g xe : page managment down
                    Antoine Herzog Master

                    globally : the problem usually comes from some trouble when trying to connect to the database and run with it.

                    the reading of data, and the storage of new data does not work, so the page management cannot run properly.

                     

                    for this, some few tracks :

                    - look in the logs, if the DataSources are properly set. (search for ""ds", you should find the lines where they is some info about them).

                    - check in the logs that there was no problem, when connecting to the data source, and using it. no exception "cannot connect to..." or "cannot ... datasource... etc..." ?

                    - if none of this kind of datasource problems, then look at the logs to see what exception are thrown.

                     

                    hope it helps,

                    Antoine

                    JBoss Portal and GateIn (JSR-286), JSF, Richfaces, J2EE, Drools, BRMS.

                    http://www.sysemo.com/Sysemo-expertise-portails-jboss-portal.php

                    • 7. Re: GateIn on Oracle DataBase 10 g xe : page managment down
                      Antoine Herzog Master

                      Where are the page data in tables of the database, in the jcr or idm database ?

                       

                      In the gateIn reference Guide, it is said we have to modify the $JBOSS_HOME/server/default/conf/gatein/configuration.properties file.

                       

                      But with the MySQL example, we modify directly gatein.ear      file, why ?

                       

                      along with miscellaneous installations in various environments, these questions have found answers :

                       

                      ****************

                      the page data are in the jcr... no doubt about that...

                      the idm database is only for the identity management (users, organisations, groups, etc...).

                       

                      ****************

                      the .../02portal.war/WEB-INF/conf/jcr/jcr-configuration file is where the configuration is done, for the jcr and datasource access to store the data.

                      this place is where to make the most flexible configuration.

                       

                      the $JBOSS_HOME/server/default/conf/gatein/configuration.properties is an upper layer, simplified, configuration.

                      it allows to defines some simple configuration of the datasources.

                       

                      ** flexible config

                      if you need some flexible configuration, to make a special customized setup of the datasources, then use the first one.

                      with this, you can also make some usual datasources files (xxxx-ds.xml file, in the deploy folder), to define the datasources, then set the configuration so the jcr uses these DS.

                       

                      to do so, you only need to keep a few properties in the configuration.properties file :

                      gatein.jcr.config.type=local

                      gatein.jcr.datasource.name=java:jdbcjcr

                      gatein.jcr.datasource.dialect=auto

                       

                      the other properties, that defines the datasource, are no longer needed.

                       

                      you need also to remove the BindReferencePlugin in the configuration :

                      - in the file "...l/02portal.war/WEB-INF/conf/jcr/jcr-configuration.xml"

                      - remove the component plugin with name "bind.datasource"

                      you can comment the definition that starts with :

                      <external-component-plugins>
                          <target-component>org.exoplatform.services.naming.InitialContextInitializer</target-component>
                                <component-plugin>
                                      <name>bind.datasource</name>
                                      <set-method>addPlugin</set-method>
                                      <type>org.exoplatform.services.naming.BindReferencePlugin</type>
                      ...
                      

                       

                       

                      as you can see in the definition of that component, this is where are used the properties that are defined in the configuration.properties file.

                      (portal.container.gatein.jcr.datasource.driver, portal.container.gatein.jcr.datasource.url, etc...)

                       

                      ** simple config

                      if you only need simple config, then only modify the properties in the configuration.properties file.

                       

                      hope it helps,...

                       

                      Antoine Herzog

                      Consultant JBoss Portal and GateIn (JSR-286), JSF, Richfaces, J2EE, Drools, BRMS.

                      • 8. Re: GateIn on Oracle DataBase 10 g xe : page managment down
                        sushalendra Joshi Newbie

                        Hi Antoine Herzog,

                         

                        Thanks for the reply. I tried these options still the issue persists.

                         

                        But issue is resolved by following steps

                        1. delete the gatein-sample-portal.ear

                        2. Create jdbcjcr_portal and jdbcidm_pportal schema in mysql server.

                        3. modify configuration.properties with mysql server details as mentioned below

                         

                        gatein.jcr.datasource.driver=com.mysql.jdbc.Driver
                        gatein.jcr.datasource.url=jdbc:mysql://localhost:3306/jdbcjcr_${name}
                        gatein.jcr.datasource.username=userid
                        gatein.jcr.datasource.password=password

                         

                        gatein.idm.datasource.driver=com.mysql.jdbc.Driver
                        gatein.idm.datasource.url=jdbc:mysql://localhost:3306/jdbcidm_${name}
                        gatein.idm.datasource.username=userid
                        gatein.idm.datasource.password=password

                         

                        Copy the mysql connector driver in the deploy/lib folder. The databases created in my sql. Page management is coming up properly.

                        Earlier I had issue with Gadets also. By this new stup the Gadget are coming up properly. All the issues related to migration of the portal db to my sql is resolved.

                         

                        Once again thanks for your response.