Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: domain of clinton.begin@gmail.com
 designates 64.233.184.195 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references;
        b=um443Um57yqLoC5anHlmS5muHC4Ex80q6wi9sSASIZG6xeTzwuTVy8KYv7C5vMPEveAfkTT+iqsLEWpvB1TWuQQ4acYzXTCpV0gKKLt/k+tbyym+aK+65JrFSnRd+OIY5QiPx+qJNS8EbNLVb+YXd0A2i6YrZvvV/W9Gh3jEF0I=
Message-ID: <16178eb1050722194261c58ffc@mail.gmail.com>
Date: Fri, 22 Jul 2005 20:42:44 -0600
From: Clinton Begin <clinton.begin@gmail.com>
Reply-To: cbegin@ibatis.com
To: user-java@ibatis.apache.org, Mississippi John Hurt <johnhurt@gmail.com>
Subject: Re: M:N example
In-Reply-To: <ff87e10b05072120123503687d@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_3685_11790231.1122086564511"
References: <CCF101E3A9447D4E9DAC3A7F1042453902165563@snofex3.tec.govt.nz>
	 <20050721225417.19509.qmail@smtp.qnet.com.pe>
	 <ff87e10b05072120123503687d@mail.gmail.com>

------=_Part_3685_11790231.1122086564511
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Ouch. That's quite a unique requirement. The biggest problem will be that=
=20
iBATIS exclusively uses PreparedStatements (for performance and security=20
reasons).=20

So the first step would be to check to see if you can run DML within a=20
Prepared statement. After that, we can start to explore whether this can be=
=20
done at all.

Cheers,
Clinton

On 7/21/05, Mississippi John Hurt <johnhurt@gmail.com> wrote:
>=20
> Hi,
>=20
> I need to encapsulate some DML (such as ALTER TABLE DISABLE CONSTRAINT) a=
s=20
> well as a long anonymous PL/SQL block of code (not compiled in the databa=
se)=20
> in Java objects. Can I do this with iBatis? If so how? From what I=20
> understand iBatis can only map SQL and a single stored procedure. How wou=
ld=20
> I map say, something like a script with DML (ALTER TABLE) followed by a=
=20
> block of anonymous PL/SQL? Thanks.
>

------=_Part_3685_11790231.1122086564511
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<br>
Ouch.&nbsp; That's quite a unique requirement.&nbsp; The biggest
problem will be that iBATIS exclusively uses PreparedStatements (for
performance and security reasons).&nbsp; <br>
<br>
So the first step would be to check to see if you can run DML within a
Prepared statement.&nbsp; After that, we can start to explore whether
this can be done at all.<br>
<br>
Cheers,<br>
Clinton<br><br><div><span class=3D"gmail_quote">On 7/21/05, <b class=3D"gma=
il_sendername">Mississippi John Hurt</b> &lt;<a href=3D"mailto:johnhurt@gma=
il.com">johnhurt@gmail.com</a>&gt; wrote:</span><blockquote class=3D"gmail_=
quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt =
0pt 0.8ex; padding-left: 1ex;">
Hi,<br>
<br>
I need to encapsulate some DML (such as ALTER TABLE DISABLE CONSTRAINT)
as well as a long anonymous PL/SQL block of code (not compiled in the
database) in Java objects.&nbsp; Can I do this with iBatis?&nbsp; If so
how?&nbsp; From what I understand iBatis can only map SQL and a single
stored procedure.&nbsp; How would I map say, something like a script
with DML (ALTER TABLE) followed by a block of anonymous PL/SQL?&nbsp;
Thanks.<br>

</blockquote></div><br>

------=_Part_3685_11790231.1122086564511--