Author: gbayon
Date: Mon Dec 5 12:39:29 2005
New Revision: 354175
URL: http://svn.apache.org/viewcvs?rev=354175&view=rev
Log:
- Updated tutorial
Added:
ibatis/trunk/cs/tutorial/WebView/ReadMe.txt
Modified:
ibatis/trunk/cs/tutorial/Model/Model.csproj
ibatis/trunk/cs/tutorial/Model/Resources/PersonHelper.xml
ibatis/trunk/cs/tutorial/Model/bin/Debug/providers.config
ibatis/trunk/cs/tutorial/Model/bin/Debug/sqlmap.config
ibatis/trunk/cs/tutorial/WebView/Resources/PersonHelper.xml
ibatis/trunk/cs/tutorial/WebView/Resources/iBatisTutorial.mdb
ibatis/trunk/cs/tutorial/WebView/WebView.csproj
ibatis/trunk/cs/tutorial/WebView/properties.config
ibatis/trunk/cs/tutorial/WebView/providers.config
ibatis/trunk/cs/tutorial/WebView/sqlmap.config
Modified: ibatis/trunk/cs/tutorial/Model/Model.csproj
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/tutorial/Model/Model.csproj?rev=354175&r1=354174&r2=354175&view=diff
==============================================================================
--- ibatis/trunk/cs/tutorial/Model/Model.csproj (original)
+++ ibatis/trunk/cs/tutorial/Model/Model.csproj Mon Dec 5 12:39:29 2005
@@ -80,14 +80,15 @@
HintPath =
"..\..\..\..\..\WINDOWS\Microsoft.NET\Framework\v1.1.4322\System.XML.dll"
/>
<Reference
- Name = "nunit.framework"
- AssemblyName = "nunit.framework"
- HintPath = "bin\Debug\nunit.framework.dll"
- />
- <Reference
Name = "IBatisNet.DataMapper"
AssemblyName = "IBatisNet.DataMapper"
- HintPath = "bin\Debug\IBatisNet.DataMapper.dll"
+ HintPath =
"..\..\mapper\IBatisNet.DataMapper\bin\Debug\IBatisNet.DataMapper.dll"
+ />
+ <Reference
+ Name = "nunit.framework"
+ AssemblyName = "nunit.framework"
+ HintPath = "F:\Program Files\NUnit
2.2\bin\nunit.framework.dll"
+ AssemblyFolderKey = "hklm\dn\nunit.framework"
/>
</References>
</Build>
Modified: ibatis/trunk/cs/tutorial/Model/Resources/PersonHelper.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/tutorial/Model/Resources/PersonHelper.xml?rev=354175&r1=354174&r2=354175&view=diff
==============================================================================
--- ibatis/trunk/cs/tutorial/Model/Resources/PersonHelper.xml (original)
+++ ibatis/trunk/cs/tutorial/Model/Resources/PersonHelper.xml Mon Dec 5
12:39:29 2005
@@ -1,9 +1,9 @@
<?xml version="1.0" encoding="utf-8" ?>
-<sqlMap
- namespace="Person"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
- xsi:noNamespaceSchemaLocation="SqlMap.xsd">
+<sqlMap namespace="Account"
+xmlns="http://ibatis.apache.org/mapping";
+xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; >
+
<!-- XML "behind" document for the People service class. -->
Modified: ibatis/trunk/cs/tutorial/Model/bin/Debug/providers.config
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/tutorial/Model/bin/Debug/providers.config?rev=354175&r1=354174&r2=354175&view=diff
==============================================================================
--- ibatis/trunk/cs/tutorial/Model/bin/Debug/providers.config (original)
+++ ibatis/trunk/cs/tutorial/Model/bin/Debug/providers.config Mon Dec 5
12:39:29 2005
@@ -1,102 +1,38 @@
-<?xml version="1.0" encoding="utf-8" ?>
+<?xml version="1.0" encoding="utf-8"?>
+<providers
+xmlns="http://ibatis.apache.org/providers";
+xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
+
+<clear/>
+
+<provider name="OleDb1.1"
+ description="OleDb, provider V1.0.5000.0 in framework .NET V1.1"
+ enabled="true"
+ assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
connectionClass="System.Data.OleDb.OleDbConnection"
+ commandClass="System.Data.OleDb.OleDbCommand"
+ parameterClass="System.Data.OleDb.OleDbParameter"
+ parameterDbTypeClass="System.Data.OleDb.OleDbType"
+ parameterDbTypeProperty="OleDbType"
+ dataAdapterClass="System.Data.OleDb.OleDbDataAdapter"
+ commandBuilderClass="System.Data.OleDb.OleDbCommandBuilder"
+ usePositionalParameters="true"
+ useParameterPrefixInSql="false"
+ useParameterPrefixInParameter="false"
+ parameterPrefix=""/>
+<provider
+ name="Odbc1.1"
+ description="Odbc, provider V1.0.5000.0 in framework .NET V1.1"
+ enabled="true"
+ assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
connectionClass="System.Data.Odbc.OdbcConnection"
+ commandClass="System.Data.Odbc.OdbcCommand"
+ parameterClass="System.Data.Odbc.OdbcParameter"
+ parameterDbTypeClass="System.Data.Odbc.OdbcType"
+ parameterDbTypeProperty="OdbcType"
+ dataAdapterClass="System.Data.Odbc.OdbcDataAdapter"
+ commandBuilderClass="System.Data.Odbc.OdbcCommandBuilder"
+ usePositionalParameters="true"
+ useParameterPrefixInSql="false"
+ useParameterPrefixInParameter="false"
+ parameterPrefix="@"/>
-<providers>
- <clear/>
- <provider
- name="sqlServer1.0"
- enabled="false"
- assemblyName="System.Data, Version=1.0.3300.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
- connectionClass="System.Data.SqlClient.SqlConnection"
- commandClass="System.Data.SqlClient.SqlCommand"
- parameterClass="System.Data.SqlClient.SqlParameter"
- parameterDbTypeClass="System.Data.SqlDbType"
- parameterDbTypeProperty="SqlDbType"
- dataAdapterClass="System.Data.SqlClient.SqlDataAdapter"
- commandBuilderClass="System.Data.SqlClient.SqlCommandBuilder"
- usePositionalParameters = "false"
- useParameterPrefixInSql = "true"
- useParameterPrefixInParameter = "true"
- parameterPrefix="@"
- />
- <provider
- name="sqlServer1.1"
- enabled="false"
- assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
- connectionClass="System.Data.SqlClient.SqlConnection"
- commandClass="System.Data.SqlClient.SqlCommand"
- parameterClass="System.Data.SqlClient.SqlParameter"
- parameterDbTypeClass="System.Data.SqlDbType"
- parameterDbTypeProperty="SqlDbType"
- dataAdapterClass="System.Data.SqlClient.SqlDataAdapter"
- commandBuilderClass="System.Data.SqlClient.SqlCommandBuilder"
- usePositionalParameters = "false"
- useParameterPrefixInSql = "true"
- useParameterPrefixInParameter = "true"
- parameterPrefix="@"
- />
- <provider
- name="OleDb1.1"
- default="true"
- assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
- connectionClass="System.Data.OleDb.OleDbConnection"
- commandClass="System.Data.OleDb.OleDbCommand"
- parameterClass="System.Data.OleDb.OleDbParameter"
- parameterDbTypeClass="System.Data.OleDb.OleDbType"
- parameterDbTypeProperty="OleDbType"
- dataAdapterClass="System.Data.OleDb.OleDbDataAdapter"
- commandBuilderClass="System.Data.OleDb.OleDbCommandBuilder"
- usePositionalParameters = "true"
- useParameterPrefixInSql = "false"
- useParameterPrefixInParameter = "false"
- parameterPrefix = ""
- />
- <provider
- name="Odbc1.1"
- enabled="false"
- assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
- connectionClass="System.Data.Odbc.OdbcConnection"
- commandClass="System.Data.Odbc.OdbcCommand"
- parameterClass="System.Data.Odbc.OdbcParameter"
- parameterDbTypeClass="System.Data.Odbc.OdbcType"
- parameterDbTypeProperty="OdbcType"
- dataAdapterClass="System.Data.Odbc.OdbcDataAdapter"
- commandBuilderClass="System.Data.Odbc.OdbcCommandBuilder"
- usePositionalParameters = "true"
- useParameterPrefixInSql = "false"
- useParameterPrefixInParameter = "false"
- parameterPrefix = "@"
- />
- <provider
- name="oracle9.2"
- enabled="false"
- assemblyName="Oracle.DataAccess, Version=9.2.0.401,
Culture=neutral, PublicKeyToken=89b483f429c47342"
- connectionClass="Oracle.DataAccess.Client.OracleConnection"
- commandClass="Oracle.DataAccess.Client.OracleCommand"
- parameterClass="Oracle.DataAccess.Client.OracleParameter"
- parameterDbTypeClass="System.Data.Client.OracleDbType"
- parameterDbTypeProperty="OracleDbType"
- dataAdapterClass="Oracle.DataAccess.Client.OracleDataAdapter"
-
commandBuilderClass="Oracle.DataAccess.Client.OracleCommandBuilder"
- usePositionalParameters = "false"
- useParameterPrefixInSql = "true"
- useParameterPrefixInParameter = "false"
- parameterPrefix=":"
- />
- <provider
- name="ByteFx"
- enabled="false"
- assemblyName="ByteFX.MySqlClient, Version=0.7.6.15073,
Culture=neutral, PublicKeyToken=f2fef6fed1732fc1"
- connectionClass="ByteFX.Data.MySqlClient.MySqlConnection"
- commandClass="ByteFX.Data.MySqlClient.MySqlCommand"
- parameterClass="ByteFX.Data.MySqlClient.MySqlParameter"
- parameterDbTypeClass="ByteFX.Data.MySqlClient.MySqlDbType"
- parameterDbTypeProperty="MySqlDbType"
- dataAdapterClass="ByteFX.Data.MySqlClient.MySqlDataAdapter"
-
commandBuilderClass="ByteFX.Data.MySqlClient.MySqlCommandBuilder"
- usePositionalParameters = "false"
- useParameterPrefixInSql = "true"
- useParameterPrefixInParameter = "true"
- parameterPrefix="@"
- />
</providers>
-
Modified: ibatis/trunk/cs/tutorial/Model/bin/Debug/sqlmap.config
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/tutorial/Model/bin/Debug/sqlmap.config?rev=354175&r1=354174&r2=354175&view=diff
==============================================================================
--- ibatis/trunk/cs/tutorial/Model/bin/Debug/sqlmap.config (original)
+++ ibatis/trunk/cs/tutorial/Model/bin/Debug/sqlmap.config Mon Dec 5 12:39:29
2005
@@ -1,5 +1,6 @@
<?xml version="1.0" encoding="utf-8"?>
-<sqlMapConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:noNamespaceSchemaLocation="SqlMapConfig.xsd">
+<sqlMapConfig xmlns="http://ibatis.apache.org/dataMapper";
+xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
 <properties resource="properties.config"/>
