[gatein-dev] GateIn on oracle DB
Prabhat Jha
pjha at redhat.com
Wed Mar 10 08:01:16 EST 2010
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 at 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 at gmail.com > wrote:
>
>
>
>
> On Wed, Mar 10, 2010 at 1:29 PM, Michal Vančo < mvanco at 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_oracle11/35/
>
> 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 at 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 at 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_oracle10/22/console
> > >> >
> > >> > http://hudson.jboss.org/hudson/job/gatein_portal_ui_selenium_tests_jboss5_oracle11/21/console
> > >> >
> > >> >
> > >> > I would appreciate any help.
> > >> >
> > >> > Thanks in advance
> > >> > Michal Vanco
> > >> >
> > >> > _______________________________________________
> > >> > gatein-dev mailing list
> > >> > gatein-dev at lists.jboss.org
> > >> > https://lists.jboss.org/mailman/listinfo/gatein-dev
> > >
> > >
> > > _______________________________________________
> > > gatein-dev mailing list
> > > gatein-dev at lists.jboss.org
> > > https://lists.jboss.org/mailman/listinfo/gatein-dev
> > >
>
>
> Thanks,
> Michal
>
> _______________________________________________
> gatein-dev mailing list
> gatein-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/gatein-dev
>
>
> --
>
> Nicolas Filotto
> JCR Product Manager
> Project Manager
> eXo Platform SAS
> nicolas.filotto at exoplatform.com
> +33 (0)6 31 32 92 19
>
>
> --
> Nicolas Filotto
> JCR Product Manager
> Project Manager
> eXo Platform SAS
> nicolas.filotto at exoplatform.com
> +33 (0)6 31 32 92 19
>
> _______________________________________________ gatein-dev mailing list gatein-dev at lists.jboss.org https://lists.jboss.org/mailman/listinfo/gatein-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/gatein-dev/attachments/20100310/70f215fd/attachment.html
More information about the gatein-dev
mailing list