[gatein-dev] GateIn on oracle DB

[Prabhat Jha]

Hi Peter,

Michal will send you tablespace/database/schema/user/rights script that you have asked for. Please keep in mind that we need to interact with our IT folks for this info.

Regards,
Prabhat


----- "Peter Nedonosko" <pnedonosko at gmail.com> wrote:

> On Wed, Mar 10, 2010 at 3:01 PM, Prabhat Jha <pjha at 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.
> >
> > 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 at 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 at gmail.com> wrote:
> >>
> >>
> >> >
> >> >
> >> >
> >> > On Wed, Mar 10, 2010 at 1:29 PM, Michal Vančo <mvanco at 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?
> 
> the error is due to a use of addConfig plugin,
> and I just described the way how it occurs with thoughts what may
> happens inside.
> 
> why it's only a Oracle10 problem it's still not clear.
> as from the JCR logic all steps are valid and should works for the
> moment.
> 
> it will help if you'll send me your Oracle
> tablespace/database/schema/user/rights script,
> I'll be able to setup similar env on my side.
> 
> >>> >
> >>
> >> >
> >> 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 at 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 at 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 at lists.jboss.org
> >>> > > >> > https://lists.jboss.org/mailman/listinfo/gatein-dev
> >>> > > >
> >>> > > >
> >>> > > > _______________________________________________
> >>> > > > gatein-dev mailing list
> >>> > > > gatein-dev at lists.jboss.org
> >>> > > > https://lists.jboss.org/mailman/listinfo/gatein-dev
> >>> > > >
> >>> >
> >>> >
> >>> >
> >>> Thanks,
> >>> > Michal
> >>> >
> >>> > _______________________________________________
> >>> > gatein-dev mailing list
> >>> > gatein-dev at lists.jboss.org
> >>> > https://lists.jboss.org/mailman/listinfo/gatein-dev
> >>> >
> >>
> >> >
> >>
> >> > --
> >> >
> >> > Nicolas Filotto
> >> > JCR Product Manager
> >> > Project Manager
> >> > eXo Platform SAS
> >> > nicolas.filotto at exoplatform.com
> >> > +33 (0)6 31 32 92 19
> >> >
> >
> >>
> >
> >> --
> >> Nicolas Filotto
> >> JCR Product Manager
> >> Project Manager
> >> eXo Platform SAS
> >> nicolas.filotto at exoplatform.com
> >> +33 (0)6 31 32 92 19
> >>
> >> _______________________________________________ gatein-dev mailing
> list
> >> gatein-dev at lists.jboss.org
> >> https://lists.jboss.org/mailman/listinfo/gatein-dev
> > _______________________________________________
> > gatein-dev mailing list
> > gatein-dev at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/gatein-dev
> >
> >