ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brice Ruth <bdr...@gmail.com>
Subject Re: execute SQL statement that are not in a map
Date Tue, 22 Mar 2005 17:29:39 GMT
you'll probably need to reference the string as $value$, unless you're
using a syntax I'm not familiar with.


On Tue, 22 Mar 2005 16:00:05 -0000, James, Steven
<Steven.James@logicacmg.com> wrote:
> create a generic statement in a sqlmap
> <statement id="Execute" parameterClass="string">
>      #string
> </statement>
> 
> 
> -----Original Message-----
> From: Steven Pannell [mailto:steven.pannell@zooplus.com]
> Sent: Tue 3/22/2005 3:16 PM
> To: 'ibatis-user-java@incubator.apache.org'
> Subject: execute SQL statement that are not in a map
> 
> Hi,
> 
> I build some SQL statements in java and want to execute them on the DB.  As
> I don't have a iBatis-map for these (they are build dynamically) what is the
> best way to execute the statements on the db. the SqlMapClient does not have
> any kind of execute method. The only thing I came up with at the moment was:
> 
> client.getDataSource().getConnection().prepareStatement(mysql).executeQuery(
> )
> 
> Bit nasty...
> 
> Any ideas?
> 
> Thanks,
> Steve.
> 
> This e-mail and any attachment is for authorised use by the intended recipient(s) only.
It may contain proprietary material, confidential information and/or be subject to legal privilege.
It should not be copied, disclosed to, retained or used by, any other party. If you are not
an intended recipient then please promptly delete this e-mail and any attachment and all copies
and inform the sender. Thank you.
>

Mime
View raw message