Base on this line:
> Cause: Could not load type from string value 'participant'.]
And the XML you provided.
I do not see a definition of type alias for 'participant' which could be
the cause of error.
<alias>
<typeAlias alias="participant" type="YourAssembly.participant,
YourAssembly" />
</alias>
Regards,
Tom Nguyen
Sr. Developer
[EMAIL PROTECTED]
-----Original Message-----
From: Schuminl [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 02, 2007 10:01 AM
To: [email protected]
Subject: Could not configure ResultMap. ResultMap named pa.SelectResult
not found, failed.
I've have the following error in Visual Studio 2005 when trying to
select a
user from a MSSQL DB.
- The error occurred while Validate SqlMap config.
- initialize ResultMap
- The error occurred in <sqlMap resource="participants.xml"
xmlns="http://ibatis.apache.org/dataMapper"; />.
- Check the pa.SelectResult.
Inner exception:
Message "Could not configure ResultMap. ResultMap named
\"pa.SelectResult\"
not found, failed. \r\n Cause: Could not load type from string value
'participant'."
My participants.xml:
<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="pa" xmlns="http://ibatis.apache.org/mapping";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
<resultMaps>
<resultMap id="pa.SelectResult" class="participant">
<result property="barcodeID" column="BarcodeID" />
<result property="name" column="Name" />
<result property="surname" column="Surname" />
<result property="adress" column="Adress" />
<result property="zipcode" column="Zipcode" />
<result property="city" column="City" />
<result property="country" column="LandOfOrigin"
/>
<result property="participations"
column="Participations" />
<result property="paid" column="Paid" />
</resultMap>
</resultMaps>
<statements>
<select id="Select" parameterClass="int"
resultMap="pa.SelectResult">
SELECT
BarcodeID,
Name,
Surname,
Adress,
Zipcode,
City,
LandOfOrigin,
Participations,
Paid
FROM Participants
<dynamic prepend="WHERE">
<isParameterPresent>
BarcodeID = #value#
</isParameterPresent>
</dynamic>
</select>
<insert id="Insert" parameterClass="participant" resultClass="int">
INSERT INTO Participants
(BarcodeID, Name, Surname, Adress, Zipcode, City, LandOfOrigin,
Participations, Paid)
VALUES
(#barcodeID#, #name#, #surname#, #adress#, #zipcode#, #city#,
#country#, #participations#, #paid#)
</insert>
</statements>
</sqlMap>
Sqlmap.config:
<?xml version="1.0" encoding="UTF-8" ?>
<sqlMapConfig xmlns="http://ibatis.apache.org/dataMapper";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
<settings>
<setting cacheModelsEnabled="true"/>
<setting useStatementNamespaces="true"/>
<setting validateSqlMap="true"/>
<setting useReflectionOptimizer="true"/>
</settings>
<database>
<provider name="sqlServer2.0"/>
<dataSource name="KennedyMarsConnection" connectionString="Data
Source=****;Initial Catalog=****;Persist Security Info=True;User
ID=***;Password=*****;" />
</database>
<sqlMaps>
<sqlMap resource="participants.xml"/>
</sqlMaps>
</sqlMapConfig>
Selection code:
participant.name = name;
participant.surname = surname;
participant.adress = adress;
participant.zipcode = zipcode;
participant.city = city;
participant.country = land;
//Mapper.Instance().Insert("Insert", participant);
//int count = Mapper.Instance().Delete("Delete", 1);
participant.barcodeID = 1;
participant =
(participant)Mapper.Instance().QueryForObject("pa.Select",
participant.barcodeID);
Does anyone have an idea about this error? ASP.NET final error:
Server Error in '/WEBTV_Website' Application.
Could not load type from string value 'participant'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.TypeLoadException: Could not load type from
string
value 'participant'.
Source Error:
Line 29: //int count = Mapper.Instance().Delete("Delete",
1);
Line 30: participant.barcodeID = 1;
Line 31: participant =
(participant)Mapper.Instance().QueryForObject("pa.Select",
participant.barcodeID);
Line 32: }
Line 33: }
Source File: e:\_School\WEBTV\WEBTV_Website\App_Code\DataAccess.cs
Line:
31
Stack Trace:
[TypeLoadException: Could not load type from string value
'participant'.]
IBatisNet.Common.Utilities.TypesResolver.TypeResolver.ResolveType(String
typeName) +220
IBatisNet.Common.Utilities.TypesResolver.TypeResolver.Resolve(String
typeName) +51
IBatisNet.Common.Utilities.TypesResolver.CachedTypeResolver.Resolve(Stri
ng
typeName) +256
IBatisNet.Common.Utilities.TypeUtils.ResolveType(String typeName) +50
IBatisNet.DataMapper.TypeHandlers.TypeHandlerFactory.GetType(String
className) +73
IBatisNet.DataMapper.Configuration.ResultMapping.ResultMap.Initialize(Co
nfigurationScope
configScope) +113
[ConfigurationException: Could not configure ResultMap. ResultMap named
"pa.SelectResult" not found, failed.
Cause: Could not load type from string value 'participant'.]
IBatisNet.DataMapper.Configuration.ResultMapping.ResultMap.Initialize(Co
nfigurationScope
configScope) +267
IBatisNet.DataMapper.Configuration.Serializers.ResultMapDeSerializer.Des
erialize(XmlNode
node, ConfigurationScope configScope) +220
IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.BuildResultMap()
+342
IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.ConfigureSqlMap()
+1648
IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Initialize()
+5093
IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocument
document, DataSource dataSource, Boolean useConfigFileWatcher, Boolean
isCallFromDao) +345
[ConfigurationException:
- The error occurred while Validate SqlMap config.
- initialize ResultMap
- The error occurred in <sqlMap resource="participants.xml"
xmlns="http://ibatis.apache.org/dataMapper"; />.
- Check the pa.SelectResult.]
IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocument
document, DataSource dataSource, Boolean useConfigFileWatcher, Boolean
isCallFromDao) +429
IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocument
document, Boolean useConfigFileWatcher) +40
IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.ConfigureAndWatch(St
ring
resource, ConfigureHandler configureDelegate) +203
IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.ConfigureAndWatch(Co
nfigureHandler
configureDelegate) +35
IBatisNet.DataMapper.Mapper.InitMapper() +89
IBatisNet.DataMapper.Mapper.Instance() +84
KennedyMars.DataAccess.setRegisterUser(String name, String surname,
String adress, String zipcode, String city, String land) in
e:\_School\WEBTV\WEBTV_Website\App_Code\DataAccess.cs:31
KennedyMars.BusinessLogic.validateRegister(String name, String
surname,
String adress, String zipcode, String city, String land) in
e:\_School\WEBTV\WEBTV_Website\App_Code\BusinessLogic.cs:30
KennedyMars.Facade.checkRegister(String name, String surname, String
adress, String zipcode, String city, String land) in
e:\_School\WEBTV\WEBTV_Website\App_Code\Facade.cs:53
Default7.btRegister_Click(Object sender, EventArgs e) in
e:\_School\WEBTV\WEBTV_Website\register.aspx.cs:21
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +96
System.Web.UI.WebControls.Button.RaisePostBackEvent(String
eventArgument)
+116
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.Rai
sePostBackEvent(String
eventArgument) +31
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +32
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
+72
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+3839
Version Information: Microsoft .NET Framework Version:2.0.50727.832;
ASP.NET
Version:2.0.50727.832
--
View this message in context:
http://www.nabble.com/Could-not-configure-ResultMap.-ResultMap-named-pa.
SelectResult-not-found%2C-failed.-tf4555353.html#a13000516
Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
************************************************************************************
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.
************************************************************************************
