Oh, and you'll probably need to specify a resultClass (or resultMap, if you have one setup). Specifying remapResults="true" won't hurt, either (especially with a resultMap specification).
On Tue, 22 Mar 2005 11:29:39 -0600, Brice Ruth <[EMAIL PROTECTED]> wrote: > 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 > <[EMAIL PROTECTED]> wrote: > > create a generic statement in a sqlmap > > <statement id="Execute" parameterClass="string"> > > #string > > </statement> > > > > > > -----Original Message----- > > From: Steven Pannell [mailto:[EMAIL PROTECTED] > > 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. > > >
