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 at 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 at 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 at gmail.com> wrote:
> >
> Hi Prabhat,
> >
> >
> my comments inline
> >
> >
> > On Wed, Mar 10, 2010 at 2:01 PM, Prabhat Jha
> <pjha at 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 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
>
> >
> >
>
> > --
> > 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
> >
>
>
>
> --
> Nicolas Filotto
> JCR Product Manager
> Project Manager
> eXo Platform SAS
> nicolas.filotto at exoplatform.com
> +33 (0)6 31 32 92 19
-------------- next part --------------
A non-text attachment was scrubbed...
Name: oracle11_jcr.png
Type: image/png
Size: 163397 bytes
Desc: not available
Url : http://lists.jboss.org/pipermail/gatein-dev/attachments/20100310/38ac08ce/attachment-0002.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: oracle11_jcr_shorten_names.png
Type: image/png
Size: 166895 bytes
Desc: not available
Url : http://lists.jboss.org/pipermail/gatein-dev/attachments/20100310/38ac08ce/attachment-0003.png