Re: [gatein-dev] GateIn on oracle DB

Hi, Nicolas Filotto wrote: > Could you please provide the list of tables that you can see with your > credentials on oracle 10 G? As I wrote yesterday in my additional reply: I'm using sqldeveloper tool to see the content of oracle DB, and at all oracle10 cases, I can't see that anything is created (tables, sequence, indexes...) in JCR schema. Only IDM schema initialization is done. > > On Wed, Mar 10, 2010 at 8:41 PM, Michal Vančo <mvanco(a)redhat.com&gt; > 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 It was added for these cases ^. > > 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&gt; 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&gt; > 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&gt; wrote: > > > > > Hi Prabhat, > > > > > > > > my comments inline > > > > > > > > > On Wed, Mar 10, 2010 at 2:01 PM, Prabhat > Jha > > <pjha(a)redhat.com&gt; 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&gt; 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&gt; > wrote: > > > > > > > > > > > > > > > > > > > > > On Wed, Mar 10, 2010 at > 1:29 PM, > > Michal Vančo > <mvanco(a)redhat.com&gt; > > 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&gt; > 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 > > > > > > -- > Nicolas Filotto > JCR Product Manager > Project Manager > eXo Platform SAS > nicolas.filotto(a)exoplatform.com > +33 (0)6 31 32 92 19 Michal