had the same problem - Rickard posted recently that this is a know bug - is
there a fix underway?


Robert.
> -----Original Message-----
> From: Shahar Solomianik [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 4 December 2000 3:22
> To: [EMAIL PROTECTED]
> Subject: [jBoss-User] JAWS customised finder doesnt work !!!
> 
> 
> Hi all.
> I have a CMP entity bean with a customised finder defined in 
> jaws.xml as
> follows:
> 
> <finder>
>   <name>findBySource</name>
>   <query>source_type_id = {0} AND source_reference_id = {1}</query>
>   <order>knowledge_id DESC</order>
> </finder>
> 
> My Oracle8.1.6 reports this :
> 
> [Knowledge] findBySource(1,ex0001)
> [JAWS] java.sql.SQLException: ORA-00923: FROM keyword not found where
> expected
> 
> Whenever I invoke this finder method.
> Other finders (findByPrimaryKey,findAll,findByAttribute) work fine.
> Can someone look at this ? It seems the generated SQL misses 
> a space between
> the select-list and the 'from' keyword.
> 
> 
> 
> --
> --------------------------------------------------------------
> To subscribe:        [EMAIL PROTECTED]
> To unsubscribe:      [EMAIL PROTECTED]
> Problems?:           [EMAIL PROTECTED]
> 


--
--------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Problems?:           [EMAIL PROTECTED]

Reply via email to