Hi,
I personally don't have any problem with it. The only difference is that I
don't use the <order> directive (use an empty node).
Works like a charm using final 2.0, JDK 1.3, iNet Software JDBC type 4
driver (evaluation version) and SQL Svr 7.
Just FYI. ;o)
Pascal Davoust.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Shahar Solomianik
Sent: Monday, December 04, 2000 4:55 PM
To: 'jBoss'
Subject: RE: [jBoss-User] JAWS customised finder doesnt work !!!
Rickard ? Is it fixed ?
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Robert Schulz
Sent: Monday, December 04, 2000 12:49 AM
To: 'jBoss'
Subject: RE: [jBoss-User] JAWS customised finder doesnt work !!!
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]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
