[gatein-dev] GateIn on oracle DB
Peter Nedonosko
pnedonosko at gmail.com
Thu Mar 11 17:46:56 EST 2010
On Thu, Mar 11, 2010 at 9:57 PM, Michal Vančo <mvanco at redhat.com> wrote:
> Hi,
>
> Peter Nedonosko wrote:
>> On Thu, Mar 11, 2010 at 1:35 PM, Michal Vančo <mvanco at redhat.com> wrote:
>> > Nicolas Filotto wrote:
>> >>
>> >>
>> >> On Thu, Mar 11, 2010 at 9:57 AM, Michal Vančo <mvanco at redhat.com>
>> >> wrote:
>> >> Hi,
>> >>
>> >> today I checked following situations with oracle10:
>> >> - oracle11 driver for oracle10 db
>> >> - create bundle with JCR 1.12.0-GA
>> >> - delete gatein-sample* in server/default/deploy -> only
>> >> change was
>> >> that it failed with: Cannot create the portal container
>> >> 'portal', before
>> >> it was: Cannot create the portal container 'sample-portal' and
>> >> Cannot
>> >> create the portal container 'portal'
>> >> - creating jcr tables manually with script:
>> >> http://anonsvn.jboss.org/repos/exo-jcr/jcr/tags/1.12.0-GA/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.ora.sql
>> >>
>> >> didn't help, but after adding script to create JCR_CONFIG
>> >> table -> it
>> >> started to work (detail of script in another mail on
>> >> gatein-dev)
>> >>
>> >> So, looks like JCR don't want to initialize. Any suggestions
>> >> why?
>> >> So far the only thing that we know is that
>> >> con.getMetaData().getTables(null, null, "JCR_CONFIG", null); returns a
>> >> result, so the JCR assumes that the table exists and thus try to
>> >> launch a query on it so it fails since actually the table doesn't
>> >> exist.
>> >> So far, we don't know why this method returns something on your side,
>> >> can you add a breakpoint on the method
>> >> org.exoplatform.services.jcr.impl.config.JDBCConfigurationPersister.isDbInitialized() of the project exo.jcr.component.core and tell us what you have in your resultset?
>> >
>> >
>> > when calling
>> > ResultSet trs = con.getMetaData().getTables(null, null, "JCR_CONFIG", null);
>> > return trs.next();
>> >
>> > it returns true and content of trs variable from debug is attached.
>> >
>> > Then it ends on line 237: ResultSet res = ps.executeQuery();
>> >
>> > Is it enough? Or what more can I explore in debug?
>>
>> con.getMetaData().getTables(null, null, "JCR_CONFIG", null);
>> is wrong on oracle at all,
>> as the call returns all JCR_CONFIG tables in the Oracle instance (crazy for me)
>> but here I have several databases with different tablespaces and I see
>> all of them within user who should not see ones.
>>
>> Nicolas, it will be like if several databases contains JCR_CONFIG table:
>> null EXOCLUSTER1 JCR_CONFIG
>> null EXOCLUSTER2 JCR_CONFIG
>> null JCRDB JCR_CONFIG
>> ....
>>
>> FYI, I have applied your script and yes - it reproduces the issue
>> but I still guess it's DBA side work to provide the rights to users
>> from one schema.
>>
>> After I replaced
>> con.getMetaData().getTables(null, null, "JCR_CONFIG", null);
>> with
>> try {
>> ResultSet tprs = con.createStatement().executeQuery("SELECT COUNT(*)
>> FROM " + tableName);
>> return tprs.next();
>> catch (SQLException e)
>> {
>> return false;
>> }
>
> I checked this:
> - get gatein trunk sources (1.12.0-GA is already set there)
> - get jcr 1.12.0-GA sources -> edit isDbInitialized method to:
> ResultSet tprs = con.createStatement().executeQuery("SELECT COUNT(*)
> FROM " + configTableName);
> - install jcr in local repo
> - build gatein bundle with local 1.12.0-GA jcr
> - run gatein on clean oracle DB
> - JCR SCHEMA IS INITIALIZED!
>
> But when initializing data, I get this error:
> org.exoplatform.services.jcr.impl.storage.JCRInvalidItemStateException:
> [system] ADD PROPERTY. Error of item add.
> []:1[http://www.jcp.org/jcr/1.0]primaryType:1, ID:
> 4eb6816b0a10590b017c461130360076, ParentID:
> 00exo0jcr0root0uuid0000000000000. Cause >>>> ORA-01400: cannot insert
> NULL into ("EPP5UIDB"."JCR_SVALUE"."ID")
this is an usecase described by eXo support in
http://jira.exoplatform.org/browse/JCR-1333 (see above)
don't change any method in eXoJCR 1.12.0-GA,
change Oracle user rights as I have proposed in the previous mail.
BR
Peter
>
> If I look at JCR_SVALUE table with sqldeveloper, I can see that ID
> column has nullable - no, it means that null values aren't allowed. Is
> it problem at initialization of DB?
>
> There is full log for more details:
> http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5_oracle10/40/console - it should be published on this url soon (from internal hudson)
>
> Hope that info helps ;)
>
> Regards,
> Michal
>
>>
>> this part works well but next thing you'll meet will be
>> http://jira.exoplatform.org/browse/JCR-1333
>>
>> so it's still DBA task IMO.
>>
>>
>> >
>> >>
>> >> Michal
>> >>
>> >>
>> >> Michal Vančo wrote:
>> >> > Hi,
>> >> >
>> >> > Nicolas Filotto wrote:
>> >> > > Could you please provide the list of tables that you can
>> >> see with your
>> >> > > credentials on oracle 10 G?
>> >> >
>> >> > As I wrote yesterday in my additional reply:
>> >> > I'm using sqldeveloper tool to see the content of oracle DB,
>> >> and at all
>> >> > oracle10 cases, I can't see that anything is created
>> >> (tables, sequence,
>> >> > indexes...) in JCR schema. Only IDM schema initialization is
>> >> done.
>> >> >
>> >> > >
>> >> > > On Wed, Mar 10, 2010 at 8:41 PM, Michal Vančo
>> >> <mvanco at redhat.com>
>> >> > > 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
>> >> >
>> >> > It was added for these cases ^.
>> >> >
>> >> > >
>> >> > > 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
>> >> > >
>> >> > >
>> >> > >
>> >> > >
>> >> > >
>> >> > > --
>> >> > > Nicolas Filotto
>> >> > > JCR Product Manager
>> >> > > Project Manager
>> >> > > eXo Platform SAS
>> >> > > nicolas.filotto at exoplatform.com
>> >> > > +33 (0)6 31 32 92 19
>> >> >
>> >> > 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
>> >>
>> >
>
>
>
More information about the gatein-dev
mailing list