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?
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> 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