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 oleksa borodie <ol...@gmail.com> on 2005/09/27 11:54:23 UTC
Will iBATIS work with Framework 2.0?
Hello.
Will iBATIS work with framework 2.0? I've compiled iBATIS sources with
VS 2005 but all unit test is failed: NUnit tries to use ByteFX
provider instead of SqlClient as specified in the configuration files.
Is there any user guide to move to the framework 2.0?
Thank you.
Re: Will iBATIS work with Framework 2.0?
Posted by oleksa borodie <ol...@gmail.com>.
> I'm waiting when all test will be finished now.
All test in the _SqlMapTest_ works fine except
ResultMapTest:
TestExtendedResultMap, TestLazyLoad, TestListMapping says that
"Ambiguous match found"
TestArrayMapping says that "no parameterless constructor defined
for this object"
StatementTest:
TestExecuteQueryForMap2 fails with "Ambiguous match found"
I'll see whats wrong with this tests if have some free time.
Re: Will iBATIS work with Framework 2.0?
Posted by oleksa borodie <ol...@gmail.com>.
> These issues have been fixed in source control.
I've deleted all provider entries except SqlServer at the my local
copy of providers.config. All MSSQL test from SqlMapTests node works
fine. I'm waiting when all test will be finished now.
> Thanks for the .Net 2.0 Sql Server provider node entry.
Don't mention it.
I've run my own test, something like
IList users = _mapper.QueryForList("LoadUsers", null);
with my own SQLMAP and DAO basic configuration files and should say
that this test was passed succesefully ;)
Good bye
RE: Will iBATIS work with Framework 2.0?
Posted by Ron Grabowski <ro...@yahoo.com>.
I've been doing a lot of thinking today haven't I ;-)
--- Ron Grabowski <ro...@yahoo.com> wrote:
> I think Java style complex type mappings would be nice.
>
> I think the Java dynamic sql tags have a prePend attribute available.
> Do you know of any other differences?
>
> I think people would appreciate a wiki entry discussing the
> differences
> between the Java and .Net versions helpful.
RE: Will iBATIS work with Framework 2.0?
Posted by Ron Grabowski <ro...@yahoo.com>.
I don't think schemas for the config and mapping files will ever be
100% identical between the Java and .Net version of iBATIS. As I
mentioned in a post earlier today, Java has attributes like jdbcType
that simply aren't available in .Net. .Net also has things like the
listClass attribute that aren't available in the Java version becuase
strongly typed collections aren't as prevalent as they are in .Net.
Regarding ComplexType mappings, are you referring to this thread:
http://www.mail-archive.com/user-cs@ibatis.apache.org/msg00321.html
I think Java style complex type mappings would be nice.
I think the Java dynamic sql tags have a prePend attribute available.
Do you know of any other differences?
I think people would appreciate a wiki entry discussing the differences
between the Java and .Net versions helpful.
--- Okku Touronen <ok...@stendahls.net> wrote:
> Hello I am running iBatis in .NET 2.0 framework. I have tried both
> the
> binary release and compiled my own from the SVN.
>
> Since iBatis is designed for 1.1 some cool features as Nullable types
> are
> not included by default. But it is easy to extend with TypeHandler
> extensions.
>
> The problems I have run into stem from that the .Net version is not
> SqlMap
> compatible with the java version. Can't remember all stuff but here
> are some
> from top of mind:
> * ComplexType in result maps must use the resultMapping design
> * New schema for the sqlmap.config
> * Some new syntax for dynamic SQL
>
> /Okku
>
> -----Original Message-----
> From: oleksa borodie [mailto:oleksa.borodie@gmail.com]
> Sent: den 27 september 2005 16:24
> To: user-cs@ibatis.apache.org; Clinton Begin
> Subject: Re: Will iBATIS work with Framework 2.0?
>
> On 9/27/05, Ron Grabowski <ro...@yahoo.com> wrote:
>
> > Did you search the list archives?
> > http://www.mail-archive.com/user-cs%40ibatis.apache.org/
> > Someone asked a very similiar questions 24 hours ago.
>
> You mean "logging in ASP.NET 2.0" thread
>
(http://www.mail-archive.com/user-cs%40ibatis.apache.org/msg00335.html)?
> I saw this thread but it is not about framework 2.0 - it's about
> logging AFIAU.
>
> > When the NUnit tests failed did you get any kind of error message?
>
> I couldn't load IBatisNet.Test.dll in the standart NUnit 2.2.0 - it
> says that dll format is invalid. I''ve compiled NUnit 2.2.2 with VS
> 2005 but it fails to test any *.nunit project :(
> But I could run NUnit test via Visual studio add-on called
> ReSharper.
> It says that "DaoManager couldn't configure providers. Provider
> named
> ByteFx ot found, failed. Cause couldn't load fle or assembly
> ByteFX.MySqlClient ..."
> I've added
> <provider
> name="sqlServer2"
> description="Microsoft SQL Server 7.0/2000 provider in
> framework .NET V2"
> default="true"
> 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="@"
> />
>
> to the providers.config and changed
> <provider name="sqlServer2"/> in the dao_MSSQL_SqlClient.config
> In the IBatisNet.Test.dll.config I've uncommented
> <add key="database" value="MSSQL"/>
> <add key="providerType" value="SqlClient"/>
>
> > Perhaps you can put together a .Net 2.0 migration guide once you
> get
> > things working correctly on your system.
>
> I cann't write such guide because will start new project for 2.0
>
> Good bye.
>
>
>
>
RE: Will iBATIS work with Framework 2.0?
Posted by Okku Touronen <ok...@stendahls.net>.
Hello I am running iBatis in .NET 2.0 framework. I have tried both the
binary release and compiled my own from the SVN.
Since iBatis is designed for 1.1 some cool features as Nullable types are
not included by default. But it is easy to extend with TypeHandler
extensions.
The problems I have run into stem from that the .Net version is not SqlMap
compatible with the java version. Can't remember all stuff but here are some
from top of mind:
* ComplexType in result maps must use the resultMapping design
* New schema for the sqlmap.config
* Some new syntax for dynamic SQL
/Okku
-----Original Message-----
From: oleksa borodie [mailto:oleksa.borodie@gmail.com]
Sent: den 27 september 2005 16:24
To: user-cs@ibatis.apache.org; Clinton Begin
Subject: Re: Will iBATIS work with Framework 2.0?
On 9/27/05, Ron Grabowski <ro...@yahoo.com> wrote:
> Did you search the list archives?
> http://www.mail-archive.com/user-cs%40ibatis.apache.org/
> Someone asked a very similiar questions 24 hours ago.
You mean "logging in ASP.NET 2.0" thread
(http://www.mail-archive.com/user-cs%40ibatis.apache.org/msg00335.html)?
I saw this thread but it is not about framework 2.0 - it's about
logging AFIAU.
> When the NUnit tests failed did you get any kind of error message?
I couldn't load IBatisNet.Test.dll in the standart NUnit 2.2.0 - it
says that dll format is invalid. I''ve compiled NUnit 2.2.2 with VS
2005 but it fails to test any *.nunit project :(
But I could run NUnit test via Visual studio add-on called ReSharper.
It says that "DaoManager couldn't configure providers. Provider named
ByteFx ot found, failed. Cause couldn't load fle or assembly
ByteFX.MySqlClient ..."
I've added
<provider
name="sqlServer2"
description="Microsoft SQL Server 7.0/2000 provider in
framework .NET V2"
default="true"
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="@"
/>
to the providers.config and changed
<provider name="sqlServer2"/> in the dao_MSSQL_SqlClient.config
In the IBatisNet.Test.dll.config I've uncommented
<add key="database" value="MSSQL"/>
<add key="providerType" value="SqlClient"/>
> Perhaps you can put together a .Net 2.0 migration guide once you get
> things working correctly on your system.
I cann't write such guide because will start new project for 2.0
Good bye.
Re: Will iBATIS work with Framework 2.0?
Posted by Ron Grabowski <ro...@yahoo.com>.
The providers.config file included as part of the 1.2.1 release of
IBatisNet.DataMapper.Test incorrectly has the enabled property set to
true for the ByteFx driver. You'll need to set the enabled attribute to
false:
<provider
name="ByteFx"
description="MySQL, ByteFx provider V0.7.6.15073"
enabled="false"
... />
You will have to do the same thing with the this provider node too:
<provider
name="PostgreSql0.7"
description="PostgreSql, Npgsql provider V0.7.0.0"
enabled="false"
... />
These issues have been fixed in source control.
Thanks for the .Net 2.0 Sql Server provider node entry.
--- oleksa borodie <ol...@gmail.com> wrote:
> On 9/27/05, Ron Grabowski <ro...@yahoo.com> wrote:
>
> > Did you search the list archives?
> > http://www.mail-archive.com/user-cs%40ibatis.apache.org/
> > Someone asked a very similiar questions 24 hours ago.
>
> You mean "logging in ASP.NET 2.0" thread
>
(http://www.mail-archive.com/user-cs%40ibatis.apache.org/msg00335.html)?
> I saw this thread but it is not about framework 2.0 - it's about
> logging AFIAU.
>
> > When the NUnit tests failed did you get any kind of error message?
>
> I couldn't load IBatisNet.Test.dll in the standart NUnit 2.2.0 - it
> says that dll format is invalid. I''ve compiled NUnit 2.2.2 with VS
> 2005 but it fails to test any *.nunit project :(
> But I could run NUnit test via Visual studio add-on called
> ReSharper.
> It says that "DaoManager couldn't configure providers. Provider
> named
> ByteFx ot found, failed. Cause couldn't load fle or assembly
> ByteFX.MySqlClient ..."
> I've added
> <provider
> name="sqlServer2"
> description="Microsoft SQL Server 7.0/2000 provider in framework
> .NET V2"
> default="true"
> 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="@"
> />
>
> to the providers.config and changed
> <provider name="sqlServer2"/> in the dao_MSSQL_SqlClient.config
> In the IBatisNet.Test.dll.config I've uncommented
> <add key="database" value="MSSQL"/>
> <add key="providerType" value="SqlClient"/>
>
> > Perhaps you can put together a .Net 2.0 migration guide once you
> get
> > things working correctly on your system.
>
> I cann't write such guide because will start new project for 2.0
>
> Good bye.
>
Re: Will iBATIS work with Framework 2.0?
Posted by oleksa borodie <ol...@gmail.com>.
On 9/27/05, Ron Grabowski <ro...@yahoo.com> wrote:
> Did you search the list archives?
> http://www.mail-archive.com/user-cs%40ibatis.apache.org/
> Someone asked a very similiar questions 24 hours ago.
You mean "logging in ASP.NET 2.0" thread
(http://www.mail-archive.com/user-cs%40ibatis.apache.org/msg00335.html)?
I saw this thread but it is not about framework 2.0 - it's about
logging AFIAU.
> When the NUnit tests failed did you get any kind of error message?
I couldn't load IBatisNet.Test.dll in the standart NUnit 2.2.0 - it
says that dll format is invalid. I''ve compiled NUnit 2.2.2 with VS
2005 but it fails to test any *.nunit project :(
But I could run NUnit test via Visual studio add-on called ReSharper.
It says that "DaoManager couldn't configure providers. Provider named
ByteFx ot found, failed. Cause couldn't load fle or assembly
ByteFX.MySqlClient ..."
I've added
<provider
name="sqlServer2"
description="Microsoft SQL Server 7.0/2000 provider in framework .NET V2"
default="true"
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="@"
/>
to the providers.config and changed
<provider name="sqlServer2"/> in the dao_MSSQL_SqlClient.config
In the IBatisNet.Test.dll.config I've uncommented
<add key="database" value="MSSQL"/>
<add key="providerType" value="SqlClient"/>
> Perhaps you can put together a .Net 2.0 migration guide once you get
> things working correctly on your system.
I cann't write such guide because will start new project for 2.0
Good bye.
Re: Will iBATIS work with Framework 2.0?
Posted by Clinton Begin <cl...@gmail.com>.
.NET 2.0 and related products such as Visual Studio 2005 will be released by
the end of November. That pretty much means that what is there, is what
you'll get. With only a couple of months, Microsoft will likely be pressing
CDs and boxing the product right now.
Clinton
On 9/27/05, Ron Grabowski <ro...@yahoo.com> wrote:
>
> There is no guide to moving towards .Net 2.0 yet. I believe the product
> is still officially a beta. Its my understanding that .Net 2.0 should
> run existing 1.1 programs with little or no modification. Did you
> search the list archives?
>
> http://www.mail-archive.com/user-cs%40ibatis.apache.org/
>
> Someone asked a very similiar questions 24 hours ago.
>
> When the NUnit tests failed did you get any kind of error message?
>
> If you want to use the ByteFx client but SqlClient is being used
> instead perhaps there is something wrong with your configuration files.
> How are we suppose to help you if you don't provide any error messages
> or config file snippets?
>
> Perhaps you can put together a .Net 2.0 migration guide once you get
> things working correctly on your system.
>
> --- oleksa borodie <ol...@gmail.com> wrote:
>
> > Hello.
> >
> > Will iBATIS work with framework 2.0? I've compiled iBATIS sources
> > with
> > VS 2005 but all unit test is failed: NUnit tries to use ByteFX
> > provider instead of SqlClient as specified in the configuration
> > files.
> >
> > Is there any user guide to move to the framework 2.0?
> >
> > Thank you.
> >
>
>
Re: Will iBATIS work with Framework 2.0?
Posted by "kooto (sent by Nabble.com)" <li...@nabble.com>.
Ron Grabowski wrote:
>
> ...Did you search the list archives?
>
> http://www.mail-archive.com/user-cs%40ibatis.apache.org/
>
> Someone asked a very similiar questions 24 hours ago. ...
>
May I suggest a nicer searchable archive by Nabble: http://www.nabble.com/iBATIS-f360.html
You can cross search all 3 iBATIS lists there, instead of searching one at a time.
There is a threaded view using frames making it easy to follow a thread of discussion, for example, this current thread: http://www.nabble.com/Will-iBATIS-work-with-Framework-2.0--t349905.html#a970182 (click 'View Threaded')
Also, there is currently no Google ads.
--
Sent from the iBATIS - User - Cs forum at Nabble.com:
http://www.nabble.com/Will-iBATIS-work-with-Framework-2.0--t349905.html#a988077
Re: Will iBATIS work with Framework 2.0?
Posted by Ron Grabowski <ro...@yahoo.com>.
There is no guide to moving towards .Net 2.0 yet. I believe the product
is still officially a beta. Its my understanding that .Net 2.0 should
run existing 1.1 programs with little or no modification. Did you
search the list archives?
http://www.mail-archive.com/user-cs%40ibatis.apache.org/
Someone asked a very similiar questions 24 hours ago.
When the NUnit tests failed did you get any kind of error message?
If you want to use the ByteFx client but SqlClient is being used
instead perhaps there is something wrong with your configuration files.
How are we suppose to help you if you don't provide any error messages
or config file snippets?
Perhaps you can put together a .Net 2.0 migration guide once you get
things working correctly on your system.
--- oleksa borodie <ol...@gmail.com> wrote:
> Hello.
>
> Will iBATIS work with framework 2.0? I've compiled iBATIS sources
> with
> VS 2005 but all unit test is failed: NUnit tries to use ByteFX
> provider instead of SqlClient as specified in the configuration
> files.
>
> Is there any user guide to move to the framework 2.0?
>
> Thank you.
>