-
1. Re: GateIn on Oracle DataBase 10 g xe : page managment down
theute May 6, 2010 10:31 AM (in response to pascal_dev)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 May 6, 2010 11:13 AM (in response to theute)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.
-
log.txt.zip 15.6 KB
-
-
3. Re: GateIn on Oracle DataBase 10 g xe : page managment down
pascal_dev May 10, 2010 5:28 AM (in response to pascal_dev)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_h Jul 23, 2010 1:49 PM (in response to pascal_dev)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
ajsushil Dec 8, 2011 6:43 AM (in response to pascal_dev)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_h Dec 8, 2011 8:34 AM (in response to ajsushil)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_h Dec 8, 2011 9:10 AM (in response to antoine_h)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
ajsushil Dec 14, 2011 2:14 AM (in response to antoine_h)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=passwordgatein.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=passwordCopy 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.