You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Ron Grabowski (JIRA)" <ib...@incubator.apache.org> on 2005/09/21 17:57:28 UTC

[jira] Created: (IBATISNET-114) Add support for Java's remapResults="true"

Add support for Java's remapResults="true"
------------------------------------------

         Key: IBATISNET-114
         URL: http://issues.apache.org/jira/browse/IBATISNET-114
     Project: iBatis for .NET
        Type: Bug
    Reporter: Ron Grabowski
 Assigned to: Gilles Bayon 
    Priority: Minor


// DynamicTest.cs
[Test] 
public void TestDynamicSqlOnColumnSelection() 
{
 Account paramAccount = new Account();
 Account resultAccount = new Account();
 IList list = null;

 paramAccount.LastName = "Dalton";
 list = sqlMap.QueryForList("DynamicSqlOnColumnSelection", paramAccount);
 resultAccount = (Account)list[0];
 Console.WriteLine("FirstName: [{0}]", resultAccount.FirstName);
 AssertAccount1((Account) list[0]);
 Assert.AreEqual(5, list.Count);

 paramAccount.LastName = "Bayon";
 list = sqlMap.QueryForList("DynamicSqlOnColumnSelection", paramAccount);
 resultAccount = (Account)list[0];			
 // should be null
 Console.WriteLine("FirstName: [{0}]", resultAccount.FirstName);
 AssertAccount1(resultAccount);
 Assert.AreEqual(5, list.Count);
}

<!-- populate certain fields based on the parameterObject -->
<statement
 id="DynamicSqlOnColumnSelection" 
 parameterClass="Account" 
 resultClass="Account">
 SELECT
  Account_ID as Id,
  <isEqual property="LastName" compareValue="Dalton" >
   Account_FirstName as FirstName,
  </isEqual>
  <isEqual property="LastName" compareValue="Dalton" >
   Account_LastName as LastName,
  </isEqual>
  Account_Email as EmailAddress
 FROM
  Accounts
</statement>



-- 
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


[jira] Closed: (IBATISNET-114) Add support for Java's remapResults="true"

