I'm sorry. I made a mistake when I wrote the EJB-QL query in my email. The finder method in my non-worked application is:
"SELECT OBJECT(c) FROM Category c WHERE c.padre=?1"
My application still doesn't work.
I'm assuming that everything else is correct in your jbosscmp-jdbc.xml file try this...
In your jbosscmp-jdbc.xml file replace your code with this
SELECT OBJECT(c)FROM Category AS c
hope this helps...