[gatein-dev] GateIn on oracle DB

Nicolas Filotto nicolas.filotto at gmail.com
Thu Mar 11 06:47:19 EST 2010


On Thu, Mar 11, 2010 at 12:44 PM, Nicolas Filotto <nicolas.filotto at gmail.com
> wrote:

>
> On Thu, Mar 11, 2010 at 12: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?
>>
> yes can you give use the results of those methods call:
>            trs.getString("TABLE_CAT")
>            trs.getString("TABLE_SCHEM")
>            trs.getString("TABLE_NAME")
>            trs.getString("TABLE_TYPE")
>            trs.getString("REMARKS"));
>
This one is wrong
try
 trs.getString("TABLE_REMARKS") instead

>
>> >
>> >         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
>> >
>>
>
>
>
> --
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/gatein-dev/attachments/20100311/b843b179/attachment-0001.html 


More information about the gatein-dev mailing list