ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Kulkarni <ashish.kulkarn...@gmail.com>
Subject Re: Issue with SQL query in ibatis
Date Fri, 20 Feb 2009 20:52:34 GMT
Hican you please explain what do you there are no parameter markers

<select id="getEnvNames"
resultClass="com.pfizer.maps.base.data.file.EnvNames"
parameterClass="com.pfizer.maps.base.data.file.EnvNames">
SELECT TYPE, AS400NAME, ENVNAME, ENVDESC, DISABLED, INIPROG,
INIPGMLIB, USERID, PASS_WRD, MAPSLOGINR FROM EnvNames WHERE TYPE =tYPE and
AS400NAME =aS400Name and ENVNAME=eNVNAME
</select>

i have TYPE=tYPE, which i expect to work as marker, the EnvNames class has
get and set method for tYPE, aS400NAME
What am i suppose to do to modify this query


On Fri, Feb 20, 2009 at 3:47 PM, Larry Meadors <larry.meadors@gmail.com>wrote:

> The first mapped statement doesn't appear to have any parameter
> markers in it. :-/
>
> Larry
>

Mime
View raw message