Michal,
It's still not clear if you updated JCR to 1.12.0.GA or if you are still
running with CR2
Thomas.
On 03/10/2010 09:15 PM, Michal Vančo wrote:
Michal Vančo 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
>
Only for completeness:
I'm using sqldeveloper tool to see the content of oracle DB, and at all
above cases, I can't see that anything is created (tables, sequence,
indexes...) in JCR schema. Only IDM schema initialization is done.
> 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
>>
> _______________________________________________
> 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