1) No. 2) Yes, you can do that for either auto-generated or assigned keys.
3) No. 4) No. That said, 3 & 4 can be pretty simple to build, depending on how intricate you want to get with them. Larry On Fri, 28 Jan 2005 10:16:42 +0800, Nathan Coast <[EMAIL PROTECTED]> wrote: > 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.

