Thanks! Could have figured this out myself :). However I didn't questioned the tutorial code. Apparently the tutorial is not up-to-date.
Now the C# build goes well. Until when I call the test class, the following error occurred: IBatisNet.Common.Exceptions.ConfigurationException was unhandled Message="\r\n- The error occurred while loading SqlMap.\r\n- The error occurred in <sqlMap resource=\"PersonMapper.xml\" xmlns=\"http://ibatis.apache.org/dataMapper\"; />." Source="IBatisNet.DataMapper" I placed the personmapper.xml in the same directory as sqlmap.config to avoid path errors. The sqlmap.config is listed below ************************************************ <?xml version="1.0" encoding="utf-8"?> <sqlMapConfig xmlns="http://ibatis.apache.org/dataMapper"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> <properties resource="properties.config"/> <providers resource="providers.config"/> <!-- Database connection information --> <database> <provider name="sqlServer1.1"/> <dataSource name="iBatisTutorial" connectionString="${connectionString}"/> </database> <sqlMaps> <sqlMap resource="PersonMapper.xml"/> </sqlMaps> </sqlMapConfig> The PersonMapper.xml is listed below: ************************************************ <?xml version="1.0" encoding="utf-8" ?> - <!-- sqlMap namespace="Person" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:noNamespaceSchemaLocation="SqlMap.xsd" --> - <sqlMap namespace="Person" xmlns="http://ibatis.apache.org/dataMapper"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> - <!-- XML "behind" document for the People service class. --> - <alias> <typeAlias alias="Person" type="iBatis.Person, iBatis" /> </alias> - <resultMaps> - <resultMap id="SelectResult" class="Person"> <result property="Id" column="PER_ID" /> <result property="FirstName" column="PER_FIRST_NAME" /> <result property="LastName" column="PER_LAST_NAME" /> <result property="BirthDate" column="PER_BIRTH_DATE" /> <result property="WeightInKilograms" column="PER_WEIGHT_KG" /> <result property="HeightInMeters" column="PER_HEIGHT_M" /> </resultMap> </resultMaps> - <statements> - <select id="Select" parameterClass="int" resultMap="SelectResult"> select PER_ID, PER_FIRST_NAME, PER_LAST_NAME, PER_BIRTH_DATE, PER_WEIGHT_KG, PER_HEIGHT_M from PERSON - <dynamic prepend="WHERE"> <isParameterPresent>PER_ID = #value#</isParameterPresent> </dynamic> </select> <insert id="Insert" parameterClass="Person" resultClass="int">insert into PERSON (PER_ID, PER_FIRST_NAME, PER_LAST_NAME, PER_BIRTH_DATE, PER_WEIGHT_KG, PER_HEIGHT_M) values (#Id#, #FirstName#, #LastName#, #BirthDate#, #WeightInKilograms#, #HeightInMeters#)</insert> <update id="Update" parameterClass="Person" resultClass="int">update PERSON set PER_FIRST_NAME = #FirstName#, PER_LAST_NAME = #LastName#, PER_BIRTH_DATE = #BirthDate#, PER_WEIGHT_KG = #WeightInKilograms#, PER_HEIGHT_M = #HeightInMeters# where PER_ID = #Id#</update> <delete id="Delete" parameterClass="int" resultClass="int">delete from PERSON where PER_ID = #value#</delete> </statements> </sqlMap> ************************************************ Any help is highly appreciated. -Frank -----Oorspronkelijk bericht----- Van: Brian Elcock [mailto:[EMAIL PROTECTED] Verzonden: maandag 22 oktober 2007 22:14 Aan: [email protected] Onderwerp: Re: Newbie ibatis Tutorial Error Frank. I'm guessing that you're using a more recent version of IBatis than was used in the tutorial. The API changed a bit back somewhere between 1.2 and 1.3, so you won't be able to run the tutorial as written if you're using the latest version of the binaries. I can't remember the exact details. If you want to run the tutorial as written, you'll need to download an older version of the binaries. Otherwise, you'll need to look at the code and adjust it per Tom's suggestions. Regards. Brian On 10/22/07, Nguyen, Tom <[EMAIL PROTECTED]> wrote: > > > > > As the error said, you have two choices: > > > > > > public ISqlMapper Mapper() > > { > > return IBatisNet.DataMapper.Mapper.Instance(); > > } > > > > Or: > > public SqlMapper Mapper() > > { > > return (IBatisNet.DataMapper.Mapper.Instance() as > SqlMapper); > > } > > > > > > > Regards, > > > Tom Nguyen > Sr. Developer > [EMAIL PROTECTED] > > > > ________________________________ > > > From: Frank van Tour [mailto:[EMAIL PROTECTED] > Sent: Monday, October 22, 2007 2:46 PM > To: [email protected] > Subject: Newbie ibatis Tutorial Error > > > > Hi , > > > > Just started with ibatis tutorial 1.2.1. ( the .net 2.0 tutorial URL failed > to download ??). > > In the singleton class ( as listed below ) I got the following error (Using > VS2005 and .Net 2.0) > > > > > > Cannot implicitly convert type 'IBatisNet.DataMapper.ISqlMapper' to > 'IBatisNet.DataMapper.SqlMapper'. > > An explicit conversion exists (are you missing a cast?) > > > > Any clues what's going on here? > > > > -Frank > > > > using IBatisNet.DataMapper; > > > > namespace iBatis > > { > > /// <summary> > > /// Base class for Mapper objects (*Mapper). > > /// Provides shared utility methods. > > /// </summary> > > public abstract class MapperBase > > { > > public SqlMapper Mapper() > > { > > return IBatisNet.DataMapper.Mapper.Instance (); > > } > > } > > } > > > > ________________________________ > > > > > This e-mail message and any files transmitted herewith, are intended solely > for the use of the individual(s) addressed and may contain confidential, > proprietary or privileged information. If you are not the addressee > indicated in this message (or responsible for delivery of this message to > such person) you may not review, use, disclose or distribute this message or > any files transmitted herewith. If you receive this message in error, > please contact the sender by reply e-mail and delete this message and all > copies of it from your system. > > ________________________________ > > > > > > > > > > >
