Hello,
I'm trying to set up a custom finder in jaws.xml, following the tips from html documentation. (My config: Jboss2.4.1 and Oracle 7)
I want to find db rows having a numstatus field such as min < numstatus < max.
Because ">" and "<" are specific Xml characters, the Verifier throws an exception if the where clause
of the query is not inside a CDATA section like this :
findByNumstatusRange
<![CDATA[ N_ETAT_LG>{0} and N_ETAT_LG<{1}]]>
But, that way, the container doesn't seems to understand the where clause and throws a FinderException :
javax.ejb.FinderException: Find failed at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(Unknown Source)
at sun.rmi.transport.StreamRemoteCall.executeCall(Unknown Source)
at sun.rmi.server.UnicastRef.invoke(Unknown Source)
at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker_Stub.invokeHome(Unknown Source)
at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invokeHome(HomeProxy.java:258)
at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:182)
at $Proxy1.findByNumstatusRange(Unknown Source)
at ClientEjb.main(ClientEJB.java:70)
Moreover, when I look into "server.log", I've got following message :
[JAWS] java.sql.SQLException: ORA-00904: invalid column name
[JAWS]
[JAWS] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
[JAWS] ...
But I'm sure that my column name is correct because finder on this field works fine ...
Has anyone succeed to define such a finder ? (range selection). Thank you for your help !
Best regards,
Laurent
