Author: gbayon
Date: Sat Apr 1 02:04:55 2006
New Revision: 390637
URL: http://svn.apache.org/viewcvs?rev=390637&view=rev
Log:
- Updated mapping files for MSSQL with oledb/obdc
Added:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Simple.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Simple.xml
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/IBatisNet.DataMapper.Test.csproj
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/Category.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Account.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Category.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Enumeration.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/LineItem.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Order.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Other.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Account.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Category.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Enumeration.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/LineItem.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Order.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Other.xml
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/ReadMe.txt
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/SqlMap_MSSQL_Odbc.config
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/SqlMap_MSSQL_OleDb.config
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/IBatisNet.DataMapper.Test.csproj
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/IBatisNet.DataMapper.Test.csproj?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/IBatisNet.DataMapper.Test.csproj
(original)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/IBatisNet.DataMapper.Test.csproj
Sat Apr 1 02:04:55 2006
@@ -410,6 +410,10 @@
BuildAction = "Content"
/>
<File
+ RelPath = "Maps\MSSQL\Odbc\Nullable.xml"
+ BuildAction = "Content"
+ />
+ <File
RelPath = "Maps\MSSQL\Odbc\Order.xml"
BuildAction = "Content"
/>
@@ -426,6 +430,10 @@
BuildAction = "Content"
/>
<File
+ RelPath = "Maps\MSSQL\Odbc\Simple.xml"
+ BuildAction = "Content"
+ />
+ <File
RelPath = "Maps\MSSQL\OleDb\Account.xml"
BuildAction = "Content"
/>
@@ -454,6 +462,10 @@
BuildAction = "Content"
/>
<File
+ RelPath = "Maps\MSSQL\OleDb\Nullable.xml"
+ BuildAction = "Content"
+ />
+ <File
RelPath = "Maps\MSSQL\OleDb\Order.xml"
BuildAction = "Content"
/>
@@ -467,6 +479,10 @@
/>
<File
RelPath = "Maps\MSSQL\OleDb\ResultClass.xml"
+ BuildAction = "Content"
+ />
+ <File
+ RelPath = "Maps\MSSQL\OleDb\Simple.xml"
BuildAction = "Content"
/>
<File
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/Category.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/Category.xml?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/Category.xml
(original)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/Access/OleDb/Category.xml
Sat Apr 1 02:04:55 2006
@@ -8,6 +8,15 @@
<statements>
+ <select id="GetCategoryWithNullValueReplacementGuid"
resultMap="Category-result" >
+ select
+ Category_ID,
+ Category_Name,
+ Category_Guid
+ from Categories
+ where Category_ID = #value#
+ </select>
+
<select id="GetCategory" parameterClass="Integer"
resultClass="Category">
select
Category_ID as [Id],
@@ -90,6 +99,10 @@
Category_Id = ?
</update>
+ <procedure id="InsertCategoryViaStoreProcedureWithMap"
parameterMap="insertMap-params">
+ ps_InsertCategorie
+ </procedure>
+
<procedure id="InsertCategoryViaStoreProcedure"
parameterMap="insert-params">
ps_InsertCategorie
</procedure>
@@ -134,18 +147,25 @@
</statements>
<parameterMaps>
- <parameterMap id="insert-params">
+
+ <parameterMap id="insertMap-params" class="Hashtable">
+ <parameter property="Id" column="Category_Id"
dbType="Integer" /><!-- Int for SqlClient, Obdc; Integer for Oledb -->
+ <parameter property="Name" column="Category_Name"/>
+ <parameter property="Guid" column="Category_Guid"
dbType="Guid"/><!--Guid for Oledb, UniqueIdentifier for SqlClient,Odbc -->
+ </parameterMap>
+
+ <parameterMap id="insert-params" class="Category">
<parameter property="Id" column="Category_Id"
dbType="Integer" /><!-- Int for SqlClient, Obdc; Integer for Oledb -->
<parameter property="Name" column="Category_Name"/>
<parameter property="Guid" column="Category_Guid"
dbType="Guid"/><!--Guid for Oledb, UniqueIdentifier for SqlClient,Odbc -->
</parameterMap>
- <parameterMap id="InsertParam">
+ <parameterMap id="InsertParam" class="Category">
<parameter property="Name" column="Category_Name"/>
<parameter property="Guid" column="Category_Guid"
dbType="Guid"/><!--Guid for Oledb, UniqueIdentifier for SqlClient,Odbc -->
</parameterMap>
- <parameterMap id="insert-null-params">
+ <parameterMap id="insert-null-params" class="Category">
<parameter property="Name" column="Category_Name"/>
<parameter property="Guid" column="Category_Guid"
nullValue="00000000-0000-0000-0000-000000000000" dbType="Guid"/><!--Guid for
Oledb, UniqueIdentifier for SqlClient,Odbc -->
</parameterMap>
@@ -156,7 +176,7 @@
<!-- Used by generated statement -->
- <parameterMap id="insert-generate-params">
+ <parameterMap id="insert-generate-params" class="Category">
<parameter property="Name" column="Category_Name"/>
<parameter property="Guid" column="Category_Guid"
dbType="Guid"/><!--Guid for Oledb, UniqueIdentifier for SqlClient,Odbc -->
</parameterMap>
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Account.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Account.xml?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Account.xml
(original)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Account.xml
Sat Apr 1 02:04:55 2006
@@ -540,16 +540,16 @@
============================================= -->
<parameterMaps>
- <parameterMap id="swap-params">
+ <parameterMap id="swap-params" class="Hashtable">
<parameter property="email1" column="First_Email" />
<parameter property="email2" column="Second_Email" />
</parameterMap>
- <parameterMap id="select-params">
+ <parameterMap id="select-params" class="Hashtable">
<parameter property="Account_ID" />
</parameterMap>
- <parameterMap id="insert-params">
+ <parameterMap id="insert-params" class="Account">
<parameter property="Id" />
<parameter property="FirstName" />
<parameter property="LastName" />
@@ -558,14 +558,14 @@
<parameter property="CartOption"
column="Account_Cart_Option" typeHandler="HundredsBool"/>
</parameterMap>
- <parameterMap id="update-params">
+ <parameterMap id="update-params" class="Account">
<parameter property="FirstName" />
<parameter property="LastName" />
<parameter property="EmailAddress" nullValue="[EMAIL
PROTECTED]"/>
<parameter property="Id" />
</parameterMap>
- <parameterMap id="update-params2">
+ <parameterMap id="update-params2" class="Account">
<parameter property="Id" />
<parameter property="FirstName" />
<parameter property="LastName" />
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Category.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Category.xml?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Category.xml
(original)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Category.xml
Sat Apr 1 02:04:55 2006
@@ -6,8 +6,25 @@
<typeAlias alias="Category"
type="IBatisNet.DataMapper.Test.Domain.Category, IBatisNet.DataMapper.Test"/>
</alias>
+ <resultMaps>
+ <resultMap id="Category-result" class="Category">
+ <result property="Id" column="Category_ID"/>
+ <result property="Name" column="Category_Name"/>
+ <result property="Guid" column="Category_Guid"
nullValue="00000000-0000-0000-0000-000000000000"/>
+ </resultMap>
+ </resultMaps >
+
<statements>
+ <select id="GetCategoryWithNullValueReplacementGuid"
resultMap="Category-result" >
+ select
+ Category_ID,
+ Category_Name,
+ Category_Guid
+ from Categories
+ where Category_ID = #value#
+ </select>
+
<select id="GetCategory" parameterClass="Integer"
resultClass="Category">
select
Category_ID as Id,
@@ -89,10 +106,14 @@
Category_Id = ?
</update>
- <procedure id="InsertCategoryViaStoreProcedure"
parameterMap="insert-params">
+ <procedure id="InsertCategoryViaStoreProcedureWithMap"
parameterMap="insertMap-params">
ps_InsertCategorie
</procedure>
+ <procedure id="InsertCategoryViaStoreProcedure"
parameterMap="insert-params">
+ ps_InsertCategorie
+ </procedure>
+
<insert id="InsertCategoryGenerate"
parameterMap="insert-generate-params">
<selectKey property="Id" type="post" resultClass="int">
select @@IDENTITY as value
@@ -134,43 +155,49 @@
</statements>
<parameterMaps>
- <parameterMap id="insert-params">
+ <parameterMap id="insertMap-params" class="Hashtable">
+ <parameter property="Id" column="Category_Id"
dbType="Int" /><!-- Int for SqlClient, Obdc; Integer for Oledb -->
+ <parameter property="Name" column="Category_Name"/>
+ <parameter property="Guid" column="Category_Guid"
dbType="UniqueIdentifier"/><!--Guid for Oledb, UniqueIdentifier for
SqlClient,Odbc -->
+ </parameterMap>
+
+ <parameterMap id="insert-params" class="Category">
<parameter property="Id" column="Category_Id"
dbType="Int" /><!-- Int for SqlClient, Obdc; Integer for Oledb -->
<parameter property="Name" column="Category_Name"/>
<parameter property="Guid" column="Category_Guid"
dbType="UniqueIdentifier"/><!--Guid for Oledb, UniqueIdentifier for
SqlClient,Odbc -->
</parameterMap>
- <parameterMap id="InsertParam">
+ <parameterMap id="InsertParam" class="Category">
<parameter property="Name" column="Category_Name"/>
<parameter property="Guid" column="Category_Guid"
dbType="UniqueIdentifier"/><!--Guid for Oledb, UniqueIdentifier for
SqlClient,Odbc -->
</parameterMap>
- <parameterMap id="insert-null-params">
+ <parameterMap id="insert-null-params" class="Category">
<parameter property="Name" column="Category_Name"/>
<parameter property="Guid" column="Category_Guid"
nullValue="00000000-0000-0000-0000-000000000000"
dbType="UniqueIdentifier"/><!--Guid for Oledb, UniqueIdentifier for
SqlClient,Odbc -->
</parameterMap>
- <parameterMap id="UpdateParam" extends="InsertParam">
+ <parameterMap id="UpdateParam" extends="InsertParam"
class="Category">
<parameter property="Id" column="Category_Id" />
</parameterMap>
<!-- Used by generated statement -->
- <parameterMap id="insert-generate-params">
+ <parameterMap id="insert-generate-params" class="Category">
<parameter property="Name" column="Category_Name"/>
<parameter property="Guid" column="Category_Guid"
dbType="UniqueIdentifier"/><!--Guid for Oledb, UniqueIdentifier for
SqlClient,Odbc -->
</parameterMap>
- <parameterMap id="update-generate-params"
extends="insert-generate-params">
+ <parameterMap id="update-generate-params"
extends="insert-generate-params" class="Category">
<parameter property="Id" column="Category_Id" />
</parameterMap>
- <parameterMap id="delete-generate-params">
+ <parameterMap id="delete-generate-params" class="Category">
<parameter property="Id" column="Category_Id" />
<parameter property="Name" column="Category_Name"/>
</parameterMap>
- <parameterMap id="select-generate-params">
+ <parameterMap id="select-generate-params" class="Category">
<parameter property="Id" column="Category_Id" />
<parameter property="Name" column="Category_Name"/>
<parameter property="Guid" column="Category_Guid"
dbType="UniqueIdentifier"/>
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Enumeration.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Enumeration.xml?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Enumeration.xml
(original)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Enumeration.xml
Sat Apr 1 02:04:55 2006
@@ -49,7 +49,7 @@
</statements>
<parameterMaps>
- <parameterMap id="insert-params">
+ <parameterMap id="insert-params" class="Enumeration">
<parameter property="Id" column="Enum_ID" />
<parameter property="Day" column="Enum_Day"/>
<parameter property="Color" column="Enum_Color" />
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/LineItem.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/LineItem.xml?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/LineItem.xml
(original)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/LineItem.xml
Sat Apr 1 02:04:55 2006
@@ -182,11 +182,11 @@
<parameterMaps>
- <parameterMap id="select-params">
+ <parameterMap id="select-params" class="int">
<parameter property="Order_ID" />
</parameterMap>
- <parameterMap id="insert-params">
+ <parameterMap id="insert-params" class="LineItem">
<parameter property="Id" />
<parameter property="Order.Id" />
<parameter property="Code" />
@@ -194,7 +194,7 @@
<parameter property="Price" dbType="Decimal"
nullValue="-99.99"/>
</parameterMap>
- <parameterMap id="insert-params-picture">
+ <parameterMap id="insert-params-picture" class="LineItem">
<parameter property="Id" />
<parameter property="Order.Id" />
<parameter property="Code" />
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Order.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Order.xml?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
--- ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Order.xml
(original)
+++ ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Order.xml
Sat Apr 1 02:04:55 2006
@@ -463,7 +463,7 @@
<parameterMaps>
- <parameterMap id="insert-params">
+ <parameterMap id="insert-params" class="Order">
<parameter property="Id" dbType="Int"/> <!-- Int for
SqlClient, Obdc; Integer for Oledb -->
<parameter property="Account.Id"/>
<parameter property="Date" nullValue="01/01/0001
00:00:00" />
@@ -476,7 +476,7 @@
<parameter property="PostalCode" />
</parameterMap>
- <parameterMap id="params-parent"> <!-- 1043181 support request
-->
+ <parameterMap id="params-parent" class="Order"> <!-- 1043181
support request -->
<parameter property="Id" dbType="Int"/>
<parameter property="Account.Id"/>
<parameter property="Date" nullValue="01/01/0001
00:00:00" />
@@ -489,7 +489,7 @@
<parameter property="PostalCode" />
</parameterMap>
- <parameterMap id="insert-extend" extends="params-parent">
+ <parameterMap id="insert-extend" extends="params-parent"
class="Order">
</parameterMap>
</parameterMaps>
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Other.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Other.xml?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
--- ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Other.xml
(original)
+++ ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Other.xml
Sat Apr 1 02:04:55 2006
@@ -156,7 +156,7 @@
</statements>
<parameterMaps>
- <parameterMap id="insert-params">
+ <parameterMap id="insert-params" class="Other" >
<parameter property="Int" />
<parameter property="Long" />
<parameter property="Bool" />
Added:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Simple.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Simple.xml?rev=390637&view=auto
==============================================================================
--- ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Simple.xml
(added)
+++ ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/Odbc/Simple.xml
Sat Apr 1 02:04:55 2006
@@ -0,0 +1,38 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<sqlMap namespace="Simple"
+xmlns="http://ibatis.apache.org/mapping";
+xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
+
+<alias>
+ <typeAlias alias="Simple" type="IBatisNet.DataMapper.Test.Domain.Simple,
IBatisNet.DataMapper.Test"/>
+</alias>
+
+<statements>
+
+ <update id="UpdateSimple" parameterClass="Simple" >
+ update Simples
+ set
+ name = #Name#,
+ address = #Address#,
+ count = #Count#,
+ date = #Date#,
+ pay = #Pay#
+ where
+ id = #Id#
+ </update>
+
+
+ <delete id="DeleteSimple" parameterClass="int">
+ delete Simples
+ where
+ id = #value#
+ </delete>
+
+ <insert id="InsertSimple" parameterClass="Simple" >
+ insert into Simples ( name, address, count, date, pay, id )
+ values
+ (#Name#, #Address#, #Count#, #Date#, #Pay#, #Id#)
+ </insert>
+
+</statements>
+</sqlMap>
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Account.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Account.xml?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Account.xml
(original)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Account.xml
Sat Apr 1 02:04:55 2006
@@ -540,16 +540,16 @@
============================================= -->
<parameterMaps>
- <parameterMap id="swap-params">
+ <parameterMap id="swap-params" class="Hashtable">
<parameter property="email1" column="First_Email" />
<parameter property="email2" column="Second_Email" />
</parameterMap>
- <parameterMap id="select-params">
+ <parameterMap id="select-params" class="Hashtable">
<parameter property="Account_ID" />
</parameterMap>
- <parameterMap id="insert-params">
+ <parameterMap id="insert-params" class="Account">
<parameter property="Id" />
<parameter property="FirstName" />
<parameter property="LastName" />
@@ -558,14 +558,14 @@
<parameter property="CartOption"
column="Account_Cart_Option" typeHandler="HundredsBool"/>
</parameterMap>
- <parameterMap id="update-params">
+ <parameterMap id="update-params" class="Account">
<parameter property="FirstName" />
<parameter property="LastName" />
<parameter property="EmailAddress" nullValue="[EMAIL
PROTECTED]"/>
<parameter property="Id" />
</parameterMap>
- <parameterMap id="update-params2">
+ <parameterMap id="update-params2" class="Account">
<parameter property="Id" />
<parameter property="FirstName" />
<parameter property="LastName" />
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Category.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Category.xml?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Category.xml
(original)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Category.xml
Sat Apr 1 02:04:55 2006
@@ -6,8 +6,25 @@
<typeAlias alias="Category"
type="IBatisNet.DataMapper.Test.Domain.Category, IBatisNet.DataMapper.Test"/>
</alias>
+ <resultMaps>
+ <resultMap id="Category-result" class="Category">
+ <result property="Id" column="Category_ID"/>
+ <result property="Name" column="Category_Name"/>
+ <result property="Guid" column="Category_Guid"
nullValue="00000000-0000-0000-0000-000000000000"/>
+ </resultMap>
+ </resultMaps >
+
<statements>
+ <select id="GetCategoryWithNullValueReplacementGuid"
resultMap="Category-result" >
+ select
+ Category_ID,
+ Category_Name,
+ Category_Guid
+ from Categories
+ where Category_ID = #value#
+ </select>
+
<select id="GetCategory" parameterClass="Integer"
resultClass="Category">
select
Category_ID as Id,
@@ -89,6 +106,10 @@
Category_Id = ?
</update>
+ <procedure id="InsertCategoryViaStoreProcedureWithMap"
parameterMap="insertMap-params">
+ ps_InsertCategorie
+ </procedure>
+
<procedure id="InsertCategoryViaStoreProcedure"
parameterMap="insert-params">
ps_InsertCategorie
</procedure>
@@ -176,47 +197,54 @@
</statements>
<parameterMaps>
- <parameterMap id="insert-params">
+
+ <parameterMap id="insertMap-params" class="Hashtable">
+ <parameter property="Id" column="Category_Id"
dbType="Integer" /><!-- Int for SqlClient, Obdc; Integer for Oledb -->
+ <parameter property="Name" column="Category_Name"/>
+ <parameter property="Guid" column="Category_Guid"
dbType="Guid"/><!--Guid for Oledb, UniqueIdentifier for SqlClient,Odbc -->
+ </parameterMap>
+
+ <parameterMap id="insert-params" class="Category">
<parameter property="Id" column="Category_Id"
dbType="Integer" /><!-- Int for SqlClient, Obdc; Integer for Oledb -->
<parameter property="Name" column="Category_Name"/>
<parameter property="Guid" column="Category_Guid"
dbType="Guid"/><!--Guid for Oledb, UniqueIdentifier for SqlClient,Odbc -->
</parameterMap>
- <parameterMap id="InsertParam">
+ <parameterMap id="InsertParam" class="Category">
<parameter property="Name" column="Category_Name"/>
<parameter property="Guid" column="Category_Guid"
dbType="Guid"/><!--Guid for Oledb, UniqueIdentifier for SqlClient,Odbc -->
</parameterMap>
- <parameterMap id="insert-null-params">
+ <parameterMap id="insert-null-params" class="Category">
<parameter property="Name" column="Category_Name"/>
<parameter property="Guid" column="Category_Guid"
nullValue="00000000-0000-0000-0000-000000000000" dbType="Guid"/><!--Guid for
Oledb, UniqueIdentifier for SqlClient,Odbc -->
</parameterMap>
- <parameterMap id="UpdateParam" extends="InsertParam">
+ <parameterMap id="UpdateParam" extends="InsertParam"
class="Category">
<parameter property="Id" column="Category_Id" />
</parameterMap>
<!-- Used by generated statement -->
- <parameterMap id="insert-generate-params">
+ <parameterMap id="insert-generate-params" class="Category">
<parameter property="Name" column="Category_Name"/>
<parameter property="Guid" column="Category_Guid"
dbType="Guid"/><!--Guid for Oledb, UniqueIdentifier for SqlClient,Odbc -->
</parameterMap>
- <parameterMap id="update-generate-params"
extends="insert-generate-params">
+ <parameterMap id="update-generate-params"
extends="insert-generate-params" class="Category">
<parameter property="Id" column="Category_Id" />
</parameterMap>
- <parameterMap id="delete-generate-params">
+ <parameterMap id="delete-generate-params" class="Category">
<parameter property="Id" column="Category_Id" />
<parameter property="Name" column="Category_Name"/>
</parameterMap>
- <parameterMap id="selectByPK-generate-params">
+ <parameterMap id="selectByPK-generate-params" class="Category">
<parameter property="Id" column="Category_Id" />
</parameterMap>
- <parameterMap id="select-generate-params">
+ <parameterMap id="select-generate-params" class="Category">
<parameter property="Id" column="Category_Id" />
<parameter property="Name" column="Category_Name"/>
<parameter property="Guid" column="Category_Guid"
dbType="Guid"/>
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Enumeration.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Enumeration.xml?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Enumeration.xml
(original)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Enumeration.xml
Sat Apr 1 02:04:55 2006
@@ -49,7 +49,7 @@
</statements>
<parameterMaps>
- <parameterMap id="insert-params">
+ <parameterMap id="insert-params" class="Enumeration">
<parameter property="Id" column="Enum_ID" />
<parameter property="Day" column="Enum_Day"/>
<parameter property="Color" column="Enum_Color" />
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/LineItem.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/LineItem.xml?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/LineItem.xml
(original)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/LineItem.xml
Sat Apr 1 02:04:55 2006
@@ -182,11 +182,11 @@
<parameterMaps>
- <parameterMap id="select-params">
+ <parameterMap id="select-params" class="int">
<parameter property="Order_ID" />
</parameterMap>
- <parameterMap id="insert-params">
+ <parameterMap id="insert-params" class="LineItem">
<parameter property="Id" />
<parameter property="Order.Id" />
<parameter property="Code" />
@@ -194,7 +194,7 @@
<parameter property="Price" dbType="Decimal"
nullValue="-99.99"/>
</parameterMap>
- <parameterMap id="insert-params-picture">
+ <parameterMap id="insert-params-picture" class="LineItem">
<parameter property="Id" />
<parameter property="Order.Id" />
<parameter property="Code" />
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Order.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Order.xml?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
--- ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Order.xml
(original)
+++ ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Order.xml
Sat Apr 1 02:04:55 2006
@@ -467,7 +467,7 @@
<parameterMaps>
- <parameterMap id="insert-params">
+ <parameterMap id="insert-params" class="Order">
<parameter property="Id" dbType="Integer"/> <!--
Int for SqlClient, Obdc; Integer for Oledb -->
<parameter property="Account.Id"/>
<parameter property="Date" nullValue="01/01/0001
00:00:00" />
@@ -480,7 +480,7 @@
<parameter property="PostalCode" />
</parameterMap>
- <parameterMap id="params-parent"> <!-- 1043181 support request
-->
+ <parameterMap id="params-parent" class="Order"> <!-- 1043181
support request -->
<parameter property="Id" dbType="Integer"/>
<parameter property="Account.Id"/>
<parameter property="Date" nullValue="01/01/0001
00:00:00" />
@@ -493,7 +493,7 @@
<parameter property="PostalCode" />
</parameterMap>
- <parameterMap id="insert-extend" extends="params-parent">
+ <parameterMap id="insert-extend" extends="params-parent"
class="Order">
</parameterMap>
</parameterMaps>
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Other.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Other.xml?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
--- ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Other.xml
(original)
+++ ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Other.xml
Sat Apr 1 02:04:55 2006
@@ -167,7 +167,7 @@
</statements>
<parameterMaps>
- <parameterMap id="insert-params">
+ <parameterMap id="insert-params" class="Other" >
<parameter property="Int" />
<parameter property="Long" />
<parameter property="Bool" />
Added:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Simple.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Simple.xml?rev=390637&view=auto
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Simple.xml
(added)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/Maps/MSSQL/OleDb/Simple.xml
Sat Apr 1 02:04:55 2006
@@ -0,0 +1,38 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<sqlMap namespace="Simple"
+xmlns="http://ibatis.apache.org/mapping";
+xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
+
+<alias>
+ <typeAlias alias="Simple" type="IBatisNet.DataMapper.Test.Domain.Simple,
IBatisNet.DataMapper.Test"/>
+</alias>
+
+<statements>
+
+ <update id="UpdateSimple" parameterClass="Simple" >
+ update Simples
+ set
+ name = #Name#,
+ address = #Address#,
+ count = #Count#,
+ date = #Date#,
+ pay = #Pay#
+ where
+ id = #Id#
+ </update>
+
+
+ <delete id="DeleteSimple" parameterClass="int">
+ delete Simples
+ where
+ id = #value#
+ </delete>
+
+ <insert id="InsertSimple" parameterClass="Simple" >
+ insert into Simples ( name, address, count, date, pay, id )
+ values
+ (#Name#, #Address#, #Count#, #Date#, #Pay#, #Id#)
+ </insert>
+
+</statements>
+</sqlMap>
Modified: ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/ReadMe.txt
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/ReadMe.txt?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
--- ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/ReadMe.txt (original)
+++ ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/ReadMe.txt Sat Apr 1
02:04:55 2006
@@ -18,4 +18,7 @@
4/ To test for .NET V2, enabled provider 'sqlServer2.0' and
set <provider name="sqlServer2.0"/> in SqlMap_MSSQL_SqlClient.config
-
\ No newline at end of file
+
+Remarks :
+- TestSelectByPK fails for MSSQL with Oledb [it's normal]
+- TestJIRA11 fails for MSSQL with Oledb/odbc [it's normal]
\ No newline at end of file
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/SqlMap_MSSQL_Odbc.config
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/SqlMap_MSSQL_Odbc.config?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/SqlMap_MSSQL_Odbc.config
(original)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/SqlMap_MSSQL_Odbc.config
Sat Apr 1 02:04:55 2006
@@ -41,7 +41,8 @@
<sqlMap resource="../../Maps/MSSQL/Odbc/ParameterClass.xml"/>
<sqlMap resource="../../Maps/MSSQL/Odbc/ResultClass.xml"/>
<sqlMap resource="../../Maps/MSSQL/Odbc/Document.xml"/>
- <sqlMap resource="../../Maps/MSSQL/Odbc/Nullable.xml"/>
+ <sqlMap resource="../../Maps/MSSQL/Odbc/Nullable.xml"/>
+ <sqlMap resource="../../Maps/MSSQL/Odbc/Simple.xml"/>
</sqlMaps>
</sqlMapConfig>
Modified:
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/SqlMap_MSSQL_OleDb.config
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/SqlMap_MSSQL_OleDb.config?rev=390637&r1=390636&r2=390637&view=diff
==============================================================================
---
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/SqlMap_MSSQL_OleDb.config
(original)
+++
ibatis/trunk/cs/mapper/IBatisNet.DataMapper.Test/bin/Debug/SqlMap_MSSQL_OleDb.config
Sat Apr 1 02:04:55 2006
@@ -40,7 +40,8 @@
<sqlMap resource="../../Maps/MSSQL/OleDb/ParameterClass.xml"/>
<sqlMap resource="../../Maps/MSSQL/OleDb/ResultClass.xml"/>
<sqlMap resource="../../Maps/MSSQL/OleDb/Document.xml"/>
- <sqlMap resource="../../Maps/MSSQL/OleDb/Nullable.xml"/>
+ <sqlMap resource="../../Maps/MSSQL/OleDb/Nullable.xml"/>
+ <sqlMap resource="../../Maps/MSSQL/OleDb/Simple.xml"/>
</sqlMaps>
</sqlMapConfig>
