I'm using single db. After running given script - tables, indexes,
trigger and sequence were created. But JCR_CONFIG table isn't present in
the script.
GateIn is still failing with the same issue.
After I added this:
CREATE TABLE "EPP5UIDB"."JCR_CONFIG"
( "NAME" VARCHAR2(64 BYTE) NOT NULL ENABLE,
"CONFIG" BLOB NOT NULL ENABLE,
CONSTRAINT "JCR_CONFIG_PK" PRIMARY KEY ("NAME")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
LOB ("CONFIG") STORE AS BASICFILE (
TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
NOCACHE LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) ;
(this is the exported DDL of jcr_config from oracle11 db)
GateIn started without erors on oracle10!!!!
On Thu, Mar 11, 2010 at 8:36 AM, Michal Vančo <mvanco(a)redhat.com>
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(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
--
Nicolas Filotto
JCR Product Manager
Project Manager
eXo Platform SAS
nicolas.filotto(a)exoplatform.com
+33 (0)6 31 32 92 19