ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kai Grabfelder <nos...@kaigrabfelder.de>
Subject Re: Trouble with SQL SERVER 2005
Date Thu, 14 May 2009 19:44:13 GMT
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,


Mime
View raw message