Re: [gatein-dev] GateIn on oracle DB

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