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]

Reply via email to