From: <glassfish_at_javadesktop.org>
Date: Mon, 07 Jul 2008 07:42:02 PDT

Hi,

I found the answer for [b]Invalid argument(s) for '='.[/b] issue. Looks like the type of the column is number(9,5) in oracle database. The finder method is being passed a String parameter in ejb-jar.xml as shown.

[i] <query-method>
               <method-name>findByCatalogId</method-name>
               <method-params>
                  <method-param>java.lang.String</method-param>
               </method-params>
            </query-method>
            <result-type-mapping>Local</result-type-mapping>
            <ejb-ql><![CDATA[SELECT DISTINCT OBJECT(o) FROM ProgramView o WHERE o.bpomPrgCashvalue = ?1]]></ejb-ql>[/i]

Changing it to java.lang.Double fixed the problem.

I'm still trying to solve the other problem with the 'IN' clause.

Thanks
Suneel
[Message sent by forum member 'suneelgv' (suneelgv)]

http://forums.java.net/jive/thread.jspa?messageID=284710