Re: [gatein-dev] GateIn on oracle DB

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(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 _______________________________________________ gatein-dev mailing list gatein-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/gatein-dev