[gatein-dev] GateIn on oracle DB
Thomas Heute
theute at redhat.com
Wed Mar 10 15:31:19 EST 2010
Michal,
It's still not clear if you updated JCR to 1.12.0.GA or if you are still
running with CR2
Thomas.
On 03/10/2010 09:15 PM, Michal Vančo wrote:
> Michal Vančo 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
>>
> Only for completeness:
> I'm using sqldeveloper tool to see the content of oracle DB, and at all
> above cases, I can't see that anything is created (tables, sequence,
> indexes...) in JCR schema. Only IDM schema initialization is done.
>
>> 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
>>>
>> _______________________________________________
>> 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
>
More information about the gatein-dev
mailing list