Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----_=_NextPart_001_01C52EF8.C369FF16"
Subject: RE: execute SQL statement that are not in a map
Date: Tue, 22 Mar 2005 16:00:05 -0000
Message-ID: <6216396AEBE36247BF62B505A88ADA0A138104@uk-ex002.groupinfra.com>
Thread-Topic: execute SQL statement that are not in a map
Thread-Index: AcUu8lxxfRJ6otrkQv6F6LIc0xfBmQABdqPA
From: "James, Steven" <Steven.James@logicacmg.com>
To: <ibatis-user-java@incubator.apache.org>

This is a multi-part message in MIME format.

------_=_NextPart_001_01C52EF8.C369FF16
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

create=20a=20generic=20statement=20in=20a=20sqlmap=20
<statement=20id=3D"Execute"=20parameterClass=3D"string">
=20=20=20=20=20#string
</statement>


-----Original=20Message-----
From:=20Steven=20Pannell=20[mailto:steven.pannell@zooplus.com]
Sent:=20Tue=203/22/2005=203:16=20PM
To:=20'ibatis-user-java@incubator.apache.org'
Subject:=20execute=20SQL=20statement=20that=20are=20not=20in=20a=20map
=20
Hi,

I=20build=20some=20SQL=20statements=20in=20java=20and=20want=20to=20execut=
e=20them=20on=20the=20DB.=20=20As
I=20don't=20have=20a=20iBatis-map=20for=20these=20(they=20are=20build=20dy=
namically)=20what=20is=20the
best=20way=20to=20execute=20the=20statements=20on=20the=20db.=20the=20SqlM=
apClient=20does=20not=20have
any=20kind=20of=20execute=20method.=20The=20only=20thing=20I=20came=20up=20=
with=20at=20the=20moment=20was:

=09
client.getDataSource().getConnection().prepareStatement(mysql).executeQuer=
y(
)

Bit=20nasty...

Any=20ideas?

Thanks,
Steve.


This=20e-mail=20and=20any=20attachment=20is=20for=20authorised=20use=20by=20=
the=20intended=20recipient(s)=20only.=20It=20may=20contain=20proprietary=20=
material,=20confidential=20information=20and/or=20be=20subject=20to=20lega=
l=20privilege.=20It=20should=20not=20be=20copied,=20disclosed=20to,=20reta=
ined=20or=20used=20by,=20any=20other=20party.=20If=20you=20are=20not=20an=20=
intended=20recipient=20then=20please=20promptly=20delete=20this=20e-mail=20=
and=20any=20attachment=20and=20all=20copies=20and=20inform=20the=20sender.=
=20Thank=20you.
------_=_NextPart_001_01C52EF8.C369FF16
Content-Type: application/ms-tnef;
	name="winmail.dat"
Content-Transfer-Encoding: base64

