Ok Guys I got the problem fixed. I have the iBatis tutorial and had the same problems as Senthilmurugan
And I fixed the problem. Here are attached xml files ________________________________ From: Dorin Manoli [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 4:31 PM To: [email protected] Subject: RE: Problem in SqlMapConfig.xsd configuration - Reg. I got the same problem configuring iBATIS tutorial project. Look in your sqlmap.config file. If there is a node <providers .../> If not add : <providers resource ="providers.config"/> ________________________________ From: Senthilmurugan, ANGLER - EIT [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 5:24 AM To: [email protected] Subject: RE: Problem in SqlMapConfig.xsd configuration - Reg. Hi Nikhil, Thanks for your response. I replaced the line as you said, That error has gone now. It goes to next step. While executing the application, the following exception was thrown. "Error while configuring the Provider named "OleDb1.1". Cause : The provider is not in 'providers.config' or is not enabled" The provider is there, But It was not enabled. So I enabled it in "providers.config file". But still it shows the same error. Do you have any idea. please help me. Thanks & regards Senthilmurugan.B ________________________________ From: Nikhil Vaghela [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 9:38 AM To: [email protected] Subject: RE: Problem in SqlMapConfig.xsd configuration - Reg. I guess the problem is in your sqlmap.config See if it works by replacing your xml name sapace with <sqlMapConfig xmlns="http://ibatis.apache.org/dataMapper"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> in your config file. Nikhil. ________________________________ From: Senthilmurugan, ANGLER - EIT [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 9:24 AM To: [email protected] Cc: Gopinath, ANGLER - EIT; Giridhar, ANGLER - CTO Subject: RE: Problem in SqlMapConfig.xsd configuration - Reg. Hi, I am using "IBatisNet.DataMapper-bin-1.5.1". I have attached the above files for your ref. Since it is my first application, I got struck. So help me to come out of this problem. Thanks in advance. Senthilmurugan ________________________________ From: Prosper [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 14, 2006 7:42 PM To: [email protected] Subject: Re: Problem in SqlMapConfig.xsd configuration - Reg. Hi, check the schema of your different Ibatis config file (sqlmap,properties)according to the version of Ibatis you are using. Can you post sqlmap.config and give more info on the version of ibatis you use? Regards "Senthilmurugan, ANGLER - EIT" <[EMAIL PROTECTED]> wrote: I have created new Asp.net application and configured everything. But I faced the following error. please help me. Invalid SqlMap.config document. cause :Cannot load schema for the namespace '' - Could not find file "C:\WINDOWS\system32\SqlMapConfig.xsd".. An error occurred at , (1, 2). The 'sqlMapConfig' element is not declared. An error occurred at , (1, 2). The 'properties' element is not declared. An error occurred at , (3, 6). Could not find schema information for the attribute 'resource'. An error occurred at , (3, 17). The 'settings' element is not declared. An error occurred at , (5, 3). The 'setting' element is not declared. An error occurred at , (5, 13). Could not find schema information for the attribute 'useStatementNamespaces'. An error occurred at , (5, 21). The 'setting' element is not declared. An error occurred at , (5, 55). Could not find schema information for the attribute 'cacheModelsEnabled'. An error occurred at , (5, 63). The 'setting' element is not declared. An error occurred at , (5, 92). Could not find schema information for the attribute 'validateSqlMap'. An error occurred at , (5, 100). The 'database' element is not declared. An error occurred at , (5, 136). The 'provider' element is not declared. An error occurred at , (5, 146). Could not find schema information for the attribute 'name'. An error occurred at , (5, 155). The 'dataSource' element is not declared. An error occurred at , (5, 177). Could not find schema information for the attribute 'name'. An error occurred at , (5, 188). Could not find schema information for the attribute 'connectionString'. An error occurred at , (5, 210). The 'sqlMaps' element is not declared. An error occurred at , (5, 263). The 'sqlMap' element is not declared. An error occurred at , (5, 272). Could not find schema information for the attribute 'resource'. An error occurred at , (5, 279). Thanks in Advance Regards Senthilmurugan ________________________________ Everyone is raving about the all-new Yahoo! Mail beta. <http://us.rd.yahoo.com/evt=45083/*http:/advision.webevents.yahoo.com/ma ilbeta>
<?xml version="1.0" encoding="utf-8" ?> <sqlMap namespace="Person" xmlns="http://ibatis.apache.org/mapping"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> <!-- XML "behind" document for the People service class. --> <alias> <typeAlias alias="Person" type="iBatisTutorial.Model.Person, iBatisTutorial.Model" /> </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"> 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"> 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"> delete from PERSON where PER_ID = #value# </delete> </statements> </sqlMap>
sqlmap.config
Description: sqlmap.config
