Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of clinton.begin@gmail.com
 designates 209.85.212.199 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=fFP/keelkzLv0BeB/skmcbW7wsRlkPiJP/UqYNUwIh3nZx4FmccxMWKH6kf9oxc5np
         i9e+sYkWWfA8dycgbuGFJcW5S7Ag81LVgF6+dUqDOrHq5+IS8QpJ2rDA6CxqgimgSVDW
         lanrZwKm2gZPX+ZCTE7LT1uUAF2JNNXNZ+DTE=
MIME-Version: 1.0
In-Reply-To: <2fd0c7810908130929n33c882dp4169d6f15cf4a667@mail.gmail.com>
References: <2f55db670908081236y170fc78aua7cf6783dfc66787@mail.gmail.com>
	 <55efbd800908081316x5ae085adnf5888d62f7954f10@mail.gmail.com>
	 <16178eb10908081333h7f720db3p9869a9a4548b3f96@mail.gmail.com>
	 <2fd0c7810908130139j2ac5e8f3r2371871096bb16c1@mail.gmail.com>
	 <16178eb10908130542h35cddbb1mb9e6a670897cc3cd@mail.gmail.com>
	 <2fd0c7810908130742k5dc9c288t2039a8aeb17a946b@mail.gmail.com>
	 <2fd0c7810908130744g665f7f92u7ea9c8bb6d519960@mail.gmail.com>
	 <16178eb10908130818n2fff1445n3408defc01b4db7@mail.gmail.com>
	 <2fd0c7810908130929n33c882dp4169d6f15cf4a667@mail.gmail.com>
Date: Thu, 13 Aug 2009 15:31:30 -0600
Message-ID: <16178eb10908131431g68b3dda3v751946e140a14802@mail.gmail.com>
Subject: Re: iBATIS 3 for Java Released (BETA 1)
From: Clinton Begin <clinton.begin@gmail.com>
To: user-java@ibatis.apache.org
Content-Type: multipart/alternative; boundary=0016e64754eab7d46004710ca8b5

--0016e64754eab7d46004710ca8b5
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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 <fjanon@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.begin@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 <fjanon@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.maves@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-unsubscribe@ibatis.apache.org
>>>>>>> >> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>>>>>> >>
>>>>>>> >>
>>>>>>> >
>>>>>>>
>>>>>>> --
>>>>>>> Sent from my mobile device
>>>>>>>
>>>>>>> ---------------------------------------------------------------------
>>>>>>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>>>>>>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>

--0016e64754eab7d46004710ca8b5
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

SqlRunner is not used by iBATIS core.=A0 It&#39;s used by the migrations to=
ol though, and I use it for unit tests all the time.=A0 Consider it part of=
 the &quot;utilities&quot; included with iBATIS.=A0 <br><br>Clinton<br><br>=
<div class=3D"gmail_quote">
On Thu, Aug 13, 2009 at 10:29 AM, Fred Janon <span dir=3D"ltr">&lt;<a href=
=3D"mailto:fjanon@gmail.com">fjanon@gmail.com</a>&gt;</span> wrote:<br><blo=
ckquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 204,=
 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Sorry, I don&#39;t get it. There is a &quot;run&quot; method in SqlRunner m=
ade for that, but it doesn&#39;t seem to be called from anywhere. I can&#39=
;t use an select, insert, update or delete since the DDL doesn&#39;t return=
 any result and they do.<br>

