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:40:04 UTC

[jira] Created: (IBATISNET-54) ODP.NET 10g (10.1) GetBoolean and GetGuid Support

ODP.NET 10g (10.1) GetBoolean and GetGuid Support
-------------------------------------------------

         Key: IBATISNET-54
         URL: http://issues.apache.org/jira/browse/IBATISNET-54
     Project: iBatis for .NET
        Type: Wish
    Versions: DataMapper 1.1    
 Environment: Oracle 9i with ODP.NET 10g (10.1) provider
    Reporter: Roberto Rabe
    Priority: Minor


This is not an iBATIS.NET-specific issue but is being recorded in JIRA for future tracking.

Currently, the provider does not support OracleDataReader.GetGuid or OracleDataReader.GetBoolean methods.

There are workarounds by using other class property CLR types and storing the GUID or Boolean data as VARCHAR2 or other dbTypes.

-- 
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-54) ODP.NET 10g (10.1) GetBoolean and GetGuid Support

Posted by "Gilles Bayon (JIRA)" <ib...@incubator.apache.org>.
     [ http://issues.apache.org/jira/browse/IBATISNET-54?page=comments#action_64703 ]
     
Gilles Bayon commented on IBATISNET-54:
---------------------------------------

Another workaround to overcome some of the shortcommings in the OracleClient and ODP is to use a 'custom type handler'.


> ODP.NET 10g (10.1) GetBoolean and GetGuid Support
> -------------------------------------------------
>
>          Key: IBATISNET-54
>          URL: http://issues.apache.org/jira/browse/IBATISNET-54
>      Project: iBatis for .NET
>         Type: Wish
>     Versions: DataMapper 1.1
>  Environment: Oracle 9i with ODP.NET 10g (10.1) provider
>     Reporter: Roberto Rabe
>     Assignee: Roberto Rabe
>     Priority: Minor

>
> This is not an iBATIS.NET-specific issue but is being recorded in JIRA for future tracking.
> Currently, the provider does not support OracleDataReader.GetGuid or OracleDataReader.GetBoolean methods.
> There are workarounds by using other class property CLR types and storing the GUID or Boolean data as VARCHAR2 or other dbTypes.

-- 
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-54) ODP.NET 10g (10.1) GetBoolean and GetGuid Support

Posted by "Roberto Rabe (JIRA)" <ib...@incubator.apache.org>.
     [ http://issues.apache.org/jira/browse/IBATISNET-54?page=comments#action_64705 ]
     
Roberto Rabe commented on IBATISNET-54:
---------------------------------------

Just to clarify the prior comment:  The custom typehandler works great for resultMaps and parameterMaps!

For the resultClass tests, the Convert.ToBoolean (ODP and MS OracleClient), Convert.ToByte (MS OracleClient) changes, and new Guid(dataReader.GetValue(...).ToString()) changes in the basic typehandlers work fine.  



> ODP.NET 10g (10.1) GetBoolean and GetGuid Support
> -------------------------------------------------
>
>          Key: IBATISNET-54
>          URL: http://issues.apache.org/jira/browse/IBATISNET-54
>      Project: iBatis for .NET
>         Type: Wish
>     Versions: DataMapper 1.1
>  Environment: Oracle 9i with ODP.NET 10g (10.1) provider
>     Reporter: Roberto Rabe
>     Assignee: Roberto Rabe
>     Priority: Minor

>
> This is not an iBATIS.NET-specific issue but is being recorded in JIRA for future tracking.
> Currently, the provider does not support OracleDataReader.GetGuid or OracleDataReader.GetBoolean methods.
> There are workarounds by using other class property CLR types and storing the GUID or Boolean data as VARCHAR2 or other dbTypes.

-- 
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-54) ODP.NET 10g (10.1) GetBoolean and GetGuid Support

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


Closing issue.

> ODP.NET 10g (10.1) GetBoolean and GetGuid Support
> -------------------------------------------------
>
>          Key: IBATISNET-54
>          URL: http://issues.apache.org/jira/browse/IBATISNET-54
>      Project: iBatis for .NET
>         Type: Wish
>     Versions: DataMapper 1.1
>  Environment: Oracle 9i with ODP.NET 10g (10.1) provider
>     Reporter: Roberto Rabe
>     Assignee: Roberto Rabe
>     Priority: Minor
>      Fix For: DataMapper 1.2

>
> This is not an iBATIS.NET-specific issue but is being recorded in JIRA for future tracking.
> Currently, the provider does not support OracleDataReader.GetGuid or OracleDataReader.GetBoolean methods.
> There are workarounds by using other class property CLR types and storing the GUID or Boolean data as VARCHAR2 or other dbTypes.

