3 Replies Latest reply on Nov 2, 2001 3:18 AM by Laurent Broudoux

    Custom finder in jaws.xml : trying tu use "<" and ">"

    Laurent Broudoux Newbie

      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