Hi Prabhat,
>
>my comments inline
>>> On Wed, Mar 10, 2010 at 2:01 PM, Prabhat Jha <pjha@redhat.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.
>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> _______________________________________________ gatein-dev mailing list gatein-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/gatein-dev
>
>
>
> ----- "Nicolas Filotto" <nicolas.filotto@gmail.com> 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@gmail.com> wrote:
> >
> >
> >> >> 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,What you meant with addConfig plugin?
> > >
> > > 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)
> >
> >
> > 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>Always on clean DBs.
> > >
> > > 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?
> >
> >
> >I shortened all table names in repository-configuration.xml and GateIn
> > >
> > > 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.
> >
> >
> > 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.
> >Thanks,
> > >
> > > 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
> > > >
> >
> >
> >
> > 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
> >
> >
> > --
> > Nicolas Filotto
> > JCR Product Manager
> > Project Manager
> > eXo Platform SAS
> > nicolas.filotto@exoplatform.com
> > +33 (0)6 31 32 92 19
> >
>>
>
> --
> Nicolas Filotto
> JCR Product Manager
> Project Manager
> eXo Platform SAS
> nicolas.filotto@exoplatform.com
> +33 (0)6 31 32 92 19
>