Hm strange. Which version of iBATIS are you using? I don't have much experience with SQLServer the only thing I can tell you is that we are using the jdts opensource JDBC. And I think we never had such problems with iBATIS.
cheers Kai --- Original Nachricht --- Absender: Abdel Olakara Datum: 14.05.2009 21:29 > 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,
