MS OracleClient 1.0.5 Update Statement with Extended Parameter Map
------------------------------------------------------------------
Key: IBATISNET-57
URL: http://issues.apache.org/jira/browse/IBATISNET-57
Project: iBatis for .NET
Type: Task
Versions: DataMapper 1.1
Environment: Oracle 9i with MS OracleClient 1.0.5 provider
Reporter: Roberto Rabe
Priority: Minor
The NUnit Oracle.StatementTest.TestUpdateCategoryWithExtendParameterMap()
throws OracleException Invalid number.
The failing NUnit update statement is:
<update id="UpdateCategoryViaParameterMap"
parameterMap="UpdateParam">
update Categories set
Category_Name = ?,
Category_Guid = ?
where
Category_Id = ?
</update>
The reason is that the parameter order is not correct in the command text:
"update Categories set Category_Name = :Id, Category_Guid = :Name
where Category_Id = :GuidString"
The MS OracleClient provider works better using an extended parameter map on
insert instead of update since the order of the properties is important.
A work-around is to use a specific parameterMap for the UPDATE or use a
parameterClass instead of an extended parameterMap.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
