Okay, here is what is happening;
Even though the MySQL documentation says that innodb is enabled by default from version
4.0 onwards, it is partially true! On Linux the MySQl version 4.0.18(which I'm using)
does not have innodb turned on. It is only true on Windows!!
So that is the source of my problem!!
This URL may also help anybody in the same boat...
http://forums.mysql.com/read.php?11,4044,4044
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4071244#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...