Sorry, I don't get it. There is a "run" method in SqlRunner made for that,
but it doesn't seem to be called from anywhere. I can't use an select,
insert, update or delete since the DDL doesn't return any result and they
do.
/**
* Executes any string as a JDBC Statement.
* Good for DDL
*
* @param sql The SQL
* @throws SQLException If statement prepration or execution fails
*/
public void run(String sql) throws SQLException {
Fred
On Thu, Aug 13, 2009 at 23:18, Clinton Begin <clinton.be...@gmail.com>wrote:
> 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
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
