ups, thats of course the correct answer to your question ;-)
--- Original Nachricht ---
Absender: christopher.mathru...@sybase.com
Datum: 14.05.2009 22:14
> Make the following change below and give it a try.
>
> <resultMap id="RegionResult" class="myapp.models.Region">
> <result property="regionId" column="region_id"/>
> <result property="regionName" column="region_name"/>
> </resultMap>
>
> <select id="selectAllRegion" resultMap="RegionResult">
> select region_id,region_name from Region
> </select>
> </sqlMap>
>
>
>
>
>
>
> Abdel Olakara <olak...@gmail.com>
> 05/14/2009 12:29 PM
> Please respond to
> user-java@ibatis.apache.org
>
>
> To
> user-java@ibatis.apache.org
> cc
>
> Subject
> Trouble with SQL SERVER 2005
>
>
>
>
>
>
>
> Hi all,
>
> I am using Sql server 2005 with iBATIS in my project. I am using
> Microsoft provided driver for my connectivity..here is my sqlMapConfig
> file:
>
> <sqlMapConfig>
>
>
> <transactionManager type="JDBC" commitRequired="false">
> <dataSource type="SIMPLE">
> <property name="JDBC.Driver"
> value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
> <property name="JDBC.ConnectionURL"
> value="jdbc:sqlserver://localhost:5356;databaseName=testdb"/>
> <property name="JDBC.Username" value="sam"/>
> <property name="JDBC.Password" value="sam"/>
> <property name="JDBC.DefaultAutoCommit" value="true" />
> </dataSource>
> </transactionManager>
>
> <sqlMap resource="myapp/models/Population.xml"/>
> <sqlMap resource="myapp/models/Region.xml"/>
> </sqlMapConfig>
>
> There is no error as such in connecting and querying but the values are
> not populated into the bean. here is my region.xml
>
> <sqlMap namespace="Region">
>
> <resultMap id="RegionResult" class="myapp.models.Region">
> <result property="regionId" column="region_id"/>
> <result property="regionName" column="region_name"/>
> </resultMap>
>
> <select id="selectAllRegion" resultClass="myapp.models.Region">
> select region_id,region_name from Region
> </select>
> </sqlMap>
>
> both reagion_id and region_name populated in the bean is null values..
> where as.. for my other object ir Population, population_id comes up but
> other values are null.
> The values are available in DB and normal JDBC programming can retrive the
> values.
>
> Can anybody give me a solution?
>
> Thanks in advance,
