I don't know XDoclet well, but I don't see any EJB-QL in this post.
thanks it's that
currently I am struggling with the similar problem.
However looking at the XDoclet sources I've discovered undocumented(?) @jboss:declared-sql tag:
* signature="<complete finder method signature, like: java.util.Collection findMethod(String parameter1, int parameter2)>"
* where="<here goes SQL WHERE clause>"
* order="<here goes SQL ORDER BY clause>"
You can discover this looking at xdoclet/ejb/vendor/jbosscmp-jdbc_xml.j in xdoclet.jar.
Hope this helps
Use the xdoclet standard ejb-ql tags instead of the jboss declared-sql tags. Also I think they are undocumented, because they are still a work in progress.