You have <select id="getModuleLevelList" resultClass="moduleLevel"
specified, instead of probably meaning <select id="getModuleLevelList" resultMap="moduleLevelResult" The former way you currnetly have, would look for a "setLevelNo(..)" method in your class (to correspond with the LEVEL_NO column), and therefore "level" would be empty. HTH. On Sun, 27 Feb 2005 18:24:07 +0000, Tim Christopher <[EMAIL PROTECTED]> wrote: > Hi, > > I've got a table with 1 column that has 3 rows of data. When I run my > app it returns a Collection of object of the correct type but whose > fields (there is only one field) are null... So in the page that > loads if I iterate the collection it prints something like: The next > value is , The next value is , The next value is. [3 times - one per > row of db]. > > This is my sqlMap, and : > > <?xml version="1.0" encoding="UTF-8" standalone="no"?> > <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" > "http://www.ibatis.com/dtd/sql-map-2.dtd";> > <sqlMap namespace="ModuleLevel"> > <typeAlias alias="moduleLevel" type="com.domain.ModuleLevel"/> > <cacheModel id="module_level_cache" type="LRU" readOnly="true"> > <flushInterval hours="24" /> > </cacheModel> > <resultMap id="moduleLevelResult" class="moduleLevel"> > <result property="level" column="LEVEL_NO"/> > </resultMap> > <select id="getModuleLevelList" resultClass="moduleLevel"> > <![CDATA[ > select LEVEL_NO from MODULE_LEVEL > ]]> > </select> > </sqlMap> > > My ModuleLevel domain object contains an empty constructor and a > private variable 'level', along the a get and set method for it > > I have tested it within my Java (Struts) Action file using the following code: > > List levels = moduleLevelService.getModuleLevelList(); > if (levels.get(0) instanceof ModuleLevel) { > System.out.println ("This line is always printed"); > } > ModuleLevel a = (ModuleLevel) t_levels.get(0); > System.out.println ("This always prints null: " + a.getLevel()); > System.out.println ("This always prints 3: " + levels.size()); > > Has anyone got any ideas? I've spent hours looking at it, and I'm > sure it's only some silly mistake that's causing the problem :-( > > Tim Christopher >
