Re: Help installing CCM/CMS 6.1

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/

-- 
|=-             Daniel P. Berrange  -  [email protected]              -=|
|=-   Red Hat, 338 Euston Road, London, NW1 3BT.  +44 (0)7977 267 243   -=|
|=-                                                                     -=|
|=- GnuPG: 7D3B9505   F3C9 553F A1DA 4AC2 5648 23C1 B3DF F742 7D3B 9505 -=|

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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAmfdZs9/3Qn07lQURAme8AJ9MK9z/2FFQSsL5/V/VuDh0/3WqpACcDErj
YFy3893hyTYOiPKB4rtLaaU=
=E7lq
-----END PGP SIGNATURE-----