0 Replies Latest reply on Feb 12, 2004 7:19 AM by German Rodriguez Lopez

    select where is null bug?

    German Rodriguez Lopez Newbie

      In jboss-3.2.1_tomcat-4.1.24 this select works fine:


      <query-method>
      <method-name>ejbSelectPermisosXAplicacion</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      <method-param>java.lang.Boolean</method-param>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <result-type-mapping>Local</result-type-mapping>
      <ejb-ql>select ps.permiso
      from UsuariosEJB as u,
      IN(u.perfiles) as pfs,
      IN(pfs.perfil.permisos) as ps
      where u.login=?1
      and ps.permiso.autorizado=?2
      and ps.permiso.aplicacion.nombre=?3
      and ps.permiso.servicio is null
      and ps.permiso.metodo is null</ejb-ql>



      but now, with jboss-3.2.3 doesen't work, the problem is in the last two lines:

      and ps.permiso.servicio is null
      and ps.permiso.metodo is null

      with them the select is empty in the new version. But with the old JBoss version and the same database, it returns one record, the correct answer.

      How can I solve this?

      thanks in advance.