stupid me. The message was loud and clear but not once did I check in WEB-INF/classes to see if message.hbm.xml was there. While building, my hbm.xml was not copied from WEB-INF/src to WEB-INF/classes. So I manually copied the file and that error went off. Then the next error I had was datasource not found. I had to then follow the instructions in the quickstart tutorial to get that working - some issue with JNDI and tomcat - there is a workaround suggested in this tutorial - clicky.
Now I am seeing this exception -
This comes when I am trying to start a transaction. Might be because I am using MySQL 4.1?? Had to do some more ing. Any suggestions on this??
Well just to update - to help anyone looking at this post - I dropped tomcat and switched to jboss. It also had its share of oddities but finally got it working. Was able to successfully insert a record into the database. I will list the steps that I followed.
1. copy my-sql.ds.xml from JBOSS_HOME/doc/examples/JSA to $JBOSS_HOME/server/default/deploy 2. Edit my-sql.ds.xml to look like this