Re: [gatein-dev] GateIn on oracle DB

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, 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 > 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