1:36 a.m.
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(a)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(a)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(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> wrote:
> >
> Hi Prabhat,
> >
> >
> my comments inline
> >
> >
> > On Wed, Mar 10, 2010 at 2:01 PM, Prabhat
Jha
> <pjha(a)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> 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>
wrote:
> > >
>
> > >
> > >
> > >
> > On Wed, Mar 10, 2010 at
1:29 PM,
> Michal Vančo
<mvanco(a)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...
> > >
> > > 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>
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
> > > > >> >
>
https://lists.jboss.org/mailman/listinfo/gatein-dev
> > > > >
> > > > >
> > > > >
>
_______________________________________________
> > > > > gatein-dev
mailing
> list
> > > > >
>
gatein-dev(a)lists.jboss.org
> > > > >
>
https://lists.jboss.org/mailman/listinfo/gatein-dev
> > > > >
> > >
> > >
> > >
> Thanks,
> > > Michal
> > >
>
>
> > >
>
_______________________________________________
> > > gatein-dev
mailing list
> > >
gatein-dev(a)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
> > > +33 (0)6 31 32 92 19
> > >
>
> > >
>
> > > --
> > > Nicolas Filotto
> > > JCR Product Manager
> > > Project Manager
> > > eXo Platform SAS
> > > nicolas.filotto(a)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
>
> >
> >
>
> > --
> > Nicolas Filotto
> > JCR Product Manager
> > Project Manager
> > eXo Platform SAS
> > nicolas.filotto(a)exoplatform.com
> > +33 (0)6 31 32 92 19
> >
>
> >
>
> > --
> > Nicolas Filotto
> > JCR Product Manager
> > Project Manager
> > eXo Platform SAS
> > nicolas.filotto(a)exoplatform.com
> > +33 (0)6 31 32 92 19
> >
>
>
>
> --
> Nicolas Filotto
> JCR Product Manager
> Project Manager
> eXo Platform SAS
> nicolas.filotto(a)exoplatform.com
> +33 (0)6 31 32 92 19
--
Nicolas Filotto
JCR Product Manager
Project Manager
eXo Platform SAS
nicolas.filotto(a)exoplatform.com
+33 (0)6 31 32 92 19
Michal