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
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