10:22 a.m.
trunk is not using JCR 1.12 GA you need to update that.
On 03/10/2010 05:19 PM, Prabhat Jha 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.
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?
thanks,
prabhat
----- "Nicolas Filotto" <nicolas.filotto(a)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(a)gmail.com <mailto:nicolas.filotto@gmail.com>> wrote:
>
Hi Prabhat,
>
>
my comments inline
>
>
> On Wed, Mar 10, 2010 at 2:01 PM, Prabhat Jha <pjha(a)redhat.com
<mailto:pjha@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(a)gmail.com
<mailto:nicolas.filotto@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(a)gmail.com <mailto:nicolas.filotto@gmail.com>>
wrote:
> >
> >
> >
> >
> On Wed, Mar 10, 2010 at 1:29 PM, Michal Vančo
<mvanco(a)redhat.com <mailto:mvanco@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
<http://jbosscache-cl-cache.jdbc.table.name>"
value="lock_portalsys" />
> > > instead of
> > > <property
name="jbosscache-cl-cache.jdbc.table.name
<http://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...
> >
> > 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(a)redhat.com <mailto:mvanco@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@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...
> > > >> >
> > > >> >
http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5...
> > > >> >
> > > >> >
> > > >> > I would appreciate any help.
> > > >> >
> > > >> > Thanks in advance
> > > >> > Michal Vanco
> > > >> >
> > > >> >
_______________________________________________
> > > >> > gatein-dev mailing list
> > > >> > gatein-dev(a)lists.jboss.org
<mailto:gatein-dev@lists.jboss.org>
> > > >> >
https://lists.jboss.org/mailman/listinfo/gatein-dev
> > > >
> > > >
> > > > _______________________________________________
> > > > gatein-dev mailing list
> > > > gatein-dev(a)lists.jboss.org
<mailto:gatein-dev@lists.jboss.org>
> > > >
https://lists.jboss.org/mailman/listinfo/gatein-dev
> > > >
> >
> >
> >
Thanks,
> > Michal
> >
> > _______________________________________________
> > gatein-dev mailing list
> > gatein-dev(a)lists.jboss.org
<mailto:gatein-dev@lists.jboss.org>
> > https://lists.jboss.org/mailman/listinfo/gatein-dev
> >
> >
> > --
> >
> Nicolas Filotto
> > JCR Product Manager
> > Project Manager
> > eXo Platform SAS
> > nicolas.filotto(a)exoplatform.com
<mailto:nicolas.filotto@exoplatform.com>
> > +33 (0)6 31 32 92 19
> >
> >
> > --
> > Nicolas Filotto
> > JCR Product Manager
> > Project Manager
> > eXo Platform SAS
> > nicolas.filotto(a)exoplatform.com
<mailto:nicolas.filotto@exoplatform.com>
> > +33 (0)6 31 32 92 19
> >
>
> _______________________________________________ gatein-dev
mailing list gatein-dev(a)lists.jboss.org
<mailto:gatein-dev@lists.jboss.org>
https://lists.jboss.org/mailman/listinfo/gatein-dev
>
>
> --
> Nicolas Filotto
> JCR Product Manager
> Project Manager
> eXo Platform SAS
> nicolas.filotto(a)exoplatform.com
<mailto:nicolas.filotto@exoplatform.com>
> +33 (0)6 31 32 92 19
>
>
> --
> Nicolas Filotto
> JCR Product Manager
> Project Manager
> eXo Platform SAS
> nicolas.filotto(a)exoplatform.com <mailto:nicolas.filotto@exoplatform.com>
> +33 (0)6 31 32 92 19
>
_______________________________________________
gatein-dev mailing list
gatein-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/gatein-dev