On Wed, Mar 10, 2010 at 1:29 PM, Michal Vančo <mvanco@redhat.com> 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_oracle11/35/

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@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_oracle10/22/console
> >> >
> >> > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5_oracle11/21/console
> >> >
> >> >
> >> > I would appreciate any help.
> >> >
> >> > Thanks in advance
> >> > Michal Vanco
> >> >
> >> > _______________________________________________
> >> > gatein-dev mailing list
> >> > gatein-dev@lists.jboss.org
> >> > https://lists.jboss.org/mailman/listinfo/gatein-dev
> >
> >
> > _______________________________________________
> > gatein-dev mailing list
> > gatein-dev@lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/gatein-dev
> >


Thanks,
Michal

_______________________________________________
gatein-dev mailing list
gatein-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/gatein-dev



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