do you have also
<!-- Assembly Descriptor -->
<!-- transactions -->
in youe ejb-jar.xml ?
Thank you for responding. I tried that, but it still doesn't work. here is what my ejb-jar.xml looks like.
The Teacher Ejb
After some further review.. i'm actually getting a parital rollback. My transaction comsists of an insert and a create table. The insert rolls back however the create table does not. Doesn't that seem kinda weird?
I might be wrong (I come from an oracle-centric background), but I'm not so sure DDL *CAN* be rolled back. And given what I know about MySQL, I would be suprised if that feature was available. DML (insert/select/update/delete) on the other hand seems to be working fine for you.
Is it absolutely critical to be able to transactionally create/alter/drop tables?
No, it's not critical, I was just more curious than anything. Thanks for the info!
DDL is not transactional in MySQL.