Glad that was it! If I had to guess, the reason that the "auto mapping" of columns to properties doesn't throw errors is for instances in which you want to have a SQL statement with feilds that aren't mapped to object properties (I can think of a few SQL statements with subselects referencing fields in the "parent" SQL that this would be 'advantageous').
Of course, one of the iBATIS devs could comment with more certainty ;) On Sun, 27 Feb 2005 19:55:51 +0000, Tim Christopher <[EMAIL PROTECTED]> wrote: > Cheers, that was it! > > Turns out as I just copy an old SQLMap to use as a starting point for > each new one (as they have a lot in common) the one I origonally > copied had an error in! However the origonal one still worked at the > db and the java object had the same names for the attributes. > > Guess I'll know better for next time... Though if it was trying to > call setLevelNo(..) I'd have thought this would have thrown an error > during the build or at runtime, as that method doesn't exist. > > Tim Christopher > > On Sun, 27 Feb 2005 13:53:11 -0500, Phil Barnes > <[EMAIL PROTECTED]> wrote: > > 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 > > > > > >
