Re: Help installing CCM/CMS 6.1

Sorry Richard, I forgot to mention in the previous message that I did 
try running the query in SQL*Plus and got the exact oracle error.

Tuan.

Richard Li wrote:
> I sent an email but I guess you must not have seen it -- did you try 
> running the query in SQL*Plus on 8.1.7 to verify that is indeed the 
> problem?
> 
> Tuan Nguyen wrote:
> 
>> 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/