Are you sure you have the correct SQL for the select of the userRoles fro mthe
table? As you can see from the error itself, the SQL exception is telling you
that there is no table called ROLES whereas you have a table called userRoles.
I think you might have cut and pasted the original SQL st
Thanks.
It works now, just adding the code you suggested.
Regards.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3839966#3839966
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3839966
-
your roles query is supposed to return two columns not one as your SQL statement is
suggesting.
The first table column should be the Role and the second the RoleGroup,
from your query
anonymous wrote : select id_servicio from
vivoen.registro where id_usuario=? AND id_website=1 AND (fecha_fin