eJ8+IgIQAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEgAEAMAAAAFJFOiBleGVjdXRlIFNRTCBz
dGF0ZW1lbnQgdGhhdCBhcmUgbm90IGluIGEgbWFwAFkQAQWAAwAOAAAA1QcDABYAEAAAAAUAAgAM
AQEggAMADgAAANUHAwAWABAABAABAAIADAEBCYABACEAAABDNjQ0Qzc5ODRCM0E2RTRBOUUzQ0RC
RDMwQjE2MEQ1RABdBwEDkAYA+AkAADgAAAADACYAAAAAAAMANgAAAAAAQAA5AKvUADf4LsUBHgA9
AAEAAAAFAAAAUkU6IAAAAAACAUcAAQAAADAAAABjPXVzO2E9IDtwPU1haWw7bD1VSy1FWDAwMi0w
NTAzMjIxNjA0MDFaLTM5MjI2MgAeAEkAAQAAACwAAABleGVjdXRlIFNRTCBzdGF0ZW1lbnQgdGhh
dCBhcmUgbm90IGluIGEgbWFwAEAATgAAyPcg8i7FAR4AWgABAAAADwAAAFN0ZXZlbiBQYW5uZWxs
AAACAVsAAQAAAEcAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAAAABTdGV2ZW4gUGFubmVsbABTTVRQ
AHN0ZXZlbi5wYW5uZWxsQHpvb3BsdXMuY29tAAACAVwAAQAAACAAAABTTVRQOlNURVZFTi5QQU5O
RUxMQFpPT1BMVVMuQ09NAB4AXQABAAAADwAAAFN0ZXZlbiBQYW5uZWxsAAACAV4AAQAAAEcAAAAA
AAAAgSsfpL6jEBmdbgDdAQ9UAgAAAABTdGV2ZW4gUGFubmVsbABTTVRQAHN0ZXZlbi5wYW5uZWxs
QHpvb3BsdXMuY29tAAACAV8AAQAAACAAAABTTVRQOlNURVZFTi5QQU5ORUxMQFpPT1BMVVMuQ09N
AB4AZgABAAAABQAAAFNNVFAAAAAAHgBnAAEAAAAbAAAAc3RldmVuLnBhbm5lbGxAem9vcGx1cy5j
b20AAB4AaAABAAAABQAAAFNNVFAAAAAAHgBpAAEAAAAbAAAAc3RldmVuLnBhbm5lbGxAem9vcGx1
cy5jb20AAB4AcAABAAAALAAAAGV4ZWN1dGUgU1FMIHN0YXRlbWVudCB0aGF0IGFyZSBub3QgaW4g
YSBtYXAAAgFxAAEAAAAbAAAAAcUu8lxxfRJ6otrkQv6F6LIc0xfBmQABdqPAAB4AdAABAAAAKAAA
ACdpYmF0aXMtdXNlci1qYXZhQGluY3ViYXRvci5hcGFjaGUub3JnJwAeABoMAQAAAA4AAABKYW1l
cywgU3RldmVuAAAAHgAdDgEAAAAsAAAAZXhlY3V0ZSBTUUwgc3RhdGVtZW50IHRoYXQgYXJlIG5v
dCBpbiBhIG1hcAACAQkQAQAAAAgDAAAEAwAAmAQAAExaRnXbgG5LAwAKAHJjcGcxMjXiMgNDdGV4
BUEBAwH3/wqAAqQD5AcTAoAP8wBQBFY/CFUHshElDlEDAQIAY2jhCsBzZXQyBgAGwxEl9jMERhO3
MBIsETMI7wn3tjsYHw4wNREiDGBjAFCzCwkBZDM2FlALpiAFAIRlYQ6wIGEgZwnw8QZxYyBzAZAO
sAeAAjBGIAuAHVFzcWwAwHALCuMKgDweCWQ9IkVKeAWQdQ6wIiAKsWHzB4AOsHJDC2AEECCQHgCh
BRBuZyI+H2QgIyJ2IyJEH2UvHgcitSUKLfUmIk8FEGcLgAdABdAHkFxzYR2AJiMfZEYDYTrLBgAO
sHYJ8CBQAHAdoBpsAyBbAMADEHRvOhseACiiLgqwKRNAem8ibwtQdXMuBaBtXS8fZAZgAjAoYFQK
UCAziC8yMiywMDA1LJCoOjE2KOBNH2RUKdCwICdpYh0gBAAtKzCBBJAtamF2YUALgDcg4C5xBbAu
HzAA0Ghlsi4FsGcnK6UvoGoFkE8sMQ7AINMGAFFMHfl0zxPgBUAKwB1Abm8ehR8hIyLFH2RIaSwl
Ckkg9GJ1AxBkHfADcDIdBCDXHqEvIh1QbjaAdwBwMvFubzGnMxAeQCACIDmSIEhEQi4jIEFzNcZk
PQIgJwVAE+AosB1RaUI/LoMfIgIQBcA5oRQQIChNOaF5M1M2RGR5JsBt4w3gB0BseSk4kDMiBAD7
OZIfZGIHkAVAOKA9sDj8szcqOfVkYjqAOiJTHwD+TR8wIdAIkB5xO1AHkTOibzuyH2QAcD2wawuA
NoBvtmYxpyGBaARwOoBUOjHvAiA/ADMBInEgNiA+0DbB/nUfQAPwMxAdUDLyRpE2sXMecTigczol
CwGRH1VjJUPjLh2AdEQdIGFT4QhhY2UoKUwCCFApEW0xcGkCIEzhcBggCrFl4yiAHiUobXke8Uzw
MbWiUQpQcnkoH2QpJQqOQkjQM5Ah8HR5LlIgnSUKQUWBIHAdEHM/JQpzRzAAcGtzNVUog1JLfQFW
cB4ANRABAAAAQQAAADw2MjE2Mzk2QUVCRTM2MjQ3QkY2MkI1MDVBODhBREEwQTEzODEwNEB1ay1l
eDAwMi5ncm91cGluZnJhLmNvbT4AAAAAHgBHEAEAAAAPAAAAbWVzc2FnZS9yZmM4MjIAAAsA8hAB
AAAAHwDzEAEAAABsAAAAUgBFACUAMwBBACAAZQB4AGUAYwB1AHQAZQAgAFMAUQBMACAAcwB0AGEA
dABlAG0AZQBuAHQAIAB0AGgAYQB0ACAAYQByAGUAIABuAG8AdAAgAGkAbgAgAGEAIABtAGEAcAAu
AEUATQBMAAAACwD2EAAAAABAAAcwq9QAN/guxQFAAAgwKep1w/guxQEDAN4/r28AAAMA8T8JBAAA
HgD4PwEAAAAOAAAASmFtZXMsIFN0ZXZlbgAAAAIB+T8BAAAAQgAAAAAAAADcp0DIwEIQGrS5CAAr
L+GCAQAAAAAAAAAvTz1NQUlML09VPVVLL0NOPVJFQ0lQSUVOVFMvQ049SkFNRVNTAAAAHgD6PwEA
AAAVAAAAU3lzdGVtIEFkbWluaXN0cmF0b3IAAAAAAgH7PwEAAAAeAAAAAAAAANynQMjAQhAatLkI
ACsv4YIBAAAAAAAAAC4AAAADAP0/5AQAAAMAGUAAAAAAAwAaQAAAAAADAB1AAAAAAAMAHkAAAAAA
HgAwQAEAAAAHAAAASkFNRVNTAAAeADFAAQAAAAcAAABKQU1FU1MAAB4AMkABAAAAGwAAAHN0ZXZl
bi5wYW5uZWxsQHpvb3BsdXMuY29tAAAeADNAAQAAABsAAABzdGV2ZW4ucGFubmVsbEB6b29wbHVz
LmNvbQAAHgA4QAEAAAAHAAAASkFNRVNTAAAeADlAAQAAAAIAAAAuAAAAAwB2QP////8LACkAAAAA
AAsAIwAAAAAAAwAGEDlBRDIDAAcQbAIAAAMAEBAAAAAAAwAREAEAAAAeAAgQAQAAAGUAAABDUkVB
VEVBR0VORVJJQ1NUQVRFTUVOVElOQVNRTE1BUDxTVEFURU1FTlRJRD0iRVhFQ1VURSJQQVJBTUVU
RVJDTEFTUz0iU1RSSU5HIiNTVFJJTkc8L1NUQVRFTUVOVC0tLS0tAAAAAAIBfwABAAAAQQAAADw2
MjE2Mzk2QUVCRTM2MjQ3QkY2MkI1MDVBODhBREEwQTEzODEwNEB1ay1leDAwMi5ncm91cGluZnJh
LmNvbT4AAAAAeXQ=

------_=_NextPart_001_01C52EF8.C369FF16--