Hi,
We've been using ibatis for a while now in a number of projects. We have been using it for dynamic, read-only cross-table queries - something that other object-relational mapping tools don't seem to do so well. We think ibatis is great, thanks for such a great product.
We have been using ibatis for queries in conjunction with ejb for insert / update / delete. After a couple of years of pain, we are now looking to replace ejb with something easier - possibly ibatis.
I have a number of (hopefully) quick questions.
1) ddl - is it possible to define your table structures in ibatis and have ibatis create the tables?
2) inserts - is the primary key retuned for all calls to the SqlMapExecutor.insert method. I have only seen examples in the docs for inserts that require a <selectKey> (oracle, ms sql server) what about auto generated keys (e.g. mysql)?
3) optimistic locking - is there any declarative support for optimistic locking - e.g. having a last_modified column in the db / object throw an error during the update method if the last mod in the value is different from the db.
4) audit trail - 4 cols: created_by, created_timestamp, modified_by, modified_timestamp. again updated by the framework during insert, update statements. would require some form of authentication (jaas) from the enclosing container. I'm guessing the majority of apps run in one container or another tomcat, jboss etc so should be possible.
Just trying to get a feel for what we'd get for free, what we'd have to build and what may be coming soon.
cheers Nathan
-- Nathan Coast Managing Director Codeczar Ltd mob : (852) 9049 5581 tel : (852) 2834 8733 fax : (852) 2834 8755 web : http://www.codeczar.com
