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.