ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Leucht, Axel" <Axel.Leu...@prodv.de>
Subject Select with dynamic where
Date Wed, 19 May 2010 07:49:30 GMT
I'm currently having one problem with iBATIS-3.

My test bed runs fine with iBATIS-2 and I have a problem with one select
statement which inserts a dynamic where clause.
The parameters, which are plain strings, are not inserted into the sql
command. 

	<select id="getSomeStudents" resultType="entities.Student"
		parameterType="list">
		select name,descr as description from student where name
in 
		<foreach item="item" index="index" collection="list"
			open="(" separator="," close=")">
				#{value,jdbcType=VARCHAR}
		</foreach>
	</select>

In Java-Code
	    List<String> props = new ArrayList<String>();
	    props.add("string1");
	    props.add("string2");
	    props.add("string3");
	    List<Student> listStudenten =
sqlSession.selectList("Student.getEinigeStudenten", props);

The log shows that the sql don't contain the parameters given.

DEBUG [main] - ==>  Executing: select name,descr as description from
student where name in ( ? , ? , ? ) 
DEBUG [main] - ==> Parameters: null, null, null

What is wrong with my approach?

/Axel

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message