Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (nike.apache.org: domain of clinton.begin@gmail.com
 designates 74.125.92.149 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=Jjat+AKWiqL22g4K/qWOR/j11qWZwrGFOp2gW1ndn6TxqiDpOtrfwvbBXWbeWVYb52
         Pcj4rqaAZ8Qq+giFGW92avPu/PB0u2FB/KoPUGeWXbjvstFgBbO6cLaIYtCRv1YV+OSX
         SB7a8PgFLeBM2mPmKyQljk4Ro0pas7vLlCKZ8=
MIME-Version: 1.0
In-Reply-To: <4B5759A3.3010701@mchambliss.com>
References: <4B5759A3.3010701@mchambliss.com>
Date: Wed, 20 Jan 2010 14:54:21 -0700
Message-ID: <16178eb11001201354i33fe2084y87aad7fe37b0d130@mail.gmail.com>
Subject: Re: Oracle PL/SQL with Schema Migrations
From: Clinton Begin <clinton.begin@gmail.com>
To: user-java@ibatis.apache.org
Content-Type: multipart/alternative; boundary=00163613a360092888047d9fa13a

--00163613a360092888047d9fa13a
Content-Type: text/plain; charset=ISO-8859-1

You can configure the line terminator in the environment properties.  Try a
full line delimiter like "GO"

On Wed, Jan 20, 2010 at 12:29 PM, Michael Chambliss <email@mchambliss.com>wrote:

> Hello,
>
> I just wanted to follow up on a question that was asked back in October:
>
> http://www.mail-archive.com/user-java@ibatis.apache.org/msg14957.html
>
> In summary, PL/SQL terminates lines with a semicolon, which causes problems
> for the line delimiter logic in the migrations tool.  Something like this:
>
> DECLARE
>  sometime date;
> BEGIN
>  select sysdate into sometime from dual;
> END;
>
> would fail on line 2.  In a more realistic case, simply creating a function
> or trigger would trip things up.  Was this scenario later compensated for
> via environment configuration options, or has anyone found a good work
> around?
>
> Thanks!
> Mike
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

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

You can configure the line terminator in the environment properties.=A0 Try=
 a full line delimiter like &quot;GO&quot;<br><br><div class=3D"gmail_quote=
">On Wed, Jan 20, 2010 at 12:29 PM, Michael Chambliss <span dir=3D"ltr">&lt=
;<a href=3D"mailto:email@mchambliss.com">email@mchambliss.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;">Hello,<br>
<br>
I just wanted to follow up on a question that was asked back in October:<br=
>
<br>
<a href=3D"http://www.mail-archive.com/user-java@ibatis.apache.org/msg14957=
.html" target=3D"_blank">http://www.mail-archive.com/user-java@ibatis.apach=
e.org/msg14957.html</a><br>
<br>
In summary, PL/SQL terminates lines with a semicolon, which causes problems=
 for the line delimiter logic in the migrations tool. =A0Something like thi=
s:<br>
<br>
DECLARE<br>
 =A0sometime date;<br>
BEGIN<br>
 =A0select sysdate into sometime from dual;<br>
END;<br>
<br>
would fail on line 2. =A0In a more realistic case, simply creating a functi=
on or trigger would trip things up. =A0Was this scenario later compensated =
for via environment configuration options, or has anyone found a good work =
around?<br>

<br>
Thanks!<br>
Mike<br>
<br>
---------------------------------------------------------------------<br>
To unsubscribe, e-mail: <a href=3D"mailto:user-java-unsubscribe@ibatis.apac=
he.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>
</blockquote></div><br>

--00163613a360092888047d9fa13a--