This question is worthy of a new thread. But since the answer is so simple:
<select/insert/update/delete statementType=STATEMENT|PREPARED|CALLABLE> For some databases you might also have to use autocommit. See the user guide for more. Clinton On Thu, Aug 13, 2009 at 8:44 AM, Fred Janon <fja...@gmail.com> wrote: > Is there a way to execute a sql statement other than select/insert/update, > like to create or alter a table? I thought there was an <sql> element in > iBatis before? > > Thanks > > Fred > > > > > >>>>> > 2009/8/8 Nathan Maves <nathan.ma...@gmail.com> >>>>> > >>>>> >> A month ago iBATIS turned 7 years old, and while we're celebrating a >>>>> >> little late, today we're happy to announce iBATIS 3 for Java. iBATIS >>>>> 3 >>>>> >> is a complete rewrite from the ground up and thus represents the >>>>> >> biggest change since the very first version of iBATIS released in >>>>> >> 2002. There are a lot of modern features that take advantage of Java >>>>> >> 5. iBATIS 3 includes simplified design and some great new tools for >>>>> >> helping you build great database driven applications. iBATIS 3 >>>>> carries >>>>> >> forward all of the principles that have made iBATIS popular. There >>>>> are >>>>> >> still no required 3rd party dependencies, it's simpler than ever, >>>>> and >>>>> >> yet far more powerful! More information will come in the next few >>>>> days >>>>> >> to help you get started. >>>>> >> Introducing the iBATIS Schema Migration System >>>>> >> >>>>> >> Along with iBATIS 3, we're happy to introduce the iBATIS Schema >>>>> >> Migration System (or iBATIS Migrations for short). This powerful >>>>> tool >>>>> >> was inspired by Rails Migrations and similar tools like dbdeploy to >>>>> >> enable good database change management practices, help teams to work >>>>> >> concurrently without stepping all over each other and avoid having >>>>> to >>>>> >> centralize database changes. Once you work this way, you'll find it >>>>> >> very hard to work any other way again. Developers and DBAs will >>>>> >> appreciate it equally. >>>>> >> >>>>> >> You can find the new artifacts including the new jar files and >>>>> manuals >>>>> >> at the URL below. >>>>> >> >>>>> >> http://ibatis.apache.org/java.cgi >>>>> >> >>>>> >> We will send out an email as soon as we get the artifacts out on the >>>>> >> Maven repositories. >>>>> >> >>>>> >> iBatis Team >>>>> >> >>>>> >> >>>>> --------------------------------------------------------------------- >>>>> >> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org >>>>> >> For additional commands, e-mail: user-java-h...@ibatis.apache.org >>>>> >> >>>>> >> >>>>> > >>>>> >>>>> -- >>>>> Sent from my mobile device >>>>> >>>>> --------------------------------------------------------------------- >>>>> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org >>>>> For additional commands, e-mail: user-java-h...@ibatis.apache.org >>>>> >>>>> >>>> >>> >> >
