From mentioned logs it looks like those errors don't come from IDM. I think the stack trace in all cases goes via "org.exoplatform.services.jcr.impl.*" Bolek On 03/09/2010 09:15 AM, Michal Vančo wrote: > Hi, > > I'm dealing with problem to start GateIn with Oracle DB. > I always start with clean DB and use 2 datasource instances (JCR, IDM). > > There are 2 different issues: > Oracle10: > - ORA-00942: table or view does not exist (start on > org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0) > - only IDM schema is initialized, JCR not > > Oracle11: > - ORA-00972: identifier is too long (Cannot instantiate component class > org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) > - both schemas are created (IDM + JCR) > > To run on oracle, I change configuration in idm-configuration.xml and > jcr-configuration.xml, then copy jdbc driver and start. > I also add<property name="hibernate.hbm2ddl.auto" value="create-drop"/> > to idm-configuration.xml (recommended by Boleslaw Dawidowicz - it worked > on EPP, but not on GateIn trunk). > > There are links to log: > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > I would appreciate any help. > > Thanks in advance > Michal Vanco > > _______________________________________________ > gatein-dev mailing list > gatein-dev(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/gatein-dev

Yes Bolek, that's true. I can't explain myself the job in hudson on EPP5 (epp_ui_selenium_tests_oracle10): Because there was same problem - table or view does not exist (build #3), builds #5 and #7 were OK (GateIn started with no errors) and following builds again failed due the same problem as before. Regards, Michal Boleslaw Dawidowicz píše v Út 09. 03. 2010 v 09:59 +0100: > From mentioned logs it looks like those errors don't come from IDM. I > think the stack trace in all cases goes via > "org.exoplatform.services.jcr.impl.*" > > Bolek > > On 03/09/2010 09:15 AM, Michal Vančo wrote: > > Hi, > > > > I'm dealing with problem to start GateIn with Oracle DB. > > I always start with clean DB and use 2 datasource instances (JCR, IDM). > > > > There are 2 different issues: > > Oracle10: > > - ORA-00942: table or view does not exist (start on > > org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0) > > - only IDM schema is initialized, JCR not > > > > Oracle11: > > - ORA-00972: identifier is too long (Cannot instantiate component class > > org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) > > - both schemas are created (IDM + JCR) > > > > To run on oracle, I change configuration in idm-configuration.xml and > > jcr-configuration.xml, then copy jdbc driver and start. > > I also add<property name="hibernate.hbm2ddl.auto" value="create-drop"/> > > to idm-configuration.xml (recommended by Boleslaw Dawidowicz - it worked > > on EPP, but not on GateIn trunk). > > > > There are links to log: > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > > > I would appreciate any help. > > > > Thanks in advance > > Michal Vanco > > > > _______________________________________________ > > gatein-dev mailing list > > gatein-dev(a)lists.jboss.org > > https://lists.jboss.org/mailman/listinfo/gatein-dev _______________________________________________ gatein-dev mailing list gatein-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/gatein-dev

Hi, oracle11 now works, oracle10 not. See below... Peter Nedonosko wrote > Hi, > > about Oracle 10 and ' table or view does not exist': > the problem is possible if addConfig used in > org.exoplatform.services.jcr.config.RepositoryServiceConfiguration > (I found it in portal\trunk\examples\portal\war\src\main\webapp\WEB-INF\conf\sample-portal\jcr\jcr-configuration.xml) What you meant with addConfig plugin? Should I add <set-method>addConfig</set-method> in jcr-configuration.xml? Or how can I solve 'table or view does not exist' on oracle10?

> > if the database is creating from the scratch and if the configuration > persister got an answer from the Oracle - your table exists in > isDbInitialized(): > ResultSet trs = con.getMetaData().getTables(null, null, configTableName, null); > return trs.next(); // true = yes > > but then Oracle fails with > PreparedStatement ps = con.prepareStatement("SELECT COUNT(*) FROM " + > configTableName + " WHERE NAME=?"); > ps.executeQuery(); // here > > but I have to reproduce it first... > does Oracle 10 and 11 runs on clean database from the start? > or just restarted on existing db for Oracle 11? Always on clean DBs. > > about Oracle11: > seems it's related to JBossCache loader, it creates a table longer of > 30 symbols (ORA-00972: identifier is too long). > Why it's not a problem for Oracle10 or why JBossCache acts in > different way on Oracle10 or etc... > try to fix the problem with shorten table name from repository-configuration.xml > e.g. > <property name="jbosscache-cl-cache.jdbc.table.name" value="lock_portalsys" /> > instead of > <property name="jbosscache-cl-cache.jdbc.table.name" > value="jcrlock_portal_system" /> > it should helps. I shortened all table names in repository-configuration.xml and GateIn on Oracle11 started without "identifier is too long" error. There is job when it starts for the first time: http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... I think that it would be better to edit configuration, because editing table names before running gatein isn't a good way. > > Regards, > Peter > > > On Tue, Mar 9, 2010 at 11:24 AM, Michal Vančo <mvanco(a)redhat.com&gt; wrote: > > Yes Bolek, that's true. > > I can't explain myself the job in hudson on EPP5 (epp_ui_selenium_tests_oracle10): > > Because there was same problem - table or view does not exist (build > > #3), builds #5 and #7 were OK (GateIn started with no errors) and > > following builds again failed due the same problem as before. > > > > Regards, > > Michal > > > > Boleslaw Dawidowicz píše v Út 09. 03. 2010 v 09:59 +0100: > >> From mentioned logs it looks like those errors don't come from IDM. I > >> think the stack trace in all cases goes via > >> "org.exoplatform.services.jcr.impl.*" > >> > >> Bolek > >> > >> On 03/09/2010 09:15 AM, Michal Vančo wrote: > >> > Hi, > >> > > >> > I'm dealing with problem to start GateIn with Oracle DB. > >> > I always start with clean DB and use 2 datasource instances (JCR, IDM). > >> > > >> > There are 2 different issues: > >> > Oracle10: > >> > - ORA-00942: table or view does not exist (start on > >> > org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0 ) > >> > - only IDM schema is initialized, JCR not > >> > > >> > Oracle11: > >> > - ORA-00972: identifier is too long (Cannot instantiate component class > >> > org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) > >> > - both schemas are created (IDM + JCR) > >> > > >> > To run on oracle, I change configuration in idm-configuration.xml and > >> > jcr-configuration.xml, then copy jdbc driver and start. > >> > I also add<property name="hibernate.hbm2ddl.auto" value="create-drop"/> > >> > to idm-configuration.xml (recommended by Boleslaw Dawidowicz - it worked > >> > on EPP, but not on GateIn trunk). > >> > > >> > There are links to log: > >> > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > >> > > >> > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > >> > > >> > > >> > I would appreciate any help. > >> > > >> > Thanks in advance > >> > Michal Vanco > >> > > >> > _______________________________________________ > >> > gatein-dev mailing list > >> > gatein-dev(a)lists.jboss.org > >> > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > _______________________________________________ > > gatein-dev mailing list > > gatein-dev(a)lists.jboss.org > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > Thanks, Michal _______________________________________________ gatein-dev mailing list gatein-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/gatein-dev

Hi Michal, could you please create JIRA issues in the eXo JCR project ( https://jira.jboss.org/jira/browse/EXOJCR ) with all the information needed to allow us to reproduce? On Wed, Mar 10, 2010 at 1:46 PM, Nicolas Filotto < nicolas.filotto(a)gmail.com > wrote:

On Wed, Mar 10, 2010 at 1:29 PM, Michal Vančo < mvanco(a)redhat.com > wrote:

oracle11 now works, oracle10 not. See below... Peter Nedonosko wrote Hi, > about Oracle 10 and ' table or view does not exist': > the problem is possible if addConfig used in > org.exoplatform.services.jcr.config.RepositoryServiceConfiguration > (I found it in portal\trunk\examples\portal\war\src\main\webapp\WEB-INF\conf\sample-portal\jcr\jcr-configuration.xml) What you meant with addConfig plugin? Should I add <set-method>addConfig</set-method> in jcr-configuration.xml? Or how can I solve 'table or view does not exist' on oracle10?

On Wed, Mar 10, 2010 at 3:01 PM, Prabhat Jha <pjha(a)redhat.com&gt; wrote: > Hi Nicolas, > > Yes, a jira is on the way but way to reproduce this problem is quite simple. > You start with a clean Oracle 10 database instance and see the problem > during startup. It would make sense to have this issue solved or have a work > around before GateIn GA. > > Quick questions: >  As per oracle11 finding, is JCR config (table names) going to be updated > across the board? > Also, I am wondiering given that Oracle 10 has been around for a while, I am > wondering what has changed in the latest JCR that it does not work here. Did > the last GA version work? > > Thanks, > Prabhat > > > > ----- "Nicolas Filotto" <nicolas.filotto(a)gmail.com&gt; wrote: >> Hi Michal, could you please create JIRA issues in the eXo JCR project >> (https://jira.jboss.org/jira/browse/EXOJCR) with all the information needed >> to allow us to reproduce? >> >> >> On Wed, Mar 10, 2010 at 1:46 PM, Nicolas Filotto >> <nicolas.filotto(a)gmail.com&gt; wrote: >> >> >> > >> > >> > >> > On Wed, Mar 10, 2010 at 1:29 PM, Michal Vančo <mvanco(a)redhat.com&gt; wrote: >> > >>> >>> Hi, >>> > >>> > oracle11 now works, oracle10 not. See below... >>> > >>> > Peter Nedonosko wrote >>> > >>> > Hi, >>> > > >>> > > about Oracle 10 and ' table or view does not exist': >>> > > the problem is possible if addConfig used in >>> > > org.exoplatform.services.jcr.config.RepositoryServiceConfiguration >>> > > (I found it in >>> > > portal\trunk\examples\portal\war\src\main\webapp\WEB-INF\conf\sample-portal\jcr\jcr-configuration.xml) >>> > >>> > >>> What you meant with addConfig plugin? >>> > Should I add <set-method>addConfig</set-method> in >>> > jcr-configuration.xml? >>> > Or how can I solve 'table or view does not exist' on oracle10? the error is due to a use of addConfig plugin, and I just described the way how it occurs with thoughts what may happens inside. why it's only a Oracle10 problem it's still not clear. as from the JCR logic all steps are valid and should works for the moment. it will help if you'll send me your Oracle tablespace/database/schema/user/rights script, I'll be able to setup similar env on my side. >>> > >> >> > >> I guess it is not related since it works with other databases >> > >>> >>> > > >>> > > if the database is creating from the scratch and if the configuration >>> > > persister got an answer from the Oracle - your table exists in >>> > > isDbInitialized(): >>> > > ResultSet trs = con.getMetaData().getTables(null, null, >>> > > configTableName, null); >>> > > return trs.next(); // true = yes >>> > > >>> > > but then Oracle fails with >>> > > PreparedStatement ps = con.prepareStatement("SELECT COUNT(*) FROM " + >>> > > configTableName + " WHERE NAME=?"); >>> > > ps.executeQuery(); // here >>> > > >>> > > but I have to reproduce it first... >>> > > does Oracle 10 and 11 runs on clean database from the start? >>> > > or just restarted on existing db for Oracle 11? >>> > >>> > >>> Always on clean DBs. >>> > >>> > > >>> > > about Oracle11: >>> > > seems it's related to JBossCache loader, it creates a table longer of >>> > > 30 symbols (ORA-00972: identifier is too long). >>> > > Why it's not a problem for Oracle10 or why JBossCache acts in >>> > > different way on Oracle10 or etc... >>> > > try to fix the problem with shorten table name from >>> > > repository-configuration.xml >>> > > e.g. >>> > > <property name="jbosscache-cl-cache.jdbc.table.name" >>> > > value="lock_portalsys" /> >>> > > instead of >>> > > <property name="jbosscache-cl-cache.jdbc.table.name" >>> > > value="jcrlock_portal_system" /> >>> > > it should helps. >>> > >>> > >>> I shortened all table names in repository-configuration.xml and GateIn >>> > on Oracle11 started without "identifier is too long" error. >>> > >>> > There is job when it starts for the first time: >>> > >>> > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >>> > >>> > I think that it would be better to edit configuration, because editing >>> > table names before running gatein isn't a good way. >>> > >>> > > >>> > > Regards, >>> > > Peter >>> > > >>> > > >>> > > On Tue, Mar 9, 2010 at 11:24 AM, Michal Vančo <mvanco(a)redhat.com&gt; >>> > > wrote: >>> > > > Yes Bolek, that's true. >>> > > > I can't explain myself the job in hudson on EPP5 >>> > > > (epp_ui_selenium_tests_oracle10): >>> > > > Because there was same problem - table or view does not exist >>> > > > (build >>> > > > #3), builds #5 and #7 were OK (GateIn started with no errors) and >>> > > > following builds again failed due the same problem as before. >>> > > > >>> > > > Regards, >>> > > > Michal >>> > > > >>> > > > Boleslaw Dawidowicz píše v Út 09. 03. 2010 v 09:59 +0100: >>> > > >> From mentioned logs it looks like those errors don't come from >>> > > >> IDM. I >>> > > >> think the stack trace in all cases goes via >>> > > >> "org.exoplatform.services.jcr.impl.*" >>> > > >> >>> > > >> Bolek >>> > > >> >>> > > >> On 03/09/2010 09:15 AM, Michal Vančo wrote: >>> > > >> > Hi, >>> > > >> > >>> > > >> > I'm dealing with problem to start GateIn with Oracle DB. >>> > > >> > I always start with clean DB and use 2 datasource instances >>> > > >> > (JCR, IDM). >>> > > >> > >>> > > >> > There are 2 different issues: >>> > > >> > Oracle10: >>> > > >> > - ORA-00942: table or view does not exist (start on >>> > > >> > >>> > > >> > org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0) >>> > > >> > - only IDM schema is initialized, JCR not >>> > > >> > >>> > > >> > Oracle11: >>> > > >> > - ORA-00972: identifier is too long (Cannot instantiate >>> > > >> > component class >>> > > >> > >>> > > >> > org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) >>> > > >> > - both schemas are created (IDM + JCR) >>> > > >> > >>> > > >> > To run on oracle, I change configuration in >>> > > >> > idm-configuration.xml and >>> > > >> > jcr-configuration.xml, then copy jdbc driver and start. >>> > > >> > I also add<property name="hibernate.hbm2ddl.auto" >>> > > >> > value="create-drop"/> >>> > > >> > to idm-configuration.xml (recommended by Boleslaw Dawidowicz - >>> > > >> > it worked >>> > > >> > on EPP, but not on GateIn trunk). >>> > > >> > >>> > > >> > There are links to log: >>> > > >> > >>> > > >> > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >>> > > >> > >>> > > >> > >>> > > >> > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >>> > > >> > >>> > > >> > >>> > > >> > I would appreciate any help. >>> > > >> > >>> > > >> > Thanks in advance >>> > > >> > Michal Vanco >>> > > >> > >>> > > >> > _______________________________________________ >>> > > >> > gatein-dev mailing list >>> > > >> > gatein-dev(a)lists.jboss.org >>> > > >> > https://lists.jboss.org/mailman/listinfo/gatein-dev >>> > > > >>> > > > >>> > > > _______________________________________________ >>> > > > gatein-dev mailing list >>> > > > gatein-dev(a)lists.jboss.org >>> > > > https://lists.jboss.org/mailman/listinfo/gatein-dev >>> > > > >>> > >>> > >>> > >>> Thanks, >>> > Michal >>> > >>> > _______________________________________________ >>> > gatein-dev mailing list >>> > gatein-dev(a)lists.jboss.org >>> > https://lists.jboss.org/mailman/listinfo/gatein-dev >>> > >> >> > >> >> > -- >> > >> > Nicolas Filotto >> > JCR Product Manager >> > Project Manager >> > eXo Platform SAS >> > nicolas.filotto(a)exoplatform.com >> > +33 (0)6 31 32 92 19 >> > > >> > >> -- >> Nicolas Filotto >> JCR Product Manager >> Project Manager >> eXo Platform SAS >> nicolas.filotto(a)exoplatform.com >> +33 (0)6 31 32 92 19 >> >> _______________________________________________ gatein-dev mailing list >> gatein-dev(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/gatein-dev > _______________________________________________ > gatein-dev mailing list > gatein-dev(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/gatein-dev > >

Hi Nicolas, Yes, a jira is on the way but way to reproduce this problem is quite simple. You start with a clean Oracle 10 database instance and see the problem during startup. It would make sense to have this issue solved or have a work around before GateIn GA.

Quick questions: As per oracle11 finding, is JCR config (table names) going to be updated across the board?

Also, I am wondiering given that Oracle 10 has been around for a while, I am wondering what has changed in the latest JCR that it does not work here. Did the last GA version work?

Thanks, Prabhat ----- "Nicolas Filotto" <nicolas.filotto(a)gmail.com&gt; wrote: > Hi Michal, could you please create JIRA issues in the eXo JCR project ( https://jira.jboss.org/jira/browse/EXOJCR) with all the information needed to allow us to reproduce? > > > On Wed, Mar 10, 2010 at 1:46 PM, Nicolas Filotto < nicolas.filotto(a)gmail.com&gt; wrote: > > > > > > > > > > > On Wed, Mar 10, 2010 at 1:29 PM, Michal Vančo <mvanco(a)redhat.com&gt;wrote: > > >> >> Hi, >> > >> > oracle11 now works, oracle10 not. See below... >> > >> > Peter Nedonosko wrote >> > >> > Hi, >> > > >> > > about Oracle 10 and ' table or view does not exist': >> > > the problem is possible if addConfig used in >> > > org.exoplatform.services.jcr.config.RepositoryServiceConfiguration >> > > (I found it in >> portal\trunk\examples\portal\war\src\main\webapp\WEB-INF\conf\sample-portal\jcr\jcr-configuration.xml) >> > >> > >> What you meant with addConfig plugin? >> > Should I add <set-method>addConfig</set-method> in >> > jcr-configuration.xml? >> > Or how can I solve 'table or view does not exist' on oracle10? >> > > > > > > I guess it is not related since it works with other databases > > >> >> >> > > >> > > if the database is creating from the scratch and if the configuration >> > > persister got an answer from the Oracle - your table exists in >> > > isDbInitialized(): >> > > ResultSet trs = con.getMetaData().getTables(null, null, >> configTableName, null); >> > > return trs.next(); // true = yes >> > > >> > > but then Oracle fails with >> > > PreparedStatement ps = con.prepareStatement("SELECT COUNT(*) FROM " + >> > > configTableName + " WHERE NAME=?"); >> > > ps.executeQuery(); // here >> > > >> > > but I have to reproduce it first... >> > > does Oracle 10 and 11 runs on clean database from the start? >> > > or just restarted on existing db for Oracle 11? >> > >> > >> Always on clean DBs. >> > >> >> > > >> > > about Oracle11: >> > > seems it's related to JBossCache loader, it creates a table longer of >> > > 30 symbols (ORA-00972: identifier is too long). >> > > Why it's not a problem for Oracle10 or why JBossCache acts in >> > > different way on Oracle10 or etc... >> > > try to fix the problem with shorten table name from >> repository-configuration.xml >> > > e.g. >> > > <property name="jbosscache-cl-cache.jdbc.table.name" >> value="lock_portalsys" /> >> > > instead of >> > > <property name="jbosscache-cl-cache.jdbc.table.name" >> > > value="jcrlock_portal_system" /> >> > > it should helps. >> > >> > >> I shortened all table names in repository-configuration.xml and GateIn >> > on Oracle11 started without "identifier is too long" error. >> > >> > There is job when it starts for the first time: >> > >> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >> > >> > I think that it would be better to edit configuration, because editing >> > table names before running gatein isn't a good way. >> > >> >> > > >> > > Regards, >> > > Peter >> > > >> > > >> > > On Tue, Mar 9, 2010 at 11:24 AM, Michal Vančo <mvanco(a)redhat.com&gt; >> wrote: >> > > > Yes Bolek, that's true. >> > > > I can't explain myself the job in hudson on EPP5 >> (epp_ui_selenium_tests_oracle10): >> > > > Because there was same problem - table or view does not exist >> (build >> > > > #3), builds #5 and #7 were OK (GateIn started with no errors) and >> > > > following builds again failed due the same problem as before. >> > > > >> > > > Regards, >> > > > Michal >> > > > >> > > > Boleslaw Dawidowicz píše v Út 09. 03. 2010 v 09:59 +0100: >> > > >> From mentioned logs it looks like those errors don't come from >> IDM. I >> > > >> think the stack trace in all cases goes via >> > > >> "org.exoplatform.services.jcr.impl.*" >> > > >> >> > > >> Bolek >> > > >> >> > > >> On 03/09/2010 09:15 AM, Michal Vančo wrote: >> > > >> > Hi, >> > > >> > >> > > >> > I'm dealing with problem to start GateIn with Oracle DB. >> > > >> > I always start with clean DB and use 2 datasource instances >> (JCR, IDM). >> > > >> > >> > > >> > There are 2 different issues: >> > > >> > Oracle10: >> > > >> > - ORA-00942: table or view does not exist (start on >> > > >> > >> org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0 >> ) >> > > >> > - only IDM schema is initialized, JCR not >> > > >> > >> > > >> > Oracle11: >> > > >> > - ORA-00972: identifier is too long (Cannot instantiate >> component class >> > > >> > >> org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) >> > > >> > - both schemas are created (IDM + JCR) >> > > >> > >> > > >> > To run on oracle, I change configuration in >> idm-configuration.xml and >> > > >> > jcr-configuration.xml, then copy jdbc driver and start. >> > > >> > I also add<property name="hibernate.hbm2ddl.auto" >> value="create-drop"/> >> > > >> > to idm-configuration.xml (recommended by Boleslaw Dawidowicz - >> it worked >> > > >> > on EPP, but not on GateIn trunk). >> > > >> > >> > > >> > There are links to log: >> > > >> > >> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >> > > >> > >> > > >> > >> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >> > > >> > >> > > >> > >> > > >> > I would appreciate any help. >> > > >> > >> > > >> > Thanks in advance >> > > >> > Michal Vanco >> > > >> > >> > > >> > _______________________________________________ >> > > >> > gatein-dev mailing list >> > > >> > gatein-dev(a)lists.jboss.org >> > > >> > https://lists.jboss.org/mailman/listinfo/gatein-dev >> > > > >> > > > >> > > > _______________________________________________ >> > > > gatein-dev mailing list >> > > > gatein-dev(a)lists.jboss.org >> > > > https://lists.jboss.org/mailman/listinfo/gatein-dev >> > > > >> > >> > >> > >> Thanks, >> > Michal >> > >> >> > _______________________________________________ >> > gatein-dev mailing list >> > gatein-dev(a)lists.jboss.org >> > https://lists.jboss.org/mailman/listinfo/gatein-dev >> > >> > > > > > > -- > > > > Nicolas Filotto > > JCR Product Manager > > Project Manager > > eXo Platform SAS > > nicolas.filotto(a)exoplatform.com > > +33 (0)6 31 32 92 19 > > > > > -- > Nicolas Filotto > JCR Product Manager > Project Manager > eXo Platform SAS > nicolas.filotto(a)exoplatform.com > +33 (0)6 31 32 92 19 > > _______________________________________________ gatein-dev mailing list gatein-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/gatein-dev

Prabhat and/or Michal, could you please provide the answers of the questions asked by Peter and me. We cannot reproduce so far, so we need your help. Please note that we blocked the release of GA because of this last issue, so we need your help to fix it asap.

On Wed, Mar 10, 2010 at 3:02 PM, Nicolas Filotto < nicolas.filotto(a)gmail.com > wrote:

Hi Nicolas, Yes, a jira is on the way but way to reproduce this problem is quite simple. You start with a clean Oracle 10 database instance and see the problem during startup. It would make sense to have this issue solved or have a work around before GateIn GA.

-- Nicolas Filotto JCR Product Manager Project Manager eXo Platform SAS nicolas.filotto(a)exoplatform.com +33 (0)6 31 32 92 19

I have created https://jira.jboss.org/jira/browse/EXOJCR-582 for oracle11 issue. Please check that I have right affects and fix versions.

The version of GateIn and JCR is the one that's in GateIn trunk currently. The way our environment is setup is that we have one Oracle10 DB servers and different usernames which I believe means different schemas in Oracle for different tests (gatein-ui, gatein-jcr etc) configured on that server. I would have to wait for Michal to show up for info. He needed to attend to some personal stuff : hospital to check on his mom. But in your environment, you have GateIn starting fine on Oracle 10, right?

thanks, prabhat ----- "Nicolas Filotto" <nicolas.filotto(a)gmail.com&gt; wrote: > Prabhat and/or Michal, could you please provide the answers of the questions asked by Peter and me. We cannot reproduce so far, so we need your help. Please note that we blocked the release of GA because of this last issue, so we need your help to fix it asap. > > Thank you in advance, BR, Nicolas > > On Wed, Mar 10, 2010 at 3:02 PM, Nicolas Filotto < nicolas.filotto(a)gmail.com&gt; wrote: > > > Hi Prabhat, > > > > > my comments inline > > > > > > On Wed, Mar 10, 2010 at 2:01 PM, Prabhat Jha <pjha(a)redhat.com&gt; wrote: > > > > >> >> > Hi Nicolas, >> > >> > Yes, a jira is on the way but way to reproduce this problem is quite >> simple. You start with a clean Oracle 10 database instance and see the >> problem during startup. It would make sense to have this issue solved or >> have a work around before GateIn GA. >> > >> > It is not enough, we need to know, which exact version of eXo JCR > and GateIn, you are using and the content of the files that you modified. > could you please open a connexion with the same account and give us the > list of tables that you can see > > >> >> > >> > Quick questions: >> > As per oracle11 finding, is JCR config (table names) going to be >> updated across the board? >> > >> > You mean to change the sql scripts for oracle 11G? If so please create a > JIRA, it will be done in the next maintenance version of eXo JCR which will > be 1.12.1 GA planned for the end of March > > >> >> > Also, I am wondiering given that Oracle 10 has been around for a while, >> I am wondering what has changed in the latest JCR that it does not work >> here. Did the last GA version work? >> > >> > Hard to say before reproducing your bug > > >> >> > >> > Thanks, >> > Prabhat >> >> > >> > >> > >> > ----- "Nicolas Filotto" <nicolas.filotto(a)gmail.com&gt; wrote: >> > > Hi Michal, could you please create JIRA issues in the eXo JCR project >> (https://jira.jboss.org/jira/browse/EXOJCR) with all the information >> needed to allow us to reproduce? >> > > >> > > >> > > On Wed, Mar 10, 2010 at 1:46 PM, Nicolas Filotto < >> nicolas.filotto(a)gmail.com&gt; wrote: >> > > >>> >>> >>> > > >>> > > >>> > > >>> > On Wed, Mar 10, 2010 at 1:29 PM, Michal Vančo <mvanco(a)redhat.com&gt;wrote: >>> > > >>>> >>>> Hi, >>>> > > >>>> > > oracle11 now works, oracle10 not. See below... >>>> > > >>>> > > Peter Nedonosko wrote >>>> > > >>>> > Hi, >>>> > > > >>>> > > > about Oracle 10 and ' table or view does not exist': >>>> > > > the problem is possible if addConfig used in >>>> > > > >>>> org.exoplatform.services.jcr.config.RepositoryServiceConfiguration >>>> > > > (I found it in >>>> portal\trunk\examples\portal\war\src\main\webapp\WEB-INF\conf\sample-portal\jcr\jcr-configuration.xml) >>>> > > >>>> > > >>>> What you meant with addConfig plugin? >>>> > > Should I add <set-method>addConfig</set-method> in >>>> > > jcr-configuration.xml? >>>> > > Or how can I solve 'table or view does not exist' on oracle10? >>>> > > >>> >>> >>> > > >>> I guess it is not related since it works with other databases >>> > >>>> >>>> >>>> > > > >>>> > > > if the database is creating from the scratch and if the >>>> configuration >>>> > > > persister got an answer from the Oracle - your table exists in >>>> > > > isDbInitialized(): >>>> > > > ResultSet trs = con.getMetaData().getTables(null, null, >>>> configTableName, null); >>>> > > > return trs.next(); // true = yes >>>> > > > >>>> > > > but then Oracle fails with >>>> > > > PreparedStatement ps = con.prepareStatement("SELECT COUNT(*) FROM >>>> " + >>>> > > > configTableName + " WHERE NAME=?"); >>>> > > > ps.executeQuery(); // here >>>> > > > >>>> > > > but I have to reproduce it first... >>>> > > > does Oracle 10 and 11 runs on clean database from the start? >>>> > > > or just restarted on existing db for Oracle 11? >>>> > > >>>> > > >>>> Always on clean DBs. >>>> > > >>>> >>>> > > > >>>> > > > about Oracle11: >>>> > > > seems it's related to JBossCache loader, it creates a table >>>> longer of >>>> > > > 30 symbols (ORA-00972: identifier is too long). >>>> > > > Why it's not a problem for Oracle10 or why JBossCache acts in >>>> > > > different way on Oracle10 or etc... >>>> > > > try to fix the problem with shorten table name from >>>> repository-configuration.xml >>>> > > > e.g. >>>> > > > <property name="jbosscache-cl-cache.jdbc.table.name" >>>> value="lock_portalsys" /> >>>> > > > instead of >>>> > > > <property name="jbosscache-cl-cache.jdbc.table.name" >>>> > > > value="jcrlock_portal_system" /> >>>> > > > it should helps. >>>> > > >>>> > > >>>> I shortened all table names in repository-configuration.xml and GateIn >>>> > > on Oracle11 started without "identifier is too long" error. >>>> > > >>>> > > There is job when it starts for the first time: >>>> > > >>>> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >>>> > > >>>> > > I think that it would be better to edit configuration, because >>>> editing >>>> > > table names before running gatein isn't a good way. >>>> > > >>>> >>>> > > > >>>> > > > Regards, >>>> > > > Peter >>>> > > > >>>> > > > >>>> > > > On Tue, Mar 9, 2010 at 11:24 AM, Michal Vančo <mvanco(a)redhat.com&gt; >>>> wrote: >>>> > > > > Yes Bolek, that's true. >>>> > > > > I can't explain myself the job in hudson on EPP5 >>>> (epp_ui_selenium_tests_oracle10): >>>> > > > > Because there was same problem - table or view does not exist >>>> (build >>>> > > > > #3), builds #5 and #7 were OK (GateIn started with no errors) >>>> and >>>> > > > > following builds again failed due the same problem as before. >>>> > > > > >>>> > > > > Regards, >>>> > > > > Michal >>>> > > > > >>>> > > > > Boleslaw Dawidowicz píše v Út 09. 03. 2010 v 09:59 +0100: >>>> > > > >> From mentioned logs it looks like those errors don't come from >>>> IDM. I >>>> > > > >> think the stack trace in all cases goes via >>>> > > > >> "org.exoplatform.services.jcr.impl.*" >>>> > > > >> >>>> > > > >> Bolek >>>> > > > >> >>>> > > > >> On 03/09/2010 09:15 AM, Michal Vančo wrote: >>>> > > > >> > Hi, >>>> > > > >> > >>>> > > > >> > I'm dealing with problem to start GateIn with Oracle DB. >>>> > > > >> > I always start with clean DB and use 2 datasource instances >>>> (JCR, IDM). >>>> > > > >> > >>>> > > > >> > There are 2 different issues: >>>> > > > >> > Oracle10: >>>> > > > >> > - ORA-00942: table or view does not exist (start on >>>> > > > >> > >>>> org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0 >>>> ) >>>> > > > >> > - only IDM schema is initialized, JCR not >>>> > > > >> > >>>> > > > >> > Oracle11: >>>> > > > >> > - ORA-00972: identifier is too long (Cannot instantiate >>>> component class >>>> > > > >> > >>>> org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) >>>> > > > >> > - both schemas are created (IDM + JCR) >>>> > > > >> > >>>> > > > >> > To run on oracle, I change configuration in >>>> idm-configuration.xml and >>>> > > > >> > jcr-configuration.xml, then copy jdbc driver and start. >>>> > > > >> > I also add<property name="hibernate.hbm2ddl.auto" >>>> value="create-drop"/> >>>> > > > >> > to idm-configuration.xml (recommended by Boleslaw Dawidowicz >>>> - it worked >>>> > > > >> > on EPP, but not on GateIn trunk). >>>> > > > >> > >>>> > > > >> > There are links to log: >>>> > > > >> > >>>> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >>>> > > > >> > >>>> > > > >> > >>>> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >>>> > > > >> > >>>> > > > >> > >>>> > > > >> > I would appreciate any help. >>>> > > > >> > >>>> > > > >> > Thanks in advance >>>> > > > >> > Michal Vanco >>>> > > > >> > >>>> > > > >> > _______________________________________________ >>>> > > > >> > gatein-dev mailing list >>>> > > > >> > gatein-dev(a)lists.jboss.org >>>> > > > >> > https://lists.jboss.org/mailman/listinfo/gatein-dev >>>> > > > > >>>> > > > > >>>> > > > > _______________________________________________ >>>> > > > > gatein-dev mailing list >>>> > > > > gatein-dev(a)lists.jboss.org >>>> > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev >>>> > > > > >>>> > > >>>> > > >>>> > > >>>> Thanks, >>>> > > Michal >>>> > > >>>> >>>> > > _______________________________________________ >>>> > > gatein-dev mailing list >>>> > > gatein-dev(a)lists.jboss.org >>>> > > https://lists.jboss.org/mailman/listinfo/gatein-dev >>>> > > >>>> >>> >>> > > >>> >>> > > -- >>> > > >>> > Nicolas Filotto >>> > > JCR Product Manager >>> > > Project Manager >>> > > eXo Platform SAS >>> > > nicolas.filotto(a)exoplatform.com >>> > > +33 (0)6 31 32 92 19 >>> > > >>> >> >> > > >> >> > > -- >> > > Nicolas Filotto >> > > JCR Product Manager >> > > Project Manager >> > > eXo Platform SAS >> > > nicolas.filotto(a)exoplatform.com >> > > +33 (0)6 31 32 92 19 >> > > >> > >> > _______________________________________________ gatein-dev mailing list >> gatein-dev(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/gatein-dev >> > > > > > > > -- > > Nicolas Filotto > > JCR Product Manager > > Project Manager > > eXo Platform SAS > > nicolas.filotto(a)exoplatform.com > > +33 (0)6 31 32 92 19 > > > > > -- > Nicolas Filotto > JCR Product Manager > Project Manager > eXo Platform SAS > nicolas.filotto(a)exoplatform.com > +33 (0)6 31 32 92 19 >

Hi, currently I have same results as before (table or view does not exist) on oracle10 in these conditions: - 2 datasources on one machine (differentiated by user names) - 1 datasource on a machine (JCR and IDM together) - 2 datasources on separate machines

To run GateIn trunk on Oracle10, I do following steps: - prepare GateIn trunk bundle - unzip bundle - change driver class, url, user and password in jcr-configuration.xml in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/ - change driver class, url, user and password in idm-configuration.xml in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/organization/ - add <property name="hibernate.hbm2ddl.auto" value="create-drop"/> in idm-configuration.xml - copy oracle10 jdbc driver into ../server/default/lib - start gatein by run.sh in bin folder (I can provide a script from hudson where you can add your own paths and credentials...) For oracle11: - when run with same config as on oracle10, I get error: ORA-00972: identifier is too long (when initializing org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) - oracle11_jcr.jpg - screen of what has been created in DB - if I edit table names in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/repository-configuration.xml, gatein started correctly - oracle11_jcr_shorten_names.jpg - screen of what has been created in DB Let me know if you need more details to reproduce it on your side. Best regards, Michal Nicolas Filotto píše v St 10. 03. 2010 v 17:39 +0100: > > > On Wed, Mar 10, 2010 at 5:19 PM, Prabhat Jha <pjha(a)redhat.com&gt; wrote: > I have created https://jira.jboss.org/jira/browse/EXOJCR-582 > for oracle11 issue. Please check that I have right affects and > fix versions. > > thx, FYI I've just set the right settings > > The version of GateIn and JCR is the one that's in GateIn > trunk currently. The way our environment is setup is that we > have one Oracle10 DB servers and different usernames which I > believe means different schemas in Oracle for different tests > (gatein-ui, gatein-jcr etc) configured on that server. I would > have to wait for Michal to show up for info. He needed to > attend to some personal stuff : hospital to check on his mom. > > But in your environment, you have GateIn starting fine on > Oracle 10, right? > > no so far, we have only tested with pure JCR but in the same > conditions as gatein, now as we know the version of gatein we will try > with the same version (i.e the trunk) > > thanks, > prabhat > > > > > ----- "Nicolas Filotto" <nicolas.filotto(a)gmail.com&gt; wrote: > > Prabhat and/or Michal, could you please provide the answers > of the questions asked by Peter and me. We cannot reproduce so > far, so we need your help. Please note that we blocked the > release of GA because of this last issue, so we need your help > to fix it asap. > > > > > Thank you in advance, > BR, > Nicolas > > > > On Wed, Mar 10, 2010 at 3:02 PM, Nicolas Filotto > <nicolas.filotto(a)gmail.com&gt; wrote: > > > Hi Prabhat, > > > > > my comments inline > > > > > > On Wed, Mar 10, 2010 at 2:01 PM, Prabhat Jha > <pjha(a)redhat.com&gt; wrote: > > > > > > Hi Nicolas, > > > > Yes, a jira is on the way but way to > reproduce this problem is quite simple. You > start with a clean Oracle 10 database instance > and see the problem during startup. It would > make sense to have this issue solved or have a > work around before GateIn GA. > > > It is not enough, we need to know, which exact version > of eXo JCR and GateIn, you are using and the content > of the files that you modified. > could you please open a connexion with the same > account and give us the list of tables that you can > see > > > > > > Quick questions: > > As per oracle11 finding, is JCR config > (table names) going to be updated across the > board? > > > You mean to change the sql scripts for oracle 11G? If > so please create a JIRA, it will be done in the next > maintenance version of eXo JCR which will be 1.12.1 GA > planned for the end of March > > > > Also, I am wondiering given that Oracle 10 > has been around for a while, I am wondering > what has changed in the latest JCR that it > does not work here. Did the last GA version > work? > > > Hard to say before reproducing your bug > > > > > > > Thanks, > > Prabhat > > > > > > > > > > ----- "Nicolas Filotto" > <nicolas.filotto(a)gmail.com&gt; wrote: > > > Hi Michal, could you please create JIRA > issues in the eXo JCR project > (https://jira.jboss.org/jira/browse/EXOJCR) > with all the information needed to allow us to > reproduce? > > > > > > > > > On Wed, Mar 10, 2010 at 1:46 PM, Nicolas > Filotto <nicolas.filotto(a)gmail.com&gt; wrote: > > > > > > > > > > > > > > > On Wed, Mar 10, 2010 at 1:29 PM, > Michal Vančo <mvanco(a)redhat.com&gt; > wrote: > > > > Hi, > > > > > > oracle11 now works, > oracle10 not. See below... > > > > > > Peter Nedonosko wrote > > > > > Hi, > > > > > > > > about Oracle 10 and ' > table or view does not exist': > > > > the problem is possible > if addConfig used in > > > > > org.exoplatform.services.jcr.config.RepositoryServiceConfiguration > > > > (I found it in portal > \trunk\examples\portal\war\src > \main\webapp\WEB-INF\conf > \sample-portal\jcr > \jcr-configuration.xml) > > > > > > > What you meant with addConfig > plugin? > > > Should I add > <set-method>addConfig</set-method> in > > > jcr-configuration.xml? > > > Or how can I solve 'table > or view does not exist' on > oracle10? > > > > > > > > I guess it is not related since it > works with other databases > > > > > > > > > > > > if the database is > creating from the scratch and > if the configuration > > > > persister got an answer > from the Oracle - your table > exists in > > > > isDbInitialized(): > > > > ResultSet trs = > con.getMetaData().getTables(null, null, configTableName, null); > > > > return trs.next(); // > true = yes > > > > > > > > but then Oracle fails > with > > > > PreparedStatement ps = > con.prepareStatement("SELECT > COUNT(*) FROM " + > > > > configTableName + " > WHERE NAME=?"); > > > > ps.executeQuery(); // > here > > > > > > > > but I have to reproduce > it first... > > > > does Oracle 10 and 11 > runs on clean database from > the start? > > > > or just restarted on > existing db for Oracle 11? > > > > > > > Always on clean DBs. > > > > > > > > > > > > about Oracle11: > > > > seems it's related to > JBossCache loader, it creates > a table longer of > > > > 30 symbols (ORA-00972: > identifier is too long). > > > > Why it's not a problem > for Oracle10 or why JBossCache > acts in > > > > different way on > Oracle10 or etc... > > > > try to fix the problem > with shorten table name from > repository-configuration.xml > > > > e.g. > > > > <property > name="jbosscache-cl-cache.jdbc.table.name" value="lock_portalsys" /> > > > > instead of > > > > <property > name="jbosscache-cl-cache.jdbc.table.name" > > > > > value="jcrlock_portal_system" /> > > > > it should helps. > > > > > > > I shortened all table names in > repository-configuration.xml > and GateIn > > > on Oracle11 started > without "identifier is too > long" error. > > > > > > There is job when it > starts for the first time: > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > > > I think that it would be > better to edit configuration, > because editing > > > table names before running > gatein isn't a good way. > > > > > > > > > > > > > Regards, > > > > Peter > > > > > > > > > > > > On Tue, Mar 9, 2010 at > 11:24 AM, Michal Vančo > <mvanco(a)redhat.com&gt; wrote: > > > > > Yes Bolek, that's > true. > > > > > I can't explain myself > the job in hudson on EPP5 > (epp_ui_selenium_tests_oracle10): > > > > > Because there was same > problem - table or view does > not exist (build > > > > > #3), builds #5 and #7 > were OK (GateIn started with > no errors) and > > > > > following builds again > failed due the same problem as > before. > > > > > > > > > > Regards, > > > > > Michal > > > > > > > > > > Boleslaw Dawidowicz > píše v Út 09. 03. 2010 v 09:59 > +0100: > > > > >> From mentioned logs > it looks like those errors > don't come from IDM. I > > > > >> think the stack trace > in all cases goes via > > > > >> > "org.exoplatform.services.jcr.impl.*" > > > > >> > > > > >> Bolek > > > > >> > > > > >> On 03/09/2010 09:15 > AM, Michal Vančo wrote: > > > > >> > Hi, > > > > >> > > > > > >> > I'm dealing with > problem to start GateIn with > Oracle DB. > > > > >> > I always start with > clean DB and use 2 datasource > instances (JCR, IDM). > > > > >> > > > > > >> > There are 2 > different issues: > > > > >> > Oracle10: > > > > >> > - ORA-00942: table > or view does not exist (start > on > > > > >> > > org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0) > > > > >> > - only IDM schema > is initialized, JCR not > > > > >> > > > > > >> > Oracle11: > > > > >> > - ORA-00972: > identifier is too long (Cannot > instantiate component class > > > > >> > > org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) > > > > >> > - both schemas are > created (IDM + JCR) > > > > >> > > > > > >> > To run on oracle, I > change configuration in > idm-configuration.xml and > > > > >> > > jcr-configuration.xml, then > copy jdbc driver and start. > > > > >> > I also add<property > name="hibernate.hbm2ddl.auto" > value="create-drop"/> > > > > >> > to > idm-configuration.xml > (recommended by Boleslaw > Dawidowicz - it worked > > > > >> > on EPP, but not on > GateIn trunk). > > > > >> > > > > > >> > There are links to > log: > > > > >> > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > >> > > > > > >> > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > >> > > > > > >> > > > > > >> > I would appreciate > any help. > > > > >> > > > > > >> > Thanks in advance > > > > >> > Michal Vanco > > > > >> > > > > > >> > > _______________________________________________ > > > > >> > gatein-dev mailing > list > > > > >> > > gatein-dev(a)lists.jboss.org > > > > >> > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > _______________________________________________ > > > > > gatein-dev mailing > list > > > > > > gatein-dev(a)lists.jboss.org > > > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > Thanks, > > > Michal > > > > > > > > > _______________________________________________ > > > gatein-dev mailing list > > > gatein-dev(a)lists.jboss.org > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > -- > > > > > > Nicolas Filotto > > > JCR Product Manager > > > Project Manager > > > eXo Platform SAS > > > nicolas.filotto(a)exoplatform.com > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > -- > > > Nicolas Filotto > > > JCR Product Manager > > > Project Manager > > > eXo Platform SAS > > > nicolas.filotto(a)exoplatform.com > > > +33 (0)6 31 32 92 19 > > > > > > > > _______________________________________________ gatein-dev mailing list gatein-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > -- > > Nicolas Filotto > > JCR Product Manager > > Project Manager > > eXo Platform SAS > > nicolas.filotto(a)exoplatform.com > > +33 (0)6 31 32 92 19 > > > > > > > > -- > > Nicolas Filotto > > JCR Product Manager > > Project Manager > > eXo Platform SAS > > nicolas.filotto(a)exoplatform.com > > +33 (0)6 31 32 92 19 > > > > > > -- > Nicolas Filotto > JCR Product Manager > Project Manager > eXo Platform SAS > nicolas.filotto(a)exoplatform.com > +33 (0)6 31 32 92 19 _______________________________________________ gatein-dev mailing list gatein-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/gatein-dev

Michal, It's still not clear if you updated JCR to 1.12.0.GA or if you are still running with CR2 Thomas. On 03/10/2010 09:15 PM, Michal Vančo wrote: > Michal Vančo wrote: > >> Hi, >> >> currently I have same results as before (table or view does not exist) >> on oracle10 in these conditions: >> - 2 datasources on one machine (differentiated by user names) >> - 1 datasource on a machine (JCR and IDM together) >> - 2 datasources on separate machines >> > Only for completeness: > I'm using sqldeveloper tool to see the content of oracle DB, and at all > above cases, I can't see that anything is created (tables, sequence, > indexes...) in JCR schema. Only IDM schema initialization is done. > >> To run GateIn trunk on Oracle10, I do following steps: >> - prepare GateIn trunk bundle >> - unzip bundle >> - change driver class, url, user and password in jcr-configuration.xml >> in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/ >> - change driver class, url, user and password in idm-configuration.xml >> in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/organization/ >> - add<property name="hibernate.hbm2ddl.auto" value="create-drop"/> in >> idm-configuration.xml >> - copy oracle10 jdbc driver into ../server/default/lib >> - start gatein by run.sh in bin folder >> >> (I can provide a script from hudson where you can add your own paths and >> credentials...) >> >> For oracle11: >> - when run with same config as on oracle10, I get error: >> ORA-00972: identifier is too long (when initializing >> org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) >> - oracle11_jcr.jpg - screen of what has been created in DB >> >> - if I edit table names >> in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/repository-configuration.xml, gatein started correctly >> - oracle11_jcr_shorten_names.jpg - screen of what has been created in DB >> >> Let me know if you need more details to reproduce it on your side. >> >> Best regards, >> >> Michal >> >> >> Nicolas Filotto píše v St 10. 03. 2010 v 17:39 +0100: >> >>> >>> On Wed, Mar 10, 2010 at 5:19 PM, Prabhat Jha&lt;pjha(a)redhat.com&gt; wrote: >>> I have created https://jira.jboss.org/jira/browse/EXOJCR-582 >>> for oracle11 issue. Please check that I have right affects and >>> fix versions. >>> >>> thx, FYI I've just set the right settings >>> >>> The version of GateIn and JCR is the one that's in GateIn >>> trunk currently. The way our environment is setup is that we >>> have one Oracle10 DB servers and different usernames which I >>> believe means different schemas in Oracle for different tests >>> (gatein-ui, gatein-jcr etc) configured on that server. I would >>> have to wait for Michal to show up for info. He needed to >>> attend to some personal stuff : hospital to check on his mom. >>> >>> But in your environment, you have GateIn starting fine on >>> Oracle 10, right? >>> >>> no so far, we have only tested with pure JCR but in the same >>> conditions as gatein, now as we know the version of gatein we will try >>> with the same version (i.e the trunk) >>> >>> thanks, >>> prabhat >>> >>> >>> >>> >>> ----- "Nicolas Filotto&quot;&lt;nicolas.filotto(a)gmail.com&gt; wrote: >>> > Prabhat and/or Michal, could you please provide the answers >>> of the questions asked by Peter and me. We cannot reproduce so >>> far, so we need your help. Please note that we blocked the >>> release of GA because of this last issue, so we need your help >>> to fix it asap. >>> > >>> > >>> Thank you in advance, >>> BR, >>> Nicolas >>> > >>> > On Wed, Mar 10, 2010 at 3:02 PM, Nicolas Filotto >>> <nicolas.filotto(a)gmail.com&gt; wrote: >>> > >>> Hi Prabhat, >>> > >>> > >>> my comments inline >>> > >>> > >>> > On Wed, Mar 10, 2010 at 2:01 PM, Prabhat Jha >>> <pjha(a)redhat.com&gt; wrote: >>> > >>> > >>> > Hi Nicolas, >>> > >>> > Yes, a jira is on the way but way to >>> reproduce this problem is quite simple. You >>> start with a clean Oracle 10 database instance >>> and see the problem during startup. It would >>> make sense to have this issue solved or have a >>> work around before GateIn GA. >>> > >>> It is not enough, we need to know, which exact version >>> of eXo JCR and GateIn, you are using and the content >>> of the files that you modified. >>> could you please open a connexion with the same >>> account and give us the list of tables that you can >>> see >>> > >>> > >>> > Quick questions: >>> > As per oracle11 finding, is JCR config >>> (table names) going to be updated across the >>> board? >>> > >>> You mean to change the sql scripts for oracle 11G? If >>> so please create a JIRA, it will be done in the next >>> maintenance version of eXo JCR which will be 1.12.1 GA >>> planned for the end of March >>> > >>> > Also, I am wondiering given that Oracle 10 >>> has been around for a while, I am wondering >>> what has changed in the latest JCR that it >>> does not work here. Did the last GA version >>> work? >>> > >>> Hard to say before reproducing your bug >>> >>> > >>> > >>> > Thanks, >>> > Prabhat >>> >>> >>> > >>> > >>> > >>> > ----- "Nicolas Filotto" >>> <nicolas.filotto(a)gmail.com&gt; wrote: >>> > > Hi Michal, could you please create JIRA >>> issues in the eXo JCR project >>> (https://jira.jboss.org/jira/browse/EXOJCR) >>> with all the information needed to allow us to >>> reproduce? >>> > > >>> > > >>> > > On Wed, Mar 10, 2010 at 1:46 PM, Nicolas >>> Filotto&lt;nicolas.filotto(a)gmail.com&gt; wrote: >>> > > >>> >>> > > >>> > > >>> > > >>> > On Wed, Mar 10, 2010 at 1:29 PM, >>> Michal Vančo&lt;mvanco(a)redhat.com&gt; >>> wrote: >>> > > >>> Hi, >>> > > >>> > > oracle11 now works, >>> oracle10 not. See below... >>> > > >>> > > Peter Nedonosko wrote >>> > > >>> > Hi, >>> > > > >>> > > > about Oracle 10 and ' >>> table or view does not exist': >>> > > > the problem is possible >>> if addConfig used in >>> > > > >>> org.exoplatform.services.jcr.config.RepositoryServiceConfiguration >>> > > > (I found it in portal >>> \trunk\examples\portal\war\src >>> \main\webapp\WEB-INF\conf >>> \sample-portal\jcr >>> \jcr-configuration.xml) >>> > > >>> > > >>> What you meant with addConfig >>> plugin? >>> > > Should I add >>> <set-method>addConfig</set-method> in >>> > > jcr-configuration.xml? >>> > > Or how can I solve 'table >>> or view does not exist' on >>> oracle10? >>> > > >>> >>> > > >>> I guess it is not related since it >>> works with other databases >>> >>> > >>> >>> > > > >>> > > > if the database is >>> creating from the scratch and >>> if the configuration >>> > > > persister got an answer >>> from the Oracle - your table >>> exists in >>> > > > isDbInitialized(): >>> > > > ResultSet trs = >>> con.getMetaData().getTables(null, null, configTableName, null); >>> > > > return trs.next(); // >>> true = yes >>> > > > >>> > > > but then Oracle fails >>> with >>> > > > PreparedStatement ps = >>> con.prepareStatement("SELECT >>> COUNT(*) FROM " + >>> > > > configTableName + " >>> WHERE NAME=?"); >>> > > > ps.executeQuery(); // >>> here >>> > > > >>> > > > but I have to reproduce >>> it first... >>> > > > does Oracle 10 and 11 >>> runs on clean database from >>> the start? >>> > > > or just restarted on >>> existing db for Oracle 11? >>> > > >>> > > >>> Always on clean DBs. >>> > > >>> >>> > > > >>> > > > about Oracle11: >>> > > > seems it's related to >>> JBossCache loader, it creates >>> a table longer of >>> > > > 30 symbols (ORA-00972: >>> identifier is too long). >>> > > > Why it's not a problem >>> for Oracle10 or why JBossCache >>> acts in >>> > > > different way on >>> Oracle10 or etc... >>> > > > try to fix the problem >>> with shorten table name from >>> repository-configuration.xml >>> > > > e.g. >>> > > > <property >>> name="jbosscache-cl-cache.jdbc.table.name" value="lock_portalsys" /> >>> > > > instead of >>> > > > <property >>> name="jbosscache-cl-cache.jdbc.table.name" >>> > > > >>> value="jcrlock_portal_system" /> >>> > > > it should helps. >>> > > >>> > > >>> I shortened all table names in >>> repository-configuration.xml >>> and GateIn >>> > > on Oracle11 started >>> without "identifier is too >>> long" error. >>> > > >>> > > There is job when it >>> starts for the first time: >>> > > >>> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >>> > > >>> > > I think that it would be >>> better to edit configuration, >>> because editing >>> > > table names before running >>> gatein isn't a good way. >>> > > >>> >>> >>> > > > >>> > > > Regards, >>> > > > Peter >>> > > > >>> > > > >>> > > > On Tue, Mar 9, 2010 at >>> 11:24 AM, Michal Vančo >>> <mvanco(a)redhat.com&gt; wrote: >>> > > > > Yes Bolek, that's >>> true. >>> > > > > I can't explain myself >>> the job in hudson on EPP5 >>> (epp_ui_selenium_tests_oracle10): >>> > > > > Because there was same >>> problem - table or view does >>> not exist (build >>> > > > > #3), builds #5 and #7 >>> were OK (GateIn started with >>> no errors) and >>> > > > > following builds again >>> failed due the same problem as >>> before. >>> > > > > >>> > > > > Regards, >>> > > > > Michal >>> > > > > >>> > > > > Boleslaw Dawidowicz >>> píše v Út 09. 03. 2010 v 09:59 >>> +0100: >>> > > > >> From mentioned logs >>> it looks like those errors >>> don't come from IDM. I >>> > > > >> think the stack trace >>> in all cases goes via >>> > > > >> >>> "org.exoplatform.services.jcr.impl.*" >>> > > > >> >>> > > > >> Bolek >>> > > > >> >>> > > > >> On 03/09/2010 09:15 >>> AM, Michal Vančo wrote: >>> > > > >> > Hi, >>> > > > >> > >>> > > > >> > I'm dealing with >>> problem to start GateIn with >>> Oracle DB. >>> > > > >> > I always start with >>> clean DB and use 2 datasource >>> instances (JCR, IDM). >>> > > > >> > >>> > > > >> > There are 2 >>> different issues: >>> > > > >> > Oracle10: >>> > > > >> > - ORA-00942: table >>> or view does not exist (start >>> on >>> > > > >> > >>> org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0) >>> > > > >> > - only IDM schema >>> is initialized, JCR not >>> > > > >> > >>> > > > >> > Oracle11: >>> > > > >> > - ORA-00972: >>> identifier is too long (Cannot >>> instantiate component class >>> > > > >> > >>> org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) >>> > > > >> > - both schemas are >>> created (IDM + JCR) >>> > > > >> > >>> > > > >> > To run on oracle, I >>> change configuration in >>> idm-configuration.xml and >>> > > > >> > >>> jcr-configuration.xml, then >>> copy jdbc driver and start. >>> > > > >> > I also add<property >>> name="hibernate.hbm2ddl.auto" >>> value="create-drop"/> >>> > > > >> > to >>> idm-configuration.xml >>> (recommended by Boleslaw >>> Dawidowicz - it worked >>> > > > >> > on EPP, but not on >>> GateIn trunk). >>> > > > >> > >>> > > > >> > There are links to >>> log: >>> > > > >> > >>> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >>> > > > >> > >>> > > > >> > >>> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >>> > > > >> > >>> > > > >> > >>> > > > >> > I would appreciate >>> any help. >>> > > > >> > >>> > > > >> > Thanks in advance >>> > > > >> > Michal Vanco >>> > > > >> > >>> > > > >> > >>> _______________________________________________ >>> > > > >> > gatein-dev mailing >>> list >>> > > > >> > >>> gatein-dev(a)lists.jboss.org >>> > > > >> > >>> https://lists.jboss.org/mailman/listinfo/gatein-dev >>> > > > > >>> > > > > >>> > > > > >>> _______________________________________________ >>> > > > > gatein-dev mailing >>> list >>> > > > > >>> gatein-dev(a)lists.jboss.org >>> > > > > >>> https://lists.jboss.org/mailman/listinfo/gatein-dev >>> > > > > >>> > > >>> > > >>> > > >>> Thanks, >>> > > Michal >>> > > >>> >>> >>> > > >>> _______________________________________________ >>> > > gatein-dev mailing list >>> > > gatein-dev(a)lists.jboss.org >>> > > >>> https://lists.jboss.org/mailman/listinfo/gatein-dev >>> > > >>> >>> > > >>> >>> > > -- >>> > > >>> >>> > Nicolas Filotto >>> > > JCR Product Manager >>> > > Project Manager >>> > > eXo Platform SAS >>> > > nicolas.filotto(a)exoplatform.com >>> > > +33 (0)6 31 32 92 19 >>> > > >>> >>> > > >>> >>> > > -- >>> > > Nicolas Filotto >>> > > JCR Product Manager >>> > > Project Manager >>> > > eXo Platform SAS >>> > > nicolas.filotto(a)exoplatform.com >>> > > +33 (0)6 31 32 92 19 >>> > > >>> > >>> > >>> _______________________________________________ gatein-dev mailing list gatein-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/gatein-dev >>> >>> > >>> > >>> >>> > -- >>> > Nicolas Filotto >>> > JCR Product Manager >>> > Project Manager >>> > eXo Platform SAS >>> > nicolas.filotto(a)exoplatform.com >>> > +33 (0)6 31 32 92 19 >>> > >>> >>> > >>> >>> > -- >>> > Nicolas Filotto >>> > JCR Product Manager >>> > Project Manager >>> > eXo Platform SAS >>> > nicolas.filotto(a)exoplatform.com >>> > +33 (0)6 31 32 92 19 >>> > >>> >>> >>> >>> -- >>> Nicolas Filotto >>> JCR Product Manager >>> Project Manager >>> eXo Platform SAS >>> nicolas.filotto(a)exoplatform.com >>> +33 (0)6 31 32 92 19 >>> >> _______________________________________________ >> gatein-dev mailing list >> gatein-dev(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/gatein-dev >> > > _______________________________________________ > gatein-dev mailing list > gatein-dev(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/gatein-dev >

As far as I understood the unique issue with Oracle 11 was about too long names, in fact we had a table name of 29 characters and it looks like JBossCache create another table suffixed with _D, so we had a table name of 31 characters while Oracle limits its table names to 30 chars. I reduced the problematic table name by 1 char and it should work out of the box now (I couldn't test I don't have any Oracle DB installed) https://jira.jboss.org/jira/browse/GTNPORTAL-862 On 03/10/2010 09:15 PM, Michal Vančo wrote: > Michal Vančo wrote: > >> Hi, >> >> currently I have same results as before (table or view does not exist) >> on oracle10 in these conditions: >> - 2 datasources on one machine (differentiated by user names) >> - 1 datasource on a machine (JCR and IDM together) >> - 2 datasources on separate machines >> > Only for completeness: > I'm using sqldeveloper tool to see the content of oracle DB, and at all > above cases, I can't see that anything is created (tables, sequence, > indexes...) in JCR schema. Only IDM schema initialization is done. > >> To run GateIn trunk on Oracle10, I do following steps: >> - prepare GateIn trunk bundle >> - unzip bundle >> - change driver class, url, user and password in jcr-configuration.xml >> in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/ >> - change driver class, url, user and password in idm-configuration.xml >> in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/organization/ >> - add<property name="hibernate.hbm2ddl.auto" value="create-drop"/> in >> idm-configuration.xml >> - copy oracle10 jdbc driver into ../server/default/lib >> - start gatein by run.sh in bin folder >> >> (I can provide a script from hudson where you can add your own paths and >> credentials...) >> >> For oracle11: >> - when run with same config as on oracle10, I get error: >> ORA-00972: identifier is too long (when initializing >> org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) >> - oracle11_jcr.jpg - screen of what has been created in DB >> >> - if I edit table names >> in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/repository-configuration.xml, gatein started correctly >> - oracle11_jcr_shorten_names.jpg - screen of what has been created in DB >> >> Let me know if you need more details to reproduce it on your side. >> >> Best regards, >> >> Michal >> >> >> Nicolas Filotto píše v St 10. 03. 2010 v 17:39 +0100: >> >>> >>> On Wed, Mar 10, 2010 at 5:19 PM, Prabhat Jha&lt;pjha(a)redhat.com&gt; wrote: >>> I have created https://jira.jboss.org/jira/browse/EXOJCR-582 >>> for oracle11 issue. Please check that I have right affects and >>> fix versions. >>> >>> thx, FYI I've just set the right settings >>> >>> The version of GateIn and JCR is the one that's in GateIn >>> trunk currently. The way our environment is setup is that we >>> have one Oracle10 DB servers and different usernames which I >>> believe means different schemas in Oracle for different tests >>> (gatein-ui, gatein-jcr etc) configured on that server. I would >>> have to wait for Michal to show up for info. He needed to >>> attend to some personal stuff : hospital to check on his mom. >>> >>> But in your environment, you have GateIn starting fine on >>> Oracle 10, right? >>> >>> no so far, we have only tested with pure JCR but in the same >>> conditions as gatein, now as we know the version of gatein we will try >>> with the same version (i.e the trunk) >>> >>> thanks, >>> prabhat >>> >>> >>> >>> >>> ----- "Nicolas Filotto&quot;&lt;nicolas.filotto(a)gmail.com&gt; wrote: >>> > Prabhat and/or Michal, could you please provide the answers >>> of the questions asked by Peter and me. We cannot reproduce so >>> far, so we need your help. Please note that we blocked the >>> release of GA because of this last issue, so we need your help >>> to fix it asap. >>> > >>> > >>> Thank you in advance, >>> BR, >>> Nicolas >>> > >>> > On Wed, Mar 10, 2010 at 3:02 PM, Nicolas Filotto >>> <nicolas.filotto(a)gmail.com&gt; wrote: >>> > >>> Hi Prabhat, >>> > >>> > >>> my comments inline >>> > >>> > >>> > On Wed, Mar 10, 2010 at 2:01 PM, Prabhat Jha >>> <pjha(a)redhat.com&gt; wrote: >>> > >>> > >>> > Hi Nicolas, >>> > >>> > Yes, a jira is on the way but way to >>> reproduce this problem is quite simple. You >>> start with a clean Oracle 10 database instance >>> and see the problem during startup. It would >>> make sense to have this issue solved or have a >>> work around before GateIn GA. >>> > >>> It is not enough, we need to know, which exact version >>> of eXo JCR and GateIn, you are using and the content >>> of the files that you modified. >>> could you please open a connexion with the same >>> account and give us the list of tables that you can >>> see >>> > >>> > >>> > Quick questions: >>> > As per oracle11 finding, is JCR config >>> (table names) going to be updated across the >>> board? >>> > >>> You mean to change the sql scripts for oracle 11G? If >>> so please create a JIRA, it will be done in the next >>> maintenance version of eXo JCR which will be 1.12.1 GA >>> planned for the end of March >>> > >>> > Also, I am wondiering given that Oracle 10 >>> has been around for a while, I am wondering >>> what has changed in the latest JCR that it >>> does not work here. Did the last GA version >>> work? >>> > >>> Hard to say before reproducing your bug >>> >>> > >>> > >>> > Thanks, >>> > Prabhat >>> >>> >>> > >>> > >>> > >>> > ----- "Nicolas Filotto" >>> <nicolas.filotto(a)gmail.com&gt; wrote: >>> > > Hi Michal, could you please create JIRA >>> issues in the eXo JCR project >>> (https://jira.jboss.org/jira/browse/EXOJCR) >>> with all the information needed to allow us to >>> reproduce? >>> > > >>> > > >>> > > On Wed, Mar 10, 2010 at 1:46 PM, Nicolas >>> Filotto&lt;nicolas.filotto(a)gmail.com&gt; wrote: >>> > > >>> >>> > > >>> > > >>> > > >>> > On Wed, Mar 10, 2010 at 1:29 PM, >>> Michal Vančo&lt;mvanco(a)redhat.com&gt; >>> wrote: >>> > > >>> Hi, >>> > > >>> > > oracle11 now works, >>> oracle10 not. See below... >>> > > >>> > > Peter Nedonosko wrote >>> > > >>> > Hi, >>> > > > >>> > > > about Oracle 10 and ' >>> table or view does not exist': >>> > > > the problem is possible >>> if addConfig used in >>> > > > >>> org.exoplatform.services.jcr.config.RepositoryServiceConfiguration >>> > > > (I found it in portal >>> \trunk\examples\portal\war\src >>> \main\webapp\WEB-INF\conf >>> \sample-portal\jcr >>> \jcr-configuration.xml) >>> > > >>> > > >>> What you meant with addConfig >>> plugin? >>> > > Should I add >>> <set-method>addConfig</set-method> in >>> > > jcr-configuration.xml? >>> > > Or how can I solve 'table >>> or view does not exist' on >>> oracle10? >>> > > >>> >>> > > >>> I guess it is not related since it >>> works with other databases >>> >>> > >>> >>> > > > >>> > > > if the database is >>> creating from the scratch and >>> if the configuration >>> > > > persister got an answer >>> from the Oracle - your table >>> exists in >>> > > > isDbInitialized(): >>> > > > ResultSet trs = >>> con.getMetaData().getTables(null, null, configTableName, null); >>> > > > return trs.next(); // >>> true = yes >>> > > > >>> > > > but then Oracle fails >>> with >>> > > > PreparedStatement ps = >>> con.prepareStatement("SELECT >>> COUNT(*) FROM " + >>> > > > configTableName + " >>> WHERE NAME=?"); >>> > > > ps.executeQuery(); // >>> here >>> > > > >>> > > > but I have to reproduce >>> it first... >>> > > > does Oracle 10 and 11 >>> runs on clean database from >>> the start? >>> > > > or just restarted on >>> existing db for Oracle 11? >>> > > >>> > > >>> Always on clean DBs. >>> > > >>> >>> > > > >>> > > > about Oracle11: >>> > > > seems it's related to >>> JBossCache loader, it creates >>> a table longer of >>> > > > 30 symbols (ORA-00972: >>> identifier is too long). >>> > > > Why it's not a problem >>> for Oracle10 or why JBossCache >>> acts in >>> > > > different way on >>> Oracle10 or etc... >>> > > > try to fix the problem >>> with shorten table name from >>> repository-configuration.xml >>> > > > e.g. >>> > > > <property >>> name="jbosscache-cl-cache.jdbc.table.name" value="lock_portalsys" /> >>> > > > instead of >>> > > > <property >>> name="jbosscache-cl-cache.jdbc.table.name" >>> > > > >>> value="jcrlock_portal_system" /> >>> > > > it should helps. >>> > > >>> > > >>> I shortened all table names in >>> repository-configuration.xml >>> and GateIn >>> > > on Oracle11 started >>> without "identifier is too >>> long" error. >>> > > >>> > > There is job when it >>> starts for the first time: >>> > > >>> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >>> > > >>> > > I think that it would be >>> better to edit configuration, >>> because editing >>> > > table names before running >>> gatein isn't a good way. >>> > > >>> >>> >>> > > > >>> > > > Regards, >>> > > > Peter >>> > > > >>> > > > >>> > > > On Tue, Mar 9, 2010 at >>> 11:24 AM, Michal Vančo >>> <mvanco(a)redhat.com&gt; wrote: >>> > > > > Yes Bolek, that's >>> true. >>> > > > > I can't explain myself >>> the job in hudson on EPP5 >>> (epp_ui_selenium_tests_oracle10): >>> > > > > Because there was same >>> problem - table or view does >>> not exist (build >>> > > > > #3), builds #5 and #7 >>> were OK (GateIn started with >>> no errors) and >>> > > > > following builds again >>> failed due the same problem as >>> before. >>> > > > > >>> > > > > Regards, >>> > > > > Michal >>> > > > > >>> > > > > Boleslaw Dawidowicz >>> píše v Út 09. 03. 2010 v 09:59 >>> +0100: >>> > > > >> From mentioned logs >>> it looks like those errors >>> don't come from IDM. I >>> > > > >> think the stack trace >>> in all cases goes via >>> > > > >> >>> "org.exoplatform.services.jcr.impl.*" >>> > > > >> >>> > > > >> Bolek >>> > > > >> >>> > > > >> On 03/09/2010 09:15 >>> AM, Michal Vančo wrote: >>> > > > >> > Hi, >>> > > > >> > >>> > > > >> > I'm dealing with >>> problem to start GateIn with >>> Oracle DB. >>> > > > >> > I always start with >>> clean DB and use 2 datasource >>> instances (JCR, IDM). >>> > > > >> > >>> > > > >> > There are 2 >>> different issues: >>> > > > >> > Oracle10: >>> > > > >> > - ORA-00942: table >>> or view does not exist (start >>> on >>> > > > >> > >>> org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0) >>> > > > >> > - only IDM schema >>> is initialized, JCR not >>> > > > >> > >>> > > > >> > Oracle11: >>> > > > >> > - ORA-00972: >>> identifier is too long (Cannot >>> instantiate component class >>> > > > >> > >>> org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) >>> > > > >> > - both schemas are >>> created (IDM + JCR) >>> > > > >> > >>> > > > >> > To run on oracle, I >>> change configuration in >>> idm-configuration.xml and >>> > > > >> > >>> jcr-configuration.xml, then >>> copy jdbc driver and start. >>> > > > >> > I also add<property >>> name="hibernate.hbm2ddl.auto" >>> value="create-drop"/> >>> > > > >> > to >>> idm-configuration.xml >>> (recommended by Boleslaw >>> Dawidowicz - it worked >>> > > > >> > on EPP, but not on >>> GateIn trunk). >>> > > > >> > >>> > > > >> > There are links to >>> log: >>> > > > >> > >>> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >>> > > > >> > >>> > > > >> > >>> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >>> > > > >> > >>> > > > >> > >>> > > > >> > I would appreciate >>> any help. >>> > > > >> > >>> > > > >> > Thanks in advance >>> > > > >> > Michal Vanco >>> > > > >> > >>> > > > >> > >>> _______________________________________________ >>> > > > >> > gatein-dev mailing >>> list >>> > > > >> > >>> gatein-dev(a)lists.jboss.org >>> > > > >> > >>> https://lists.jboss.org/mailman/listinfo/gatein-dev >>> > > > > >>> > > > > >>> > > > > >>> _______________________________________________ >>> > > > > gatein-dev mailing >>> list >>> > > > > >>> gatein-dev(a)lists.jboss.org >>> > > > > >>> https://lists.jboss.org/mailman/listinfo/gatein-dev >>> > > > > >>> > > >>> > > >>> > > >>> Thanks, >>> > > Michal >>> > > >>> >>> >>> > > >>> _______________________________________________ >>> > > gatein-dev mailing list >>> > > gatein-dev(a)lists.jboss.org >>> > > >>> https://lists.jboss.org/mailman/listinfo/gatein-dev >>> > > >>> >>> > > >>> >>> > > -- >>> > > >>> >>> > Nicolas Filotto >>> > > JCR Product Manager >>> > > Project Manager >>> > > eXo Platform SAS >>> > > nicolas.filotto(a)exoplatform.com >>> > > +33 (0)6 31 32 92 19 >>> > > >>> >>> > > >>> >>> > > -- >>> > > Nicolas Filotto >>> > > JCR Product Manager >>> > > Project Manager >>> > > eXo Platform SAS >>> > > nicolas.filotto(a)exoplatform.com >>> > > +33 (0)6 31 32 92 19 >>> > > >>> > >>> > >>> _______________________________________________ gatein-dev mailing list gatein-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/gatein-dev >>> >>> > >>> > >>> >>> > -- >>> > Nicolas Filotto >>> > JCR Product Manager >>> > Project Manager >>> > eXo Platform SAS >>> > nicolas.filotto(a)exoplatform.com >>> > +33 (0)6 31 32 92 19 >>> > >>> >>> > >>> >>> > -- >>> > Nicolas Filotto >>> > JCR Product Manager >>> > Project Manager >>> > eXo Platform SAS >>> > nicolas.filotto(a)exoplatform.com >>> > +33 (0)6 31 32 92 19 >>> > >>> >>> >>> >>> -- >>> Nicolas Filotto >>> JCR Product Manager >>> Project Manager >>> eXo Platform SAS >>> nicolas.filotto(a)exoplatform.com >>> +33 (0)6 31 32 92 19 >>> >> _______________________________________________ >> gatein-dev mailing list >> gatein-dev(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/gatein-dev >> > > _______________________________________________ > gatein-dev mailing list > gatein-dev(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/gatein-dev > _______________________________________________ gatein-dev mailing list gatein-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/gatein-dev

Hi, currently I have same results as before (table or view does not exist) on oracle10 in these conditions: - 2 datasources on one machine (differentiated by user names) - 1 datasource on a machine (JCR and IDM together) - 2 datasources on separate machines To run GateIn trunk on Oracle10, I do following steps: - prepare GateIn trunk bundle - unzip bundle - change driver class, url, user and password in jcr-configuration.xml in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/ - change driver class, url, user and password in idm-configuration.xml in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/organization/ - add <property name="hibernate.hbm2ddl.auto" value="create-drop"/> in idm-configuration.xml - copy oracle10 jdbc driver into ../server/default/lib - start gatein by run.sh in bin folder (I can provide a script from hudson where you can add your own paths and credentials...) For oracle11: - when run with same config as on oracle10, I get error: ORA-00972: identifier is too long (when initializing org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) - oracle11_jcr.jpg - screen of what has been created in DB - if I edit table names in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/repository-configuration.xml, gatein started correctly - oracle11_jcr_shorten_names.jpg - screen of what has been created in DB Let me know if you need more details to reproduce it on your side. Best regards, Michal Nicolas Filotto píše v St 10. 03. 2010 v 17:39 +0100: > > > On Wed, Mar 10, 2010 at 5:19 PM, Prabhat Jha <pjha(a)redhat.com&gt; wrote: > I have created https://jira.jboss.org/jira/browse/EXOJCR-582 > for oracle11 issue. Please check that I have right affects and > fix versions. > > thx, FYI I've just set the right settings > > The version of GateIn and JCR is the one that's in GateIn > trunk currently. The way our environment is setup is that we > have one Oracle10 DB servers and different usernames which I > believe means different schemas in Oracle for different tests > (gatein-ui, gatein-jcr etc) configured on that server. I would > have to wait for Michal to show up for info. He needed to > attend to some personal stuff : hospital to check on his mom. > > But in your environment, you have GateIn starting fine on > Oracle 10, right? > > no so far, we have only tested with pure JCR but in the same > conditions as gatein, now as we know the version of gatein we will try > with the same version (i.e the trunk) > > thanks, > prabhat > > > > > ----- "Nicolas Filotto" <nicolas.filotto(a)gmail.com&gt; wrote: > > Prabhat and/or Michal, could you please provide the answers > of the questions asked by Peter and me. We cannot reproduce so > far, so we need your help. Please note that we blocked the > release of GA because of this last issue, so we need your help > to fix it asap. > > > > > Thank you in advance, > BR, > Nicolas > > > > On Wed, Mar 10, 2010 at 3:02 PM, Nicolas Filotto > <nicolas.filotto(a)gmail.com&gt; wrote: > > > Hi Prabhat, > > > > > my comments inline > > > > > > On Wed, Mar 10, 2010 at 2:01 PM, Prabhat Jha > <pjha(a)redhat.com&gt; wrote: > > > > > > Hi Nicolas, > > > > Yes, a jira is on the way but way to > reproduce this problem is quite simple. You > start with a clean Oracle 10 database instance > and see the problem during startup. It would > make sense to have this issue solved or have a > work around before GateIn GA. > > > It is not enough, we need to know, which exact version > of eXo JCR and GateIn, you are using and the content > of the files that you modified. > could you please open a connexion with the same > account and give us the list of tables that you can > see > > > > > > Quick questions: > > As per oracle11 finding, is JCR config > (table names) going to be updated across the > board? > > > You mean to change the sql scripts for oracle 11G? If > so please create a JIRA, it will be done in the next > maintenance version of eXo JCR which will be 1.12.1 GA > planned for the end of March > > > > Also, I am wondiering given that Oracle 10 > has been around for a while, I am wondering > what has changed in the latest JCR that it > does not work here. Did the last GA version > work? > > > Hard to say before reproducing your bug > > > > > > > Thanks, > > Prabhat > > > > > > > > > > ----- "Nicolas Filotto" > <nicolas.filotto(a)gmail.com&gt; wrote: > > > Hi Michal, could you please create JIRA > issues in the eXo JCR project > (https://jira.jboss.org/jira/browse/EXOJCR) > with all the information needed to allow us to > reproduce? > > > > > > > > > On Wed, Mar 10, 2010 at 1:46 PM, Nicolas > Filotto <nicolas.filotto(a)gmail.com&gt; wrote: > > > > > > > > > > > > > > > On Wed, Mar 10, 2010 at 1:29 PM, > Michal Vančo <mvanco(a)redhat.com&gt; > wrote: > > > > Hi, > > > > > > oracle11 now works, > oracle10 not. See below... > > > > > > Peter Nedonosko wrote > > > > > Hi, > > > > > > > > about Oracle 10 and ' > table or view does not exist': > > > > the problem is possible > if addConfig used in > > > > > org.exoplatform.services.jcr.config.RepositoryServiceConfiguration > > > > (I found it in portal > \trunk\examples\portal\war\src > \main\webapp\WEB-INF\conf > \sample-portal\jcr > \jcr-configuration.xml) > > > > > > > What you meant with addConfig > plugin? > > > Should I add > <set-method>addConfig</set-method> in > > > jcr-configuration.xml? > > > Or how can I solve 'table > or view does not exist' on > oracle10? > > > > > > > > I guess it is not related since it > works with other databases > > > > > > > > > > > > if the database is > creating from the scratch and > if the configuration > > > > persister got an answer > from the Oracle - your table > exists in > > > > isDbInitialized(): > > > > ResultSet trs = > con.getMetaData().getTables(null, null, configTableName, null); > > > > return trs.next(); // > true = yes > > > > > > > > but then Oracle fails > with > > > > PreparedStatement ps = > con.prepareStatement("SELECT > COUNT(*) FROM " + > > > > configTableName + " > WHERE NAME=?"); > > > > ps.executeQuery(); // > here > > > > > > > > but I have to reproduce > it first... > > > > does Oracle 10 and 11 > runs on clean database from > the start? > > > > or just restarted on > existing db for Oracle 11? > > > > > > > Always on clean DBs. > > > > > > > > > > > > about Oracle11: > > > > seems it's related to > JBossCache loader, it creates > a table longer of > > > > 30 symbols (ORA-00972: > identifier is too long). > > > > Why it's not a problem > for Oracle10 or why JBossCache > acts in > > > > different way on > Oracle10 or etc... > > > > try to fix the problem > with shorten table name from > repository-configuration.xml > > > > e.g. > > > > <property > name=" jbosscache-cl-cache.jdbc.table.name" value="lock_portalsys" /> > > > > instead of > > > > <property > name=" jbosscache-cl-cache.jdbc.table.name" > > > > > value="jcrlock_portal_system" /> > > > > it should helps. > > > > > > > I shortened all table names in > repository-configuration.xml > and GateIn > > > on Oracle11 started > without "identifier is too > long" error. > > > > > > There is job when it > starts for the first time: > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > > > I think that it would be > better to edit configuration, > because editing > > > table names before running > gatein isn't a good way. > > > > > > > > > > > > > Regards, > > > > Peter > > > > > > > > > > > > On Tue, Mar 9, 2010 at > 11:24 AM, Michal Vančo > <mvanco(a)redhat.com&gt; wrote: > > > > > Yes Bolek, that's > true. > > > > > I can't explain myself > the job in hudson on EPP5 > (epp_ui_selenium_tests_oracle10): > > > > > Because there was same > problem - table or view does > not exist (build > > > > > #3), builds #5 and #7 > were OK (GateIn started with > no errors) and > > > > > following builds again > failed due the same problem as > before. > > > > > > > > > > Regards, > > > > > Michal > > > > > > > > > > Boleslaw Dawidowicz > píše v Út 09. 03. 2010 v 09:59 > +0100: > > > > >> From mentioned logs > it looks like those errors > don't come from IDM. I > > > > >> think the stack trace > in all cases goes via > > > > >> > "org.exoplatform.services.jcr.impl.*" > > > > >> > > > > >> Bolek > > > > >> > > > > >> On 03/09/2010 09:15 > AM, Michal Vančo wrote: > > > > >> > Hi, > > > > >> > > > > > >> > I'm dealing with > problem to start GateIn with > Oracle DB. > > > > >> > I always start with > clean DB and use 2 datasource > instances (JCR, IDM). > > > > >> > > > > > >> > There are 2 > different issues: > > > > >> > Oracle10: > > > > >> > - ORA-00942: table > or view does not exist (start > on > > > > >> > > org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0 ) > > > > >> > - only IDM schema > is initialized, JCR not > > > > >> > > > > > >> > Oracle11: > > > > >> > - ORA-00972: > identifier is too long (Cannot > instantiate component class > > > > >> > > org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) > > > > >> > - both schemas are > created (IDM + JCR) > > > > >> > > > > > >> > To run on oracle, I > change configuration in > idm-configuration.xml and > > > > >> > > jcr-configuration.xml, then > copy jdbc driver and start. > > > > >> > I also add<property > name="hibernate.hbm2ddl.auto" > value="create-drop"/> > > > > >> > to > idm-configuration.xml > (recommended by Boleslaw > Dawidowicz - it worked > > > > >> > on EPP, but not on > GateIn trunk). > > > > >> > > > > > >> > There are links to > log: > > > > >> > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > >> > > > > > >> > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > >> > > > > > >> > > > > > >> > I would appreciate > any help. > > > > >> > > > > > >> > Thanks in advance > > > > >> > Michal Vanco > > > > >> > > > > > >> > > _______________________________________________ > > > > >> > gatein-dev mailing > list > > > > >> > > gatein-dev(a)lists.jboss.org > > > > >> > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > _______________________________________________ > > > > > gatein-dev mailing > list > > > > > > gatein-dev(a)lists.jboss.org > > > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > Thanks, > > > Michal > > > > > > > > > _______________________________________________ > > > gatein-dev mailing list > > > gatein-dev(a)lists.jboss.org > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > -- > > > > > > Nicolas Filotto > > > JCR Product Manager > > > Project Manager > > > eXo Platform SAS > > > nicolas.filotto(a)exoplatform.com > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > -- > > > Nicolas Filotto > > > JCR Product Manager > > > Project Manager > > > eXo Platform SAS > > > nicolas.filotto(a)exoplatform.com > > > +33 (0)6 31 32 92 19 > > > > > > > > _______________________________________________ gatein-dev mailing list gatein-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > -- > > Nicolas Filotto > > JCR Product Manager > > Project Manager > > eXo Platform SAS > > nicolas.filotto(a)exoplatform.com > > +33 (0)6 31 32 92 19 > > > > > > > > -- > > Nicolas Filotto > > JCR Product Manager > > Project Manager > > eXo Platform SAS > > nicolas.filotto(a)exoplatform.com > > +33 (0)6 31 32 92 19 > > > > > > -- > Nicolas Filotto > JCR Product Manager > Project Manager > eXo Platform SAS > nicolas.filotto(a)exoplatform.com > +33 (0)6 31 32 92 19

Hi, Nicolas Filotto wrote: > Could you please provide the list of tables that you can see with your > credentials on oracle 10 G? As I wrote yesterday in my additional reply: I'm using sqldeveloper tool to see the content of oracle DB, and at all oracle10 cases, I can't see that anything is created (tables, sequence, indexes...) in JCR schema. Only IDM schema initialization is done. > > On Wed, Mar 10, 2010 at 8:41 PM, Michal Vančo <mvanco(a)redhat.com&gt; > wrote: > Hi, > > currently I have same results as before (table or view does > not exist) > on oracle10 in these conditions: > - 2 datasources on one machine (differentiated by user names) > - 1 datasource on a machine (JCR and IDM together) > - 2 datasources on separate machines It was added for these cases ^. > > To run GateIn trunk on Oracle10, I do following steps: > - prepare GateIn trunk bundle > - unzip bundle > - change driver class, url, user and password in > jcr-configuration.xml > in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/ > - change driver class, url, user and password in > idm-configuration.xml > in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/organization/ > - add <property name="hibernate.hbm2ddl.auto" > value="create-drop"/> in > idm-configuration.xml > - copy oracle10 jdbc driver into ../server/default/lib > - start gatein by run.sh in bin folder > > (I can provide a script from hudson where you can add your own > paths and > credentials...) > > For oracle11: > - when run with same config as on oracle10, I get error: > ORA-00972: identifier is too long (when initializing > org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) > > - oracle11_jcr.jpg - screen of what has been created in DB > > - if I edit table names > in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/repository-configuration.xml, gatein started correctly > - oracle11_jcr_shorten_names.jpg - screen of what has been > created in DB > > Let me know if you need more details to reproduce it on your > side. > > Best regards, > > Michal > > > Nicolas Filotto píše v St 10. 03. 2010 v 17:39 +0100: > > > > > > > On Wed, Mar 10, 2010 at 5:19 PM, Prabhat Jha > <pjha(a)redhat.com&gt; wrote: > > I have created > https://jira.jboss.org/jira/browse/EXOJCR-582 > > for oracle11 issue. Please check that I have right > affects and > > fix versions. > > > > thx, FYI I've just set the right settings > > > > The version of GateIn and JCR is the one that's in > GateIn > > trunk currently. The way our environment is setup is > that we > > have one Oracle10 DB servers and different usernames > which I > > believe means different schemas in Oracle for > different tests > > (gatein-ui, gatein-jcr etc) configured on that > server. I would > > have to wait for Michal to show up for info. He > needed to > > attend to some personal stuff : hospital to check on > his mom. > > > > But in your environment, you have GateIn starting > fine on > > Oracle 10, right? > > > > no so far, we have only tested with pure JCR but in the same > > conditions as gatein, now as we know the version of gatein > we will try > > with the same version (i.e the trunk) > > > > thanks, > > prabhat > > > > > > > > > > ----- "Nicolas Filotto" <nicolas.filotto(a)gmail.com&gt; > wrote: > > > Prabhat and/or Michal, could you please provide > the answers > > of the questions asked by Peter and me. We cannot > reproduce so > > far, so we need your help. Please note that we > blocked the > > release of GA because of this last issue, so we need > your help > > to fix it asap. > > > > > > > > Thank you in advance, > > BR, > > Nicolas > > > > > > On Wed, Mar 10, 2010 at 3:02 PM, Nicolas Filotto > > <nicolas.filotto(a)gmail.com&gt; wrote: > > > > > Hi Prabhat, > > > > > > > > my comments inline > > > > > > > > > On Wed, Mar 10, 2010 at 2:01 PM, Prabhat > Jha > > <pjha(a)redhat.com&gt; wrote: > > > > > > > > > Hi Nicolas, > > > > > > Yes, a jira is on the way but way > to > > reproduce this problem is quite > simple. You > > start with a clean Oracle 10 > database instance > > and see the problem during startup. > It would > > make sense to have this issue solved > or have a > > work around before GateIn GA. > > > > > It is not enough, we need to know, which > exact version > > of eXo JCR and GateIn, you are using and the > content > > of the files that you modified. > > could you please open a connexion with the > same > > account and give us the list of tables that > you can > > see > > > > > > > > > Quick questions: > > > As per oracle11 finding, is JCR > config > > (table names) going to be updated > across the > > board? > > > > > You mean to change the sql scripts for > oracle 11G? If > > so please create a JIRA, it will be done in > the next > > maintenance version of eXo JCR which will be > 1.12.1 GA > > planned for the end of March > > > > > > Also, I am wondiering given that > Oracle 10 > > has been around for a while, I am > wondering > > what has changed in the latest JCR > that it > > does not work here. Did the last GA > version > > work? > > > > > Hard to say before reproducing your bug > > > > > > > > > > > Thanks, > > > Prabhat > > > > > > > > > > > > > > > > ----- "Nicolas Filotto" > > <nicolas.filotto(a)gmail.com&gt; wrote: > > > > Hi Michal, could you please > create JIRA > > issues in the eXo JCR project > > > (https://jira.jboss.org/jira/browse/EXOJCR) > > with all the information needed to > allow us to > > reproduce? > > > > > > > > > > > > On Wed, Mar 10, 2010 at 1:46 PM, > Nicolas > > Filotto <nicolas.filotto(a)gmail.com&gt; > wrote: > > > > > > > > > > > > > > > > > > > > > On Wed, Mar 10, 2010 at > 1:29 PM, > > Michal Vančo > <mvanco(a)redhat.com&gt; > > wrote: > > > > > > Hi, > > > > > > > > oracle11 now > works, > > oracle10 not. See > below... > > > > > > > > Peter Nedonosko > wrote > > > > > > > Hi, > > > > > > > > > > about Oracle > 10 and ' > > table or view does > not exist': > > > > > the problem is > possible > > if addConfig used in > > > > > > > > org.exoplatform.services.jcr.config.RepositoryServiceConfiguration > > > > > (I found it in > portal > > \trunk\examples > \portal\war\src > > \main\webapp\WEB-INF > \conf > > \sample-portal\jcr > > > \jcr-configuration.xml) > > > > > > > > > > What you meant with > addConfig > > plugin? > > > > Should I add > > > <set-method>addConfig</set-method> in > > > > > jcr-configuration.xml? > > > > Or how can I > solve 'table > > or view does not > exist' on > > oracle10? > > > > > > > > > > > > I guess it is not related > since it > > works with other databases > > > > > > > > > > > > > > > > > if the > database is > > creating from the > scratch and > > if the configuration > > > > > persister got > an answer > > from the Oracle - > your table > > exists in > > > > > > isDbInitialized(): > > > > > ResultSet trs > = > > > con.getMetaData().getTables(null, null, configTableName, > null); > > > > > return > trs.next(); // > > true = yes > > > > > > > > > > but then > Oracle fails > > with > > > > > > PreparedStatement ps = > > > con.prepareStatement("SELECT > > COUNT(*) FROM " + > > > > > > configTableName + " > > WHERE NAME=?"); > > > > > > ps.executeQuery(); // > > here > > > > > > > > > > but I have to > reproduce > > it first... > > > > > does Oracle 10 > and 11 > > runs on clean > database from > > the start? > > > > > or just > restarted on > > existing db for > Oracle 11? > > > > > > > > > > Always on clean DBs. > > > > > > > > > > > > > > > > about > Oracle11: > > > > > seems it's > related to > > JBossCache loader, > it creates > > a table longer of > > > > > 30 symbols > (ORA-00972: > > identifier is too > long). > > > > > Why it's not a > problem > > for Oracle10 or why > JBossCache > > acts in > > > > > different way > on > > Oracle10 or etc... > > > > > try to fix the > problem > > with shorten table > name from > > > repository-configuration.xml > > > > > e.g. > > > > > <property > > > name="jbosscache-cl-cache.jdbc.table.name" > value="lock_portalsys" /> > > > > > instead of > > > > > <property > > > name="jbosscache-cl-cache.jdbc.table.name" > > > > > > > > value="jcrlock_portal_system" /> > > > > > it should > helps. > > > > > > > > > > I shortened all > table names in > > > repository-configuration.xml > > and GateIn > > > > on Oracle11 > started > > without "identifier > is too > > long" error. > > > > > > > > There is job > when it > > starts for the first > time: > > > > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > > > > > I think that it > would be > > better to edit > configuration, > > because editing > > > > table names > before running > > gatein isn't a good > way. > > > > > > > > > > > > > > > > > > Regards, > > > > > Peter > > > > > > > > > > > > > > > On Tue, Mar 9, > 2010 at > > 11:24 AM, Michal > Vančo > > <mvanco(a)redhat.com&gt; > wrote: > > > > > > Yes Bolek, > that's > > true. > > > > > > I can't > explain myself > > the job in hudson on > EPP5 > > > (epp_ui_selenium_tests_oracle10): > > > > > > Because > there was same > > problem - table or > view does > > not exist (build > > > > > > #3), builds > #5 and #7 > > were OK (GateIn > started with > > no errors) and > > > > > > following > builds again > > failed due the same > problem as > > before. > > > > > > > > > > > > Regards, > > > > > > Michal > > > > > > > > > > > > Boleslaw > Dawidowicz > > píše v Út 09. 03. > 2010 v 09:59 > > +0100: > > > > > >> From > mentioned logs > > it looks like those > errors > > don't come from IDM. > I > > > > > >> think the > stack trace > > in all cases goes > via > > > > > >> > > > "org.exoplatform.services.jcr.impl.*" > > > > > >> > > > > > >> Bolek > > > > > >> > > > > > >> On > 03/09/2010 09:15 > > AM, Michal Vančo > wrote: > > > > > >> > Hi, > > > > > >> > > > > > > >> > I'm > dealing with > > problem to start > GateIn with > > Oracle DB. > > > > > >> > I always > start with > > clean DB and use 2 > datasource > > instances (JCR, > IDM). > > > > > >> > > > > > > >> > There are > 2 > > different issues: > > > > > >> > Oracle10: > > > > > >> > - > ORA-00942: table > > or view does not > exist (start > > on > > > > > >> > > > > org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0 ) > > > > > >> > - only > IDM schema > > is initialized, JCR > not > > > > > >> > > > > > > >> > Oracle11: > > > > > >> > - > ORA-00972: > > identifier is too > long (Cannot > > instantiate > component class > > > > > >> > > > > org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) > > > > > >> > - both > schemas are > > created (IDM + JCR) > > > > > >> > > > > > > >> > To run on > oracle, I > > change configuration > in > > > idm-configuration.xml and > > > > > >> > > > > jcr-configuration.xml, then > > copy jdbc driver and > start. > > > > > >> > I also > add<property > > > name="hibernate.hbm2ddl.auto" > > > value="create-drop"/> > > > > > >> > to > > > idm-configuration.xml > > (recommended by > Boleslaw > > Dawidowicz - it > worked > > > > > >> > on EPP, > but not on > > GateIn trunk). > > > > > >> > > > > > > >> > There are > links to > > log: > > > > > >> > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > > >> > > > > > > >> > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > > >> > > > > > > >> > > > > > > >> > I would > appreciate > > any help. > > > > > >> > > > > > > >> > Thanks in > advance > > > > > >> > Michal > Vanco > > > > > >> > > > > > > >> > > > > _______________________________________________ > > > > > >> > > gatein-dev mailing > > list > > > > > >> > > > > gatein-dev(a)lists.jboss.org > > > > > >> > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > > > gatein-dev > mailing > > list > > > > > > > > > gatein-dev(a)lists.jboss.org > > > > > > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > > > > > Thanks, > > > > Michal > > > > > > > > > > > > > > > _______________________________________________ > > > > gatein-dev > mailing list > > > > > gatein-dev(a)lists.jboss.org > > > > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > -- > > > > > > > > > Nicolas Filotto > > > > JCR Product Manager > > > > Project Manager > > > > eXo Platform SAS > > > > > nicolas.filotto(a)exoplatform.com > > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > > > > > > -- > > > > Nicolas Filotto > > > > JCR Product Manager > > > > Project Manager > > > > eXo Platform SAS > > > > nicolas.filotto(a)exoplatform.com > > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > > > _______________________________________________ gatein-dev > mailing list gatein-dev(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > -- > > > Nicolas Filotto > > > JCR Product Manager > > > Project Manager > > > eXo Platform SAS > > > nicolas.filotto(a)exoplatform.com > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > > > -- > > > Nicolas Filotto > > > JCR Product Manager > > > Project Manager > > > eXo Platform SAS > > > nicolas.filotto(a)exoplatform.com > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > -- > > Nicolas Filotto > > JCR Product Manager > > Project Manager > > eXo Platform SAS > > nicolas.filotto(a)exoplatform.com > > +33 (0)6 31 32 92 19 > > > > > > -- > Nicolas Filotto > JCR Product Manager > Project Manager > eXo Platform SAS > nicolas.filotto(a)exoplatform.com > +33 (0)6 31 32 92 19 Michal

Nicolas Filotto wrote: > in sqldeveloper, try to launch this script > http://anonsvn.jboss.org/repos/exo-jcr/jcr/tags/1.12.0-GA/exo.jcr.compone... you are in single db mode or http://anonsvn.jboss.org/repos/exo-jcr/jcr/tags/1.12.0-GA/exo.jcr.compone... you are in multi db mode I'm using single db. After running given script - tables, indexes, trigger and sequence were created. But JCR_CONFIG table isn't present in the script.

GateIn is still failing with the same issue. After I added this: CREATE TABLE "EPP5UIDB"."JCR_CONFIG" ( "NAME" VARCHAR2(64 BYTE) NOT NULL ENABLE, "CONFIG" BLOB NOT NULL ENABLE, CONSTRAINT "JCR_CONFIG_PK" PRIMARY KEY ("NAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" ENABLE ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOB ("CONFIG") STORE AS BASICFILE ( TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) ; (this is the exported DDL of jcr_config from oracle11 db) GateIn started without erors on oracle10!!!! > > On Thu, Mar 11, 2010 at 8:36 AM, Michal Vančo <mvanco(a)redhat.com&gt; > wrote: > Hi, > > Nicolas Filotto wrote: > > Could you please provide the list of tables that you can see > with your > > credentials on oracle 10 G? > > > As I wrote yesterday in my additional reply: > I'm using sqldeveloper tool to see the content of oracle DB, > and at all > > oracle10 cases, I can't see that anything is created (tables, > sequence, > indexes...) in JCR schema. Only IDM schema initialization is > done. > > > > > > On Wed, Mar 10, 2010 at 8:41 PM, Michal Vančo > <mvanco(a)redhat.com&gt; > > wrote: > > Hi, > > > > currently I have same results as before (table or > view does > > not exist) > > on oracle10 in these conditions: > > - 2 datasources on one machine (differentiated by > user names) > > - 1 datasource on a machine (JCR and IDM together) > > - 2 datasources on separate machines > > > It was added for these cases ^. > > > > > > To run GateIn trunk on Oracle10, I do following > steps: > > - prepare GateIn trunk bundle > > - unzip bundle > > - change driver class, url, user and password in > > jcr-configuration.xml > > > in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/ > > - change driver class, url, user and password in > > idm-configuration.xml > > > in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/organization/ > > - add <property name="hibernate.hbm2ddl.auto" > > value="create-drop"/> in > > idm-configuration.xml > > - copy oracle10 jdbc driver > into ../server/default/lib > > - start gatein by run.sh in bin folder > > > > (I can provide a script from hudson where you can > add your own > > paths and > > credentials...) > > > > For oracle11: > > - when run with same config as on oracle10, I get > error: > > ORA-00972: identifier is too long (when initializing > > > org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) > > > > - oracle11_jcr.jpg - screen of what has been > created in DB > > > > - if I edit table names > > > in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/repository-configuration.xml, gatein started correctly > > - oracle11_jcr_shorten_names.jpg - screen of what > has been > > created in DB > > > > Let me know if you need more details to reproduce it > on your > > side. > > > > Best regards, > > > > Michal > > > > > > Nicolas Filotto píše v St 10. 03. 2010 v 17:39 > +0100: > > > > > > > > > > > On Wed, Mar 10, 2010 at 5:19 PM, Prabhat Jha > > <pjha(a)redhat.com&gt; wrote: > > > I have created > > https://jira.jboss.org/jira/browse/EXOJCR-582 > > > for oracle11 issue. Please check that I > have right > > affects and > > > fix versions. > > > > > > thx, FYI I've just set the right settings > > > > > > The version of GateIn and JCR is the one > that's in > > GateIn > > > trunk currently. The way our environment > is setup is > > that we > > > have one Oracle10 DB servers and different > usernames > > which I > > > believe means different schemas in Oracle > for > > different tests > > > (gatein-ui, gatein-jcr etc) configured on > that > > server. I would > > > have to wait for Michal to show up for > info. He > > needed to > > > attend to some personal stuff : hospital > to check on > > his mom. > > > > > > But in your environment, you have GateIn > starting > > fine on > > > Oracle 10, right? > > > > > > no so far, we have only tested with pure JCR but > in the same > > > conditions as gatein, now as we know the version > of gatein > > we will try > > > with the same version (i.e the trunk) > > > > > > thanks, > > > prabhat > > > > > > > > > > > > > > > ----- "Nicolas Filotto" > <nicolas.filotto(a)gmail.com&gt; > > wrote: > > > > Prabhat and/or Michal, could you please > provide > > the answers > > > of the questions asked by Peter and me. We > cannot > > reproduce so > > > far, so we need your help. Please note > that we > > blocked the > > > release of GA because of this last issue, > so we need > > your help > > > to fix it asap. > > > > > > > > > > > Thank you in advance, > > > BR, > > > Nicolas > > > > > > > > On Wed, Mar 10, 2010 at 3:02 PM, Nicolas > Filotto > > > <nicolas.filotto(a)gmail.com&gt; wrote: > > > > > > > Hi Prabhat, > > > > > > > > > > > my comments inline > > > > > > > > > > > > On Wed, Mar 10, 2010 at 2:01 PM, > Prabhat > > Jha > > > <pjha(a)redhat.com&gt; wrote: > > > > > > > > > > > > Hi Nicolas, > > > > > > > > Yes, a jira is on the > way but way > > to > > > reproduce this problem is > quite > > simple. You > > > start with a clean Oracle > 10 > > database instance > > > and see the problem during > startup. > > It would > > > make sense to have this > issue solved > > or have a > > > work around before GateIn > GA. > > > > > > > It is not enough, we need to know, > which > > exact version > > > of eXo JCR and GateIn, you are > using and the > > content > > > of the files that you modified. > > > could you please open a connexion > with the > > same > > > account and give us the list of > tables that > > you can > > > see > > > > > > > > > > > > Quick questions: > > > > As per oracle11 > finding, is JCR > > config > > > (table names) going to be > updated > > across the > > > board? > > > > > > > You mean to change the sql > scripts for > > oracle 11G? If > > > so please create a JIRA, it will > be done in > > the next > > > maintenance version of eXo JCR > which will be > > 1.12.1 GA > > > planned for the end of March > > > > > > > > Also, I am wondiering > given that > > Oracle 10 > > > has been around for a > while, I am > > wondering > > > what has changed in the > latest JCR > > that it > > > does not work here. Did > the last GA > > version > > > work? > > > > > > > Hard to say before reproducing > your bug > > > > > > > > > > > > > > > Thanks, > > > > Prabhat > > > > > > > > > > > > > > > > > > > > > > ----- "Nicolas Filotto" > > > > <nicolas.filotto(a)gmail.com&gt; wrote: > > > > > Hi Michal, could you > please > > create JIRA > > > issues in the eXo JCR > project > > > > > (https://jira.jboss.org/jira/browse/EXOJCR) > > > with all the information > needed to > > allow us to > > > reproduce? > > > > > > > > > > > > > > > On Wed, Mar 10, 2010 > at 1:46 PM, > > Nicolas > > > Filotto > <nicolas.filotto(a)gmail.com&gt; > > wrote: > > > > > > > > > > > > > > > > > > > > > > > > > > > On Wed, Mar 10, > 2010 at > > 1:29 PM, > > > Michal Vančo > > <mvanco(a)redhat.com&gt; > > > wrote: > > > > > > > > Hi, > > > > > > > > > > > oracle11 now > > works, > > > oracle10 > not. See > > below... > > > > > > > > > > Peter > Nedonosko > > wrote > > > > > > > > > Hi, > > > > > > > > > > > > > about Oracle > > 10 and ' > > > table or > view does > > not exist': > > > > > > the > problem is > > possible > > > if > addConfig used in > > > > > > > > > > > > org.exoplatform.services.jcr.config.RepositoryServiceConfiguration > > > > > > (I > found it in > > portal > > > \trunk > \examples > > \portal\war\src > > > \main > \webapp\WEB-INF > > \conf > > > > \sample-portal\jcr > > > > > \jcr-configuration.xml) > > > > > > > > > > > > > What you > meant with > > addConfig > > > plugin? > > > > > Should > I add > > > > > <set-method>addConfig</set-method> in > > > > > > > jcr-configuration.xml? > > > > > Or how > can I > > solve 'table > > > or view > does not > > exist' on > > > oracle10? > > > > > > > > > > > > > > > > I guess it is not > related > > since it > > > works with other > databases > > > > > > > > > > > > > > > > > > > > > > if > the > > database is > > > creating > from the > > scratch and > > > if the > configuration > > > > > > > persister got > > an answer > > > from the > Oracle - > > your table > > > exists in > > > > > > > > isDbInitialized(): > > > > > > > ResultSet trs > > = > > > > > con.getMetaData().getTables(null, null, > configTableName, > > null); > > > > > > > return > > trs.next(); // > > > true = yes > > > > > > > > > > > > but > then > > Oracle fails > > > with > > > > > > > > PreparedStatement ps = > > > > > con.prepareStatement("SELECT > > > COUNT(*) > FROM " + > > > > > > > > configTableName + " > > > WHERE > NAME=?"); > > > > > > > > ps.executeQuery(); // > > > here > > > > > > > > > > > > but > I have to > > reproduce > > > it > first... > > > > > > does > Oracle 10 > > and 11 > > > runs on > clean > > database from > > > the start? > > > > > > or > just > > restarted on > > > existing > db for > > Oracle 11? > > > > > > > > > > > > > Always on > clean DBs. > > > > > > > > > > > > > > > > > > > > > about > > Oracle11: > > > > > > > seems it's > > related to > > > JBossCache > loader, > > it creates > > > a table > longer of > > > > > > 30 > symbols > > (ORA-00972: > > > identifier > is too > > long). > > > > > > Why > it's not a > > problem > > > for > Oracle10 or why > > JBossCache > > > acts in > > > > > > > different way > > on > > > Oracle10 > or etc... > > > > > > try > to fix the > > problem > > > with > shorten table > > name from > > > > > repository-configuration.xml > > > > > > e.g. > > > > > > > <property > > > > > name="jbosscache-cl-cache.jdbc.table.name" > > value="lock_portalsys" /> > > > > > > > instead of > > > > > > > <property > > > > > name="jbosscache-cl-cache.jdbc.table.name" > > > > > > > > > > > value="jcrlock_portal_system" /> > > > > > > it > should > > helps. > > > > > > > > > > > > > I > shortened all > > table names in > > > > > repository-configuration.xml > > > and GateIn > > > > > on > Oracle11 > > started > > > without > "identifier > > is too > > > long" > error. > > > > > > > > > > There > is job > > when it > > > starts for > the first > > time: > > > > > > > > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > > > > > > > I > think that it > > would be > > > better to > edit > > configuration, > > > because > editing > > > > > table > names > > before running > > > gatein > isn't a good > > way. > > > > > > > > > > > > > > > > > > > > > > > > Regards, > > > > > > > Peter > > > > > > > > > > > > > > > > > > On > Tue, Mar 9, > > 2010 at > > > 11:24 AM, > Michal > > Vančo > > > > <mvanco(a)redhat.com&gt; > > wrote: > > > > > > > > Yes Bolek, > > that's > > > true. > > > > > > > I > can't > > explain myself > > > the job in > hudson on > > EPP5 > > > > > (epp_ui_selenium_tests_oracle10): > > > > > > > > Because > > there was same > > > problem - > table or > > view does > > > not exist > (build > > > > > > > > #3), builds > > #5 and #7 > > > were OK > (GateIn > > started with > > > no errors) > and > > > > > > > > following > > builds again > > > failed due > the same > > problem as > > > before. > > > > > > > > > > > > > > > Regards, > > > > > > > > Michal > > > > > > > > > > > > > > > Boleslaw > > Dawidowicz > > > píše v Út > 09. 03. > > 2010 v 09:59 > > > +0100: > > > > > > >> > From > > mentioned logs > > > it looks > like those > > errors > > > don't come > from IDM. > > I > > > > > > >> > think the > > stack trace > > > in all > cases goes > > via > > > > > > >> > > > > > "org.exoplatform.services.jcr.impl.*" > > > > > > >> > > > > > > >> > Bolek > > > > > > >> > > > > > > >> > On > > 03/09/2010 09:15 > > > AM, Michal > Vančo > > wrote: > > > > > > >> > > Hi, > > > > > > >> > > > > > > > >> > > I'm > > dealing with > > > problem to > start > > GateIn with > > > Oracle DB. > > > > > > >> > > I always > > start with > > > clean DB > and use 2 > > datasource > > > instances > (JCR, > > IDM). > > > > > > >> > > > > > > > >> > > There are > > 2 > > > different > issues: > > > > > > >> > > Oracle10: > > > > > > >> > > - > > ORA-00942: table > > > or view > does not > > exist (start > > > on > > > > > > >> > > > > > > > org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0 ) > > > > > > >> > > - only > > IDM schema > > > is > initialized, JCR > > not > > > > > > >> > > > > > > > >> > > Oracle11: > > > > > > >> > > - > > ORA-00972: > > > identifier > is too > > long (Cannot > > > > instantiate > > component class > > > > > > >> > > > > > > > org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) > > > > > > >> > > - both > > schemas are > > > created > (IDM + JCR) > > > > > > >> > > > > > > > >> > > To run on > > oracle, I > > > change > configuration > > in > > > > > idm-configuration.xml and > > > > > > >> > > > > > > jcr-configuration.xml, then > > > copy jdbc > driver and > > start. > > > > > > >> > > I also > > add<property > > > > > name="hibernate.hbm2ddl.auto" > > > > > value="create-drop"/> > > > > > > >> > > to > > > > > idm-configuration.xml > > > > (recommended by > > Boleslaw > > > Dawidowicz > - it > > worked > > > > > > >> > > on EPP, > > but not on > > > GateIn > trunk). > > > > > > >> > > > > > > > >> > > There are > > links to > > > log: > > > > > > >> > > > > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > > > >> > > > > > > > >> > > > > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > > > >> > > > > > > > >> > > > > > > > >> > > I would > > appreciate > > > any help. > > > > > > >> > > > > > > > >> > > Thanks in > > advance > > > > > > >> > > Michal > > Vanco > > > > > > >> > > > > > > > >> > > > > > > _______________________________________________ > > > > > > >> > > > gatein-dev mailing > > > list > > > > > > >> > > > > > > gatein-dev(a)lists.jboss.org > > > > > > >> > > > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > > > > > gatein-dev > > mailing > > > list > > > > > > > > > > > > gatein-dev(a)lists.jboss.org > > > > > > > > > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > > > > > > > > > > Thanks, > > > > > Michal > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > > > gatein-dev > > mailing list > > > > > > > gatein-dev(a)lists.jboss.org > > > > > > > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > Nicolas Filotto > > > > > JCR Product > Manager > > > > > Project > Manager > > > > > eXo Platform > SAS > > > > > > > nicolas.filotto(a)exoplatform.com > > > > > +33 (0)6 31 32 > 92 19 > > > > > > > > > > > > > > > > > > > > > -- > > > > > Nicolas Filotto > > > > > JCR Product Manager > > > > > Project Manager > > > > > eXo Platform SAS > > > > > > nicolas.filotto(a)exoplatform.com > > > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > > > > > > > > _______________________________________________ > gatein-dev > > mailing list gatein-dev(a)lists.jboss.org > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > > > -- > > > > Nicolas Filotto > > > > JCR Product Manager > > > > Project Manager > > > > eXo Platform SAS > > > > nicolas.filotto(a)exoplatform.com > > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > > > > > > > > -- > > > > Nicolas Filotto > > > > JCR Product Manager > > > > Project Manager > > > > eXo Platform SAS > > > > nicolas.filotto(a)exoplatform.com > > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > > > > > > -- > > > Nicolas Filotto > > > JCR Product Manager > > > Project Manager > > > eXo Platform SAS > > > nicolas.filotto(a)exoplatform.com > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > > -- > > Nicolas Filotto > > JCR Product Manager > > Project Manager > > eXo Platform SAS > > nicolas.filotto(a)exoplatform.com > > +33 (0)6 31 32 92 19 > > > Michal > > > > > -- > Nicolas Filotto > JCR Product Manager > Project Manager > eXo Platform SAS > nicolas.filotto(a)exoplatform.com > +33 (0)6 31 32 92 19

Hi, today I checked following situations with oracle10: - oracle11 driver for oracle10 db - create bundle with JCR 1.12.0-GA - delete gatein-sample* in server/default/deploy -> only change was that it failed with: Cannot create the portal container 'portal', before it was: Cannot create the portal container 'sample-portal' and Cannot create the portal container 'portal' - creating jcr tables manually with script: http://anonsvn.jboss.org/repos/exo-jcr/jcr/tags/1.12.0-GA/exo.jcr.compone... didn't help, but after adding script to create JCR_CONFIG table -> it started to work (detail of script in another mail on gatein-dev) So, looks like JCR don't want to initialize. Any suggestions why?

Michal Michal Vančo wrote: > Hi, > > Nicolas Filotto wrote: > > Could you please provide the list of tables that you can see with your > > credentials on oracle 10 G? > > As I wrote yesterday in my additional reply: > I'm using sqldeveloper tool to see the content of oracle DB, and at all > oracle10 cases, I can't see that anything is created (tables, sequence, > indexes...) in JCR schema. Only IDM schema initialization is done. > > > > > On Wed, Mar 10, 2010 at 8:41 PM, Michal Vančo <mvanco(a)redhat.com&gt; > > wrote: > > Hi, > > > > currently I have same results as before (table or view does > > not exist) > > on oracle10 in these conditions: > > - 2 datasources on one machine (differentiated by user names) > > - 1 datasource on a machine (JCR and IDM together) > > - 2 datasources on separate machines > > It was added for these cases ^. > > > > > To run GateIn trunk on Oracle10, I do following steps: > > - prepare GateIn trunk bundle > > - unzip bundle > > - change driver class, url, user and password in > > jcr-configuration.xml > > in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/ > > - change driver class, url, user and password in > > idm-configuration.xml > > in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/organization/ > > - add <property name="hibernate.hbm2ddl.auto" > > value="create-drop"/> in > > idm-configuration.xml > > - copy oracle10 jdbc driver into ../server/default/lib > > - start gatein by run.sh in bin folder > > > > (I can provide a script from hudson where you can add your own > > paths and > > credentials...) > > > > For oracle11: > > - when run with same config as on oracle10, I get error: > > ORA-00972: identifier is too long (when initializing > > org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) > > > > - oracle11_jcr.jpg - screen of what has been created in DB > > > > - if I edit table names > > in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/repository-configuration.xml, gatein started correctly > > - oracle11_jcr_shorten_names.jpg - screen of what has been > > created in DB > > > > Let me know if you need more details to reproduce it on your > > side. > > > > Best regards, > > > > Michal > > > > > > Nicolas Filotto píše v St 10. 03. 2010 v 17:39 +0100: > > > > > > > > > > > On Wed, Mar 10, 2010 at 5:19 PM, Prabhat Jha > > <pjha(a)redhat.com&gt; wrote: > > > I have created > > https://jira.jboss.org/jira/browse/EXOJCR-582 > > > for oracle11 issue. Please check that I have right > > affects and > > > fix versions. > > > > > > thx, FYI I've just set the right settings > > > > > > The version of GateIn and JCR is the one that's in > > GateIn > > > trunk currently. The way our environment is setup is > > that we > > > have one Oracle10 DB servers and different usernames > > which I > > > believe means different schemas in Oracle for > > different tests > > > (gatein-ui, gatein-jcr etc) configured on that > > server. I would > > > have to wait for Michal to show up for info. He > > needed to > > > attend to some personal stuff : hospital to check on > > his mom. > > > > > > But in your environment, you have GateIn starting > > fine on > > > Oracle 10, right? > > > > > > no so far, we have only tested with pure JCR but in the same > > > conditions as gatein, now as we know the version of gatein > > we will try > > > with the same version (i.e the trunk) > > > > > > thanks, > > > prabhat > > > > > > > > > > > > > > > ----- "Nicolas Filotto" <nicolas.filotto(a)gmail.com&gt; > > wrote: > > > > Prabhat and/or Michal, could you please provide > > the answers > > > of the questions asked by Peter and me. We cannot > > reproduce so > > > far, so we need your help. Please note that we > > blocked the > > > release of GA because of this last issue, so we need > > your help > > > to fix it asap. > > > > > > > > > > > Thank you in advance, > > > BR, > > > Nicolas > > > > > > > > On Wed, Mar 10, 2010 at 3:02 PM, Nicolas Filotto > > > <nicolas.filotto(a)gmail.com&gt; wrote: > > > > > > > Hi Prabhat, > > > > > > > > > > > my comments inline > > > > > > > > > > > > On Wed, Mar 10, 2010 at 2:01 PM, Prabhat > > Jha > > > <pjha(a)redhat.com&gt; wrote: > > > > > > > > > > > > Hi Nicolas, > > > > > > > > Yes, a jira is on the way but way > > to > > > reproduce this problem is quite > > simple. You > > > start with a clean Oracle 10 > > database instance > > > and see the problem during startup. > > It would > > > make sense to have this issue solved > > or have a > > > work around before GateIn GA. > > > > > > > It is not enough, we need to know, which > > exact version > > > of eXo JCR and GateIn, you are using and the > > content > > > of the files that you modified. > > > could you please open a connexion with the > > same > > > account and give us the list of tables that > > you can > > > see > > > > > > > > > > > > Quick questions: > > > > As per oracle11 finding, is JCR > > config > > > (table names) going to be updated > > across the > > > board? > > > > > > > You mean to change the sql scripts for > > oracle 11G? If > > > so please create a JIRA, it will be done in > > the next > > > maintenance version of eXo JCR which will be > > 1.12.1 GA > > > planned for the end of March > > > > > > > > Also, I am wondiering given that > > Oracle 10 > > > has been around for a while, I am > > wondering > > > what has changed in the latest JCR > > that it > > > does not work here. Did the last GA > > version > > > work? > > > > > > > Hard to say before reproducing your bug > > > > > > > > > > > > > > > Thanks, > > > > Prabhat > > > > > > > > > > > > > > > > > > > > > > ----- "Nicolas Filotto" > > > <nicolas.filotto(a)gmail.com&gt; wrote: > > > > > Hi Michal, could you please > > create JIRA > > > issues in the eXo JCR project > > > > > (https://jira.jboss.org/jira/browse/EXOJCR) > > > with all the information needed to > > allow us to > > > reproduce? > > > > > > > > > > > > > > > On Wed, Mar 10, 2010 at 1:46 PM, > > Nicolas > > > Filotto <nicolas.filotto(a)gmail.com&gt; > > wrote: > > > > > > > > > > > > > > > > > > > > > > > > > > > On Wed, Mar 10, 2010 at > > 1:29 PM, > > > Michal Vančo > > <mvanco(a)redhat.com&gt; > > > wrote: > > > > > > > > Hi, > > > > > > > > > > oracle11 now > > works, > > > oracle10 not. See > > below... > > > > > > > > > > Peter Nedonosko > > wrote > > > > > > > > > Hi, > > > > > > > > > > > > about Oracle > > 10 and ' > > > table or view does > > not exist': > > > > > > the problem is > > possible > > > if addConfig used in > > > > > > > > > > > org.exoplatform.services.jcr.config.RepositoryServiceConfiguration > > > > > > (I found it in > > portal > > > \trunk\examples > > \portal\war\src > > > \main\webapp\WEB-INF > > \conf > > > \sample-portal\jcr > > > > > \jcr-configuration.xml) > > > > > > > > > > > > > What you meant with > > addConfig > > > plugin? > > > > > Should I add > > > > > <set-method>addConfig</set-method> in > > > > > > > jcr-configuration.xml? > > > > > Or how can I > > solve 'table > > > or view does not > > exist' on > > > oracle10? > > > > > > > > > > > > > > > > I guess it is not related > > since it > > > works with other databases > > > > > > > > > > > > > > > > > > > > > > if the > > database is > > > creating from the > > scratch and > > > if the configuration > > > > > > persister got > > an answer > > > from the Oracle - > > your table > > > exists in > > > > > > > > isDbInitialized(): > > > > > > ResultSet trs > > = > > > > > con.getMetaData().getTables(null, null, configTableName, > > null); > > > > > > return > > trs.next(); // > > > true = yes > > > > > > > > > > > > but then > > Oracle fails > > > with > > > > > > > > PreparedStatement ps = > > > > > con.prepareStatement("SELECT > > > COUNT(*) FROM " + > > > > > > > > configTableName + " > > > WHERE NAME=?"); > > > > > > > > ps.executeQuery(); // > > > here > > > > > > > > > > > > but I have to > > reproduce > > > it first... > > > > > > does Oracle 10 > > and 11 > > > runs on clean > > database from > > > the start? > > > > > > or just > > restarted on > > > existing db for > > Oracle 11? > > > > > > > > > > > > > Always on clean DBs. > > > > > > > > > > > > > > > > > > > > about > > Oracle11: > > > > > > seems it's > > related to > > > JBossCache loader, > > it creates > > > a table longer of > > > > > > 30 symbols > > (ORA-00972: > > > identifier is too > > long). > > > > > > Why it's not a > > problem > > > for Oracle10 or why > > JBossCache > > > acts in > > > > > > different way > > on > > > Oracle10 or etc... > > > > > > try to fix the > > problem > > > with shorten table > > name from > > > > > repository-configuration.xml > > > > > > e.g. > > > > > > <property > > > > > name="jbosscache-cl-cache.jdbc.table.name" > > value="lock_portalsys" /> > > > > > > instead of > > > > > > <property > > > > > name="jbosscache-cl-cache.jdbc.table.name" > > > > > > > > > > > value="jcrlock_portal_system" /> > > > > > > it should > > helps. > > > > > > > > > > > > > I shortened all > > table names in > > > > > repository-configuration.xml > > > and GateIn > > > > > on Oracle11 > > started > > > without "identifier > > is too > > > long" error. > > > > > > > > > > There is job > > when it > > > starts for the first > > time: > > > > > > > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > > > > > > > I think that it > > would be > > > better to edit > > configuration, > > > because editing > > > > > table names > > before running > > > gatein isn't a good > > way. > > > > > > > > > > > > > > > > > > > > > > > Regards, > > > > > > Peter > > > > > > > > > > > > > > > > > > On Tue, Mar 9, > > 2010 at > > > 11:24 AM, Michal > > Vančo > > > <mvanco(a)redhat.com&gt; > > wrote: > > > > > > > Yes Bolek, > > that's > > > true. > > > > > > > I can't > > explain myself > > > the job in hudson on > > EPP5 > > > > > (epp_ui_selenium_tests_oracle10): > > > > > > > Because > > there was same > > > problem - table or > > view does > > > not exist (build > > > > > > > #3), builds > > #5 and #7 > > > were OK (GateIn > > started with > > > no errors) and > > > > > > > following > > builds again > > > failed due the same > > problem as > > > before. > > > > > > > > > > > > > > Regards, > > > > > > > Michal > > > > > > > > > > > > > > Boleslaw > > Dawidowicz > > > píše v Út 09. 03. > > 2010 v 09:59 > > > +0100: > > > > > > >> From > > mentioned logs > > > it looks like those > > errors > > > don't come from IDM. > > I > > > > > > >> think the > > stack trace > > > in all cases goes > > via > > > > > > >> > > > > > "org.exoplatform.services.jcr.impl.*" > > > > > > >> > > > > > > >> Bolek > > > > > > >> > > > > > > >> On > > 03/09/2010 09:15 > > > AM, Michal Vančo > > wrote: > > > > > > >> > Hi, > > > > > > >> > > > > > > > >> > I'm > > dealing with > > > problem to start > > GateIn with > > > Oracle DB. > > > > > > >> > I always > > start with > > > clean DB and use 2 > > datasource > > > instances (JCR, > > IDM). > > > > > > >> > > > > > > > >> > There are > > 2 > > > different issues: > > > > > > >> > Oracle10: > > > > > > >> > - > > ORA-00942: table > > > or view does not > > exist (start > > > on > > > > > > >> > > > > > > org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0 ) > > > > > > >> > - only > > IDM schema > > > is initialized, JCR > > not > > > > > > >> > > > > > > > >> > Oracle11: > > > > > > >> > - > > ORA-00972: > > > identifier is too > > long (Cannot > > > instantiate > > component class > > > > > > >> > > > > > > org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) > > > > > > >> > - both > > schemas are > > > created (IDM + JCR) > > > > > > >> > > > > > > > >> > To run on > > oracle, I > > > change configuration > > in > > > > > idm-configuration.xml and > > > > > > >> > > > > > > jcr-configuration.xml, then > > > copy jdbc driver and > > start. > > > > > > >> > I also > > add<property > > > > > name="hibernate.hbm2ddl.auto" > > > > > value="create-drop"/> > > > > > > >> > to > > > > > idm-configuration.xml > > > (recommended by > > Boleslaw > > > Dawidowicz - it > > worked > > > > > > >> > on EPP, > > but not on > > > GateIn trunk). > > > > > > >> > > > > > > > >> > There are > > links to > > > log: > > > > > > >> > > > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > > > >> > > > > > > > >> > > > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > > > >> > > > > > > > >> > > > > > > > >> > I would > > appreciate > > > any help. > > > > > > >> > > > > > > > >> > Thanks in > > advance > > > > > > >> > Michal > > Vanco > > > > > > >> > > > > > > > >> > > > > > > _______________________________________________ > > > > > > >> > > > gatein-dev mailing > > > list > > > > > > >> > > > > > > gatein-dev(a)lists.jboss.org > > > > > > >> > > > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > > > > gatein-dev > > mailing > > > list > > > > > > > > > > > > gatein-dev(a)lists.jboss.org > > > > > > > > > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > > > > > > > > > > Thanks, > > > > > Michal > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > > gatein-dev > > mailing list > > > > > > > gatein-dev(a)lists.jboss.org > > > > > > > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > Nicolas Filotto > > > > > JCR Product Manager > > > > > Project Manager > > > > > eXo Platform SAS > > > > > > > nicolas.filotto(a)exoplatform.com > > > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > > > > > > > > > > > -- > > > > > Nicolas Filotto > > > > > JCR Product Manager > > > > > Project Manager > > > > > eXo Platform SAS > > > > > nicolas.filotto(a)exoplatform.com > > > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > > > > > > > > _______________________________________________ gatein-dev > > mailing list gatein-dev(a)lists.jboss.org > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > > > -- > > > > Nicolas Filotto > > > > JCR Product Manager > > > > Project Manager > > > > eXo Platform SAS > > > > nicolas.filotto(a)exoplatform.com > > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > > > > > > > > -- > > > > Nicolas Filotto > > > > JCR Product Manager > > > > Project Manager > > > > eXo Platform SAS > > > > nicolas.filotto(a)exoplatform.com > > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > > > > > > -- > > > Nicolas Filotto > > > JCR Product Manager > > > Project Manager > > > eXo Platform SAS > > > nicolas.filotto(a)exoplatform.com > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > > -- > > Nicolas Filotto > > JCR Product Manager > > Project Manager > > eXo Platform SAS > > nicolas.filotto(a)exoplatform.com > > +33 (0)6 31 32 92 19 > > Michal > > _______________________________________________ > gatein-dev mailing list > gatein-dev(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/gatein-dev

Nicolas Filotto wrote: > > > On Thu, Mar 11, 2010 at 9:57 AM, Michal Vančo <mvanco(a)redhat.com&gt; > wrote: > Hi, > > today I checked following situations with oracle10: > - oracle11 driver for oracle10 db > - create bundle with JCR 1.12.0-GA > - delete gatein-sample* in server/default/deploy -> only > change was > that it failed with: Cannot create the portal container > 'portal', before > it was: Cannot create the portal container 'sample-portal' and > Cannot > create the portal container 'portal' > - creating jcr tables manually with script: > http://anonsvn.jboss.org/repos/exo-jcr/jcr/tags/1.12.0-GA/exo.jcr.compone... > > didn't help, but after adding script to create JCR_CONFIG > table -> it > started to work (detail of script in another mail on > gatein-dev) > > So, looks like JCR don't want to initialize. Any suggestions > why? > So far the only thing that we know is that > con.getMetaData().getTables(null, null, "JCR_CONFIG", null); returns a > result, so the JCR assumes that the table exists and thus try to > launch a query on it so it fails since actually the table doesn't > exist. > So far, we don't know why this method returns something on your side, > can you add a breakpoint on the method > org.exoplatform.services.jcr.impl.config.JDBCConfigurationPersister.isDbInitialized() of the project exo.jcr.component.core and tell us what you have in your resultset? when calling ResultSet trs = con.getMetaData().getTables(null, null, "JCR_CONFIG", null); return trs.next(); it returns true and content of trs variable from debug is attached. Then it ends on line 237: ResultSet res = ps.executeQuery(); Is it enough? Or what more can I explore in debug?

> > Michal > > > Michal Vančo wrote: > > Hi, > > > > Nicolas Filotto wrote: > > > Could you please provide the list of tables that you can > see with your > > > credentials on oracle 10 G? > > > > As I wrote yesterday in my additional reply: > > I'm using sqldeveloper tool to see the content of oracle DB, > and at all > > oracle10 cases, I can't see that anything is created > (tables, sequence, > > indexes...) in JCR schema. Only IDM schema initialization is > done. > > > > > > > > On Wed, Mar 10, 2010 at 8:41 PM, Michal Vančo > <mvanco(a)redhat.com&gt; > > > wrote: > > > Hi, > > > > > > currently I have same results as before (table or > view does > > > not exist) > > > on oracle10 in these conditions: > > > - 2 datasources on one machine (differentiated by > user names) > > > - 1 datasource on a machine (JCR and IDM > together) > > > - 2 datasources on separate machines > > > > It was added for these cases ^. > > > > > > > > To run GateIn trunk on Oracle10, I do following > steps: > > > - prepare GateIn trunk bundle > > > - unzip bundle > > > - change driver class, url, user and password in > > > jcr-configuration.xml > > > > in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/ > > > - change driver class, url, user and password in > > > idm-configuration.xml > > > > in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/organization/ > > > - add <property name="hibernate.hbm2ddl.auto" > > > value="create-drop"/> in > > > idm-configuration.xml > > > - copy oracle10 jdbc driver > into ../server/default/lib > > > - start gatein by run.sh in bin folder > > > > > > (I can provide a script from hudson where you can > add your own > > > paths and > > > credentials...) > > > > > > For oracle11: > > > - when run with same config as on oracle10, I get > error: > > > ORA-00972: identifier is too long (when > initializing > > > > org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) > > > > > > - oracle11_jcr.jpg - screen of what has been > created in DB > > > > > > - if I edit table names > > > > in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/repository-configuration.xml, gatein started correctly > > > - oracle11_jcr_shorten_names.jpg - screen of what > has been > > > created in DB > > > > > > Let me know if you need more details to reproduce > it on your > > > side. > > > > > > Best regards, > > > > > > Michal > > > > > > > > > Nicolas Filotto píše v St 10. 03. 2010 v 17:39 > +0100: > > > > > > > > > > > > > > > On Wed, Mar 10, 2010 at 5:19 PM, Prabhat Jha > > > <pjha(a)redhat.com&gt; wrote: > > > > I have created > > > https://jira.jboss.org/jira/browse/EXOJCR-582 > > > > for oracle11 issue. Please check that I > have right > > > affects and > > > > fix versions. > > > > > > > > thx, FYI I've just set the right settings > > > > > > > > The version of GateIn and JCR is the one > that's in > > > GateIn > > > > trunk currently. The way our environment > is setup is > > > that we > > > > have one Oracle10 DB servers and > different usernames > > > which I > > > > believe means different schemas in > Oracle for > > > different tests > > > > (gatein-ui, gatein-jcr etc) configured > on that > > > server. I would > > > > have to wait for Michal to show up for > info. He > > > needed to > > > > attend to some personal stuff : hospital > to check on > > > his mom. > > > > > > > > But in your environment, you have GateIn > starting > > > fine on > > > > Oracle 10, right? > > > > > > > > no so far, we have only tested with pure JCR but > in the same > > > > conditions as gatein, now as we know the version > of gatein > > > we will try > > > > with the same version (i.e the trunk) > > > > > > > > thanks, > > > > prabhat > > > > > > > > > > > > > > > > > > > > ----- "Nicolas Filotto" > <nicolas.filotto(a)gmail.com&gt; > > > wrote: > > > > > Prabhat and/or Michal, could you > please provide > > > the answers > > > > of the questions asked by Peter and me. > We cannot > > > reproduce so > > > > far, so we need your help. Please note > that we > > > blocked the > > > > release of GA because of this last > issue, so we need > > > your help > > > > to fix it asap. > > > > > > > > > > > > > > Thank you in advance, > > > > BR, > > > > Nicolas > > > > > > > > > > On Wed, Mar 10, 2010 at 3:02 PM, > Nicolas Filotto > > > > <nicolas.filotto(a)gmail.com&gt; wrote: > > > > > > > > > Hi Prabhat, > > > > > > > > > > > > > > my comments inline > > > > > > > > > > > > > > > On Wed, Mar 10, 2010 at 2:01 > PM, Prabhat > > > Jha > > > > <pjha(a)redhat.com&gt; wrote: > > > > > > > > > > > > > > > Hi Nicolas, > > > > > > > > > > Yes, a jira is on the > way but way > > > to > > > > reproduce this problem > is quite > > > simple. You > > > > start with a clean > Oracle 10 > > > database instance > > > > and see the problem > during startup. > > > It would > > > > make sense to have this > issue solved > > > or have a > > > > work around before > GateIn GA. > > > > > > > > > It is not enough, we need to > know, which > > > exact version > > > > of eXo JCR and GateIn, you are > using and the > > > content > > > > of the files that you modified. > > > > could you please open a > connexion with the > > > same > > > > account and give us the list of > tables that > > > you can > > > > see > > > > > > > > > > > > > > > Quick questions: > > > > > As per oracle11 > finding, is JCR > > > config > > > > (table names) going to > be updated > > > across the > > > > board? > > > > > > > > > You mean to change the sql > scripts for > > > oracle 11G? If > > > > so please create a JIRA, it will > be done in > > > the next > > > > maintenance version of eXo JCR > which will be > > > 1.12.1 GA > > > > planned for the end of March > > > > > > > > > > Also, I am wondiering > given that > > > Oracle 10 > > > > has been around for a > while, I am > > > wondering > > > > what has changed in the > latest JCR > > > that it > > > > does not work here. Did > the last GA > > > version > > > > work? > > > > > > > > > Hard to say before reproducing > your bug > > > > > > > > > > > > > > > > > > > Thanks, > > > > > Prabhat > > > > > > > > > > > > > > > > > > > > > > > > > > > > ----- "Nicolas > Filotto" > > > > > <nicolas.filotto(a)gmail.com&gt; wrote: > > > > > > Hi Michal, could you > please > > > create JIRA > > > > issues in the eXo JCR > project > > > > > > > (https://jira.jboss.org/jira/browse/EXOJCR) > > > > with all the information > needed to > > > allow us to > > > > reproduce? > > > > > > > > > > > > > > > > > > On Wed, Mar 10, 2010 > at 1:46 PM, > > > Nicolas > > > > Filotto > <nicolas.filotto(a)gmail.com&gt; > > > wrote: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Wed, Mar > 10, 2010 at > > > 1:29 PM, > > > > Michal Vančo > > > <mvanco(a)redhat.com&gt; > > > > wrote: > > > > > > > > > > Hi, > > > > > > > > > > > > > oracle11 now > > > works, > > > > oracle10 > not. See > > > below... > > > > > > > > > > > > > Peter Nedonosko > > > wrote > > > > > > > > > > > Hi, > > > > > > > > > > > > > > > about Oracle > > > 10 and ' > > > > table or > view does > > > not exist': > > > > > > > > the problem is > > > possible > > > > if > addConfig used in > > > > > > > > > > > > > > > org.exoplatform.services.jcr.config.RepositoryServiceConfiguration > > > > > > > (I > found it in > > > portal > > > > \trunk > \examples > > > \portal\war\src > > > > \main > \webapp\WEB-INF > > > \conf > > > > > \sample-portal\jcr > > > > > > > \jcr-configuration.xml) > > > > > > > > > > > > > > > > What you > meant with > > > addConfig > > > > plugin? > > > > > > > Should I add > > > > > > > <set-method>addConfig</set-method> in > > > > > > > > > jcr-configuration.xml? > > > > > > Or > how can I > > > solve 'table > > > > or view > does not > > > exist' on > > > > > oracle10? > > > > > > > > > > > > > > > > > > > > I guess it is > not related > > > since it > > > > works with other > databases > > > > > > > > > > > > > > > > > > > > > > > > > > > if > the > > > database is > > > > creating > from the > > > scratch and > > > > if the > configuration > > > > > > > > persister got > > > an answer > > > > from the > Oracle - > > > your table > > > > exists > in > > > > > > > > > > isDbInitialized(): > > > > > > > > ResultSet trs > > > = > > > > > > > con.getMetaData().getTables(null, null, > configTableName, > > > null); > > > > > > > > return > > > trs.next(); // > > > > true = > yes > > > > > > > > > > > > > > > but then > > > Oracle fails > > > > with > > > > > > > > > > PreparedStatement ps = > > > > > > > con.prepareStatement("SELECT > > > > COUNT(*) > FROM " + > > > > > > > > > > configTableName + " > > > > WHERE > NAME=?"); > > > > > > > > > > ps.executeQuery(); // > > > > here > > > > > > > > > > > > > > > but I have to > > > reproduce > > > > it > first... > > > > > > > > does Oracle 10 > > > and 11 > > > > runs on > clean > > > database from > > > > the > start? > > > > > > > or > just > > > restarted on > > > > existing > db for > > > Oracle 11? > > > > > > > > > > > > > > > > Always > on clean DBs. > > > > > > > > > > > > > > > > > > > > > > > > > about > > > Oracle11: > > > > > > > > seems it's > > > related to > > > > > JBossCache loader, > > > it creates > > > > a table > longer of > > > > > > > 30 > symbols > > > (ORA-00972: > > > > > identifier is too > > > long). > > > > > > > > Why it's not a > > > problem > > > > for > Oracle10 or why > > > JBossCache > > > > acts in > > > > > > > > different way > > > on > > > > Oracle10 > or etc... > > > > > > > > try to fix the > > > problem > > > > with > shorten table > > > name from > > > > > > > repository-configuration.xml > > > > > > > > e.g. > > > > > > > > <property > > > > > > > name="jbosscache-cl-cache.jdbc.table.name" > > > value="lock_portalsys" /> > > > > > > > > instead of > > > > > > > > <property > > > > > > > name="jbosscache-cl-cache.jdbc.table.name" > > > > > > > > > > > > > > value="jcrlock_portal_system" /> > > > > > > > it > should > > > helps. > > > > > > > > > > > > > > > > I > shortened all > > > table names in > > > > > > > repository-configuration.xml > > > > and > GateIn > > > > > > on > Oracle11 > > > started > > > > without > "identifier > > > is too > > > > long" > error. > > > > > > > > > > > > > There is job > > > when it > > > > starts > for the first > > > time: > > > > > > > > > > > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > > > > > > > > > I > think that it > > > would be > > > > better > to edit > > > configuration, > > > > because > editing > > > > > > > table names > > > before running > > > > gatein > isn't a good > > > way. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Regards, > > > > > > > > Peter > > > > > > > > > > > > > > > > > > > > > On > Tue, Mar 9, > > > 2010 at > > > > 11:24 > AM, Michal > > > Vančo > > > > > <mvanco(a)redhat.com&gt; > > > wrote: > > > > > > > > > Yes Bolek, > > > that's > > > > true. > > > > > > > > > I can't > > > explain myself > > > > the job > in hudson on > > > EPP5 > > > > > > > (epp_ui_selenium_tests_oracle10): > > > > > > > > > Because > > > there was same > > > > problem > - table or > > > view does > > > > not > exist (build > > > > > > > > > #3), builds > > > #5 and #7 > > > > were OK > (GateIn > > > started with > > > > no > errors) and > > > > > > > > > following > > > builds again > > > > failed > due the same > > > problem as > > > > before. > > > > > > > > > > > > > > > > > Regards, > > > > > > > > > Michal > > > > > > > > > > > > > > > > > Boleslaw > > > Dawidowicz > > > > píše v > Út 09. 03. > > > 2010 v 09:59 > > > > +0100: > > > > > > > >> > From > > > mentioned logs > > > > it looks > like those > > > errors > > > > don't > come from IDM. > > > I > > > > > > > >> > think the > > > stack trace > > > > in all > cases goes > > > via > > > > > > > >> > > > > > > > "org.exoplatform.services.jcr.impl.*" > > > > > > > >> > > > > > > > >> > Bolek > > > > > > > >> > > > > > > > >> > On > > > 03/09/2010 09:15 > > > > AM, > Michal Vančo > > > wrote: > > > > > > > >> > > Hi, > > > > > > > >> > > > > > > > > > >> > > I'm > > > dealing with > > > > problem > to start > > > GateIn with > > > > Oracle > DB. > > > > > > > >> > > I always > > > start with > > > > clean DB > and use 2 > > > datasource > > > > > instances (JCR, > > > IDM). > > > > > > > >> > > > > > > > > > >> > > There are > > > 2 > > > > > different issues: > > > > > > > >> > > Oracle10: > > > > > > > >> > > - > > > ORA-00942: table > > > > or view > does not > > > exist (start > > > > on > > > > > > > >> > > > > > > > > > > org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0 ) > > > > > > > >> > > - only > > > IDM schema > > > > is > initialized, JCR > > > not > > > > > > > >> > > > > > > > > > >> > > Oracle11: > > > > > > > >> > > - > > > ORA-00972: > > > > > identifier is too > > > long (Cannot > > > > > instantiate > > > component class > > > > > > > >> > > > > > > > > > > org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) > > > > > > > >> > > - both > > > schemas are > > > > created > (IDM + JCR) > > > > > > > >> > > > > > > > > > >> > > To run on > > > oracle, I > > > > change > configuration > > > in > > > > > > > idm-configuration.xml and > > > > > > > >> > > > > > > > > > jcr-configuration.xml, then > > > > copy > jdbc driver and > > > start. > > > > > > > >> > > I also > > > add<property > > > > > > > name="hibernate.hbm2ddl.auto" > > > > > > > value="create-drop"/> > > > > > > > >> > > to > > > > > > > idm-configuration.xml > > > > > (recommended by > > > Boleslaw > > > > > Dawidowicz - it > > > worked > > > > > > > >> > > on EPP, > > > but not on > > > > GateIn > trunk). > > > > > > > >> > > > > > > > > > >> > > There are > > > links to > > > > log: > > > > > > > >> > > > > > > > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > > > > >> > > > > > > > > > >> > > > > > > > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > > > > > > > >> > > > > > > > > > >> > > > > > > > > > >> > > I would > > > appreciate > > > > any > help. > > > > > > > >> > > > > > > > > > >> > > Thanks in > > > advance > > > > > > > >> > > Michal > > > Vanco > > > > > > > >> > > > > > > > > > >> > > > > > > > > > _______________________________________________ > > > > > > > >> > > > > > gatein-dev mailing > > > > list > > > > > > > >> > > > > > > > > > gatein-dev(a)lists.jboss.org > > > > > > > >> > > > > > > > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > > > > > > gatein-dev > > > mailing > > > > list > > > > > > > > > > > > > > > gatein-dev(a)lists.jboss.org > > > > > > > > > > > > > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Thanks, > > > > > > > Michal > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > > > > gatein-dev > > > mailing list > > > > > > > > > gatein-dev(a)lists.jboss.org > > > > > > > > > > > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > > > > Nicolas > Filotto > > > > > > JCR Product > Manager > > > > > > Project > Manager > > > > > > eXo Platform > SAS > > > > > > > > > nicolas.filotto(a)exoplatform.com > > > > > > +33 (0)6 31 > 32 92 19 > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > Nicolas Filotto > > > > > > JCR Product Manager > > > > > > Project Manager > > > > > > eXo Platform SAS > > > > > > > nicolas.filotto(a)exoplatform.com > > > > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > gatein-dev > > > mailing list gatein-dev(a)lists.jboss.org > > > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > Nicolas Filotto > > > > > JCR Product Manager > > > > > Project Manager > > > > > eXo Platform SAS > > > > > > nicolas.filotto(a)exoplatform.com > > > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > Nicolas Filotto > > > > > JCR Product Manager > > > > > Project Manager > > > > > eXo Platform SAS > > > > > nicolas.filotto(a)exoplatform.com > > > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > > > > > > > > > > > -- > > > > Nicolas Filotto > > > > JCR Product Manager > > > > Project Manager > > > > eXo Platform SAS > > > > nicolas.filotto(a)exoplatform.com > > > > +33 (0)6 31 32 92 19 > > > > > > > > > > > > > > > > > > -- > > > Nicolas Filotto > > > JCR Product Manager > > > Project Manager > > > eXo Platform SAS > > > nicolas.filotto(a)exoplatform.com > > > +33 (0)6 31 32 92 19 > > > > Michal > > > > _______________________________________________ > > gatein-dev mailing list > > gatein-dev(a)lists.jboss.org > > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > -- > Nicolas Filotto > JCR Product Manager > Project Manager > eXo Platform SAS > nicolas.filotto(a)exoplatform.com > +33 (0)6 31 32 92 19 >

Nicolas Filotto wrote: > > > On Thu, Mar 11, 2010 at 9:57 AM, Michal Vančo <mvanco(a)redhat.com&gt; > wrote: >         Hi, > >         today I checked following situations with oracle10: >          - oracle11 driver for oracle10 db >          - create bundle with JCR 1.12.0-GA >          - delete gatein-sample* in server/default/deploy -> only >         change was >         that it failed with: Cannot create the portal container >         'portal', before >         it was: Cannot create the portal container 'sample-portal' and >         Cannot >         create the portal container 'portal' >          - creating jcr tables manually with script: >         http://anonsvn.jboss.org/repos/exo-jcr/jcr/tags/1.12.0-GA/exo.jcr.compone... > >         didn't help, but after adding script to create JCR_CONFIG >         table -> it >         started to work (detail of script in another mail on >         gatein-dev) > >         So, looks like JCR don't want to initialize. Any suggestions >         why? > So far the only thing that we know is that > con.getMetaData().getTables(null, null, "JCR_CONFIG", null); returns a > result, so the JCR assumes that the table exists and thus try to > launch a query on it so it fails since actually the table doesn't > exist. > So far, we don't know why this method returns something on your side, > can you add a breakpoint on the method > org.exoplatform.services.jcr.impl.config.JDBCConfigurationPersister.isDbInitialized() of the project exo.jcr.component.core and tell us what you have in your resultset? when calling ResultSet trs = con.getMetaData().getTables(null, null, "JCR_CONFIG", null); return trs.next(); it returns true and content of trs variable from debug is attached. Then it ends on line 237: ResultSet res = ps.executeQuery(); Is it enough? Or what more can I explore in debug?

> >         Michal > > >         Michal Vančo wrote: >         > Hi, >         > >         > Nicolas Filotto wrote: >         > > Could you please provide the list of tables that you can >         see with your >         > > credentials on oracle 10 G? >         > >         > As I wrote yesterday in my additional reply: >         > I'm using sqldeveloper tool to see the content of oracle DB, >         and at all >         > oracle10 cases, I can't see that anything is created >         (tables, sequence, >         > indexes...) in JCR schema. Only IDM schema initialization is >         done. >         > >         > > >         > > On Wed, Mar 10, 2010 at 8:41 PM, Michal Vančo >         <mvanco(a)redhat.com&gt; >         > > wrote: >         > >         Hi, >         > > >         > >         currently I have same results as before (table or >         view does >         > >         not exist) >         > >         on oracle10 in these conditions: >         > >          - 2 datasources on one machine (differentiated by >         user names) >         > >          - 1 datasource on a machine (JCR and IDM >         together) >         > >          - 2 datasources on separate machines >         > >         > It was added for these cases ^. >         > >         > > >         > >         To run GateIn trunk on Oracle10, I do following >         steps: >         > >          - prepare GateIn trunk bundle >         > >          - unzip bundle >         > >          - change driver class, url, user and password in >         > >         jcr-configuration.xml >         > > >         in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/ >         > >          - change driver class, url, user and password in >         > >         idm-configuration.xml >         > > >         in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/organization/ >         > >          - add <property name="hibernate.hbm2ddl.auto" >         > >         value="create-drop"/> in >         > >         idm-configuration.xml >         > >          - copy oracle10 jdbc driver >         into ../server/default/lib >         > >          - start gatein by run.sh in bin folder >         > > >         > >         (I can provide a script from hudson where you can >         add your own >         > >         paths and >         > >         credentials...) >         > > >         > >         For oracle11: >         > >          - when run with same config as on oracle10, I get >         error: >         > >         ORA-00972: identifier is too long (when >         initializing >         > > >         org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) >         > > >         > >          - oracle11_jcr.jpg - screen of what has been >         created in DB >         > > >         > >          - if I edit table names >         > > >         in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/repository-configuration.xml, gatein started correctly >         > >         - oracle11_jcr_shorten_names.jpg - screen of what >         has been >         > >         created in DB >         > > >         > >         Let me know if you need more details to reproduce >         it on your >         > >         side. >         > > >         > >         Best regards, >         > > >         > >         Michal >         > > >         > > >         > >         Nicolas Filotto píše v St 10. 03. 2010 v 17:39 >         +0100: >         > > >         > >         > >         > >         > >         > >         > On Wed, Mar 10, 2010 at 5:19 PM, Prabhat Jha >         > >         <pjha(a)redhat.com&gt; wrote: >         > >         >         I have created >         > >         https://jira.jboss.org/jira/browse/EXOJCR-582 >         > >         >         for oracle11 issue. Please check that I >         have right >         > >         affects and >         > >         >         fix versions. >         > >         > >         > >         > thx, FYI I've just set the right settings >         > >         > >         > >         >         The version of GateIn and JCR is the one >         that's in >         > >         GateIn >         > >         >         trunk currently. The way our environment >         is setup is >         > >         that we >         > >         >         have one Oracle10 DB servers and >         different usernames >         > >         which I >         > >         >         believe means different schemas in >         Oracle for >         > >         different tests >         > >         >         (gatein-ui, gatein-jcr etc) configured >         on that >         > >         server. I would >         > >         >         have to wait for Michal to show up for >         info. He >         > >         needed to >         > >         >         attend to some personal stuff : hospital >         to check on >         > >         his mom. >         > >         > >         > >         >         But in your environment, you have GateIn >         starting >         > >         fine on >         > >         >         Oracle 10, right? >         > >         > >         > >         > no so far, we have only tested with pure JCR but >         in the same >         > >         > conditions as gatein, now as we know the version >         of gatein >         > >         we will try >         > >         > with the same version (i.e the trunk) >         > >         > >         > >         >         thanks, >         > >         >         prabhat >         > >         > >         > >         > >         > >         > >         > >         > >         > >         >         ----- "Nicolas Filotto" >         <nicolas.filotto(a)gmail.com&gt; >         > >         wrote: >         > >         >         > Prabhat and/or Michal, could you >         please provide >         > >         the answers >         > >         >         of the questions asked by Peter and me. >         We cannot >         > >         reproduce so >         > >         >         far, so we need your help. Please note >         that we >         > >         blocked the >         > >         >         release of GA because of this last >         issue, so we need >         > >         your help >         > >         >         to fix it asap. >         > >         >         > >         > >         >         > >         > >         >         Thank you in advance, >         > >         >         BR, >         > >         >         Nicolas >         > >         >         > >         > >         >         > On Wed, Mar 10, 2010 at 3:02 PM, >         Nicolas Filotto >         > >         >         <nicolas.filotto(a)gmail.com&gt; wrote: >         > >         >         > >         > >         >                 Hi Prabhat, >         > >         >                 > >         > >         >                 > >         > >         >                 my comments inline >         > >         >                 > >         > >         >                 > >         > >         >                 > On Wed, Mar 10, 2010 at 2:01 >         PM, Prabhat >         > >         Jha >         > >         >                 <pjha(a)redhat.com&gt; wrote: >         > >         >                 > >         > >         >                 > >         > >         >                         > Hi Nicolas, >         > >         >                         > >         > >         >                         > Yes, a jira is on the >         way but way >         > >         to >         > >         >                         reproduce this problem >         is quite >         > >         simple. You >         > >         >                         start with a clean >         Oracle 10 >         > >         database instance >         > >         >                         and see the problem >         during startup. >         > >         It would >         > >         >                         make sense to have this >         issue solved >         > >         or have a >         > >         >                         work around before >         GateIn GA. >         > >         >                         > >         > >         >                 It is not enough, we need to >         know, which >         > >         exact version >         > >         >                 of eXo JCR and GateIn, you are >         using and the >         > >         content >         > >         >                 of the files that you modified. >         > >         >                 could you please open a >         connexion with the >         > >         same >         > >         >                 account and give us the list of >         tables that >         > >         you can >         > >         >                 see >         > >         >                 > >         > >         >                         > >         > >         >                         > Quick questions: >         > >         >                         >  As per oracle11 >         finding, is JCR >         > >         config >         > >         >                         (table names) going to >         be updated >         > >         across the >         > >         >                         board? >         > >         >                         > >         > >         >                  You mean to change the sql >         scripts for >         > >         oracle 11G? If >         > >         >                 so please create a JIRA, it will >         be done in >         > >         the next >         > >         >                 maintenance version of eXo JCR >         which will be >         > >         1.12.1 GA >         > >         >                 planned for the end of March >         > >         >                 > >         > >         >                         > Also, I am wondiering >         given that >         > >         Oracle 10 >         > >         >                         has been around for a >         while, I am >         > >         wondering >         > >         >                         what has changed in the >         latest JCR >         > >         that it >         > >         >                         does not work here. Did >         the last GA >         > >         version >         > >         >                         work? >         > >         >                         > >         > >         >                 Hard to say before reproducing >         your bug >         > >         > >         > >         >                 > >         > >         >                         > >         > >         >                         > Thanks, >         > >         >                         > Prabhat >         > >         > >         > >         > >         > >         >                         > >         > >         >                         > >         > >         >                         > >         > >         >                         > ----- "Nicolas >         Filotto" >         > >         > >         <nicolas.filotto(a)gmail.com&gt; wrote: >         > >         >                         > > Hi Michal, could you >         please >         > >         create JIRA >         > >         >                         issues in the eXo JCR >         project >         > >         > >         > >         (https://jira.jboss.org/jira/browse/EXOJCR) >         > >         >                         with all the information >         needed to >         > >         allow us to >         > >         >                         reproduce? >         > >         >                         > > >         > >         >                         > > >         > >         >                         > > On Wed, Mar 10, 2010 >         at 1:46 PM, >         > >         Nicolas >         > >         >                         Filotto >         <nicolas.filotto(a)gmail.com&gt; >         > >         wrote: >         > >         >                         > > >         > >         > >         > >         >                                 > > >         > >         >                                 > > >         > >         >                                 > > >         > >         >                                 > On Wed, Mar >         10, 2010 at >         > >         1:29 PM, >         > >         >                                 Michal Vančo >         > >         <mvanco(a)redhat.com&gt; >         > >         >                                 wrote: >         > >         >                                 > > >         > >         >                                         Hi, >         > >         >                                         > > >         > >         >                                         > > >         oracle11 now >         > >         works, >         > >         >                                         oracle10 >         not. See >         > >         below... >         > >         >                                         > > >         > >         >                                         > > >         Peter Nedonosko >         > >         wrote >         > >         >                                         > > >         > >         >                                         > Hi, >         > >         >                                         > > > >         > >         >                                         > > > >         about Oracle >         > >         10 and ' >         > >         >                                         table or >         view does >         > >         not exist': >         > >         >                                         > > > >         the problem is >         > >         possible >         > >         >                                         if >         addConfig used in >         > >         >                                         > > > >         > >         > >         > > >         org.exoplatform.services.jcr.config.RepositoryServiceConfiguration >         > >         >                                         > > > (I >         found it in >         > >         portal >         > >         >                                         \trunk >         \examples >         > >         \portal\war\src >         > >         >                                         \main >         \webapp\WEB-INF >         > >         \conf >         > >         > >         \sample-portal\jcr >         > >         > >         > >         \jcr-configuration.xml) >         > >         >                                         > > >         > >         >                                         > > >         > >         >                                         What you >         meant with >         > >         addConfig >         > >         >                                         plugin? >         > >         >                                         > > >         Should I add >         > >         > >         > >         <set-method>addConfig</set-method> in >         > >         >                                         > > >         > >         jcr-configuration.xml? >         > >         >                                         > > Or >         how can I >         > >         solve 'table >         > >         >                                         or view >         does not >         > >         exist' on >         > >         > >         oracle10? >         > >         >                                         > > >         > >         > >         > >         >                                 > > >         > >         >                                 I guess it is >         not related >         > >         since it >         > >         >                                 works with other >         databases >         > >         > >         > >         >                                 > >         > >         > >         > >         >                                         > > > >         > >         >                                         > > > if >         the >         > >         database is >         > >         >                                         creating >         from the >         > >         scratch and >         > >         >                                         if the >         configuration >         > >         >                                         > > > >         persister got >         > >         an answer >         > >         >                                         from the >         Oracle - >         > >         your table >         > >         >                                         exists >         in >         > >         >                                         > > > >         > >         isDbInitialized(): >         > >         >                                         > > > >         ResultSet trs >         > >         = >         > >         > >         > >         con.getMetaData().getTables(null, null, >         configTableName, >         > >         null); >         > >         >                                         > > > >         return >         > >         trs.next(); // >         > >         >                                         true = >         yes >         > >         >                                         > > > >         > >         >                                         > > > >         but then >         > >         Oracle fails >         > >         >                                         with >         > >         >                                         > > > >         > >         PreparedStatement ps = >         > >         > >         > >         con.prepareStatement("SELECT >         > >         >                                         COUNT(*) >         FROM " + >         > >         >                                         > > > >         > >         configTableName + " >         > >         >                                         WHERE >         NAME=?"); >         > >         >                                         > > > >         > >         ps.executeQuery(); // >         > >         >                                         here >         > >         >                                         > > > >         > >         >                                         > > > >         but I have to >         > >         reproduce >         > >         >                                         it >         first... >         > >         >                                         > > > >         does Oracle 10 >         > >         and 11 >         > >         >                                         runs on >         clean >         > >         database from >         > >         >                                         the >         start? >         > >         >                                         > > > or >         just >         > >         restarted on >         > >         >                                         existing >         db for >         > >         Oracle 11? >         > >         >                                         > > >         > >         >                                         > > >         > >         >                                         Always >         on clean DBs. >         > >         >                                         > > >         > >         > >         > >         >                                         > > > >         > >         >                                         > > > >         about >         > >         Oracle11: >         > >         >                                         > > > >         seems it's >         > >         related to >         > >         > >         JBossCache loader, >         > >         it creates >         > >         >                                         a table >         longer of >         > >         >                                         > > > 30 >         symbols >         > >         (ORA-00972: >         > >         > >         identifier is too >         > >         long). >         > >         >                                         > > > >         Why it's not a >         > >         problem >         > >         >                                         for >         Oracle10 or why >         > >         JBossCache >         > >         >                                         acts in >         > >         >                                         > > > >         different way >         > >         on >         > >         >                                         Oracle10 >         or etc... >         > >         >                                         > > > >         try to fix the >         > >         problem >         > >         >                                         with >         shorten table >         > >         name from >         > >         > >         > >         repository-configuration.xml >         > >         >                                         > > > >         e.g. >         > >         >                                         > > > >         <property >         > >         > >         > >         name="jbosscache-cl-cache.jdbc.table.name" >         > >         value="lock_portalsys" /> >         > >         >                                         > > > >         instead of >         > >         >                                         > > > >         <property >         > >         > >         > >         name="jbosscache-cl-cache.jdbc.table.name" >         > >         >                                         > > > >         > >         > >         > >         value="jcrlock_portal_system" /> >         > >         >                                         > > > it >         should >         > >         helps. >         > >         >                                         > > >         > >         >                                         > > >         > >         >                                         I >         shortened all >         > >         table names in >         > >         > >         > >         repository-configuration.xml >         > >         >                                         and >         GateIn >         > >         >                                         > > on >         Oracle11 >         > >         started >         > >         >                                         without >         "identifier >         > >         is too >         > >         >                                         long" >         error. >         > >         >                                         > > >         > >         >                                         > > >         There is job >         > >         when it >         > >         >                                         starts >         for the first >         > >         time: >         > >         >                                         > > >         > >         > >         > > >         http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >         > >         >                                         > > >         > >         >                                         > > I >         think that it >         > >         would be >         > >         >                                         better >         to edit >         > >         configuration, >         > >         >                                         because >         editing >         > >         >                                         > > >         table names >         > >         before running >         > >         >                                         gatein >         isn't a good >         > >         way. >         > >         >                                         > > >         > >         > >         > >         > >         > >         >                                         > > > >         > >         >                                         > > > >         Regards, >         > >         >                                         > > > >         Peter >         > >         >                                         > > > >         > >         >                                         > > > >         > >         >                                         > > > On >         Tue, Mar 9, >         > >         2010 at >         > >         >                                         11:24 >         AM, Michal >         > >         Vančo >         > >         > >         <mvanco(a)redhat.com&gt; >         > >         wrote: >         > >         >                                         > > > > >         Yes Bolek, >         > >         that's >         > >         >                                         true. >         > >         >                                         > > > > >         I can't >         > >         explain myself >         > >         >                                         the job >         in hudson on >         > >         EPP5 >         > >         > >         > >         (epp_ui_selenium_tests_oracle10): >         > >         >                                         > > > > >         Because >         > >         there was same >         > >         >                                         problem >         - table or >         > >         view does >         > >         >                                         not >         exist (build >         > >         >                                         > > > > >         #3), builds >         > >         #5 and #7 >         > >         >                                         were OK >         (GateIn >         > >         started with >         > >         >                                         no >         errors) and >         > >         >                                         > > > > >         following >         > >         builds again >         > >         >                                         failed >         due the same >         > >         problem as >         > >         >                                         before. >         > >         >                                         > > > > >         > >         >                                         > > > > >         Regards, >         > >         >                                         > > > > >         Michal >         > >         >                                         > > > > >         > >         >                                         > > > > >         Boleslaw >         > >         Dawidowicz >         > >         >                                         píše v >         Út 09. 03. >         > >         2010 v 09:59 >         > >         >                                         +0100: >         > >         >                                         > > > >> >         From >         > >         mentioned logs >         > >         >                                         it looks >         like those >         > >         errors >         > >         >                                         don't >         come from IDM. >         > >         I >         > >         >                                         > > > >> >         think the >         > >         stack trace >         > >         >                                         in all >         cases goes >         > >         via >         > >         >                                         > > > >> >         > >         > >         > >         "org.exoplatform.services.jcr.impl.*" >         > >         >                                         > > > >> >         > >         >                                         > > > >> >         Bolek >         > >         >                                         > > > >> >         > >         >                                         > > > >> >         On >         > >         03/09/2010 09:15 >         > >         >                                         AM, >         Michal Vančo >         > >         wrote: >         > >         >                                         > > > >> >         > Hi, >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > I'm >         > >         dealing with >         > >         >                                         problem >         to start >         > >         GateIn with >         > >         >                                         Oracle >         DB. >         > >         >                                         > > > >> >         > I always >         > >         start with >         > >         >                                         clean DB >         and use 2 >         > >         datasource >         > >         > >         instances (JCR, >         > >         IDM). >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > There are >         > >         2 >         > >         > >         different issues: >         > >         >                                         > > > >> >         > Oracle10: >         > >         >                                         > > > >> >         > - >         > >         ORA-00942: table >         > >         >                                         or view >         does not >         > >         exist (start >         > >         >                                         on >         > >         >                                         > > > >> >         > >         > >         > >         > > >         org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0) >         > >         >                                         > > > >> >         > - only >         > >         IDM schema >         > >         >                                         is >         initialized, JCR >         > >         not >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > Oracle11: >         > >         >                                         > > > >> >         > - >         > >         ORA-00972: >         > >         > >         identifier is too >         > >         long (Cannot >         > >         > >         instantiate >         > >         component class >         > >         >                                         > > > >> >         > >         > >         > >         > > >         org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) >         > >         >                                         > > > >> >         > - both >         > >         schemas are >         > >         >                                         created >         (IDM + JCR) >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > To run on >         > >         oracle, I >         > >         >                                         change >         configuration >         > >         in >         > >         > >         > >         idm-configuration.xml and >         > >         >                                         > > > >> >         > >         > >         > >         > >         jcr-configuration.xml, then >         > >         >                                         copy >         jdbc driver and >         > >         start. >         > >         >                                         > > > >> >         > I also >         > >         add<property >         > >         > >         > >         name="hibernate.hbm2ddl.auto" >         > >         > >         > >         value="create-drop"/> >         > >         >                                         > > > >> >         > to >         > >         > >         > >         idm-configuration.xml >         > >         > >         (recommended by >         > >         Boleslaw >         > >         > >         Dawidowicz - it >         > >         worked >         > >         >                                         > > > >> >         > on EPP, >         > >         but not on >         > >         >                                         GateIn >         trunk). >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > There are >         > >         links to >         > >         >                                         log: >         > >         >                                         > > > >> >         > >         > >         > >         > > >         http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > >         > >         > >         > > >         http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > I would >         > >         appreciate >         > >         >                                         any >         help. >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > Thanks in >         > >         advance >         > >         >                                         > > > >> >         > Michal >         > >         Vanco >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > >         > >         > >         > >         _______________________________________________ >         > >         >                                         > > > >> >         > >         > >         gatein-dev mailing >         > >         >                                         list >         > >         >                                         > > > >> >         > >         > >         > >         > >         gatein-dev(a)lists.jboss.org >         > >         >                                         > > > >> >         > >         > >         > >         > > >         https://lists.jboss.org/mailman/listinfo/gatein-dev >         > >         >                                         > > > > >         > >         >                                         > > > > >         > >         >                                         > > > > >         > >         > >         > >         _______________________________________________ >         > >         >                                         > > > > >         gatein-dev >         > >         mailing >         > >         >                                         list >         > >         >                                         > > > > >         > >         > >         > >         gatein-dev(a)lists.jboss.org >         > >         >                                         > > > > >         > >         > >         > > >         https://lists.jboss.org/mailman/listinfo/gatein-dev >         > >         >                                         > > > > >         > >         >                                         > > >         > >         >                                         > > >         > >         >                                         > > >         > >         >                                         Thanks, >         > >         >                                         > > >         Michal >         > >         >                                         > > >         > >         > >         > >         > >         > >         >                                         > > >         > >         > >         > >         _______________________________________________ >         > >         >                                         > > >         gatein-dev >         > >         mailing list >         > >         >                                         > > >         > >         gatein-dev(a)lists.jboss.org >         > >         >                                         > > >         > >         > >         > > >         https://lists.jboss.org/mailman/listinfo/gatein-dev >         > >         >                                         > > >         > >         > >         > >         >                                 > > >         > >         > >         > >         >                                 > > -- >         > >         >                                 > > >         > >         > >         > >         >                                 > Nicolas >         Filotto >         > >         >                                 > > JCR Product >         Manager >         > >         >                                 > > Project >         Manager >         > >         >                                 > > eXo Platform >         SAS >         > >         >                                 > > >         > >         nicolas.filotto(a)exoplatform.com >         > >         >                                 > > +33 (0)6 31 >         32 92 19 >         > >         >                                 > > >         > >         > >         > >         >                         > > >         > >         > >         > >         >                         > > -- >         > >         >                         > > Nicolas Filotto >         > >         >                         > > JCR Product Manager >         > >         >                         > > Project Manager >         > >         >                         > > eXo Platform SAS >         > >         >                         > > >         nicolas.filotto(a)exoplatform.com >         > >         >                         > > +33 (0)6 31 32 92 19 >         > >         >                         > > >         > >         >                         > >         > >         >                         > >         > >         > >         > >         _______________________________________________ >         gatein-dev >         > >         mailing list gatein-dev(a)lists.jboss.org >         > > >         https://lists.jboss.org/mailman/listinfo/gatein-dev >         > >         > >         > >         >                 > >         > >         >                 > >         > >         > >         > >         >                 > -- >         > >         >                 > Nicolas Filotto >         > >         >                 > JCR Product Manager >         > >         >                 > Project Manager >         > >         >                 > eXo Platform SAS >         > >         >                 > >         nicolas.filotto(a)exoplatform.com >         > >         >                 > +33 (0)6 31 32 92 19 >         > >         >                 > >         > >         > >         > >         >         > >         > >         > >         > >         >         > -- >         > >         >         > Nicolas Filotto >         > >         >         > JCR Product Manager >         > >         >         > Project Manager >         > >         >         > eXo Platform SAS >         > >         >         > nicolas.filotto(a)exoplatform.com >         > >         >         > +33 (0)6 31 32 92 19 >         > >         >         > >         > >         > >         > >         > >         > >         > >         > >         > -- >         > >         > Nicolas Filotto >         > >         > JCR Product Manager >         > >         > Project Manager >         > >         > eXo Platform SAS >         > >         > nicolas.filotto(a)exoplatform.com >         > >         > +33 (0)6 31 32 92 19 >         > > >         > > >         > > >         > > >         > > >         > > -- >         > > Nicolas Filotto >         > > JCR Product Manager >         > > Project Manager >         > > eXo Platform SAS >         > > nicolas.filotto(a)exoplatform.com >         > > +33 (0)6 31 32 92 19 >         > >         > Michal >         > >         > _______________________________________________ >         > gatein-dev mailing list >         > gatein-dev(a)lists.jboss.org >         > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > -- > Nicolas Filotto > JCR Product Manager > Project Manager > eXo Platform SAS > nicolas.filotto(a)exoplatform.com > +33 (0)6 31 32 92 19 >

On Thu, Mar 11, 2010 at 1:52 PM, Peter Nedonosko&lt;pnedonosko(a)gmail.com&gt; wrote: > On Thu, Mar 11, 2010 at 1:35 PM, Michal Vančo&lt;mvanco(a)redhat.com&gt; wrote: > >> Nicolas Filotto wrote: >> >>> >>> On Thu, Mar 11, 2010 at 9:57 AM, Michal Vančo&lt;mvanco(a)redhat.com&gt; >>> wrote: >>> Hi, >>> >>> today I checked following situations with oracle10: >>> - oracle11 driver for oracle10 db >>> - create bundle with JCR 1.12.0-GA >>> - delete gatein-sample* in server/default/deploy -> only >>> change was >>> that it failed with: Cannot create the portal container >>> 'portal', before >>> it was: Cannot create the portal container 'sample-portal' and >>> Cannot >>> create the portal container 'portal' >>> - creating jcr tables manually with script: >>> http://anonsvn.jboss.org/repos/exo-jcr/jcr/tags/1.12.0-GA/exo.jcr.compone... >>> >>> didn't help, but after adding script to create JCR_CONFIG >>> table -> it >>> started to work (detail of script in another mail on >>> gatein-dev) >>> >>> So, looks like JCR don't want to initialize. Any suggestions >>> why? >>> So far the only thing that we know is that >>> con.getMetaData().getTables(null, null, "JCR_CONFIG", null); returns a >>> result, so the JCR assumes that the table exists and thus try to >>> launch a query on it so it fails since actually the table doesn't >>> exist. >>> So far, we don't know why this method returns something on your side, >>> can you add a breakpoint on the method >>> org.exoplatform.services.jcr.impl.config.JDBCConfigurationPersister.isDbInitialized() of the project exo.jcr.component.core and tell us what you have in your resultset? >>> >> >> when calling >> ResultSet trs = con.getMetaData().getTables(null, null, "JCR_CONFIG", null); >> return trs.next(); >> >> it returns true and content of trs variable from debug is attached. >> >> Then it ends on line 237: ResultSet res = ps.executeQuery(); >> >> Is it enough? Or what more can I explore in debug? >> > con.getMetaData().getTables(null, null, "JCR_CONFIG", null); > is wrong on oracle at all, > as the call returns all JCR_CONFIG tables in the Oracle instance (crazy for me) > but here I have several databases with different tablespaces and I see > all of them within user who should not see ones. > > Nicolas, it will be like if several databases contains JCR_CONFIG table: > null EXOCLUSTER1 JCR_CONFIG > null EXOCLUSTER2 JCR_CONFIG > null JCRDB JCR_CONFIG > .... > > FYI, I have applied your script and yes - it reproduces the issue > but I still guess it's DBA side work to provide the rights to users > from one schema. > > After I replaced > con.getMetaData().getTables(null, null, "JCR_CONFIG", null); > with > try { > ResultSet tprs = con.createStatement().executeQuery("SELECT COUNT(*) > FROM " + tableName); > return tprs.next(); > catch (SQLException e) > { > return false; > } > > this part works well but next thing you'll meet will be > http://jira.exoplatform.org/browse/JCR-1333 > the issue about insufficient rights for triggers creation, user should have rights for tables, triggers and sequences creation. it's actual for single and multi-db. > so it's still DBA task IMO. > > > >> >>> Michal >>> >>> >>> Michal Vančo wrote: >>> > Hi, >>> > >>> > Nicolas Filotto wrote: >>> > > Could you please provide the list of tables that you can >>> see with your >>> > > credentials on oracle 10 G? >>> > >>> > As I wrote yesterday in my additional reply: >>> > I'm using sqldeveloper tool to see the content of oracle DB, >>> and at all >>> > oracle10 cases, I can't see that anything is created >>> (tables, sequence, >>> > indexes...) in JCR schema. Only IDM schema initialization is >>> done. >>> > >>> > > >>> > > On Wed, Mar 10, 2010 at 8:41 PM, Michal Vančo >>> <mvanco(a)redhat.com&gt; >>> > > wrote: >>> > > Hi, >>> > > >>> > > currently I have same results as before (table or >>> view does >>> > > not exist) >>> > > on oracle10 in these conditions: >>> > > - 2 datasources on one machine (differentiated by >>> user names) >>> > > - 1 datasource on a machine (JCR and IDM >>> together) >>> > > - 2 datasources on separate machines >>> > >>> > It was added for these cases ^. >>> > >>> > > >>> > > To run GateIn trunk on Oracle10, I do following >>> steps: >>> > > - prepare GateIn trunk bundle >>> > > - unzip bundle >>> > > - change driver class, url, user and password in >>> > > jcr-configuration.xml >>> > > >>> in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/ >>> > > - change driver class, url, user and password in >>> > > idm-configuration.xml >>> > > >>> in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/organization/ >>> > > - add<property name="hibernate.hbm2ddl.auto" >>> > > value="create-drop"/> in >>> > > idm-configuration.xml >>> > > - copy oracle10 jdbc driver >>> into ../server/default/lib >>> > > - start gatein by run.sh in bin folder >>> > > >>> > > (I can provide a script from hudson where you can >>> add your own >>> > > paths and >>> > > credentials...) >>> > > >>> > > For oracle11: >>> > > - when run with same config as on oracle10, I get >>> error: >>> > > ORA-00972: identifier is too long (when >>> initializing >>> > > >>> org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) >>> > > >>> > > - oracle11_jcr.jpg - screen of what has been >>> created in DB >>> > > >>> > > - if I edit table names >>> > > >>> in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/repository-configuration.xml, gatein started correctly >>> > > - oracle11_jcr_shorten_names.jpg - screen of what >>> has been >>> > > created in DB >>> > > >>> > > Let me know if you need more details to reproduce >>> it on your >>> > > side. >>> > > >>> > > Best regards, >>> > > >>> > > Michal >>> > > >>> > > >>> > > Nicolas Filotto píše v St 10. 03. 2010 v 17:39 >>> +0100: >>> > > >>> > > > >>> > > > >>> > > > On Wed, Mar 10, 2010 at 5:19 PM, Prabhat Jha >>> > > <pjha(a)redhat.com&gt; wrote: >>> > > > I have created >>> > > https://jira.jboss.org/jira/browse/EXOJCR-582 >>> > > > for oracle11 issue. Please check that I >>> have right >>> > > affects and >>> > > > fix versions. >>> > > > >>> > > > thx, FYI I've just set the right settings >>> > > > >>> > > > The version of GateIn and JCR is the one >>> that's in >>> > > GateIn >>> > > > trunk currently. The way our environment >>> is setup is >>> > > that we >>> > > > have one Oracle10 DB servers and >>> different usernames >>> > > which I >>> > > > believe means different schemas in >>> Oracle for >>> > > different tests >>> > > > (gatein-ui, gatein-jcr etc) configured >>> on that >>> > > server. I would >>> > > > have to wait for Michal to show up for >>> info. He >>> > > needed to >>> > > > attend to some personal stuff : hospital >>> to check on >>> > > his mom. >>> > > > >>> > > > But in your environment, you have GateIn >>> starting >>> > > fine on >>> > > > Oracle 10, right? >>> > > > >>> > > > no so far, we have only tested with pure JCR but >>> in the same >>> > > > conditions as gatein, now as we know the version >>> of gatein >>> > > we will try >>> > > > with the same version (i.e the trunk) >>> > > > >>> > > > thanks, >>> > > > prabhat >>> > > > >>> > > > >>> > > > >>> > > > >>> > > > ----- "Nicolas Filotto" >>> <nicolas.filotto(a)gmail.com&gt; >>> > > wrote: >>> > > > > Prabhat and/or Michal, could you >>> please provide >>> > > the answers >>> > > > of the questions asked by Peter and me. >>> We cannot >>> > > reproduce so >>> > > > far, so we need your help. Please note >>> that we >>> > > blocked the >>> > > > release of GA because of this last >>> issue, so we need >>> > > your help >>> > > > to fix it asap. >>> > > > > >>> > > > > >>> > > > Thank you in advance, >>> > > > BR, >>> > > > Nicolas >>> > > > > >>> > > > > On Wed, Mar 10, 2010 at 3:02 PM, >>> Nicolas Filotto >>> > > > <nicolas.filotto(a)gmail.com&gt; wrote: >>> > > > > >>> > > > Hi Prabhat, >>> > > > > >>> > > > > >>> > > > my comments inline >>> > > > > >>> > > > > >>> > > > > On Wed, Mar 10, 2010 at 2:01 >>> PM, Prabhat >>> > > Jha >>> > > > <pjha(a)redhat.com&gt; wrote: >>> > > > > >>> > > > > >>> > > > > Hi Nicolas, >>> > > > > >>> > > > > Yes, a jira is on the >>> way but way >>> > > to >>> > > > reproduce this problem >>> is quite >>> > > simple. You >>> > > > start with a clean >>> Oracle 10 >>> > > database instance >>> > > > and see the problem >>> during startup. >>> > > It would >>> > > > make sense to have this >>> issue solved >>> > > or have a >>> > > > work around before >>> GateIn GA. >>> > > > > >>> > > > It is not enough, we need to >>> know, which >>> > > exact version >>> > > > of eXo JCR and GateIn, you are >>> using and the >>> > > content >>> > > > of the files that you modified. >>> > > > could you please open a >>> connexion with the >>> > > same >>> > > > account and give us the list of >>> tables that >>> > > you can >>> > > > see >>> > > > > >>> > > > > >>> > > > > Quick questions: >>> > > > > As per oracle11 >>> finding, is JCR >>> > > config >>> > > > (table names) going to >>> be updated >>> > > across the >>> > > > board? >>> > > > > >>> > > > You mean to change the sql >>> scripts for >>> > > oracle 11G? If >>> > > > so please create a JIRA, it will >>> be done in >>> > > the next >>> > > > maintenance version of eXo JCR >>> which will be >>> > > 1.12.1 GA >>> > > > planned for the end of March >>> > > > > >>> > > > > Also, I am wondiering >>> given that >>> > > Oracle 10 >>> > > > has been around for a >>> while, I am >>> > > wondering >>> > > > what has changed in the >>> latest JCR >>> > > that it >>> > > > does not work here. Did >>> the last GA >>> > > version >>> > > > work? >>> > > > > >>> > > > Hard to say before reproducing >>> your bug >>> > > > >>> > > > > >>> > > > > >>> > > > > Thanks, >>> > > > > Prabhat >>> > > > >>> > > > >>> > > > > >>> > > > > >>> > > > > >>> > > > > ----- "Nicolas >>> Filotto" >>> > > > >>> <nicolas.filotto(a)gmail.com&gt; wrote: >>> > > > > > Hi Michal, could you >>> please >>> > > create JIRA >>> > > > issues in the eXo JCR >>> project >>> > > > >>> > > (https://jira.jboss.org/jira/browse/EXOJCR) >>> > > > with all the information >>> needed to >>> > > allow us to >>> > > > reproduce? >>> > > > > > >>> > > > > > >>> > > > > > On Wed, Mar 10, 2010 >>> at 1:46 PM, >>> > > Nicolas >>> > > > Filotto >>> <nicolas.filotto(a)gmail.com&gt; >>> > > wrote: >>> > > > > > >>> > > > >>> > > > > > >>> > > > > > >>> > > > > > >>> > > > > On Wed, Mar >>> 10, 2010 at >>> > > 1:29 PM, >>> > > > Michal Vančo >>> > > <mvanco(a)redhat.com&gt; >>> > > > wrote: >>> > > > > > >>> > > > Hi, >>> > > > > > >>> > > > > > >>> oracle11 now >>> > > works, >>> > > > oracle10 >>> not. See >>> > > below... >>> > > > > > >>> > > > > > >>> Peter Nedonosko >>> > > wrote >>> > > > > > >>> > > > > Hi, >>> > > > > > > >>> > > > > > > >>> about Oracle >>> > > 10 and ' >>> > > > table or >>> view does >>> > > not exist': >>> > > > > > > >>> the problem is >>> > > possible >>> > > > if >>> addConfig used in >>> > > > > > > >>> > > > >>> > > >>> org.exoplatform.services.jcr.config.RepositoryServiceConfiguration >>> > > > > > > (I >>> found it in >>> > > portal >>> > > > \trunk >>> \examples >>> > > \portal\war\src >>> > > > \main >>> \webapp\WEB-INF >>> > > \conf >>> > > > >>> \sample-portal\jcr >>> > > > >>> > > \jcr-configuration.xml) >>> > > > > > >>> > > > > > >>> > > > What you >>> meant with >>> > > addConfig >>> > > > plugin? >>> > > > > > >>> Should I add >>> > > > >>> > > <set-method>addConfig</set-method> in >>> > > > > > >>> > > jcr-configuration.xml? >>> > > > > > Or >>> how can I >>> > > solve 'table >>> > > > or view >>> does not >>> > > exist' on >>> > > > >>> oracle10? >>> > > > > > >>> > > > >>> > > > > > >>> > > > I guess it is >>> not related >>> > > since it >>> > > > works with other >>> databases >>> > > > >>> > > > > >>> > > > >>> > > > > > > >>> > > > > > > if >>> the >>> > > database is >>> > > > creating >>> from the >>> > > scratch and >>> > > > if the >>> configuration >>> > > > > > > >>> persister got >>> > > an answer >>> > > > from the >>> Oracle - >>> > > your table >>> > > > exists >>> in >>> > > > > > > >>> > > isDbInitialized(): >>> > > > > > > >>> ResultSet trs >>> > > = >>> > > > >>> > > con.getMetaData().getTables(null, null, >>> configTableName, >>> > > null); >>> > > > > > > >>> return >>> > > trs.next(); // >>> > > > true = >>> yes >>> > > > > > > >>> > > > > > > >>> but then >>> > > Oracle fails >>> > > > with >>> > > > > > > >>> > > PreparedStatement ps = >>> > > > >>> > > con.prepareStatement("SELECT >>> > > > COUNT(*) >>> FROM " + >>> > > > > > > >>> > > configTableName + " >>> > > > WHERE >>> NAME=?"); >>> > > > > > > >>> > > ps.executeQuery(); // >>> > > > here >>> > > > > > > >>> > > > > > > >>> but I have to >>> > > reproduce >>> > > > it >>> first... >>> > > > > > > >>> does Oracle 10 >>> > > and 11 >>> > > > runs on >>> clean >>> > > database from >>> > > > the >>> start? >>> > > > > > > or >>> just >>> > > restarted on >>> > > > existing >>> db for >>> > > Oracle 11? >>> > > > > > >>> > > > > > >>> > > > Always >>> on clean DBs. >>> > > > > > >>> > > > >>> > > > > > > >>> > > > > > > >>> about >>> > > Oracle11: >>> > > > > > > >>> seems it's >>> > > related to >>> > > > >>> JBossCache loader, >>> > > it creates >>> > > > a table >>> longer of >>> > > > > > > 30 >>> symbols >>> > > (ORA-00972: >>> > > > >>> identifier is too >>> > > long). >>> > > > > > > >>> Why it's not a >>> > > problem >>> > > > for >>> Oracle10 or why >>> > > JBossCache >>> > > > acts in >>> > > > > > > >>> different way >>> > > on >>> > > > Oracle10 >>> or etc... >>> > > > > > > >>> try to fix the >>> > > problem >>> > > > with >>> shorten table >>> > > name from >>> > > > >>> > > repository-configuration.xml >>> > > > > > > >>> e.g. >>> > > > > > > >>> <property >>> > > > >>> > > name="jbosscache-cl-cache.jdbc.table.name" >>> > > value="lock_portalsys" /> >>> > > > > > > >>> instead of >>> > > > > > > >>> <property >>> > > > >>> > > name="jbosscache-cl-cache.jdbc.table.name" >>> > > > > > > >>> > > > >>> > > value="jcrlock_portal_system" /> >>> > > > > > > it >>> should >>> > > helps. >>> > > > > > >>> > > > > > >>> > > > I >>> shortened all >>> > > table names in >>> > > > >>> > > repository-configuration.xml >>> > > > and >>> GateIn >>> > > > > > on >>> Oracle11 >>> > > started >>> > > > without >>> "identifier >>> > > is too >>> > > > long" >>> error. >>> > > > > > >>> > > > > > >>> There is job >>> > > when it >>> > > > starts >>> for the first >>> > > time: >>> > > > > > >>> > > > >>> > > >>> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >>> > > > > > >>> > > > > > I >>> think that it >>> > > would be >>> > > > better >>> to edit >>> > > configuration, >>> > > > because >>> editing >>> > > > > > >>> table names >>> > > before running >>> > > > gatein >>> isn't a good >>> > > way. >>> > > > > > >>> > > > >>> > > > >>> > > > > > > >>> > > > > > > >>> Regards, >>> > > > > > > >>> Peter >>> > > > > > > >>> > > > > > > >>> > > > > > > On >>> Tue, Mar 9, >>> > > 2010 at >>> > > > 11:24 >>> AM, Michal >>> > > Vančo >>> > > > >>> <mvanco(a)redhat.com&gt; >>> > > wrote: >>> > > > > > > > >>> Yes Bolek, >>> > > that's >>> > > > true. >>> > > > > > > > >>> I can't >>> > > explain myself >>> > > > the job >>> in hudson on >>> > > EPP5 >>> > > > >>> > > (epp_ui_selenium_tests_oracle10): >>> > > > > > > > >>> Because >>> > > there was same >>> > > > problem >>> - table or >>> > > view does >>> > > > not >>> exist (build >>> > > > > > > > >>> #3), builds >>> > > #5 and #7 >>> > > > were OK >>> (GateIn >>> > > started with >>> > > > no >>> errors) and >>> > > > > > > > >>> following >>> > > builds again >>> > > > failed >>> due the same >>> > > problem as >>> > > > before. >>> > > > > > > > >>> > > > > > > > >>> Regards, >>> > > > > > > > >>> Michal >>> > > > > > > > >>> > > > > > > > >>> Boleslaw >>> > > Dawidowicz >>> > > > píše v >>> Út 09. 03. >>> > > 2010 v 09:59 >>> > > > +0100: >>> > > > > > > >> >>> From >>> > > mentioned logs >>> > > > it looks >>> like those >>> > > errors >>> > > > don't >>> come from IDM. >>> > > I >>> > > > > > > >> >>> think the >>> > > stack trace >>> > > > in all >>> cases goes >>> > > via >>> > > > > > > >> >>> > > > >>> > > "org.exoplatform.services.jcr.impl.*" >>> > > > > > > >> >>> > > > > > > >> >>> Bolek >>> > > > > > > >> >>> > > > > > > >> >>> On >>> > > 03/09/2010 09:15 >>> > > > AM, >>> Michal Vančo >>> > > wrote: >>> > > > > > > >> >>> > Hi, >>> > > > > > > >> >>> > >>> > > > > > > >> >>> > I'm >>> > > dealing with >>> > > > problem >>> to start >>> > > GateIn with >>> > > > Oracle >>> DB. >>> > > > > > > >> >>> > I always >>> > > start with >>> > > > clean DB >>> and use 2 >>> > > datasource >>> > > > >>> instances (JCR, >>> > > IDM). >>> > > > > > > >> >>> > >>> > > > > > > >> >>> > There are >>> > > 2 >>> > > > >>> different issues: >>> > > > > > > >> >>> > Oracle10: >>> > > > > > > >> >>> > - >>> > > ORA-00942: table >>> > > > or view >>> does not >>> > > exist (start >>> > > > on >>> > > > > > > >> >>> > >>> > > > >>> > > >>> org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0) >>> > > > > > > >> >>> > - only >>> > > IDM schema >>> > > > is >>> initialized, JCR >>> > > not >>> > > > > > > >> >>> > >>> > > > > > > >> >>> > Oracle11: >>> > > > > > > >> >>> > - >>> > > ORA-00972: >>> > > > >>> identifier is too >>> > > long (Cannot >>> > > > >>> instantiate >>> > > component class >>> > > > > > > >> >>> > >>> > > > >>> > > >>> org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) >>> > > > > > > >> >>> > - both >>> > > schemas are >>> > > > created >>> (IDM + JCR) >>> > > > > > > >> >>> > >>> > > > > > > >> >>> > To run on >>> > > oracle, I >>> > > > change >>> configuration >>> > > in >>> > > > >>> > > idm-configuration.xml and >>> > > > > > > >> >>> > >>> > > > >>> > > jcr-configuration.xml, then >>> > > > copy >>> jdbc driver and >>> > > start. >>> > > > > > > >> >>> > I also >>> > > add<property >>> > > > >>> > > name="hibernate.hbm2ddl.auto" >>> > > > >>> > > value="create-drop"/> >>> > > > > > > >> >>> > to >>> > > > >>> > > idm-configuration.xml >>> > > > >>> (recommended by >>> > > Boleslaw >>> > > > >>> Dawidowicz - it >>> > > worked >>> > > > > > > >> >>> > on EPP, >>> > > but not on >>> > > > GateIn >>> trunk). >>> > > > > > > >> >>> > >>> > > > > > > >> >>> > There are >>> > > links to >>> > > > log: >>> > > > > > > >> >>> > >>> > > > >>> > > >>> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >>> > > > > > > >> >>> > >>> > > > > > > >> >>> > >>> > > > >>> > > >>> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >>> > > > > > > >> >>> > >>> > > > > > > >> >>> > >>> > > > > > > >> >>> > I would >>> > > appreciate >>> > > > any >>> help. >>> > > > > > > >> >>> > >>> > > > > > > >> >>> > Thanks in >>> > > advance >>> > > > > > > >> >>> > Michal >>> > > Vanco >>> > > > > > > >> >>> > >>> > > > > > > >> >>> > >>> > > > >>> > > _______________________________________________ >>> > > > > > > >> >>> > >>> > > gatein-dev mailing >>> > > > list >>> > > > > > > >> >>> > >>> > > > >>> > > gatein-dev(a)lists.jboss.org >>> > > > > > > >> >>> > >>> > > > >>> > > >>> https://lists.jboss.org/mailman/listinfo/gatein-dev >>> > > > > > > > >>> > > > > > > > >>> > > > > > > > >>> > > > >>> > > _______________________________________________ >>> > > > > > > > >>> gatein-dev >>> > > mailing >>> > > > list >>> > > > > > > > >>> > > > >>> > > gatein-dev(a)lists.jboss.org >>> > > > > > > > >>> > > > >>> > > >>> https://lists.jboss.org/mailman/listinfo/gatein-dev >>> > > > > > > > >>> > > > > > >>> > > > > > >>> > > > > > >>> > > > Thanks, >>> > > > > > >>> Michal >>> > > > > > >>> > > > >>> > > > >>> > > > > > >>> > > > >>> > > _______________________________________________ >>> > > > > > >>> gatein-dev >>> > > mailing list >>> > > > > > >>> > > gatein-dev(a)lists.jboss.org >>> > > > > > >>> > > > >>> > > >>> https://lists.jboss.org/mailman/listinfo/gatein-dev >>> > > > > > >>> > > > >>> > > > > > >>> > > > >>> > > > > > -- >>> > > > > > >>> > > > >>> > > > > Nicolas >>> Filotto >>> > > > > > JCR Product >>> Manager >>> > > > > > Project >>> Manager >>> > > > > > eXo Platform >>> SAS >>> > > > > > >>> > > nicolas.filotto(a)exoplatform.com >>> > > > > > +33 (0)6 31 >>> 32 92 19 >>> > > > > > >>> > > > >>> > > > > > >>> > > > >>> > > > > > -- >>> > > > > > Nicolas Filotto >>> > > > > > JCR Product Manager >>> > > > > > Project Manager >>> > > > > > eXo Platform SAS >>> > > > > > >>> nicolas.filotto(a)exoplatform.com >>> > > > > > +33 (0)6 31 32 92 19 >>> > > > > > >>> > > > > >>> > > > > >>> > > > >>> > > _______________________________________________ >>> gatein-dev >>> > > mailing list gatein-dev(a)lists.jboss.org >>> > > >>> https://lists.jboss.org/mailman/listinfo/gatein-dev >>> > > > >>> > > > > >>> > > > > >>> > > > >>> > > > > -- >>> > > > > Nicolas Filotto >>> > > > > JCR Product Manager >>> > > > > Project Manager >>> > > > > eXo Platform SAS >>> > > > > >>> nicolas.filotto(a)exoplatform.com >>> > > > > +33 (0)6 31 32 92 19 >>> > > > > >>> > > > >>> > > > > >>> > > > >>> > > > > -- >>> > > > > Nicolas Filotto >>> > > > > JCR Product Manager >>> > > > > Project Manager >>> > > > > eXo Platform SAS >>> > > > > nicolas.filotto(a)exoplatform.com >>> > > > > +33 (0)6 31 32 92 19 >>> > > > > >>> > > > >>> > > > >>> > > > >>> > > > -- >>> > > > Nicolas Filotto >>> > > > JCR Product Manager >>> > > > Project Manager >>> > > > eXo Platform SAS >>> > > > nicolas.filotto(a)exoplatform.com >>> > > > +33 (0)6 31 32 92 19 >>> > > >>> > > >>> > > >>> > > >>> > > >>> > > -- >>> > > Nicolas Filotto >>> > > JCR Product Manager >>> > > Project Manager >>> > > eXo Platform SAS >>> > > nicolas.filotto(a)exoplatform.com >>> > > +33 (0)6 31 32 92 19 >>> > >>> > Michal >>> > >>> > _______________________________________________ >>> > gatein-dev mailing list >>> > gatein-dev(a)lists.jboss.org >>> > https://lists.jboss.org/mailman/listinfo/gatein-dev >>> >>> >>> >>> >>> >>> >>> -- >>> Nicolas Filotto >>> JCR Product Manager >>> Project Manager >>> eXo Platform SAS >>> nicolas.filotto(a)exoplatform.com >>> +33 (0)6 31 32 92 19 >>> >>> >> > _______________________________________________ gatein-dev mailing list gatein-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/gatein-dev

At this point, it is too late to test the workaround proposed by Peter on all DB, so let's consider that as a limitation of eXo JCR 1.12.0 GA. Which means that eXo JCR needs a dedicated tablespace to avoid potential conflicts, shared tablespace is not yet supported. On Thu, Mar 11, 2010 at 1:19 PM, Thomas Heute <theute(a)redhat.com&gt; wrote: > > So again, we *need* to have a release of JCR. > > What's the status related to Oracle 10 support ? > > Has this: > > try { >  ResultSet tprs = con.createStatement(). > executeQuery("SELECT COUNT(*) > FROM " + tableName); >  return tprs.next(); > catch (SQLException e) > { >  return false; > } > > Been tested on all DB ? If yes can we put this in the GA ? > > Also about the other issue JCR-1333, is there a workaround that has been > tested ? > Such as: > "use tablespace per user to prevent such error (simplest way) or grant > enough rights/roles to all users in one tablespace." > > Thomas. > > > > On 03/11/2010 01:03 PM, Peter Nedonosko wrote: > > On Thu, Mar 11, 2010 at 1:52 PM, Peter Nedonosko <pnedonosko(a)gmail.com&gt; > wrote: > > > On Thu, Mar 11, 2010 at 1:35 PM, Michal Vančo <mvanco(a)redhat.com&gt; wrote: > > > Nicolas Filotto wrote: > > > On Thu, Mar 11, 2010 at 9:57 AM, Michal Vančo <mvanco(a)redhat.com&gt; > wrote: >         Hi, > >         today I checked following situations with oracle10: >          - oracle11 driver for oracle10 db >          - create bundle with JCR 1.12.0-GA >          - delete gatein-sample* in server/default/deploy -> only >         change was >         that it failed with: Cannot create the portal container >         'portal', before >         it was: Cannot create the portal container 'sample-portal' and >         Cannot >         create the portal container 'portal' >          - creating jcr tables manually with script: > > http://anonsvn.jboss.org/repos/exo-jcr/jcr/tags/1.12.0-GA/exo.jcr.compone... > >         didn't help, but after adding script to create JCR_CONFIG >         table -> it >         started to work (detail of script in another mail on >         gatein-dev) > >         So, looks like JCR don't want to initialize. Any suggestions >         why? > So far the only thing that we know is that > con.getMetaData().getTables(null, null, "JCR_CONFIG", null); returns a > result, so the JCR assumes that the table exists and thus try to > launch a query on it so it fails since actually the table doesn't > exist. > So far, we don't know why this method returns something on your side, > can you add a breakpoint on the method > > org.exoplatform.services.jcr.impl.config.JDBCConfigurationPersister.isDbInitialized() > of the project exo.jcr.component.core and tell us what you have in your > resultset? > > > when calling > ResultSet trs = con.getMetaData().getTables(null, null, "JCR_CONFIG", > null); > return trs.next(); > > it returns true and content of trs variable from debug is attached. > > Then it ends on line 237: ResultSet res = ps.executeQuery(); > > Is it enough? Or what more can I explore in debug? > > > con.getMetaData().getTables(null, null, "JCR_CONFIG", null); > is wrong on oracle at all, > as the call returns all JCR_CONFIG tables in the Oracle instance (crazy > for me) > but here I have several databases with different tablespaces and I see > all of them within user who should not see ones. > > Nicolas, it will be like if several databases contains JCR_CONFIG table: > null EXOCLUSTER1 JCR_CONFIG > null EXOCLUSTER2 JCR_CONFIG > null JCRDB JCR_CONFIG > .... > > FYI, I have applied your script and yes - it reproduces the issue > but I still guess it's DBA side work to provide the rights to users > from one schema. > > After I replaced > con.getMetaData().getTables(null, null, "JCR_CONFIG", null); > with > try { >  ResultSet tprs = con.createStatement().executeQuery("SELECT COUNT(*) > FROM " + tableName); >  return tprs.next(); > catch (SQLException e) > { >  return false; > } > > this part works well but next thing you'll meet will be > http://jira.exoplatform.org/browse/JCR-1333 > > > the issue about insufficient rights for triggers creation, > user should have rights for tables, triggers and sequences creation. > it's actual for single and multi-db. > > > > so it's still DBA task IMO. > > > > > > >         Michal > > >         Michal Vančo wrote: >         > Hi, >         > >         > Nicolas Filotto wrote: >         > > Could you please provide the list of tables that you can >         see with your >         > > credentials on oracle 10 G? >         > >         > As I wrote yesterday in my additional reply: >         > I'm using sqldeveloper tool to see the content of oracle DB, >         and at all >         > oracle10 cases, I can't see that anything is created >         (tables, sequence, >         > indexes...) in JCR schema. Only IDM schema initialization is >         done. >         > >         > > >         > > On Wed, Mar 10, 2010 at 8:41 PM, Michal Vančo >         <mvanco(a)redhat.com&gt; >         > > wrote: >         > >         Hi, >         > > >         > >         currently I have same results as before (table or >         view does >         > >         not exist) >         > >         on oracle10 in these conditions: >         > >          - 2 datasources on one machine (differentiated by >         user names) >         > >          - 1 datasource on a machine (JCR and IDM >         together) >         > >          - 2 datasources on separate machines >         > >         > It was added for these cases ^. >         > >         > > >         > >         To run GateIn trunk on Oracle10, I do following >         steps: >         > >          - prepare GateIn trunk bundle >         > >          - unzip bundle >         > >          - change driver class, url, user and password in >         > >         jcr-configuration.xml >         > > >         in > ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/ >         > >          - change driver class, url, user and password in >         > >         idm-configuration.xml >         > > >         in > ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/organization/ >         > >          - add <property name="hibernate.hbm2ddl.auto" >         > >         value="create-drop"/> in >         > >         idm-configuration.xml >         > >          - copy oracle10 jdbc driver >         into ../server/default/lib >         > >          - start gatein by run.sh in bin folder >         > > >         > >         (I can provide a script from hudson where you can >         add your own >         > >         paths and >         > >         credentials...) >         > > >         > >         For oracle11: >         > >          - when run with same config as on oracle10, I get >         error: >         > >         ORA-00972: identifier is too long (when >         initializing >         > > > > org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) >         > > >         > >          - oracle11_jcr.jpg - screen of what has been >         created in DB >         > > >         > >          - if I edit table names >         > > >         in > ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/repository-configuration.xml, > gatein started correctly >         > >         - oracle11_jcr_shorten_names.jpg - screen of what >         has been >         > >         created in DB >         > > >         > >         Let me know if you need more details to reproduce >         it on your >         > >         side. >         > > >         > >         Best regards, >         > > >         > >         Michal >         > > >         > > >         > >         Nicolas Filotto píše v St 10. 03. 2010 v 17:39 >         +0100: >         > > >         > >         > >         > >         > >         > >         > On Wed, Mar 10, 2010 at 5:19 PM, Prabhat Jha >         > >         <pjha(a)redhat.com&gt; wrote: >         > >         >         I have created >         > >         https://jira.jboss.org/jira/browse/EXOJCR-582 >         > >         >         for oracle11 issue. Please check that I >         have right >         > >         affects and >         > >         >         fix versions. >         > >         > >         > >         > thx, FYI I've just set the right settings >         > >         > >         > >         >         The version of GateIn and JCR is the one >         that's in >         > >         GateIn >         > >         >         trunk currently. The way our environment >         is setup is >         > >         that we >         > >         >         have one Oracle10 DB servers and >         different usernames >         > >         which I >         > >         >         believe means different schemas in >         Oracle for >         > >         different tests >         > >         >         (gatein-ui, gatein-jcr etc) configured >         on that >         > >         server. I would >         > >         >         have to wait for Michal to show up for >         info. He >         > >         needed to >         > >         >         attend to some personal stuff : hospital >         to check on >         > >         his mom. >         > >         > >         > >         >         But in your environment, you have GateIn >         starting >         > >         fine on >         > >         >         Oracle 10, right? >         > >         > >         > >         > no so far, we have only tested with pure JCR but >         in the same >         > >         > conditions as gatein, now as we know the version >         of gatein >         > >         we will try >         > >         > with the same version (i.e the trunk) >         > >         > >         > >         >         thanks, >         > >         >         prabhat >         > >         > >         > >         > >         > >         > >         > >         > >         > >         >         ----- "Nicolas Filotto" >         <nicolas.filotto(a)gmail.com&gt; >         > >         wrote: >         > >         >         > Prabhat and/or Michal, could you >         please provide >         > >         the answers >         > >         >         of the questions asked by Peter and me. >         We cannot >         > >         reproduce so >         > >         >         far, so we need your help. Please note >         that we >         > >         blocked the >         > >         >         release of GA because of this last >         issue, so we need >         > >         your help >         > >         >         to fix it asap. >         > >         >         > >         > >         >         > >         > >         >         Thank you in advance, >         > >         >         BR, >         > >         >         Nicolas >         > >         >         > >         > >         >         > On Wed, Mar 10, 2010 at 3:02 PM, >         Nicolas Filotto >         > >         >         <nicolas.filotto(a)gmail.com&gt; wrote: >         > >         >         > >         > >         >                 Hi Prabhat, >         > >         >                 > >         > >         >                 > >         > >         >                 my comments inline >         > >         >                 > >         > >         >                 > >         > >         >                 > On Wed, Mar 10, 2010 at 2:01 >         PM, Prabhat >         > >         Jha >         > >         >                 <pjha(a)redhat.com&gt; wrote: >         > >         >                 > >         > >         >                 > >         > >         >                         > Hi Nicolas, >         > >         >                         > >         > >         >                         > Yes, a jira is on the >         way but way >         > >         to >         > >         >                         reproduce this problem >         is quite >         > >         simple. You >         > >         >                         start with a clean >         Oracle 10 >         > >         database instance >         > >         >                         and see the problem >         during startup. >         > >         It would >         > >         >                         make sense to have this >         issue solved >         > >         or have a >         > >         >                         work around before >         GateIn GA. >         > >         >                         > >         > >         >                 It is not enough, we need to >         know, which >         > >         exact version >         > >         >                 of eXo JCR and GateIn, you are >         using and the >         > >         content >         > >         >                 of the files that you modified. >         > >         >                 could you please open a >         connexion with the >         > >         same >         > >         >                 account and give us the list of >         tables that >         > >         you can >         > >         >                 see >         > >         >                 > >         > >         >                         > >         > >         >                         > Quick questions: >         > >         >                         >  As per oracle11 >         finding, is JCR >         > >         config >         > >         >                         (table names) going to >         be updated >         > >         across the >         > >         >                         board? >         > >         >                         > >         > >         >                  You mean to change the sql >         scripts for >         > >         oracle 11G? If >         > >         >                 so please create a JIRA, it will >         be done in >         > >         the next >         > >         >                 maintenance version of eXo JCR >         which will be >         > >         1.12.1 GA >         > >         >                 planned for the end of March >         > >         >                 > >         > >         >                         > Also, I am wondiering >         given that >         > >         Oracle 10 >         > >         >                         has been around for a >         while, I am >         > >         wondering >         > >         >                         what has changed in the >         latest JCR >         > >         that it >         > >         >                         does not work here. Did >         the last GA >         > >         version >         > >         >                         work? >         > >         >                         > >         > >         >                 Hard to say before reproducing >         your bug >         > >         > >         > >         >                 > >         > >         >                         > >         > >         >                         > Thanks, >         > >         >                         > Prabhat >         > >         > >         > >         > >         > >         >                         > >         > >         >                         > >         > >         >                         > >         > >         >                         > ----- "Nicolas >         Filotto" >         > >         > >         <nicolas.filotto(a)gmail.com&gt; wrote: >         > >         >                         > > Hi Michal, could you >         please >         > >         create JIRA >         > >         >                         issues in the eXo JCR >         project >         > >         > >         > >         (https://jira.jboss.org/jira/browse/EXOJCR) >         > >         >                         with all the information >         needed to >         > >         allow us to >         > >         >                         reproduce? >         > >         >                         > > >         > >         >                         > > >         > >         >                         > > On Wed, Mar 10, 2010 >         at 1:46 PM, >         > >         Nicolas >         > >         >                         Filotto >         <nicolas.filotto(a)gmail.com&gt; >         > >         wrote: >         > >         >                         > > >         > >         > >         > >         >                                 > > >         > >         >                                 > > >         > >         >                                 > > >         > >         >                                 > On Wed, Mar >         10, 2010 at >         > >         1:29 PM, >         > >         >                                 Michal Vančo >         > >         <mvanco(a)redhat.com&gt; >         > >         >                                 wrote: >         > >         >                                 > > >         > >         >                                         Hi, >         > >         >                                         > > >         > >         >                                         > > >         oracle11 now >         > >         works, >         > >         >                                         oracle10 >         not. See >         > >         below... >         > >         >                                         > > >         > >         >                                         > > >         Peter Nedonosko >         > >         wrote >         > >         >                                         > > >         > >         >                                         > Hi, >         > >         >                                         > > > >         > >         >                                         > > > >         about Oracle >         > >         10 and ' >         > >         >                                         table or >         view does >         > >         not exist': >         > >         >                                         > > > >         the problem is >         > >         possible >         > >         >                                         if >         addConfig used in >         > >         >                                         > > > >         > >         > >         > > >         org.exoplatform.services.jcr.config.RepositoryServiceConfiguration >         > >         >                                         > > > (I >         found it in >         > >         portal >         > >         >                                         \trunk >         \examples >         > >         \portal\war\src >         > >         >                                         \main >         \webapp\WEB-INF >         > >         \conf >         > >         > >         \sample-portal\jcr >         > >         > >         > >         \jcr-configuration.xml) >         > >         >                                         > > >         > >         >                                         > > >         > >         >                                         What you >         meant with >         > >         addConfig >         > >         >                                         plugin? >         > >         >                                         > > >         Should I add >         > >         > >         > >         <set-method>addConfig</set-method> in >         > >         >                                         > > >         > >         jcr-configuration.xml? >         > >         >                                         > > Or >         how can I >         > >         solve 'table >         > >         >                                         or view >         does not >         > >         exist' on >         > >         > >         oracle10? >         > >         >                                         > > >         > >         > >         > >         >                                 > > >         > >         >                                 I guess it is >         not related >         > >         since it >         > >         >                                 works with other >         databases >         > >         > >         > >         >                                 > >         > >         > >         > >         >                                         > > > >         > >         >                                         > > > if >         the >         > >         database is >         > >         >                                         creating >         from the >         > >         scratch and >         > >         >                                         if the >         configuration >         > >         >                                         > > > >         persister got >         > >         an answer >         > >         >                                         from the >         Oracle - >         > >         your table >         > >         >                                         exists >         in >         > >         >                                         > > > >         > >         isDbInitialized(): >         > >         >                                         > > > >         ResultSet trs >         > >         = >         > >         > >         > >         con.getMetaData().getTables(null, null, >         configTableName, >         > >         null); >         > >         >                                         > > > >         return >         > >         trs.next(); // >         > >         >                                         true = >         yes >         > >         >                                         > > > >         > >         >                                         > > > >         but then >         > >         Oracle fails >         > >         >                                         with >         > >         >                                         > > > >         > >         PreparedStatement ps = >         > >         > >         > >         con.prepareStatement("SELECT >         > >         >                                         COUNT(*) >         FROM " + >         > >         >                                         > > > >         > >         configTableName + " >         > >         >                                         WHERE >         NAME=?"); >         > >         >                                         > > > >         > >         ps.executeQuery(); // >         > >         >                                         here >         > >         >                                         > > > >         > >         >                                         > > > >         but I have to >         > >         reproduce >         > >         >                                         it >         first... >         > >         >                                         > > > >         does Oracle 10 >         > >         and 11 >         > >         >                                         runs on >         clean >         > >         database from >         > >         >                                         the >         start? >         > >         >                                         > > > or >         just >         > >         restarted on >         > >         >                                         existing >         db for >         > >         Oracle 11? >         > >         >                                         > > >         > >         >                                         > > >         > >         >                                         Always >         on clean DBs. >         > >         >                                         > > >         > >         > >         > >         >                                         > > > >         > >         >                                         > > > >         about >         > >         Oracle11: >         > >         >                                         > > > >         seems it's >         > >         related to >         > >         > >         JBossCache loader, >         > >         it creates >         > >         >                                         a table >         longer of >         > >         >                                         > > > 30 >         symbols >         > >         (ORA-00972: >         > >         > >         identifier is too >         > >         long). >         > >         >                                         > > > >         Why it's not a >         > >         problem >         > >         >                                         for >         Oracle10 or why >         > >         JBossCache >         > >         >                                         acts in >         > >         >                                         > > > >         different way >         > >         on >         > >         >                                         Oracle10 >         or etc... >         > >         >                                         > > > >         try to fix the >         > >         problem >         > >         >                                         with >         shorten table >         > >         name from >         > >         > >         > >         repository-configuration.xml >         > >         >                                         > > > >         e.g. >         > >         >                                         > > > >         <property >         > >         > >         > >         name="jbosscache-cl-cache.jdbc.table.name" >         > >         value="lock_portalsys" /> >         > >         >                                         > > > >         instead of >         > >         >                                         > > > >         <property >         > >         > >         > >         name="jbosscache-cl-cache.jdbc.table.name" >         > >         >                                         > > > >         > >         > >         > >         value="jcrlock_portal_system" /> >         > >         >                                         > > > it >         should >         > >         helps. >         > >         >                                         > > >         > >         >                                         > > >         > >         >                                         I >         shortened all >         > >         table names in >         > >         > >         > >         repository-configuration.xml >         > >         >                                         and >         GateIn >         > >         >                                         > > on >         Oracle11 >         > >         started >         > >         >                                         without >         "identifier >         > >         is too >         > >         >                                         long" >         error. >         > >         >                                         > > >         > >         >                                         > > >         There is job >         > >         when it >         > >         >                                         starts >         for the first >         > >         time: >         > >         >                                         > > >         > >         > >         > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >         > >         >                                         > > >         > >         >                                         > > I >         think that it >         > >         would be >         > >         >                                         better >         to edit >         > >         configuration, >         > >         >                                         because >         editing >         > >         >                                         > > >         table names >         > >         before running >         > >         >                                         gatein >         isn't a good >         > >         way. >         > >         >                                         > > >         > >         > >         > >         > >         > >         >                                         > > > >         > >         >                                         > > > >         Regards, >         > >         >                                         > > > >         Peter >         > >         >                                         > > > >         > >         >                                         > > > >         > >         >                                         > > > On >         Tue, Mar 9, >         > >         2010 at >         > >         >                                         11:24 >         AM, Michal >         > >         Vančo >         > >         > >         <mvanco(a)redhat.com&gt; >         > >         wrote: >         > >         >                                         > > > > >         Yes Bolek, >         > >         that's >         > >         >                                         true. >         > >         >                                         > > > > >         I can't >         > >         explain myself >         > >         >                                         the job >         in hudson on >         > >         EPP5 >         > >         > >         > >         (epp_ui_selenium_tests_oracle10): >         > >         >                                         > > > > >         Because >         > >         there was same >         > >         >                                         problem >         - table or >         > >         view does >         > >         >                                         not >         exist (build >         > >         >                                         > > > > >         #3), builds >         > >         #5 and #7 >         > >         >                                         were OK >         (GateIn >         > >         started with >         > >         >                                         no >         errors) and >         > >         >                                         > > > > >         following >         > >         builds again >         > >         >                                         failed >         due the same >         > >         problem as >         > >         >                                         before. >         > >         >                                         > > > > >         > >         >                                         > > > > >         Regards, >         > >         >                                         > > > > >         Michal >         > >         >                                         > > > > >         > >         >                                         > > > > >         Boleslaw >         > >         Dawidowicz >         > >         >                                         píše v >         Út 09. 03. >         > >         2010 v 09:59 >         > >         >                                         +0100: >         > >         >                                         > > > >> >         From >         > >         mentioned logs >         > >         >                                         it looks >         like those >         > >         errors >         > >         >                                         don't >         come from IDM. >         > >         I >         > >         >                                         > > > >> >         think the >         > >         stack trace >         > >         >                                         in all >         cases goes >         > >         via >         > >         >                                         > > > >> >         > >         > >         > >         "org.exoplatform.services.jcr.impl.*" >         > >         >                                         > > > >> >         > >         >                                         > > > >> >         Bolek >         > >         >                                         > > > >> >         > >         >                                         > > > >> >         On >         > >         03/09/2010 09:15 >         > >         >                                         AM, >         Michal Vančo >         > >         wrote: >         > >         >                                         > > > >> >         > Hi, >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > I'm >         > >         dealing with >         > >         >                                         problem >         to start >         > >         GateIn with >         > >         >                                         Oracle >         DB. >         > >         >                                         > > > >> >         > I always >         > >         start with >         > >         >                                         clean DB >         and use 2 >         > >         datasource >         > >         > >         instances (JCR, >         > >         IDM). >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > There are >         > >         2 >         > >         > >         different issues: >         > >         >                                         > > > >> >         > Oracle10: >         > >         >                                         > > > >> >         > - >         > >         ORA-00942: table >         > >         >                                         or view >         does not >         > >         exist (start >         > >         >                                         on >         > >         >                                         > > > >> >         > >         > >         > >         > > > > org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0) >         > >         >                                         > > > >> >         > - only >         > >         IDM schema >         > >         >                                         is >         initialized, JCR >         > >         not >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > Oracle11: >         > >         >                                         > > > >> >         > - >         > >         ORA-00972: >         > >         > >         identifier is too >         > >         long (Cannot >         > >         > >         instantiate >         > >         component class >         > >         >                                         > > > >> >         > >         > >         > >         > > > > org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) >         > >         >                                         > > > >> >         > - both >         > >         schemas are >         > >         >                                         created >         (IDM + JCR) >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > To run on >         > >         oracle, I >         > >         >                                         change >         configuration >         > >         in >         > >         > >         > >         idm-configuration.xml and >         > >         >                                         > > > >> >         > >         > >         > >         > >         jcr-configuration.xml, then >         > >         >                                         copy >         jdbc driver and >         > >         start. >         > >         >                                         > > > >> >         > I also >         > >         add<property >         > >         > >         > >         name="hibernate.hbm2ddl.auto" >         > >         > >         > >         value="create-drop"/> >         > >         >                                         > > > >> >         > to >         > >         > >         > >         idm-configuration.xml >         > >         > >         (recommended by >         > >         Boleslaw >         > >         > >         Dawidowicz - it >         > >         worked >         > >         >                                         > > > >> >         > on EPP, >         > >         but not on >         > >         >                                         GateIn >         trunk). >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > There are >         > >         links to >         > >         >                                         log: >         > >         >                                         > > > >> >         > >         > >         > >         > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > >         > >         > >         > > > > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > I would >         > >         appreciate >         > >         >                                         any >         help. >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > Thanks in >         > >         advance >         > >         >                                         > > > >> >         > Michal >         > >         Vanco >         > >         >                                         > > > >> >         > >         > >         >                                         > > > >> >         > >         > >         > >         > >         _______________________________________________ >         > >         >                                         > > > >> >         > >         > >         gatein-dev mailing >         > >         >                                         list >         > >         >                                         > > > >> >         > >         > >         > >         > >         gatein-dev(a)lists.jboss.org >         > >         >                                         > > > >> >         > >         > >         > >         > > >         https://lists.jboss.org/mailman/listinfo/gatein-dev >         > >         >                                         > > > > >         > >         >                                         > > > > >         > >         >                                         > > > > >         > >         > >         > >         _______________________________________________ >         > >         >                                         > > > > >         gatein-dev >         > >         mailing >         > >         >                                         list >         > >         >                                         > > > > >         > >         > >         > >         gatein-dev(a)lists.jboss.org >         > >         >                                         > > > > >         > >         > >         > > >         https://lists.jboss.org/mailman/listinfo/gatein-dev >         > >         >                                         > > > > >         > >         >                                         > > >         > >         >                                         > > >         > >         >                                         > > >         > >         >                                         Thanks, >         > >         >                                         > > >         Michal >         > >         >                                         > > >         > >         > >         > >         > >         > >         >                                         > > >         > >         > >         > >         _______________________________________________ >         > >         >                                         > > >         gatein-dev >         > >         mailing list >         > >         >                                         > > >         > >         gatein-dev(a)lists.jboss.org >         > >         >                                         > > >         > >         > >         > > >         https://lists.jboss.org/mailman/listinfo/gatein-dev >         > >         >                                         > > >         > >         > >         > >         >                                 > > >         > >         > >         > >         >                                 > > -- >         > >         >                                 > > >         > >         > >         > >         >                                 > Nicolas >         Filotto >         > >         >                                 > > JCR Product >         Manager >         > >         >                                 > > Project >         Manager >         > >         >                                 > > eXo Platform >         SAS >         > >         >                                 > > >         > >         nicolas.filotto(a)exoplatform.com >         > >         >                                 > > +33 (0)6 31 >         32 92 19 >         > >         >                                 > > >         > >         > >         > >         >                         > > >         > >         > >         > >         >                         > > -- >         > >         >                         > > Nicolas Filotto >         > >         >                         > > JCR Product Manager >         > >         >                         > > Project Manager >         > >         >                         > > eXo Platform SAS >         > >         >                         > > >         nicolas.filotto(a)exoplatform.com >         > >         >                         > > +33 (0)6 31 32 92 19 >         > >         >                         > > >         > >         >                         > >         > >         >                         > >         > >         > >         > >         _______________________________________________ >         gatein-dev >         > >         mailing list gatein-dev(a)lists.jboss.org >         > > >         https://lists.jboss.org/mailman/listinfo/gatein-dev >         > >         > >         > >         >                 > >         > >         >                 > >         > >         > >         > >         >                 > -- >         > >         >                 > Nicolas Filotto >         > >         >                 > JCR Product Manager >         > >         >                 > Project Manager >         > >         >                 > eXo Platform SAS >         > >         >                 > >         nicolas.filotto(a)exoplatform.com >         > >         >                 > +33 (0)6 31 32 92 19 >         > >         >                 > >         > >         > >         > >         >         > >         > >         > >         > >         >         > -- >         > >         >         > Nicolas Filotto >         > >         >         > JCR Product Manager >         > >         >         > Project Manager >         > >         >         > eXo Platform SAS >         > >         >         > nicolas.filotto(a)exoplatform.com >         > >         >         > +33 (0)6 31 32 92 19 >         > >         >         > >         > >         > >         > >         > >         > >         > >         > >         > -- >         > >         > Nicolas Filotto >         > >         > JCR Product Manager >         > >         > Project Manager >         > >         > eXo Platform SAS >         > >         > nicolas.filotto(a)exoplatform.com >         > >         > +33 (0)6 31 32 92 19 >         > > >         > > >         > > >         > > >         > > >         > > -- >         > > Nicolas Filotto >         > > JCR Product Manager >         > > Project Manager >         > > eXo Platform SAS >         > > nicolas.filotto(a)exoplatform.com >         > > +33 (0)6 31 32 92 19 >         > >         > Michal >         > >         > _______________________________________________ >         > gatein-dev mailing list >         > gatein-dev(a)lists.jboss.org >         > https://lists.jboss.org/mailman/listinfo/gatein-dev > > > > > > > -- > Nicolas Filotto > JCR Product Manager > Project Manager > eXo Platform SAS > nicolas.filotto(a)exoplatform.com > +33 (0)6 31 32 92 19 > > > > > > > > _______________________________________________ > gatein-dev mailing list > gatein-dev(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/gatein-dev > -- Nicolas Filotto JCR Product Manager Project Manager eXo Platform SAS nicolas.filotto(a)exoplatform.com +33 (0)6 31 32 92 19

Hi, Peter Nedonosko wrote: > On Thu, Mar 11, 2010 at 1:35 PM, Michal Vančo <mvanco(a)redhat.com&gt; wrote: > > Nicolas Filotto wrote: > >> > >> > >> On Thu, Mar 11, 2010 at 9:57 AM, Michal Vančo <mvanco(a)redhat.com&gt; > >> wrote: > >>         Hi, > >> > >>         today I checked following situations with oracle10: > >>          - oracle11 driver for oracle10 db > >>          - create bundle with JCR 1.12.0-GA > >>          - delete gatein-sample* in server/default/deploy -> only > >>         change was > >>         that it failed with: Cannot create the portal container > >>         'portal', before > >>         it was: Cannot create the portal container 'sample-portal' and > >>         Cannot > >>         create the portal container 'portal' > >>          - creating jcr tables manually with script: > >>         http://anonsvn.jboss.org/repos/exo-jcr/jcr/tags/1.12.0-GA/exo.jcr.compone... > >> > >>         didn't help, but after adding script to create JCR_CONFIG > >>         table -> it > >>         started to work (detail of script in another mail on > >>         gatein-dev) > >> > >>         So, looks like JCR don't want to initialize. Any suggestions > >>         why? > >> So far the only thing that we know is that > >> con.getMetaData().getTables(null, null, "JCR_CONFIG", null); returns a > >> result, so the JCR assumes that the table exists and thus try to > >> launch a query on it so it fails since actually the table doesn't > >> exist. > >> So far, we don't know why this method returns something on your side, > >> can you add a breakpoint on the method > >> org.exoplatform.services.jcr.impl.config.JDBCConfigurationPersister.isDbInitialized() of the project exo.jcr.component.core and tell us what you have in your resultset? > > > > > > when calling > > ResultSet trs = con.getMetaData().getTables(null, null, "JCR_CONFIG", null); > > return trs.next(); > > > > it returns true and content of trs variable from debug is attached. > > > > Then it ends on line 237: ResultSet res = ps.executeQuery(); > > > > Is it enough? Or what more can I explore in debug? > > con.getMetaData().getTables(null, null, "JCR_CONFIG", null); > is wrong on oracle at all, > as the call returns all JCR_CONFIG tables in the Oracle instance (crazy for me) > but here I have several databases with different tablespaces and I see > all of them within user who should not see ones. > > Nicolas, it will be like if several databases contains JCR_CONFIG table: > null EXOCLUSTER1 JCR_CONFIG > null EXOCLUSTER2 JCR_CONFIG > null JCRDB JCR_CONFIG > .... > > FYI, I have applied your script and yes - it reproduces the issue > but I still guess it's DBA side work to provide the rights to users > from one schema. > > After I replaced > con.getMetaData().getTables(null, null, "JCR_CONFIG", null); > with > try { >   ResultSet tprs = con.createStatement().executeQuery("SELECT COUNT(*) > FROM " + tableName); >   return tprs.next(); > catch (SQLException e) > { >   return false; > } I checked this:  - get gatein trunk sources (1.12.0-GA is already set there)  - get jcr 1.12.0-GA sources -> edit isDbInitialized method to: ResultSet tprs = con.createStatement().executeQuery("SELECT COUNT(*) FROM " + configTableName);  - install jcr in local repo  - build gatein bundle with local 1.12.0-GA jcr  - run gatein on clean oracle DB  - JCR SCHEMA IS INITIALIZED! But when initializing data, I get this error: org.exoplatform.services.jcr.impl.storage.JCRInvalidItemStateException: [system] ADD PROPERTY. Error of item add. []:1[http://www.jcp.org/jcr/1.0]primaryType:1, ID: 4eb6816b0a10590b017c461130360076, ParentID: 00exo0jcr0root0uuid0000000000000. Cause >>>> ORA-01400: cannot insert NULL into ("EPP5UIDB"."JCR_SVALUE"."ID")

If I look at JCR_SVALUE table with sqldeveloper, I can see that ID column has nullable - no, it means that null values aren't allowed. Is it problem at initialization of DB? There is full log for more details: http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... - it should be published on this url soon (from internal hudson) Hope that info helps ;) Regards, Michal > > this part works well but next thing you'll meet will be > http://jira.exoplatform.org/browse/JCR-1333 > > so it's still DBA task IMO. > > > > > >> > >>         Michal > >> > >> > >>         Michal Vančo wrote: > >>         > Hi, > >>         > > >>         > Nicolas Filotto wrote: > >>         > > Could you please provide the list of tables that you can > >>         see with your > >>         > > credentials on oracle 10 G? > >>         > > >>         > As I wrote yesterday in my additional reply: > >>         > I'm using sqldeveloper tool to see the content of oracle DB, > >>         and at all > >>         > oracle10 cases, I can't see that anything is created > >>         (tables, sequence, > >>         > indexes...) in JCR schema. Only IDM schema initialization is > >>         done. > >>         > > >>         > > > >>         > > On Wed, Mar 10, 2010 at 8:41 PM, Michal Vančo > >>         <mvanco(a)redhat.com&gt; > >>         > > wrote: > >>         > >         Hi, > >>         > > > >>         > >         currently I have same results as before (table or > >>         view does > >>         > >         not exist) > >>         > >         on oracle10 in these conditions: > >>         > >          - 2 datasources on one machine (differentiated by > >>         user names) > >>         > >          - 1 datasource on a machine (JCR and IDM > >>         together) > >>         > >          - 2 datasources on separate machines > >>         > > >>         > It was added for these cases ^. > >>         > > >>         > > > >>         > >         To run GateIn trunk on Oracle10, I do following > >>         steps: > >>         > >          - prepare GateIn trunk bundle > >>         > >          - unzip bundle > >>         > >          - change driver class, url, user and password in > >>         > >         jcr-configuration.xml > >>         > > > >>         in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/ > >>         > >          - change driver class, url, user and password in > >>         > >         idm-configuration.xml > >>         > > > >>         in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/organization/ > >>         > >          - add <property name="hibernate.hbm2ddl.auto" > >>         > >         value="create-drop"/> in > >>         > >         idm-configuration.xml > >>         > >          - copy oracle10 jdbc driver > >>         into ../server/default/lib > >>         > >          - start gatein by run.sh in bin folder > >>         > > > >>         > >         (I can provide a script from hudson where you can > >>         add your own > >>         > >         paths and > >>         > >         credentials...) > >>         > > > >>         > >         For oracle11: > >>         > >          - when run with same config as on oracle10, I get > >>         error: > >>         > >         ORA-00972: identifier is too long (when > >>         initializing > >>         > > > >>         org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) > >>         > > > >>         > >          - oracle11_jcr.jpg - screen of what has been > >>         created in DB > >>         > > > >>         > >          - if I edit table names > >>         > > > >>         in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/repository-configuration.xml, gatein started correctly > >>         > >         - oracle11_jcr_shorten_names.jpg - screen of what > >>         has been > >>         > >         created in DB > >>         > > > >>         > >         Let me know if you need more details to reproduce > >>         it on your > >>         > >         side. > >>         > > > >>         > >         Best regards, > >>         > > > >>         > >         Michal > >>         > > > >>         > > > >>         > >         Nicolas Filotto píše v St 10. 03. 2010 v 17:39 > >>         +0100: > >>         > > > >>         > >         > > >>         > >         > > >>         > >         > On Wed, Mar 10, 2010 at 5:19 PM, Prabhat Jha > >>         > >         <pjha(a)redhat.com&gt; wrote: > >>         > >         >         I have created > >>         > >         https://jira.jboss.org/jira/browse/EXOJCR-582 > >>         > >         >         for oracle11 issue. Please check that I > >>         have right > >>         > >         affects and > >>         > >         >         fix versions. > >>         > >         > > >>         > >         > thx, FYI I've just set the right settings > >>         > >         > > >>         > >         >         The version of GateIn and JCR is the one > >>         that's in > >>         > >         GateIn > >>         > >         >         trunk currently. The way our environment > >>         is setup is > >>         > >         that we > >>         > >         >         have one Oracle10 DB servers and > >>         different usernames > >>         > >         which I > >>         > >         >         believe means different schemas in > >>         Oracle for > >>         > >         different tests > >>         > >         >         (gatein-ui, gatein-jcr etc) configured > >>         on that > >>         > >         server. I would > >>         > >         >         have to wait for Michal to show up for > >>         info. He > >>         > >         needed to > >>         > >         >         attend to some personal stuff : hospital > >>         to check on > >>         > >         his mom. > >>         > >         > > >>         > >         >         But in your environment, you have GateIn > >>         starting > >>         > >         fine on > >>         > >         >         Oracle 10, right? > >>         > >         > > >>         > >         > no so far, we have only tested with pure JCR but > >>         in the same > >>         > >         > conditions as gatein, now as we know the version > >>         of gatein > >>         > >         we will try > >>         > >         > with the same version (i.e the trunk) > >>         > >         > > >>         > >         >         thanks, > >>         > >         >         prabhat > >>         > >         > > >>         > >         > > >>         > >         > > >>         > >         > > >>         > >         >         ----- "Nicolas Filotto" > >>         <nicolas.filotto(a)gmail.com&gt; > >>         > >         wrote: > >>         > >         >         > Prabhat and/or Michal, could you > >>         please provide > >>         > >         the answers > >>         > >         >         of the questions asked by Peter and me. > >>         We cannot > >>         > >         reproduce so > >>         > >         >         far, so we need your help. Please note > >>         that we > >>         > >         blocked the > >>         > >         >         release of GA because of this last > >>         issue, so we need > >>         > >         your help > >>         > >         >         to fix it asap. > >>         > >         >         > > >>         > >         >         > > >>         > >         >         Thank you in advance, > >>         > >         >         BR, > >>         > >         >         Nicolas > >>         > >         >         > > >>         > >         >         > On Wed, Mar 10, 2010 at 3:02 PM, > >>         Nicolas Filotto > >>         > >         >         <nicolas.filotto(a)gmail.com&gt; wrote: > >>         > >         >         > > >>         > >         >                 Hi Prabhat, > >>         > >         >                 > > >>         > >         >                 > > >>         > >         >                 my comments inline > >>         > >         >                 > > >>         > >         >                 > > >>         > >         >                 > On Wed, Mar 10, 2010 at 2:01 > >>         PM, Prabhat > >>         > >         Jha > >>         > >         >                 <pjha(a)redhat.com&gt; wrote: > >>         > >         >                 > > >>         > >         >                 > > >>         > >         >                         > Hi Nicolas, > >>         > >         >                         > > >>         > >         >                         > Yes, a jira is on the > >>         way but way > >>         > >         to > >>         > >         >                         reproduce this problem > >>         is quite > >>         > >         simple. You > >>         > >         >                         start with a clean > >>         Oracle 10 > >>         > >         database instance > >>         > >         >                         and see the problem > >>         during startup. > >>         > >         It would > >>         > >         >                         make sense to have this > >>         issue solved > >>         > >         or have a > >>         > >         >                         work around before > >>         GateIn GA. > >>         > >         >                         > > >>         > >         >                 It is not enough, we need to > >>         know, which > >>         > >         exact version > >>         > >         >                 of eXo JCR and GateIn, you are > >>         using and the > >>         > >         content > >>         > >         >                 of the files that you modified. > >>         > >         >                 could you please open a > >>         connexion with the > >>         > >         same > >>         > >         >                 account and give us the list of > >>         tables that > >>         > >         you can > >>         > >         >                 see > >>         > >         >                 > > >>         > >         >                         > > >>         > >         >                         > Quick questions: > >>         > >         >                         >  As per oracle11 > >>         finding, is JCR > >>         > >         config > >>         > >         >                         (table names) going to > >>         be updated > >>         > >         across the > >>         > >         >                         board? > >>         > >         >                         > > >>         > >         >                  You mean to change the sql > >>         scripts for > >>         > >         oracle 11G? If > >>         > >         >                 so please create a JIRA, it will > >>         be done in > >>         > >         the next > >>         > >         >                 maintenance version of eXo JCR > >>         which will be > >>         > >         1.12.1 GA > >>         > >         >                 planned for the end of March > >>         > >         >                 > > >>         > >         >                         > Also, I am wondiering > >>         given that > >>         > >         Oracle 10 > >>         > >         >                         has been around for a > >>         while, I am > >>         > >         wondering > >>         > >         >                         what has changed in the > >>         latest JCR > >>         > >         that it > >>         > >         >                         does not work here. Did > >>         the last GA > >>         > >         version > >>         > >         >                         work? > >>         > >         >                         > > >>         > >         >                 Hard to say before reproducing > >>         your bug > >>         > >         > > >>         > >         >                 > > >>         > >         >                         > > >>         > >         >                         > Thanks, > >>         > >         >                         > Prabhat > >>         > >         > > >>         > >         > > >>         > >         >                         > > >>         > >         >                         > > >>         > >         >                         > > >>         > >         >                         > ----- "Nicolas > >>         Filotto" > >>         > >         > > >>         <nicolas.filotto(a)gmail.com&gt; wrote: > >>         > >         >                         > > Hi Michal, could you > >>         please > >>         > >         create JIRA > >>         > >         >                         issues in the eXo JCR > >>         project > >>         > >         > > >>         > >         (https://jira.jboss.org/jira/browse/EXOJCR) > >>         > >         >                         with all the information > >>         needed to > >>         > >         allow us to > >>         > >         >                         reproduce? > >>         > >         >                         > > > >>         > >         >                         > > > >>         > >         >                         > > On Wed, Mar 10, 2010 > >>         at 1:46 PM, > >>         > >         Nicolas > >>         > >         >                         Filotto > >>         <nicolas.filotto(a)gmail.com&gt; > >>         > >         wrote: > >>         > >         >                         > > > >>         > >         > > >>         > >         >                                 > > > >>         > >         >                                 > > > >>         > >         >                                 > > > >>         > >         >                                 > On Wed, Mar > >>         10, 2010 at > >>         > >         1:29 PM, > >>         > >         >                                 Michal Vančo > >>         > >         <mvanco(a)redhat.com&gt; > >>         > >         >                                 wrote: > >>         > >         >                                 > > > >>         > >         >                                         Hi, > >>         > >         >                                         > > > >>         > >         >                                         > > > >>         oracle11 now > >>         > >         works, > >>         > >         >                                         oracle10 > >>         not. See > >>         > >         below... > >>         > >         >                                         > > > >>         > >         >                                         > > > >>         Peter Nedonosko > >>         > >         wrote > >>         > >         >                                         > > > >>         > >         >                                         > Hi, > >>         > >         >                                         > > > > >>         > >         >                                         > > > > >>         about Oracle > >>         > >         10 and ' > >>         > >         >                                         table or > >>         view does > >>         > >         not exist': > >>         > >         >                                         > > > > >>         the problem is > >>         > >         possible > >>         > >         >                                         if > >>         addConfig used in > >>         > >         >                                         > > > > >>         > >         > > >>         > > > >>         org.exoplatform.services.jcr.config.RepositoryServiceConfiguration > >>         > >         >                                         > > > (I > >>         found it in > >>         > >         portal > >>         > >         >                                         \trunk > >>         \examples > >>         > >         \portal\war\src > >>         > >         >                                         \main > >>         \webapp\WEB-INF > >>         > >         \conf > >>         > >         > > >>         \sample-portal\jcr > >>         > >         > > >>         > >         \jcr-configuration.xml) > >>         > >         >                                         > > > >>         > >         >                                         > > > >>         > >         >                                         What you > >>         meant with > >>         > >         addConfig > >>         > >         >                                         plugin? > >>         > >         >                                         > > > >>         Should I add > >>         > >         > > >>         > >         <set-method>addConfig</set-method> in > >>         > >         >                                         > > > >>         > >         jcr-configuration.xml? > >>         > >         >                                         > > Or > >>         how can I > >>         > >         solve 'table > >>         > >         >                                         or view > >>         does not > >>         > >         exist' on > >>         > >         > > >>         oracle10? > >>         > >         >                                         > > > >>         > >         > > >>         > >         >                                 > > > >>         > >         >                                 I guess it is > >>         not related > >>         > >         since it > >>         > >         >                                 works with other > >>         databases > >>         > >         > > >>         > >         >                                 > > >>         > >         > > >>         > >         >                                         > > > > >>         > >         >                                         > > > if > >>         the > >>         > >         database is > >>         > >         >                                         creating > >>         from the > >>         > >         scratch and > >>         > >         >                                         if the > >>         configuration > >>         > >         >                                         > > > > >>         persister got > >>         > >         an answer > >>         > >         >                                         from the > >>         Oracle - > >>         > >         your table > >>         > >         >                                         exists > >>         in > >>         > >         >                                         > > > > >>         > >         isDbInitialized(): > >>         > >         >                                         > > > > >>         ResultSet trs > >>         > >         = > >>         > >         > > >>         > >         con.getMetaData().getTables(null, null, > >>         configTableName, > >>         > >         null); > >>         > >         >                                         > > > > >>         return > >>         > >         trs.next(); // > >>         > >         >                                         true = > >>         yes > >>         > >         >                                         > > > > >>         > >         >                                         > > > > >>         but then > >>         > >         Oracle fails > >>         > >         >                                         with > >>         > >         >                                         > > > > >>         > >         PreparedStatement ps = > >>         > >         > > >>         > >         con.prepareStatement("SELECT > >>         > >         >                                         COUNT(*) > >>         FROM " + > >>         > >         >                                         > > > > >>         > >         configTableName + " > >>         > >         >                                         WHERE > >>         NAME=?"); > >>         > >         >                                         > > > > >>         > >         ps.executeQuery(); // > >>         > >         >                                         here > >>         > >         >                                         > > > > >>         > >         >                                         > > > > >>         but I have to > >>         > >         reproduce > >>         > >         >                                         it > >>         first... > >>         > >         >                                         > > > > >>         does Oracle 10 > >>         > >         and 11 > >>         > >         >                                         runs on > >>         clean > >>         > >         database from > >>         > >         >                                         the > >>         start? > >>         > >         >                                         > > > or > >>         just > >>         > >         restarted on > >>         > >         >                                         existing > >>         db for > >>         > >         Oracle 11? > >>         > >         >                                         > > > >>         > >         >                                         > > > >>         > >         >                                         Always > >>         on clean DBs. > >>         > >         >                                         > > > >>         > >         > > >>         > >         >                                         > > > > >>         > >         >                                         > > > > >>         about > >>         > >         Oracle11: > >>         > >         >                                         > > > > >>         seems it's > >>         > >         related to > >>         > >         > > >>         JBossCache loader, > >>         > >         it creates > >>         > >         >                                         a table > >>         longer of > >>         > >         >                                         > > > 30 > >>         symbols > >>         > >         (ORA-00972: > >>         > >         > > >>         identifier is too > >>         > >         long). > >>         > >         >                                         > > > > >>         Why it's not a > >>         > >         problem > >>         > >         >                                         for > >>         Oracle10 or why > >>         > >         JBossCache > >>         > >         >                                         acts in > >>         > >         >                                         > > > > >>         different way > >>         > >         on > >>         > >         >                                         Oracle10 > >>         or etc... > >>         > >         >                                         > > > > >>         try to fix the > >>         > >         problem > >>         > >         >                                         with > >>         shorten table > >>         > >         name from > >>         > >         > > >>         > >         repository-configuration.xml > >>         > >         >                                         > > > > >>         e.g. > >>         > >         >                                         > > > > >>         <property > >>         > >         > > >>         > >         name="jbosscache-cl-cache.jdbc.table.name" > >>         > >         value="lock_portalsys" /> > >>         > >         >                                         > > > > >>         instead of > >>         > >         >                                         > > > > >>         <property > >>         > >         > > >>         > >         name="jbosscache-cl-cache.jdbc.table.name" > >>         > >         >                                         > > > > >>         > >         > > >>         > >         value="jcrlock_portal_system" /> > >>         > >         >                                         > > > it > >>         should > >>         > >         helps. > >>         > >         >                                         > > > >>         > >         >                                         > > > >>         > >         >                                         I > >>         shortened all > >>         > >         table names in > >>         > >         > > >>         > >         repository-configuration.xml > >>         > >         >                                         and > >>         GateIn > >>         > >         >                                         > > on > >>         Oracle11 > >>         > >         started > >>         > >         >                                         without > >>         "identifier > >>         > >         is too > >>         > >         >                                         long" > >>         error. > >>         > >         >                                         > > > >>         > >         >                                         > > > >>         There is job > >>         > >         when it > >>         > >         >                                         starts > >>         for the first > >>         > >         time: > >>         > >         >                                         > > > >>         > >         > > >>         > > > >>         http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > >>         > >         >                                         > > > >>         > >         >                                         > > I > >>         think that it > >>         > >         would be > >>         > >         >                                         better > >>         to edit > >>         > >         configuration, > >>         > >         >                                         because > >>         editing > >>         > >         >                                         > > > >>         table names > >>         > >         before running > >>         > >         >                                         gatein > >>         isn't a good > >>         > >         way. > >>         > >         >                                         > > > >>         > >         > > >>         > >         > > >>         > >         >                                         > > > > >>         > >         >                                         > > > > >>         Regards, > >>         > >         >                                         > > > > >>         Peter > >>         > >         >                                         > > > > >>         > >         >                                         > > > > >>         > >         >                                         > > > On > >>         Tue, Mar 9, > >>         > >         2010 at > >>         > >         >                                         11:24 > >>         AM, Michal > >>         > >         Vančo > >>         > >         > > >>         <mvanco(a)redhat.com&gt; > >>         > >         wrote: > >>         > >         >                                         > > > > > >>         Yes Bolek, > >>         > >         that's > >>         > >         >                                         true. > >>         > >         >                                         > > > > > >>         I can't > >>         > >         explain myself > >>         > >         >                                         the job > >>         in hudson on > >>         > >         EPP5 > >>         > >         > > >>         > >         (epp_ui_selenium_tests_oracle10): > >>         > >         >                                         > > > > > >>         Because > >>         > >         there was same > >>         > >         >                                         problem > >>         - table or > >>         > >         view does > >>         > >         >                                         not > >>         exist (build > >>         > >         >                                         > > > > > >>         #3), builds > >>         > >         #5 and #7 > >>         > >         >                                         were OK > >>         (GateIn > >>         > >         started with > >>         > >         >                                         no > >>         errors) and > >>         > >         >                                         > > > > > >>         following > >>         > >         builds again > >>         > >         >                                         failed > >>         due the same > >>         > >         problem as > >>         > >         >                                         before. > >>         > >         >                                         > > > > > >>         > >         >                                         > > > > > >>         Regards, > >>         > >         >                                         > > > > > >>         Michal > >>         > >         >                                         > > > > > >>         > >         >                                         > > > > > >>         Boleslaw > >>         > >         Dawidowicz > >>         > >         >                                         píše v > >>         Út 09. 03. > >>         > >         2010 v 09:59 > >>         > >         >                                         +0100: > >>         > >         >                                         > > > >> > >>         From > >>         > >         mentioned logs > >>         > >         >                                         it looks > >>         like those > >>         > >         errors > >>         > >         >                                         don't > >>         come from IDM. > >>         > >         I > >>         > >         >                                         > > > >> > >>         think the > >>         > >         stack trace > >>         > >         >                                         in all > >>         cases goes > >>         > >         via > >>         > >         >                                         > > > >> > >>         > >         > > >>         > >         "org.exoplatform.services.jcr.impl.*" > >>         > >         >                                         > > > >> > >>         > >         >                                         > > > >> > >>         Bolek > >>         > >         >                                         > > > >> > >>         > >         >                                         > > > >> > >>         On > >>         > >         03/09/2010 09:15 > >>         > >         >                                         AM, > >>         Michal Vančo > >>         > >         wrote: > >>         > >         >                                         > > > >> > >>         > Hi, > >>         > >         >                                         > > > >> > >>         > > >>         > >         >                                         > > > >> > >>         > I'm > >>         > >         dealing with > >>         > >         >                                         problem > >>         to start > >>         > >         GateIn with > >>         > >         >                                         Oracle > >>         DB. > >>         > >         >                                         > > > >> > >>         > I always > >>         > >         start with > >>         > >         >                                         clean DB > >>         and use 2 > >>         > >         datasource > >>         > >         > > >>         instances (JCR, > >>         > >         IDM). > >>         > >         >                                         > > > >> > >>         > > >>         > >         >                                         > > > >> > >>         > There are > >>         > >         2 > >>         > >         > > >>         different issues: > >>         > >         >                                         > > > >> > >>         > Oracle10: > >>         > >         >                                         > > > >> > >>         > - > >>         > >         ORA-00942: table > >>         > >         >                                         or view > >>         does not > >>         > >         exist (start > >>         > >         >                                         on > >>         > >         >                                         > > > >> > >>         > > >>         > >         > > >>         > > > >>         org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@b2ecc0) > >>         > >         >                                         > > > >> > >>         > - only > >>         > >         IDM schema > >>         > >         >                                         is > >>         initialized, JCR > >>         > >         not > >>         > >         >                                         > > > >> > >>         > > >>         > >         >                                         > > > >> > >>         > Oracle11: > >>         > >         >                                         > > > >> > >>         > - > >>         > >         ORA-00972: > >>         > >         > > >>         identifier is too > >>         > >         long (Cannot > >>         > >         > > >>         instantiate > >>         > >         component class > >>         > >         >                                         > > > >> > >>         > > >>         > >         > > >>         > > > >>         org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl) > >>         > >         >                                         > > > >> > >>         > - both > >>         > >         schemas are > >>         > >         >                                         created > >>         (IDM + JCR) > >>         > >         >                                         > > > >> > >>         > > >>         > >         >                                         > > > >> > >>         > To run on > >>         > >         oracle, I > >>         > >         >                                         change > >>         configuration > >>         > >         in > >>         > >         > > >>         > >         idm-configuration.xml and > >>         > >         >                                         > > > >> > >>         > > >>         > >         > > >>         > >         jcr-configuration.xml, then > >>         > >         >                                         copy > >>         jdbc driver and > >>         > >         start. > >>         > >         >                                         > > > >> > >>         > I also > >>         > >         add<property > >>         > >         > > >>         > >         name="hibernate.hbm2ddl.auto" > >>         > >         > > >>         > >         value="create-drop"/> > >>         > >         >                                         > > > >> > >>         > to > >>         > >         > > >>         > >         idm-configuration.xml > >>         > >         > > >>         (recommended by > >>         > >         Boleslaw > >>         > >         > > >>         Dawidowicz - it > >>         > >         worked > >>         > >         >                                         > > > >> > >>         > on EPP, > >>         > >         but not on > >>         > >         >                                         GateIn > >>         trunk). > >>         > >         >                                         > > > >> > >>         > > >>         > >         >                                         > > > >> > >>         > There are > >>         > >         links to > >>         > >         >                                         log: > >>         > >         >                                         > > > >> > >>         > > >>         > >         > > >>         > > > >>         http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > >>         > >         >                                         > > > >> > >>         > > >>         > >         >                                         > > > >> > >>         > > >>         > >         > > >>         > > > >>         http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5... > >>         > >         >                                         > > > >> > >>         > > >>         > >         >                                         > > > >> > >>         > > >>         > >         >                                         > > > >> > >>         > I would > >>         > >         appreciate > >>         > >         >                                         any > >>         help. > >>         > >         >                                         > > > >> > >>         > > >>         > >         >                                         > > > >> > >>         > Thanks in > >>         > >         advance > >>         > >         >                                         > > > >> > >>         > Michal > >>         > >         Vanco > >>         > >         >                                         > > > >> > >>         > > >>         > >         >                                         > > > >> > >>         > > >>         > >         > > >>         > >         _______________________________________________ > >>         > >         >                                         > > > >> > >>         > > >>         > >         gatein-dev mailing > >>         > >         >                                         list > >>         > >         >                                         > > > >> > >>         > > >>         > >         > > >>         > >         gatein-dev(a)lists.jboss.org > >>         > >         >                                         > > > >> > >>         > > >>         > >         > > >>         > > > >>         https://lists.jboss.org/mailman/listinfo/gatein-dev > >>         > >         >                                         > > > > > >>         > >         >                                         > > > > > >>         > >         >                                         > > > > > >>         > >         > > >>         > >         _______________________________________________ > >>         > >         >                                         > > > > > >>         gatein-dev > >>         > >         mailing > >>         > >         >                                         list > >>         > >         >                                         > > > > > >>         > >         > > >>         > >         gatein-dev(a)lists.jboss.org > >>         > >         >                                         > > > > > >>         > >         > > >>         > > > >>         https://lists.jboss.org/mailman/listinfo/gatein-dev > >>         > >         >                                         > > > > > >>         > >         >                                         > > > >>         > >         >                                         > > > >>         > >         >                                         > > > >>         > >         >                                         Thanks, > >>         > >         >                                         > > > >>         Michal > >>         > >         >                                         > > > >>         > >         > > >>         > >         > > >>         > >         >                                         > > > >>         > >         > > >>         > >         _______________________________________________ > >>         > >         >                                         > > > >>         gatein-dev > >>         > >         mailing list > >>         > >         >                                         > > > >>         > >         gatein-dev(a)lists.jboss.org > >>         > >         >                                         > > > >>         > >         > > >>         > > > >>         https://lists.jboss.org/mailman/listinfo/gatein-dev > >>         > >         >                                         > > > >>         > >         > > >>         > >         >                                 > > > >>         > >         > > >>         > >         >                                 > > -- > >>         > >         >                                 > > > >>         > >         > > >>         > >         >                                 > Nicolas > >>         Filotto > >>         > >         >                                 > > JCR Product > >>         Manager > >>         > >         >                                 > > Project > >>         Manager > >>         > >         >                                 > > eXo Platform > >>         SAS > >>         > >         >                                 > > > >>         > >         nicolas.filotto(a)exoplatform.com > >>         > >         >                                 > > +33 (0)6 31 > >>         32 92 19 > >>         > >         >                                 > > > >>         > >         > > >>         > >         >                         > > > >>         > >         > > >>         > >         >                         > > -- > >>         > >         >                         > > Nicolas Filotto > >>         > >         >                         > > JCR Product Manager > >>         > >         >                         > > Project Manager > >>         > >         >                         > > eXo Platform SAS > >>         > >         >                         > > > >>         nicolas.filotto(a)exoplatform.com > >>         > >         >                         > > +33 (0)6 31 32 92 19 > >>         > >         >                         > > > >>         > >         >                         > > >>         > >         >                         > > >>         > >         > > >>         > >         _______________________________________________ > >>         gatein-dev > >>         > >         mailing list gatein-dev(a)lists.jboss.org > >>         > > > >>         https://lists.jboss.org/mailman/listinfo/gatein-dev > >>         > >         > > >>         > >         >                 > > >>         > >         >                 > > >>         > >         > > >>         > >         >                 > -- > >>         > >         >                 > Nicolas Filotto > >>         > >         >                 > JCR Product Manager > >>         > >         >                 > Project Manager > >>         > >         >                 > eXo Platform SAS > >>         > >         >                 > > >>         nicolas.filotto(a)exoplatform.com > >>         > >         >                 > +33 (0)6 31 32 92 19 > >>         > >         >                 > > >>         > >         > > >>         > >         >         > > >>         > >         > > >>         > >         >         > -- > >>         > >         >         > Nicolas Filotto > >>         > >         >         > JCR Product Manager > >>         > >         >         > Project Manager > >>         > >         >         > eXo Platform SAS > >>         > >         >         > nicolas.filotto(a)exoplatform.com > >>         > >         >         > +33 (0)6 31 32 92 19 > >>         > >         >         > > >>         > >         > > >>         > >         > > >>         > >         > > >>         > >         > -- > >>         > >         > Nicolas Filotto > >>         > >         > JCR Product Manager > >>         > >         > Project Manager > >>         > >         > eXo Platform SAS > >>         > >         > nicolas.filotto(a)exoplatform.com > >>         > >         > +33 (0)6 31 32 92 19 > >>         > > > >>         > > > >>         > > > >>         > > > >>         > > > >>         > > -- > >>         > > Nicolas Filotto > >>         > > JCR Product Manager > >>         > > Project Manager > >>         > > eXo Platform SAS > >>         > > nicolas.filotto(a)exoplatform.com > >>         > > +33 (0)6 31 32 92 19 > >>         > > >>         > Michal > >>         > > >>         > _______________________________________________ > >>         > gatein-dev mailing list > >>         > gatein-dev(a)lists.jboss.org > >>         > https://lists.jboss.org/mailman/listinfo/gatein-dev > >> > >> > >> > >> > >> > >> > >> -- > >> Nicolas Filotto > >> JCR Product Manager > >> Project Manager > >> eXo Platform SAS > >> nicolas.filotto(a)exoplatform.com > >> +33 (0)6 31 32 92 19 > >> > >