You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-cs@ibatis.apache.org by Marcelo de Oliveira <ol...@terra.com.br> on 2009/02/27 00:35:44 UTC

iBatis x Newer DataBases

Hi All,

 

I'd like to know if iBatis Mapper works well with new versions of Sql Server
(2005 and 2008) and with Progress 10.x.

I Have some future customers which I'd like to develop a solution using
iBatis, but according with the page
http://opensource.atlassian.com/confluence/oss/display/IBATIS/What+database-
provider+combinations+have+been+tested+with+the+.NET+DataMapper, only SQL
Server 2000 was tested.

 

I am developing with .net framework 3.5, visual studio 2008, SQL Server 2005
and Progress Databases.

 

Regards,

Marcelo.

Problem with c# automatic properties?

Posted by Sal Bass <sa...@hotmail.com>.
I'm having an issue with Ibatis.Net 1.6.2 and the auto properties of c# 3. Basically I have a nullable boolean property. When I map to the auto property it comes back as false when it should be null. However, when I convert the property to a traditional property with a backing field it comes back correctly as null. Is this a known issue?

 

Thanks!

_________________________________________________________________
Access your email online and on the go with Windows Live Hotmail.
http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_HM_AE_Access_022009

Problem with c# automatic properties?

Posted by Sal Bass <sa...@hotmail.com>.
I'm having an issue with Ibatis.Net 1.6.2 and the auto properties of c# 3. Basically I have a nullable boolean property. When I map to the auto property it comes back as false when it should be null. However, when I convert the property to a traditional property with a backing field it comes back correctly as null. Is this a known issue?

 

Thanks!

_________________________________________________________________
It’s the same Hotmail®. If by “same” you mean up to 70% faster. 
http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_HM_AE_Same_022009

Re: iBatis x Newer DataBases

Posted by Brian Elcock <br...@gmail.com>.
Hello Marcelo.

That is exactly what I am using. I would guess that it may not support
certain functions? But it has been sufficient for my needs and has not
resulted in any errors.

Brian

On Thu, Feb 26, 2009 at 4:49 PM, Marcelo de Oliveira
<ol...@terra.com.br> wrote:
> Hi Brian,
>
> A doubt. In the providers.config, we have some structures for all databases
> supported, like the one below:
>
> <provider
>    name="sqlServer2.0"
>    enabled="true"
>    default="true"
>    description="Microsoft SQL Server, provider V2.0.0.0 in framework .NET
> V2.0"
>    assemblyName="System.Data, Version=2.0.0.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="@"
>    allowMARS="false"
> />
>
> May you tell me what I need to do, to configure that file to support SQL
> Server 2005 ? I think that it could be the same, changing only de name, but
> I would lik to confirm that ! :)
>
> Thanks,
> Marcelo.
>
> -----Mensagem original-----
> De: Brian Elcock [mailto:brian.elcock@gmail.com]
> Enviada em: quinta-feira, 26 de fevereiro de 2009 20:40
> Para: user-cs@ibatis.apache.org
> Assunto: Re: iBatis x Newer DataBases
>
> I have used iBatis with SQL Server 2005 and 2008, using .NET 2.0 and
> 3.5 with no issues. I don't know about Progress.
>
> That's my own experience, for what it's worth.
>
> Regards.
> Brian
>
> On Thu, Feb 26, 2009 at 4:35 PM, Marcelo de Oliveira
> <ol...@terra.com.br> wrote:
>> Hi All,
>>
>>
>>
>> I’d like to know if iBatis Mapper works well with new versions of Sql
> Server
>> (2005 and 2008) and with Progress 10.x.
>>
>> I Have some future customers which I’d like to develop a solution using
>> iBatis, but according with the page
>>
> http://opensource.atlassian.com/confluence/oss/display/IBATIS/What+database-
> provider+combinations+have+been+tested+with+the+.NET+DataMapper,
>> only SQL Server 2000 was tested.
>>
>>
>>
>> I am developing with .net framework 3.5, visual studio 2008, SQL Server
> 2005
>> and Progress Databases.
>>
>>
>>
>> Regards,
>>
>> Marcelo.
>
> E-mail verificado pelo Terra Anti-Spam.
> Para classificar esta mensagem como spam ou não spam, visite
> http://mail.terra.com.br/cgi-bin/reportspam.cgi?+_d=SCY1OTI5MzM5I3Blcm0hdGVy
> cmEmMSwxMjM1NjkxNjQ2LjU4NTI0NS4yMzg0MC5iZXR1bmUudGVycmEuY29tLDQyNDg=
> Verifique periodicamente a pasta Spam para garantir que apenas mensagens
> indesejadas sejam classificadas como Spam.
>
> Esta mensagem foi verificada pelo E-mail Protegido Terra.
> Atualizado em 26/02/2009
>
>
>

RES: iBatis x Newer DataBases

Posted by Marcelo de Oliveira <ol...@terra.com.br>.
Hi Brian,

A doubt. In the providers.config, we have some structures for all databases
supported, like the one below:

<provider
    name="sqlServer2.0"
    enabled="true"
    default="true"
    description="Microsoft SQL Server, provider V2.0.0.0 in framework .NET
V2.0" 
    assemblyName="System.Data, Version=2.0.0.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="@"
    allowMARS="false"
/>

