What's the inner exception?
Alastair Handley wrote:
Hello to all.
I am making use of the DAO and DataMapper Frameworks using .NET 2.0
I am new to Ibatis and have created a small application (driven by
NUnit) which allows me to do simple CRUD operations on a single
database table. In addiiton I have made use of IBatis so that I can
support multiple databases. In my case I send different users to
different databases for their specific data.
Everything was working until I added another alias type and result map
to my only SQLMap.xml file. As soon as I made that change I get the
following error ....
Failsafe.HomeServe.Domain.PunchListTest (TestFixtureSetUp) :
- The error occurred while configure DaoSessionHandler.
- The error occurred in <property name="resource"
value="sqlmap.config" xmlns=" http://ibatis.apache.org/dataAccess"; />.
- Check the
IBatisNet.DataAccess.DaoSessionHandlers.SqlMapDaoSessionHandler .
My SQLMap.xml contains the following ....
<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
" http://ibatis.apache.org/dtd/sql-map-2.dtd";>
<sqlMap namespace="Failsafe.HomeServe.Domain"
xmlns="http://ibatis.apache.org/mapping";
xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance";>
<alias>
<typeAlias alias="PunchList"
type="Failsafe.HomeServe.Domain.PunchList, Failsafe.HomeServe.Domain" />
<typeAlias alias="PunchListItem"
type="Failsafe.HomeServe.Domain.PunchListItem ,
Failsafe.HomeServe.Domain" />
</alias>
<resultMaps>
<resultMap id="Select-PunchList-Result" class="PunchList">
<result property="guid" column="listID" dbType ="UniqueIdentifier" />
<result property="name" column="Name" />
<result property="startDate" column="StartDate"/>
<result property="endDate" column="EndDate"/>
</resultMap>
<resultMap id="SelectPunchListItem" class="PunchListItem">
<result property="guidx" column="listItemID" dbType
="UniqueIdentifier" />
<result property="namex" column="Name" />
<result property="startDatex" column="StartDate"/>
<result property="endDatex" column="EndDate"/>
</resultMap>
</resultMaps>
<statements>
<insert id="Insert" parameterClass="PunchList">
insert into List
(ListID, Name, StartDate, EndDate)
values
(#guid#, #name#, #startDate#, #endDate#)
</insert>
<select id="Select" parameterClass="Guid"
resultMap="Select-PunchList-Result">
select * from List
<dynamic prepend="WHERE">
<isParameterPresent>
ListID = #value#
</isParameterPresent>
</dynamic>
</select>
</statements>
</sqlMap>
......
If I remove the second resultMap definition everything works OK. Can
someome enlighten me as to what I am doing wrong?
Thanks
Alastairt
--
Bruno Silva
Cool Advance - Information Systems
http://www.cooladvance.com/
