You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Roberto Rabe (JIRA)" <ib...@incubator.apache.org> on 2005/05/06 07:29:05 UTC

[jira] Created: (IBATISNET-53) Oracle with ODP.NET 10g Dynamic Composite Key Mapping

Oracle with ODP.NET 10g Dynamic Composite Key Mapping
-----------------------------------------------------

         Key: IBATISNET-53
         URL: http://issues.apache.org/jira/browse/IBATISNET-53
     Project: iBatis for .NET
        Type: Bug
    Versions: DataMapper 1.1    
 Environment: Oracle 9i with ODP.NET 10g provider using current SVN code (5 May 2005)
    Reporter: Roberto Rabe
 Assigned to: Gilles Bayon 


The NUnit ResultMapTest.TestDynamiqueCompositeKeyMapping throws an Oracle.DataAccess.Types.OracleTypeException : numeric precision specifier is out of range (1 to 38)
		
		at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
		at Oracle.DataAccess.Client.OracleCommand.System.Data.IDbCommand.ExecuteReader()
		at IBatisNet.DataMapper.MappedStatements.MappedStatement.RunQueryForObject(RequestScope request, IDalSession session, Object parameterObject, Object resultObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 571
		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject, Object resultObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 517
		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 498
		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecutePostSelect(IDalSession session, RequestScope request) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 1027
		at IBatisNet.DataMapper.MappedStatements.MappedStatement.RunQueryForObject(RequestScope request, IDalSession session, Object parameterObject, Object resultObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 579
		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject, Object resultObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 517
		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 498
		at IBatisNet.DataMapper.SqlMapper.QueryForObject(String statementName, Object parameterObject) in c:\projects\ibatis\asf\trunk\cs\mapper\ibatisnet.datamapper\sqlmapper.cs:line 508
		at IBatisNet.DataMapper.Test.NUnit.SqlMapTests.ResultMapTest.TestDynamiqueCompositeKeyMapping() in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper.Test\NUnit\SqlMapTests\ResultMapTest.cs:line 276

The issue is caused when ExecutePostSelect calls ExecuteQueryForObject which sets the parameters with ApplyParameterMap.  Unfortunately, the proper DbType (Int32) is not set since that part of the code is commented (for other reasons).


-- 
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] Updated: (IBATISNET-53) ODP.NET 10g Dynamic Composite Key Mapping

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

Roberto Rabe updated IBATISNET-53:
----------------------------------

    Summary: ODP.NET 10g Dynamic Composite Key Mapping  (was: Oracle with ODP.NET 10g Dynamic Composite Key Mapping)

> ODP.NET 10g Dynamic Composite Key Mapping
> -----------------------------------------
>
>          Key: IBATISNET-53
>          URL: http://issues.apache.org/jira/browse/IBATISNET-53
>      Project: iBatis for .NET
>         Type: Bug
>     Versions: DataMapper 1.1
>  Environment: Oracle 9i with ODP.NET 10g provider using current SVN code (5 May 2005)
>     Reporter: Roberto Rabe
>     Assignee: Gilles Bayon

>
> The NUnit ResultMapTest.TestDynamiqueCompositeKeyMapping throws an Oracle.DataAccess.Types.OracleTypeException : numeric precision specifier is out of range (1 to 38)
> 		
> 		at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
> 		at Oracle.DataAccess.Client.OracleCommand.System.Data.IDbCommand.ExecuteReader()
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.RunQueryForObject(RequestScope request, IDalSession session, Object parameterObject, Object resultObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 571
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject, Object resultObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 517
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 498
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecutePostSelect(IDalSession session, RequestScope request) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 1027
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.RunQueryForObject(RequestScope request, IDalSession session, Object parameterObject, Object resultObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 579
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject, Object resultObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 517
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 498
> 		at IBatisNet.DataMapper.SqlMapper.QueryForObject(String statementName, Object parameterObject) in c:\projects\ibatis\asf\trunk\cs\mapper\ibatisnet.datamapper\sqlmapper.cs:line 508
> 		at IBatisNet.DataMapper.Test.NUnit.SqlMapTests.ResultMapTest.TestDynamiqueCompositeKeyMapping() in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper.Test\NUnit\SqlMapTests\ResultMapTest.cs:line 276
> The issue is caused when ExecutePostSelect calls ExecuteQueryForObject which sets the parameters with ApplyParameterMap.  Unfortunately, the proper DbType (Int32) is not set since that part of the code is commented (for other reasons).

-- 
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] Assigned: (IBATISNET-53) ODP.NET 10g Dynamic Composite Key Mapping

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

Gilles Bayon reassigned IBATISNET-53:
-------------------------------------

    Assign To: Roberto Rabe  (was: Gilles Bayon)

> ODP.NET 10g Dynamic Composite Key Mapping
> -----------------------------------------
>
>          Key: IBATISNET-53
>          URL: http://issues.apache.org/jira/browse/IBATISNET-53
>      Project: iBatis for .NET
>         Type: Bug
>     Versions: DataMapper 1.1
>  Environment: Oracle 9i with ODP.NET 10g provider using current SVN code (5 May 2005)
>     Reporter: Roberto Rabe
>     Assignee: Roberto Rabe

>
> The NUnit ResultMapTest.TestDynamiqueCompositeKeyMapping throws an Oracle.DataAccess.Types.OracleTypeException : numeric precision specifier is out of range (1 to 38)
> 		
> 		at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
> 		at Oracle.DataAccess.Client.OracleCommand.System.Data.IDbCommand.ExecuteReader()
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.RunQueryForObject(RequestScope request, IDalSession session, Object parameterObject, Object resultObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 571
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject, Object resultObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 517
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 498
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecutePostSelect(IDalSession session, RequestScope request) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 1027
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.RunQueryForObject(RequestScope request, IDalSession session, Object parameterObject, Object resultObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 579
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject, Object resultObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 517
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 498
> 		at IBatisNet.DataMapper.SqlMapper.QueryForObject(String statementName, Object parameterObject) in c:\projects\ibatis\asf\trunk\cs\mapper\ibatisnet.datamapper\sqlmapper.cs:line 508
> 		at IBatisNet.DataMapper.Test.NUnit.SqlMapTests.ResultMapTest.TestDynamiqueCompositeKeyMapping() in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper.Test\NUnit\SqlMapTests\ResultMapTest.cs:line 276
> The issue is caused when ExecutePostSelect calls ExecuteQueryForObject which sets the parameters with ApplyParameterMap.  Unfortunately, the proper DbType (Int32) is not set since that part of the code is commented (for other reasons).

-- 
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-53) ODP.NET 10g Dynamic Composite Key Mapping

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

     Resolution: Fixed
    Fix Version: DataMapper 1.2

Gilles applied fix in SVN r178022!

> ODP.NET 10g Dynamic Composite Key Mapping
> -----------------------------------------
>
>          Key: IBATISNET-53
>          URL: http://issues.apache.org/jira/browse/IBATISNET-53
>      Project: iBatis for .NET
>         Type: Bug
>     Versions: DataMapper 1.1
>  Environment: Oracle 9i with ODP.NET 10g provider using current SVN code (5 May 2005)
>     Reporter: Roberto Rabe
>     Assignee: Roberto Rabe
>      Fix For: DataMapper 1.2

>
> The NUnit ResultMapTest.TestDynamiqueCompositeKeyMapping throws an Oracle.DataAccess.Types.OracleTypeException : numeric precision specifier is out of range (1 to 38)
> 		
> 		at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
> 		at Oracle.DataAccess.Client.OracleCommand.System.Data.IDbCommand.ExecuteReader()
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.RunQueryForObject(RequestScope request, IDalSession session, Object parameterObject, Object resultObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 571
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject, Object resultObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 517
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 498
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecutePostSelect(IDalSession session, RequestScope request) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 1027
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.RunQueryForObject(RequestScope request, IDalSession session, Object parameterObject, Object resultObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 579
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject, Object resultObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 517
> 		at IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(IDalSession session, Object parameterObject) in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper\MappedStatements\MappedStatement.cs:line 498
> 		at IBatisNet.DataMapper.SqlMapper.QueryForObject(String statementName, Object parameterObject) in c:\projects\ibatis\asf\trunk\cs\mapper\ibatisnet.datamapper\sqlmapper.cs:line 508
> 		at IBatisNet.DataMapper.Test.NUnit.SqlMapTests.ResultMapTest.TestDynamiqueCompositeKeyMapping() in C:\projects\ibatis\asf\trunk\cs\mapper\IBatisNet.DataMapper.Test\NUnit\SqlMapTests\ResultMapTest.cs:line 276
> The issue is caused when ExecutePostSelect calls ExecuteQueryForObject which sets the parameters with ApplyParameterMap.  Unfortunately, the proper DbType (Int32) is not set since that part of the code is commented (for other reasons).

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