ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ron Grabowski <rongrabow...@yahoo.com>
Subject RE: execute SQL statement that are not in a map
Date Wed, 23 Mar 2005 13:52:06 GMT
Use dollar signs around value instead of pound signs:

 $value$

--- Steven Pannell <steven.pannell@zooplus.com> wrote:
> Hi,
> 
> I tried this to execute my dynamic SQL statement but does not work. 
> anyone
> an idea how to resolve this???
> The SQL statements have to be built in the java code, so I cannot use
> a
> standard map.
> 
> 
> 	<statement id="execute-rule" parameterClass="string"
> resultClass="long" >
> 		<![CDATA[
> 			#value#
> 		]]>
> 	</statement>
> 
> //Java code
> 
> client.insert("execute-rule","insert into myTable(id) values (1)");
> 
> 
> THX,
> steve.
> 
> 
> -----Original Message-----
> From: James, Steven [mailto:Steven.James@logicacmg.com]
> Sent: 22 March 2005 17:00
> To: ibatis-user-java@incubator.apache.org
> Subject: RE: execute SQL statement that are not in a map
> 
> 
> 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