Posted by "Gilles Bayon (JIRA)" <ib...@incubator.apache.org>.
     [ http://issues.apache.org/jira/browse/IBATISNET-114?page=all ]
     
Gilles Bayon closed IBATISNET-114:
----------------------------------

    Fix Version: DataMapper 1.3
     Resolution: Fixed

In SVN

> Add support for Java's remapResults="true"
> ------------------------------------------
>
>          Key: IBATISNET-114
>          URL: http://issues.apache.org/jira/browse/IBATISNET-114
>      Project: iBatis for .NET
>         Type: Bug
>     Reporter: Ron Grabowski
>     Assignee: Gilles Bayon
>     Priority: Minor
>      Fix For: DataMapper 1.3

>
> // DynamicTest.cs
> [Test] 
> public void TestDynamicSqlOnColumnSelection() 
> {
>  Account paramAccount = new Account();
>  Account resultAccount = new Account();
>  IList list = null;
>  paramAccount.LastName = "Dalton";
>  list = sqlMap.QueryForList("DynamicSqlOnColumnSelection", paramAccount);
>  resultAccount = (Account)list[0];
>  Console.WriteLine("FirstName: [{0}]", resultAccount.FirstName);
>  AssertAccount1((Account) list[0]);
>  Assert.AreEqual(5, list.Count);
>  paramAccount.LastName = "Bayon";
>  list = sqlMap.QueryForList("DynamicSqlOnColumnSelection", paramAccount);
>  resultAccount = (Account)list[0];			
>  // should be null
>  Console.WriteLine("FirstName: [{0}]", resultAccount.FirstName);
>  AssertAccount1(resultAccount);
>  Assert.AreEqual(5, list.Count);
> }
> <!-- populate certain fields based on the parameterObject -->
> <statement
>  id="DynamicSqlOnColumnSelection" 
>  parameterClass="Account" 
>  resultClass="Account">
>  SELECT
>   Account_ID as Id,
>   <isEqual property="LastName" compareValue="Dalton" >
>    Account_FirstName as FirstName,
>   </isEqual>
>   <isEqual property="LastName" compareValue="Dalton" >
>    Account_LastName as LastName,
>   </isEqual>
>   Account_Email as EmailAddress
>  FROM
>   Accounts
> </statement>

-- 
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


[jira] Commented: (IBATISNET-114) Add support for Java's remapResults="true"

Posted by "Ron Grabowski (JIRA)" <ib...@incubator.apache.org>.
    [ http://issues.apache.org/jira/browse/IBATISNET-114?page=comments#action_12330105 ] 

Ron Grabowski commented on IBATISNET-114:
-----------------------------------------

System.IndexOutOfRangeException : FirstName

at IBatisNet.DataMapper.TypeHandlers.StringTypeHandler.GetValueByName(ResultProperty mapping, IDataReader dataReader) in
\IBatisNet.DataMapper\TypeHandlers\StringTypeHandler.cs:line 54

at IBatisNet.DataMapper.Configuration.ResultMapping.ResultProperty.GetDataBaseValue(IDataReader dataReader) in
\IBatisNet.DataMapper\Configuration\ResultMapping\ResultProperty.cs:line 310

at IBatisNet.DataMapper.MappedStatements.ReaderAutoMapper.AutoMapReader(IDataReader reader, Object& resultObject) in
\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 1170

at IBatisNet.DataMapper.MappedStatements.MappedStatement.AutoMapReader(IDataReader reader, Object& resultObject) in
\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 1085

at IBatisNet.DataMapper.MappedStatements.MappedStatement.ApplyResultMap(RequestScope request, IDataReader reader, Object resultObject) in
\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 297

at IBatisNet.DataMapper.MappedStatements.MappedStatement.RunQueryForList(RequestScope request, IDalSession session, Object parameterObject, Int32 skipResults, Int32 maxResults, RowDelegate rowDelegate) in
\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 552

at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForList(IDalSession session, Object parameterObject, Int32 skipResults, Int32 maxResults) in
\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 503

at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForList(IDalSession session, Object parameterObject) in
\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 486

at IBatisNet.DataMapper.SqlMapper.QueryForList(String statementName, Object parameterObject) in
\IBatisNet.DataMapper\SqlMapper.cs:line 740


> Add support for Java's remapResults="true"
> ------------------------------------------
>
>          Key: IBATISNET-114
>          URL: http://issues.apache.org/jira/browse/IBATISNET-114
>      Project: iBatis for .NET
>         Type: Bug
>     Reporter: Ron Grabowski
>     Assignee: Gilles Bayon
>     Priority: Minor

>
> // DynamicTest.cs
> [Test] 
> public void TestDynamicSqlOnColumnSelection() 
> {
>  Account paramAccount = new Account();
>  Account resultAccount = new Account();
>  IList list = null;
>  paramAccount.LastName = "Dalton";
>  list = sqlMap.QueryForList("DynamicSqlOnColumnSelection", paramAccount);
>  resultAccount = (Account)list[0];
>  Console.WriteLine("FirstName: [{0}]", resultAccount.FirstName);
>  AssertAccount1((Account) list[0]);
>  Assert.AreEqual(5, list.Count);
>  paramAccount.LastName = "Bayon";
>  list = sqlMap.QueryForList("DynamicSqlOnColumnSelection", paramAccount);
>  resultAccount = (Account)list[0];			
>  // should be null
>  Console.WriteLine("FirstName: [{0}]", resultAccount.FirstName);
>  AssertAccount1(resultAccount);
>  Assert.AreEqual(5, list.Count);
> }
> <!-- populate certain fields based on the parameterObject -->
> <statement
>  id="DynamicSqlOnColumnSelection" 
>  parameterClass="Account" 
>  resultClass="Account">
>  SELECT
>   Account_ID as Id,
>   <isEqual property="LastName" compareValue="Dalton" >
>    Account_FirstName as FirstName,
>   </isEqual>
>   <isEqual property="LastName" compareValue="Dalton" >
>    Account_LastName as LastName,
>   </isEqual>
>   Account_Email as EmailAddress
>  FROM
>   Accounts
> </statement>

-- 
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