May you tell me what I need to do, to configure that file to support SQL
Server 2005 ? I think that it could be the same, changing only de name, but
I would lik to confirm that ! :)

Thanks,
Marcelo.

-----Mensagem original-----
De: Brian Elcock [mailto:brian.elcock@gmail.com] 
Enviada em: quinta-feira, 26 de fevereiro de 2009 20:40
Para: user-cs@ibatis.apache.org
Assunto: Re: iBatis x Newer DataBases

I have used iBatis with SQL Server 2005 and 2008, using .NET 2.0 and
3.5 with no issues. I don't know about Progress.

That's my own experience, for what it's worth.

Regards.
Brian

On Thu, Feb 26, 2009 at 4:35 PM, Marcelo de Oliveira
<ol...@terra.com.br> wrote:
> Hi All,
>
>
>
> I’d like to know if iBatis Mapper works well with new versions of Sql
Server
> (2005 and 2008) and with Progress 10.x.
>
> I Have some future customers which I’d like to develop a solution using
> iBatis, but according with the page
>
http://opensource.atlassian.com/confluence/oss/display/IBATIS/What+database-
provider+combinations+have+been+tested+with+the+.NET+DataMapper,
> only SQL Server 2000 was tested.
>
>
>
> I am developing with .net framework 3.5, visual studio 2008, SQL Server
2005
> and Progress Databases.
>
>
>
> Regards,
>
> Marcelo.

E-mail verificado pelo Terra Anti-Spam.
Para classificar esta mensagem como spam ou não spam, visite
http://mail.terra.com.br/cgi-bin/reportspam.cgi?+_d=SCY1OTI5MzM5I3Blcm0hdGVy
cmEmMSwxMjM1NjkxNjQ2LjU4NTI0NS4yMzg0MC5iZXR1bmUudGVycmEuY29tLDQyNDg=
Verifique periodicamente a pasta Spam para garantir que apenas mensagens
indesejadas sejam classificadas como Spam.

Esta mensagem foi verificada pelo E-mail Protegido Terra.
Atualizado em 26/02/2009

RES: iBatis x Newer DataBases

Posted by Marcelo de Oliveira <ol...@terra.com.br>.
Thanks Brian !!!

It will help your experience... I will wait someone else answer. I wish
someone had had some kind of experience with Progress, but your opinion will
help me to start my development, to solve a part of my problems !! ;)

Thanks again,
Marcelo.

-----Mensagem original-----
De: Brian Elcock [mailto:brian.elcock@gmail.com] 
Enviada em: quinta-feira, 26 de fevereiro de 2009 20:40
Para: user-cs@ibatis.apache.org
Assunto: Re: iBatis x Newer DataBases

I have used iBatis with SQL Server 2005 and 2008, using .NET 2.0 and
3.5 with no issues. I don't know about Progress.

That's my own experience, for what it's worth.

Regards.
Brian

On Thu, Feb 26, 2009 at 4:35 PM, Marcelo de Oliveira
<ol...@terra.com.br> wrote:
> Hi All,
>
>
>
> I’d like to know if iBatis Mapper works well with new versions of Sql
Server
> (2005 and 2008) and with Progress 10.x.
>
> I Have some future customers which I’d like to develop a solution using
> iBatis, but according with the page
>
http://opensource.atlassian.com/confluence/oss/display/IBATIS/What+database-
provider+combinations+have+been+tested+with+the+.NET+DataMapper,
> only SQL Server 2000 was tested.
>
>
>
> I am developing with .net framework 3.5, visual studio 2008, SQL Server
2005
> and Progress Databases.
>
>
>
> Regards,
>
> Marcelo.

E-mail verificado pelo Terra Anti-Spam.
Para classificar esta mensagem como spam ou não spam, visite
http://mail.terra.com.br/cgi-bin/reportspam.cgi?+_d=SCY1OTI5MzM5I3Blcm0hdGVy
cmEmMSwxMjM1NjkxNjQ2LjU4NTI0NS4yMzg0MC5iZXR1bmUudGVycmEuY29tLDQyNDg=
Verifique periodicamente a pasta Spam para garantir que apenas mensagens
indesejadas sejam classificadas como Spam.

Esta mensagem foi verificada pelo E-mail Protegido Terra.
Atualizado em 26/02/2009

Re: iBatis x Newer DataBases

Posted by Brian Elcock <br...@gmail.com>.
I have used iBatis with SQL Server 2005 and 2008, using .NET 2.0 and
3.5 with no issues. I don't know about Progress.

That's my own experience, for what it's worth.

Regards.
Brian

On Thu, Feb 26, 2009 at 4:35 PM, Marcelo de Oliveira
<ol...@terra.com.br> wrote:
> Hi All,
>
>
>
> I’d like to know if iBatis Mapper works well with new versions of Sql Server
> (2005 and 2008) and with Progress 10.x.
>
> I Have some future customers which I’d like to develop a solution using
> iBatis, but according with the page
> http://opensource.atlassian.com/confluence/oss/display/IBATIS/What+database-provider+combinations+have+been+tested+with+the+.NET+DataMapper,
> only SQL Server 2000 was tested.
>
>
>
> I am developing with .net framework 3.5, visual studio 2008, SQL Server 2005
> and Progress Databases.
>
>
>
> Regards,
>
> Marcelo.