[gatein-dev] GateIn on oracle DB
Michal Vančo
mvanco at redhat.com
Wed Mar 10 15:38:39 EST 2010
Hi Thomas,
I'm using JCR which is now in GateIn trunk (there is 1.12.0-CR2), I
didn't update anything in that bundle.
Michal
Thomas Heute píše v St 10. 03. 2010 v 21:31 +0100:
> Michal,
>
> It's still not clear if you updated JCR to 1.12.0.GA or if you are still
> running with CR2
>
> Thomas.
>
>
> On 03/10/2010 09:15 PM, Michal Vančo wrote:
> > Michal Vančo wrote:
> >
> >> Hi,
> >>
> >> currently I have same results as before (table or view does not exist)
> >> on oracle10 in these conditions:
> >> - 2 datasources on one machine (differentiated by user names)
> >> - 1 datasource on a machine (JCR and IDM together)
> >> - 2 datasources on separate machines
> >>
> > Only for completeness:
> > I'm using sqldeveloper tool to see the content of oracle DB, and at all
> > above cases, I can't see that anything is created (tables, sequence,
> > indexes...) in JCR schema. Only IDM schema initialization is done.
> >
> >> To run GateIn trunk on Oracle10, I do following steps:
> >> - prepare GateIn trunk bundle
> >> - unzip bundle
> >> - change driver class, url, user and password in jcr-configuration.xml
> >> in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/
> >> - change driver class, url, user and password in idm-configuration.xml
> >> in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/organization/
> >> - add<property name="hibernate.hbm2ddl.auto" value="create-drop"/> in
> >> idm-configuration.xml
> >> - copy oracle10 jdbc driver into ../server/default/lib
> >> - start gatein by run.sh in bin folder
> >>
> >> (I can provide a script from hudson where you can add your own paths and
> >> credentials...)
> >>
> >> For oracle11:
> >> - when run with same config as on oracle10, I get error:
> >> ORA-00972: identifier is too long (when initializing
> >> org.exoplatform.services.jcr.impl.core.lock.jbosscache.CacheableLockManagerImpl)
> >> - oracle11_jcr.jpg - screen of what has been created in DB
> >>
> >> - if I edit table names
> >> in ../server/default/deploy/gatein.ear/02portal.war/WEB-INF/conf/jcr/repository-configuration.xml, gatein started correctly
> >> - oracle11_jcr_shorten_names.jpg - screen of what has been created in DB
> >>
> >> Let me know if you need more details to reproduce it on your side.
> >>
> >> Best regards,
> >>
> >> Michal
> >>
> >>
> >> Nicolas Filotto píše v St 10. 03. 2010 v 17:39 +0100:
> >>
> >>>
> >>> On Wed, Mar 10, 2010 at 5:19 PM, Prabhat Jha<pjha at redhat.com> wrote:
> >>> I have created https://jira.jboss.org/jira/browse/EXOJCR-582
> >>> for oracle11 issue. Please check that I have right affects and
> >>> fix versions.
> >>>
> >>> thx, FYI I've just set the right settings
> >>>
> >>> The version of GateIn and JCR is the one that's in GateIn
> >>> trunk currently. The way our environment is setup is that we
> >>> have one Oracle10 DB servers and different usernames which I
> >>> believe means different schemas in Oracle for different tests
> >>> (gatein-ui, gatein-jcr etc) configured on that server. I would
> >>> have to wait for Michal to show up for info. He needed to
> >>> attend to some personal stuff : hospital to check on his mom.
> >>>
> >>> But in your environment, you have GateIn starting fine on
> >>> Oracle 10, right?
> >>>
> >>> no so far, we have only tested with pure JCR but in the same
> >>> conditions as gatein, now as we know the version of gatein we will try
> >>> with the same version (i.e the trunk)
> >>>
> >>> thanks,
> >>> prabhat
> >>>
> >>>
> >>>
> >>>
> >>> ----- "Nicolas Filotto"<nicolas.filotto at gmail.com> wrote:
> >>> > Prabhat and/or Michal, could you please provide the answers
> >>> of the questions asked by Peter and me. We cannot reproduce so
> >>> far, so we need your help. Please note that we blocked the
> >>> release of GA because of this last issue, so we need your help
> >>> to fix it asap.
> >>> >
> >>> >
> >>> Thank you in advance,
> >>> BR,
> >>> Nicolas
> >>> >
> >>> > On Wed, Mar 10, 2010 at 3:02 PM, Nicolas Filotto
> >>> <nicolas.filotto at gmail.com> wrote:
> >>> >
> >>> Hi Prabhat,
> >>> >
> >>> >
> >>> my comments inline
> >>> >
> >>> >
> >>> > On Wed, Mar 10, 2010 at 2: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.
> >>> >
> >>> 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
> >>>
> >>>
> >>> >
> >>> >
> >>> >
> >>> > ----- "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?
> >>> > >
> >>>
> >>> > >
> >>> 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
> >>>
> >>> >
> >>> >
> >>>
> >>> > --
> >>> > 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
> >>> >
> >>>
> >>>
> >>>
> >>> --
> >>> 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
> >
>
More information about the gatein-dev
mailing list