Re: [JBoss-user] Help me with EJB QL Error

[Marek L. <ml...@ob...>]

Ramrakhiani, Vikas wrote:
> Hi,
> 
> I am trying to write a where clause query in EJB QL,
> 		<query> 
> 		<query-method> 
> 		<method-name>findAllFieldsWithTypeCode</method-name> 
> 	
> <method-params><method-param>java.lang.String</method-param></method-params>
> 
> 		</query-method> 
> 		<ejb-ql> 
> 		<![CDATA[SELECT OBJECT (a) FROM FieldData AS a WHERE
> (a.typecode = "2")]]>
> 		</ejb-ql> 
> 		</query> 

I think you should write ?1 as the parameter instead of "2". You have to 
set the param in your application:

SELECT OBJECT (a) FROM FieldData AS a WHERE a.typecode = ?1

-marek