Re: Help installing CCM/CMS 6.1

Hmm, that can't be good, our existing site is using 5.2 on 8.1.7. I 
thought 6.1 was tested on 8i as per the release notes. Why the sudden 
change without any backward compatibility?

Tuan.

Daniel P. Berrange wrote:
> On Wed, May 05, 2004 at 06:55:15PM -0400, Tuan Nguyen wrote:
> 
>>Thanks Vadim,
>>
>>Your guess is correct, I am running on oracle 8.1.7. Is there a work 
>>around for this issue.
> 
> 
> No, the persistence query optimizer generates SQL92 compliant
> joins conditions only, so you'll need to upgrade to 9i.
> 
> 
>>Tuan.
>>
>>Vadim Nasardinov wrote:
>>
>>>On Wednesday 05 May 2004 17:21, Tuan Nguyen wrote:
>>>
>>>
>>>>2004-05-05 17:12:55,096 [ main] ERROR rdbms.RDBMSEngine - select
>>>>t0.pdl_id as "this.id",
>>>>      t6.object_type as "this.objectType",
>>>>      t6.display_name as "this.displayName",
>>>>      t6.default_domain_class as "this.defaultDomainClass",
>>>>      t0.pdl_file as "this.pdlFile",
>>>>      t0.dynamic_object_type as "this.dynamicType"
>>>
>>>>from persistence_dynamic_ot t0
>>>
>>>>join acs_objects t6 on t0.pdl_id = t6.object_id
>>>>java.sql.SQLException: ORA-00933: SQL command not properly ended
>>>
>>>
>>>Have  you tried running this query in SQL*Plus?  What version of Oracle
>>>are you using?  This looks like SQL92 syntax to me.  Probably works on
>>>Oracle 9, but not, say, 8.1.7.
>>>
>>>
>>
>>
>>-- 
>>Redhat-ccm-list mailing list
>>[email protected]
>>https://www.redhat.com/mailman/listinfo/redhat-ccm-list
>>Archives: https://www.redhat.com/pipermail/redhat-ccm-list/
> 
> 


-- 
Redhat-ccm-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/redhat-ccm-list
Archives: https://www.redhat.com/pipermail/redhat-ccm-list/