You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by wilberto <wi...@ec-red.com> on 2005/07/22 00:54:16 UTC
M:N example
Hi
Somebody know a link were i cant see and M:N example in the guide only is
the 1:N example.
thank you
Wilberto
---------------------------------------------------------------
EC Red Internet gr@tis
InscrÃbete en www.ec-red.com
Re: M:N example
Posted by Clinton Begin <cl...@gmail.com>.
>From the wiki...
http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+around+the+N+Plus+1+selects+problem%3F
Clinton
On 7/21/05, wilberto <wi...@ec-red.com> wrote:
>
> Hi
>
> Somebody know a link were i cant see and M:N example in the guide only is
> the 1:N example.
>
> thank you
>
> Wilberto
> ---------------------------------------------------------------
> EC Red Internet gr@tis
> InscrÃbete en www.ec-red.com <http://www.ec-red.com>
>
Can iBatis Map a script of DML (ALTER TABLE) with Anonymous PL/SQL block?
Posted by Mississippi John Hurt <jo...@gmail.com>.
Hi,
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. Can I do this with iBatis? If so how? From what I
understand iBatis can only map SQL and a single stored procedure. How would
I map say, something like a script with DML (ALTER TABLE) followed by a
block of anonymous PL/SQL? Thanks.
Re: M:N example
Posted by Clinton Begin <cl...@gmail.com>.
Ouch. That's quite a unique requirement. The biggest problem will be that
iBATIS exclusively uses PreparedStatements (for performance and security
reasons).
So the first step would be to check to see if you can run DML within a
Prepared statement. After that, we can start to explore whether this can be
done at all.
Cheers,
Clinton
On 7/21/05, Mississippi John Hurt <jo...@gmail.com> wrote:
>
> Hi,
>
> 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. Can I do this with iBatis? If so how? From what I
> understand iBatis can only map SQL and a single stored procedure. How would
> I map say, something like a script with DML (ALTER TABLE) followed by a
> block of anonymous PL/SQL? Thanks.
>
Re: M:N example
Posted by Mississippi John Hurt <jo...@gmail.com>.
Hi,
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. Can I do this with iBatis? If so how? From what I
understand iBatis can only map SQL and a single stored procedure. How would
I map say, something like a script with DML (ALTER TABLE) followed by a
block of anonymous PL/SQL? Thanks.