SqlRunner is not used by iBATIS core. It's used by the migrations tool
though, and I use it for unit tests all the time. Consider it part of the
"utilities" included with iBATIS.
Clinton
On Thu, Aug 13, 2009 at 10:29 AM, Fred Janon <fja...@gmail.com> wrote:
> 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
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
