11:45 a.m.
Hi,
Peter Nedonosko wrote
On Wed, Mar 10, 2010 at 3: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.
>
> Quick questions:
> As per oracle11 finding, is JCR config (table names) going to be updated
> across the board?
> 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?
>
> 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?
the error is due to a use of addConfig plugin,
and I just described the way how it occurs with thoughts what may
happens inside.
why it's only a Oracle10 problem it's still not clear.
as from the JCR logic all steps are valid and should works for the moment.
it will help if you'll send me your Oracle
tablespace/database/schema/user/rights script,
I'll be able to setup similar env on my side.
there is script to create initial schema in oracle10 DB:
CREATE USER username IDENTIFIED by username TABLESPACE users TEMPORARY
TABLESPACE temp QUOTA UNLIMITED ON users;
grant DBA to username;
>>> >
>>
>> >
>> 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
> _______________________________________________
> 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
Michal