4:33 a.m.
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)
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?
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.
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