Â
Added: ibatis/trunk/cs/tutorial/WebView/ReadMe.txt
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/tutorial/WebView/ReadMe.txt?rev=354175&view=auto
==============================================================================
--- ibatis/trunk/cs/tutorial/WebView/ReadMe.txt (added)
+++ ibatis/trunk/cs/tutorial/WebView/ReadMe.txt Mon Dec 5 12:39:29 2005
@@ -0,0 +1,6 @@
+If you got error
+"Operation must use an updateable query."
+
+This is almost always a permissions issue. Be sure that the MDB file is in a
folder
+where <machineName>\ASPNET have read/write access
+(because it needs to create an .LDB file when modifying the database).
Modified: ibatis/trunk/cs/tutorial/WebView/Resources/PersonHelper.xml
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/tutorial/WebView/Resources/PersonHelper.xml?rev=354175&r1=354174&r2=354175&view=diff
==============================================================================
--- ibatis/trunk/cs/tutorial/WebView/Resources/PersonHelper.xml (original)
+++ ibatis/trunk/cs/tutorial/WebView/Resources/PersonHelper.xml Mon Dec 5
12:39:29 2005
@@ -1,9 +1,8 @@
<?xml version="1.0" encoding="utf-8" ?>
-<sqlMap
- namespace="Person"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
- xsi:noNamespaceSchemaLocation="SqlMap.xsd">
+<sqlMap namespace="Account"
+xmlns="http://ibatis.apache.org/mapping";
+xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; >
<!-- XML "behind" document for the People service class. -->
Modified: ibatis/trunk/cs/tutorial/WebView/Resources/iBatisTutorial.mdb
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/tutorial/WebView/Resources/iBatisTutorial.mdb?rev=354175&r1=354174&r2=354175&view=diff
==============================================================================
Binary files - no diff available.
Modified: ibatis/trunk/cs/tutorial/WebView/WebView.csproj
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/tutorial/WebView/WebView.csproj?rev=354175&r1=354174&r2=354175&view=diff
==============================================================================
--- ibatis/trunk/cs/tutorial/WebView/WebView.csproj (original)
+++ ibatis/trunk/cs/tutorial/WebView/WebView.csproj Mon Dec 5 12:39:29 2005
@@ -132,6 +132,10 @@
BuildAction = "None"
/>
<File
+ RelPath = "ReadMe.txt"
+ BuildAction = "Content"
+ />
+ <File
RelPath = "sqlmap.config"
BuildAction = "Content"
/>
Modified: ibatis/trunk/cs/tutorial/WebView/properties.config
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/tutorial/WebView/properties.config?rev=354175&r1=354174&r2=354175&view=diff
==============================================================================
--- ibatis/trunk/cs/tutorial/WebView/properties.config (original)
+++ ibatis/trunk/cs/tutorial/WebView/properties.config Mon Dec 5 12:39:29 2005
@@ -5,6 +5,6 @@
<add key="provider" value="OleDb1.1" />
<add
key="connectionString"
- value="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\projects\ibatis\asf\trunk\cs\tutorial\WebView\Resources\iBatisTutorial.mdb"
/>
+ value="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=H:\iBATIS\trunk\cs\tutorial\WebView\Resources\iBatisTutorial.mdb" />
<add key="root" value="./" />
</settings>
Modified: ibatis/trunk/cs/tutorial/WebView/providers.config
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/tutorial/WebView/providers.config?rev=354175&r1=354174&r2=354175&view=diff
==============================================================================
--- ibatis/trunk/cs/tutorial/WebView/providers.config (original)
+++ ibatis/trunk/cs/tutorial/WebView/providers.config Mon Dec 5 12:39:29 2005
@@ -1,102 +1,38 @@
-<?xml version="1.0" encoding="utf-8" ?>
+<?xml version="1.0" encoding="utf-8"?>
+<providers
+xmlns="http://ibatis.apache.org/providers";
+xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
+
+<clear/>
+
+<provider name="OleDb1.1"
+ description="OleDb, provider V1.0.5000.0 in framework .NET V1.1"
+ enabled="true"
+ assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
connectionClass="System.Data.OleDb.OleDbConnection"
+ commandClass="System.Data.OleDb.OleDbCommand"
+ parameterClass="System.Data.OleDb.OleDbParameter"
+ parameterDbTypeClass="System.Data.OleDb.OleDbType"
+ parameterDbTypeProperty="OleDbType"
+ dataAdapterClass="System.Data.OleDb.OleDbDataAdapter"
+ commandBuilderClass="System.Data.OleDb.OleDbCommandBuilder"
+ usePositionalParameters="true"
+ useParameterPrefixInSql="false"
+ useParameterPrefixInParameter="false"
+ parameterPrefix=""/>
+<provider
+ name="Odbc1.1"
+ description="Odbc, provider V1.0.5000.0 in framework .NET V1.1"
+ enabled="true"
+ assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
connectionClass="System.Data.Odbc.OdbcConnection"
+ commandClass="System.Data.Odbc.OdbcCommand"
+ parameterClass="System.Data.Odbc.OdbcParameter"
+ parameterDbTypeClass="System.Data.Odbc.OdbcType"
+ parameterDbTypeProperty="OdbcType"
+ dataAdapterClass="System.Data.Odbc.OdbcDataAdapter"
+ commandBuilderClass="System.Data.Odbc.OdbcCommandBuilder"
+ usePositionalParameters="true"
+ useParameterPrefixInSql="false"
+ useParameterPrefixInParameter="false"
+ parameterPrefix="@"/>
-<providers>
- <clear/>
- <provider
- name="sqlServer1.0"
- enabled="false"
- assemblyName="System.Data, Version=1.0.3300.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
- connectionClass="System.Data.SqlClient.SqlConnection"
- commandClass="System.Data.SqlClient.SqlCommand"
- parameterClass="System.Data.SqlClient.SqlParameter"
- parameterDbTypeClass="System.Data.SqlDbType"
- parameterDbTypeProperty="SqlDbType"
- dataAdapterClass="System.Data.SqlClient.SqlDataAdapter"
- commandBuilderClass="System.Data.SqlClient.SqlCommandBuilder"
- usePositionalParameters = "false"
- useParameterPrefixInSql = "true"
- useParameterPrefixInParameter = "true"
- parameterPrefix="@"
- />
- <provider
- name="sqlServer1.1"
- enabled="false"
- assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
- connectionClass="System.Data.SqlClient.SqlConnection"
- commandClass="System.Data.SqlClient.SqlCommand"
- parameterClass="System.Data.SqlClient.SqlParameter"
- parameterDbTypeClass="System.Data.SqlDbType"
- parameterDbTypeProperty="SqlDbType"
- dataAdapterClass="System.Data.SqlClient.SqlDataAdapter"
- commandBuilderClass="System.Data.SqlClient.SqlCommandBuilder"
- usePositionalParameters = "false"
- useParameterPrefixInSql = "true"
- useParameterPrefixInParameter = "true"
- parameterPrefix="@"
- />
- <provider
- name="OleDb1.1"
- default="true"
- assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
- connectionClass="System.Data.OleDb.OleDbConnection"
- commandClass="System.Data.OleDb.OleDbCommand"
- parameterClass="System.Data.OleDb.OleDbParameter"
- parameterDbTypeClass="System.Data.OleDb.OleDbType"
- parameterDbTypeProperty="OleDbType"
- dataAdapterClass="System.Data.OleDb.OleDbDataAdapter"
- commandBuilderClass="System.Data.OleDb.OleDbCommandBuilder"
- usePositionalParameters = "true"
- useParameterPrefixInSql = "false"
- useParameterPrefixInParameter = "false"
- parameterPrefix = ""
- />
- <provider
- name="Odbc1.1"
- enabled="false"
- assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089"
- connectionClass="System.Data.Odbc.OdbcConnection"
- commandClass="System.Data.Odbc.OdbcCommand"
- parameterClass="System.Data.Odbc.OdbcParameter"
- parameterDbTypeClass="System.Data.Odbc.OdbcType"
- parameterDbTypeProperty="OdbcType"
- dataAdapterClass="System.Data.Odbc.OdbcDataAdapter"
- commandBuilderClass="System.Data.Odbc.OdbcCommandBuilder"
- usePositionalParameters = "true"
- useParameterPrefixInSql = "false"
- useParameterPrefixInParameter = "false"
- parameterPrefix = "@"
- />
- <provider
- name="oracle9.2"
- enabled="false"
- assemblyName="Oracle.DataAccess, Version=9.2.0.401,
Culture=neutral, PublicKeyToken=89b483f429c47342"
- connectionClass="Oracle.DataAccess.Client.OracleConnection"
- commandClass="Oracle.DataAccess.Client.OracleCommand"
- parameterClass="Oracle.DataAccess.Client.OracleParameter"
- parameterDbTypeClass="System.Data.Client.OracleDbType"
- parameterDbTypeProperty="OracleDbType"
- dataAdapterClass="Oracle.DataAccess.Client.OracleDataAdapter"
-
commandBuilderClass="Oracle.DataAccess.Client.OracleCommandBuilder"
- usePositionalParameters = "false"
- useParameterPrefixInSql = "true"
- useParameterPrefixInParameter = "false"
- parameterPrefix=":"
- />
- <provider
- name="ByteFx"
- enabled="false"
- assemblyName="ByteFX.MySqlClient, Version=0.7.6.15073,
Culture=neutral, PublicKeyToken=f2fef6fed1732fc1"
- connectionClass="ByteFX.Data.MySqlClient.MySqlConnection"
- commandClass="ByteFX.Data.MySqlClient.MySqlCommand"
- parameterClass="ByteFX.Data.MySqlClient.MySqlParameter"
- parameterDbTypeClass="ByteFX.Data.MySqlClient.MySqlDbType"
- parameterDbTypeProperty="MySqlDbType"
- dataAdapterClass="ByteFX.Data.MySqlClient.MySqlDataAdapter"
-
commandBuilderClass="ByteFX.Data.MySqlClient.MySqlCommandBuilder"
- usePositionalParameters = "false"
- useParameterPrefixInSql = "true"
- useParameterPrefixInParameter = "true"
- parameterPrefix="@"
- />
</providers>
-
Modified: ibatis/trunk/cs/tutorial/WebView/sqlmap.config
URL:
http://svn.apache.org/viewcvs/ibatis/trunk/cs/tutorial/WebView/sqlmap.config?rev=354175&r1=354174&r2=354175&view=diff
==============================================================================
--- ibatis/trunk/cs/tutorial/WebView/sqlmap.config (original)
+++ ibatis/trunk/cs/tutorial/WebView/sqlmap.config Mon Dec 5 12:39:29 2005
@@ -1,5 +1,6 @@
<?xml version="1.0" encoding="UTF-8" ?>
-<sqlMapConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:noNamespaceSchemaLocation="SqlMapConfig.xsd">
+<sqlMapConfig xmlns="http://ibatis.apache.org/dataMapper";
+xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
 <properties resource="properties.config"/>
Â
@@ -14,7 +15,7 @@
</database>
<sqlMaps>
- <sqlMap resource="${root}Resources/PersonHelper.xml"/>
+ <sqlMap resource="Resources/PersonHelper.xml"/>
</sqlMaps>
</sqlMapConfig>
