[gatein-dev] GateIn on oracle DB

[Nicolas Filotto]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/gatein-dev/attachments/20100310/fa059652/attachment.html