[gatein-dev] GateIn on oracle DB
Prabhat Jha
pjha at redhat.com
Wed Mar 10 18:56:20 EST 2010
Michal,
Please fire up all ui-db tests with GateIn trunk.
thanks,
prabhat
----- "Thomas Heute" <theute at redhat.com> wrote:
> As far as I understood the unique issue with Oracle 11 was about too
> long names, in fact we had a table name of 29 characters and it looks
> like JBossCache create another table suffixed with _D, so we had a
> table
> name of 31 characters while Oracle limits its table names to 30 chars.
>
> I reduced the problematic table name by 1 char and it should work out
> of
> the box now (I couldn't test I don't have any Oracle DB installed)
> https://jira.jboss.org/jira/browse/GTNPORTAL-862
>
>
>
> 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
> >
>
> _______________________________________________
> 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