-- 
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-54) ODP.NET 10g (10.1) GetBoolean and GetGuid Support

Posted by "Roberto Rabe (JIRA)" <ib...@incubator.apache.org>.
     [ http://issues.apache.org/jira/browse/IBATISNET-54?page=comments#action_64704 ]
     
Roberto Rabe commented on IBATISNET-54:
---------------------------------------

Thanks for adding that feature Gilles!  Works great for this!

> ODP.NET 10g (10.1) GetBoolean and GetGuid Support
> -------------------------------------------------
>
>          Key: IBATISNET-54
>          URL: http://issues.apache.org/jira/browse/IBATISNET-54
>      Project: iBatis for .NET
>         Type: Wish
>     Versions: DataMapper 1.1
>  Environment: Oracle 9i with ODP.NET 10g (10.1) provider
>     Reporter: Roberto Rabe
>     Assignee: Roberto Rabe
>     Priority: Minor

>
> This is not an iBATIS.NET-specific issue but is being recorded in JIRA for future tracking.
> Currently, the provider does not support OracleDataReader.GetGuid or OracleDataReader.GetBoolean methods.
> There are workarounds by using other class property CLR types and storing the GUID or Boolean data as VARCHAR2 or other dbTypes.

-- 
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] Resolved: (IBATISNET-54) ODP.NET 10g (10.1) GetBoolean and GetGuid Support

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

     Resolution: Fixed
    Fix Version: DataMapper 1.2

NUnit tests now pass!

> ODP.NET 10g (10.1) GetBoolean and GetGuid Support
> -------------------------------------------------
>
>          Key: IBATISNET-54
>          URL: http://issues.apache.org/jira/browse/IBATISNET-54
>      Project: iBatis for .NET
>         Type: Wish
>     Versions: DataMapper 1.1
>  Environment: Oracle 9i with ODP.NET 10g (10.1) provider
>     Reporter: Roberto Rabe
>     Assignee: Roberto Rabe
>     Priority: Minor
>      Fix For: DataMapper 1.2

>
> This is not an iBATIS.NET-specific issue but is being recorded in JIRA for future tracking.
> Currently, the provider does not support OracleDataReader.GetGuid or OracleDataReader.GetBoolean methods.
> There are workarounds by using other class property CLR types and storing the GUID or Boolean data as VARCHAR2 or other dbTypes.

-- 
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-54) ODP.NET 10g (10.1) GetBoolean and GetGuid Support

Posted by "Gilles Bayon (JIRA)" <ib...@incubator.apache.org>.
     [ http://issues.apache.org/jira/browse/IBATISNET-54?page=comments#action_64636 ]
     
Gilles Bayon commented on IBATISNET-54:
---------------------------------------

Another workaround is to use

Convert.ToBoolean( dataReader.GetValue(..) )

instead of dataReader.GetBoolean(...);

in BooleanTypeHandler (same workaround to GuidTypeHandler).

What do you think ?



> ODP.NET 10g (10.1) GetBoolean and GetGuid Support
> -------------------------------------------------
>
>          Key: IBATISNET-54
>          URL: http://issues.apache.org/jira/browse/IBATISNET-54
>      Project: iBatis for .NET
>         Type: Wish
>     Versions: DataMapper 1.1
>  Environment: Oracle 9i with ODP.NET 10g (10.1) provider
>     Reporter: Roberto Rabe
>     Priority: Minor

>
> This is not an iBATIS.NET-specific issue but is being recorded in JIRA for future tracking.
> Currently, the provider does not support OracleDataReader.GetGuid or OracleDataReader.GetBoolean methods.
> There are workarounds by using other class property CLR types and storing the GUID or Boolean data as VARCHAR2 or other dbTypes.

-- 
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-54) ODP.NET 10g (10.1) GetBoolean and GetGuid Support

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

Gilles Bayon reassigned IBATISNET-54:
-------------------------------------

    Assign To: Roberto Rabe

> ODP.NET 10g (10.1) GetBoolean and GetGuid Support
> -------------------------------------------------
>
>          Key: IBATISNET-54
>          URL: http://issues.apache.org/jira/browse/IBATISNET-54
>      Project: iBatis for .NET
>         Type: Wish
>     Versions: DataMapper 1.1
>  Environment: Oracle 9i with ODP.NET 10g (10.1) provider
>     Reporter: Roberto Rabe
>     Assignee: Roberto Rabe
>     Priority: Minor

>
> This is not an iBATIS.NET-specific issue but is being recorded in JIRA for future tracking.
> Currently, the provider does not support OracleDataReader.GetGuid or OracleDataReader.GetBoolean methods.
> There are workarounds by using other class property CLR types and storing the GUID or Boolean data as VARCHAR2 or other dbTypes.

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