Trying to depend on the module won't help. You need to depend on the deployment of the HornetQ JCA RA. Try using something like "deployment.hornetq-ra" in your dependency.
Thanks for the reply! That "deployment." prefix is definitely one of the pieces I'm looking for. I overlooked it in the AS7 manual.
Now I'm looking for the latter part. "deployment.hornetq-ra", "deployment.hornetq-ra.rar" and "deployment.RaActivatorhornetq-ra" doesn't work as expected. I'll keep investigating but if you get any idea on it, please let me know.