You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ibatis.apache.org by ro...@apache.org on 2005/12/13 02:11:17 UTC
svn commit: r356440 - in
/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle:
ODP/Order.xml ODP/Other.xml OracleClient/Order.xml
OracleClient/ResultClass.xml
Author: roberto
Date: Mon Dec 12 17:11:07 2005
New Revision: 356440
URL: http://svn.apache.org/viewcvs?rev=356440&view=rev
Log:
~Updated C# DataMapper Oracle (ODP & OracleClient) SqlMaps
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/ODP/Order.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/ODP/Other.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/OracleClient/Order.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/OracleClient/ResultClass.xml
Modified: ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/ODP/Order.xml
URL: http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/ODP/Order.xml?rev=356440&r1=356439&r2=356440&view=diff
==============================================================================
--- ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/ODP/Order.xml (original)
+++ ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/ODP/Order.xml Mon Dec 12 17:11:07 2005
@@ -282,19 +282,19 @@
parameterClass="Integer"
resultClass="Order" >
select
- Orders.Order_ID as Id,
- Order_Date as Date,
- Order_CardExpiry as CardExpiry,
- Order_CardType as CardType,
- Order_CardNumber as CardNumber,
- Order_Street as Street,
- Order_City as City,
- Order_Province as Province,
- Order_PostalCode as PostalCode,
- LineItem_ID as "FavouriteLineItem.Id",
- LineItem_Code as "FavouriteLineItem.Code",
- LineItem_Quantity as "FavouriteLineItem.Quantity",
- LineItem_Price as "FavouriteLineItem.Price"
+ Orders.Order_ID Id,
+ Order_Date "Date",
+ Order_CardExpiry CardExpiry,
+ Order_CardType CardType,
+ Order_CardNumber CardNumber,
+ Order_Street Street,
+ Order_City City,
+ Order_Province Province,
+ Order_PostalCode PostalCode,
+ LineItem_ID "FavouriteLineItem.Id",
+ LineItem_Code "FavouriteLineItem.Code",
+ LineItem_Quantity "FavouriteLineItem.Quantity",
+ LineItem_Price "FavouriteLineItem.Price"
from Orders, LineItems
where Orders.Order_ID = LineItems.Order_ID
and Order_FavouriteLineItem = LineItems.LineItem_ID
Modified: ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/ODP/Other.xml
URL: http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/ODP/Other.xml?rev=356440&r1=356439&r2=356440&view=diff
==============================================================================
--- ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/ODP/Other.xml (original)
+++ ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/ODP/Other.xml Mon Dec 12 17:11:07 2005
@@ -102,6 +102,10 @@
</statement>
<!--
+ Use custom typeHandler to get around error since Oracle column is an integer and
+ ODP does not have a proper typeHandler to convert bool to Oracle integer data type
+
+ Otherwise...
Throws System.ArgumentException :
Value does not fall within the expected range.
@@ -123,15 +127,19 @@
Other_Bit,
Other_String
from Others
- Where Other_Bit = #Bool#
+ Where Other_Bit = #Bool,handler=OneZeroBool#
</statement>
+ <!--
+ Use typeHandler to get around error since Oracle column is an integer and
+ ODP does not have a proper typeHandler to convert bool to Oracle integer data type
+ -->
<statement id="InsertBool"
parameterClass="Other">
Insert into Others
( Other_Int, Other_Long, Other_Bit, Other_String )
values
- ( #Int#, #Long#, #Bool#, 'Yes')
+ ( #Int#, #Long#, #Bool,handler=OneZeroBool#, 'Yes')
</statement>
<statement id="InsertCustomTypeHandler"
@@ -159,7 +167,7 @@
Insert into Others
( Other_Int, Other_Long, Other_Bit, Other_String )
values
- ( #Int#, #Long#, #Bool#, #Bool2,type=bool,dbType=VarChar#)
+ ( #Int#, #Long#, #Bool,handler=OneZeroBool#, #Bool2,type=bool,dbType=Varchar2#)
</statement>
<statement id="InsertInlineCustomTypeHandlerV2"
@@ -167,7 +175,7 @@
Insert into Others
( Other_Int, Other_Long, Other_Bit, Other_String )
values
- ( #Int#, #Long#, #Bool#, #Bool2,handler=OuiNonBool#)
+ ( #Int#, #Long#, #Bool,handler=OneZeroBool#, #Bool2,handler=OuiNonBool#)
</statement>
</statements>
Modified: ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/OracleClient/Order.xml
URL: http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/OracleClient/Order.xml?rev=356440&r1=356439&r2=356440&view=diff
==============================================================================
--- ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/OracleClient/Order.xml (original)
+++ ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/OracleClient/Order.xml Mon Dec 12 17:11:07 2005
@@ -282,19 +282,19 @@
parameterClass="Integer"
resultClass="Order" >
select
- Orders.Order_ID as Id,
- Order_Date as Date,
- Order_CardExpiry as CardExpiry,
- Order_CardType as CardType,
- Order_CardNumber as CardNumber,
- Order_Street as Street,
- Order_City as City,
- Order_Province as Province,
- Order_PostalCode as PostalCode,
- LineItem_ID as "FavouriteLineItem.Id",
- LineItem_Code as "FavouriteLineItem.Code",
- LineItem_Quantity as "FavouriteLineItem.Quantity",
- LineItem_Price as "FavouriteLineItem.Price"
+ Orders.Order_ID Id,
+ Order_Date "Date",
+ Order_CardExpiry CardExpiry,
+ Order_CardType CardType,
+ Order_CardNumber CardNumber,
+ Order_Street Street,
+ Order_City City,
+ Order_Province Province,
+ Order_PostalCode PostalCode,
+ LineItem_ID "FavouriteLineItem.Id",
+ LineItem_Code "FavouriteLineItem.Code",
+ LineItem_Quantity "FavouriteLineItem.Quantity",
+ LineItem_Price "FavouriteLineItem.Price"
from Orders, LineItems
where Orders.Order_ID = LineItems.Order_ID
and Order_FavouriteLineItem = LineItems.LineItem_ID
Modified: ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/OracleClient/ResultClass.xml
URL: http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/OracleClient/ResultClass.xml?rev=356440&r1=356439&r2=356440&view=diff
==============================================================================
--- ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/OracleClient/ResultClass.xml (original)
+++ ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Oracle/OracleClient/ResultClass.xml Mon Dec 12 17:11:07 2005
@@ -97,6 +97,10 @@
resultClass="long" >
select 9223372036854775800 from dual where 1 = #value#
</statement>
+ <statement id="GetInt64WithoutResultClass"
+ parameterClass="Int"
+ extends="GetInt64">
+ </statement>
<statement id="GetSingle"
parameterClass="Int"