ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: Temp table
Date Mon, 20 Mar 2006 23:33:34 GMT
Write a stored procedure?

Larry


On 3/20/06, Suman.Mishra@ubs.com <Suman.Mishra@ubs.com> wrote:
>
> Thanks Sven.
>
> Is there any workaround if I want to have multiple statements.
>
>
> Thanks in advance,
> -suman
>
>
>
> -----Original Message-----
> From: Sven Boden [mailto:list123@pandora.be]
> Sent: Monday, March 20, 2006 4:56 PM
> To: user-java@ibatis.apache.org
> Subject: Re: Temp table
>
>
> Probably not, most drivers want a single SQL statement when using
> PreparedStatements.
>
> Regards,
> Sven
>
> Suman.Mishra@ubs.com wrote:
>
> >Hi,
> >
> >Can I use something like this -
> >
> ><select id = "xxx" resultClass="ABC1" parameterClass="ABC2">
> >
> >Select * from T where <>
> >
> >insert into #temp
> >Select * from T where <>
> >
> >Select * from #temp
> >
> ></select>
> >
> >
> >
> >Regards,
> >Suman Mishra
> >203-719-1698
> >
> >
> >
> >
> >
> >-----------------------------------------------------------------------
> >-
> >
> >
> >Visit our website at http://www.ubs.com
> >
> >This message contains confidential information and is intended only for
>
> >the individual named.  If you are not the named addressee you should
> >not disseminate, distribute or copy this e-mail.  Please notify the
> >sender immediately by e-mail if you have received this e-mail by
> >mistake and delete this e-mail from your system.
> >
> >E-mail transmission cannot be guaranteed to be secure or error-free as
> >information could be intercepted, corrupted, lost, destroyed, arrive
> >late or incomplete, or contain viruses.  The sender therefore does not
> >accept liability for any errors or omissions in the contents of this
> >message which arise as a result of e-mail transmission.  If
> >verification is required please request a hard-copy version.  This
> >message is provided for informational purposes and should not be
> >construed as a solicitation or offer to buy or sell any securities or
> >related financial instruments.
> >
> >
>
>
> Visit our website at http://www.ubs.com
>
> This message contains confidential information and is intended only
> for the individual named.  If you are not the named addressee you
> should not disseminate, distribute or copy this e-mail.  Please
> notify the sender immediately by e-mail if you have received this
> e-mail by mistake and delete this e-mail from your system.
>
> E-mail transmission cannot be guaranteed to be secure or error-free
> as information could be intercepted, corrupted, lost, destroyed,
> arrive late or incomplete, or contain viruses.  The sender therefore
> does not accept liability for any errors or omissions in the contents
> of this message which arise as a result of e-mail transmission.  If
> verification is required please request a hard-copy version.  This
> message is provided for informational purposes and should not be
> construed as a solicitation or offer to buy or sell any securities or
> related financial instruments.
>
>

Mime
View raw message