<br>/**<br>=A0=A0 * Executes any string as a JDBC Statement.<br>=A0=A0 * Go=
od for DDL<br>=A0=A0 *<br>=A0=A0 * @param sql The SQL<br>=A0=A0 * @throws S=
QLException If statement prepration or execution fails<br>=A0=A0 */<br>=A0 =
public void run(String sql) throws SQLException {<br>
<font color=3D"#888888">
<br>Fred</font><div><div></div><div class=3D"h5"><br><br><div class=3D"gmai=
l_quote">On Thu, Aug 13, 2009 at 23:18, Clinton Begin <span dir=3D"ltr">&lt=
;<a href=3D"mailto:clinton.begin@gmail.com" target=3D"_blank">clinton.begin=
@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
This question is worthy of a new thread.=A0 But since the answer is so simp=
le:<br><br>&lt;select/insert/update/delete=A0 statementType=3DSTATEMENT|PRE=
PARED|CALLABLE&gt;<br><br>For some databases you might also have to use aut=
ocommit.<br>


<br>See the user guide for more.<br><font color=3D"#888888"><br>Clinton</fo=
nt><div><div></div><div><br><br><div class=3D"gmail_quote">On Thu, Aug 13, =
2009 at 8:44 AM, Fred Janon <span dir=3D"ltr">&lt;<a href=3D"mailto:fjanon@=
gmail.com" target=3D"_blank">fjanon@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
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 &lt;sql&gt; element=
 in iBatis before?<br><br>Thanks<br><font color=3D"#888888"><br>Fred</font>=
<div>


<div></div><div><br><br><div class=3D"gmail_quote">
<br><blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(2=
04, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div><di=
v class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"border-l=
eft: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left:=
 1ex;">


<div><div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" styl=
e=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; =
padding-left: 1ex;"><div><div><div class=3D"gmail_quote"><blockquote class=
=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin=
: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">


<div><div>&gt;<br>
&gt; 2009/8/8 Nathan Maves &lt;<a href=3D"mailto:nathan.maves@gmail.com" ta=
rget=3D"_blank">nathan.maves@gmail.com</a>&gt;<br>
&gt;<br>
&gt;&gt; A month ago iBATIS turned 7 years old, and while we&#39;re celebra=
ting a<br>
&gt;&gt; little late, today we&#39;re happy to announce iBATIS 3 for Java. =
iBATIS 3<br>
&gt;&gt; is a complete rewrite from the ground up and thus represents the<b=
r>
&gt;&gt; biggest change since the very first version of iBATIS released in<=
br>
&gt;&gt; 2002. There are a lot of modern features that take advantage of Ja=
va<br>
&gt;&gt; 5. iBATIS 3 includes simplified design and some great new tools fo=
r<br>
&gt;&gt; helping you build great database driven applications. iBATIS 3 car=
ries<br>
&gt;&gt; forward all of the principles that have made iBATIS popular. There=
 are<br>
&gt;&gt; still no required 3rd party dependencies, it&#39;s simpler than ev=
er, and<br>
&gt;&gt; yet far more powerful! More information will come in the next few =
days<br>
&gt;&gt; to help you get started.<br>
&gt;&gt; Introducing the iBATIS Schema Migration System<br>
&gt;&gt;<br>
&gt;&gt; Along with iBATIS 3, we&#39;re happy to introduce the iBATIS Schem=
a<br>
&gt;&gt; Migration System (or iBATIS Migrations for short). This powerful t=
ool<br>
&gt;&gt; was inspired by Rails Migrations and similar tools like dbdeploy t=
o<br>
&gt;&gt; enable good database change management practices, help teams to wo=
rk<br>
&gt;&gt; concurrently without stepping all over each other and avoid having=
 to<br>
&gt;&gt; centralize database changes. Once you work this way, you&#39;ll fi=
nd it<br>
&gt;&gt; very hard to work any other way again. Developers and DBAs will<br=
>
&gt;&gt; appreciate it equally.<br>
&gt;&gt;<br>
&gt;&gt; You can find the new artifacts including the new jar files and man=
uals<br>
&gt;&gt; at the URL below.<br>
&gt;&gt;<br>
&gt;&gt; <a href=3D"http://ibatis.apache.org/java.cgi" target=3D"_blank">ht=
tp://ibatis.apache.org/java.cgi</a><br>
&gt;&gt;<br>
&gt;&gt; We will send out an email as soon as we get the artifacts out on t=
he<br>
&gt;&gt; Maven repositories.<br>
&gt;&gt;<br>
&gt;&gt; iBatis Team<br>
&gt;&gt;<br>
&gt;&gt; ------------------------------------------------------------------=
---<br>
&gt;&gt; To unsubscribe, e-mail: <a href=3D"mailto:user-java-unsubscribe@ib=
atis.apache.org" target=3D"_blank">user-java-unsubscribe@ibatis.apache.org<=
/a><br>
&gt;&gt; For additional commands, e-mail: <a href=3D"mailto:user-java-help@=
ibatis.apache.org" target=3D"_blank">user-java-help@ibatis.apache.org</a><b=
r>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;<br>
<br>
</div></div><div>--<br>
Sent from my mobile device<br>
<br>
---------------------------------------------------------------------<br>
</div><div><div></div><div>To unsubscribe, e-mail: <a href=3D"mailto:user-j=
ava-unsubscribe@ibatis.apache.org" target=3D"_blank">user-java-unsubscribe@=
ibatis.apache.org</a><br>
For additional commands, e-mail: <a href=3D"mailto:user-java-help@ibatis.ap=
ache.org" target=3D"_blank">user-java-help@ibatis.apache.org</a><br>
<br>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br>

--0016e64754eab7d46004710ca8b5--