I'm NOT completely sure, but you migth try to comment the next line in your hibernate.cfg.xml file:
Also, you could use another user (with no provileges to create, drop, alter tables) to connect to your database, since the behavior you're seeing is being done by Hibernate (as far as I know, it's updating your database according your hibernate mappings, and is doing it by droping tables, in order to create the new tables).
Hope this helps.
i did not use any such line in my cfg.xml file.
any other suggestions pls?
uhhmm... do you use the in-memory hsqldb?
yes, i am suing the hsql db that comes along with the Jboss server package.
that was not what I meant, hsqldb can be run in-memory and with file persistence, regardles of what server it comes with