[ANNOUNCE] iBATIS.NET BETA available

The iBATIS.NET team is proud to announce that the BETA release of DataAccess V1.9.2 and DataMapper V1.6.2 are now available. This release is mainly a maintenance release. We expect that there will be a vote to promote to General Availability status in two weeks. You can obtain it from: http://i

Re: New Release For .NET?

me too, :-) On Mon, Oct 27, 2008 at 11:54 PM, Vincent Apesa <[EMAIL PROTECTED]> wrote: > I've been running the v3 build in a production environment for around two > months and haven't seen any problems. It seems pretty stable. > > > - Original Message - > *From:* Clinton Begin <[EMAIL P

Re: New Release For .NET?

The next week, I will do a maintenance release 1.6.2. For iBATIS V3, a BETA will be available before the end of the year or on the next beginning year. Cheers, Gilles

Re: New Release For .NET?

soon. Cheers, Gilles

Re: how to get a recent build of ibatis.NET data mapper

https://svn.apache.org/repos/asf/ibatis/trunk/cs/V1/src/ Cheers, Gilles

Re: Anyone thought of a web interface to the XML and config files??

There is no web interface in the development roadmap. Cheers, Gilles

Re: Problem mapping join on many tables to complex objects

Yes it's handle and ther'es even unit test to check example select c.Category_Id, c.Category_Name, null as Product_Id, null as Product_Name, null as Item_Id, null as Item_UnitCost, null as Item_Status from Categories c Category_Id Category_NameProduct_Id FISHFish

Re: SVN question

I haven't try TortoiseSVN 1.5 yet but have you just try a simple checkout ? -- Cheers, Gilles

Re: batch inserts

; > - Original Message > From: Gilles Bayon <[EMAIL PROTECTED]> > To: user-cs@ibatis.apache.org > Sent: Monday, June 30, 2008 3:43:57 PM > Subject: Re: batch inserts > > In ADO.NET there is no simple way to do batch statement in a db provider > independent manner as

Re: batch inserts

In ADO.NET there is no simple way to do batch statement in a db provider independent manner as in JBDC. For now, I haven't think of a good solution to implement batch support in iBATIS.NET. Perhaps other people have some ideas ? If you use SQL Server you do that with a store procedure and an XML

Re: SessionStore gets instantiated with wrong daoManagerId during configuration

We don't release at each issue. It's open source, the issue is corrected and you can grab the current source when you want :-) The next release will come when the time comes. -- Cheers, Gilles

Re: SessionStore gets instantiated with wrong daoManagerId during configuration

Yes. -- Cheers, Gilles

Re: SessionStore gets instantiated with wrong daoManagerId during configuration

You could attach your path to the issue I will take a look this week-end -- Cheers, Gilles

Re: new to this forum, need help

Yes, it is -- Cheers, Gilles

Re: Next Release?

I'm used it and I think Ron too. -- Cheers, Gilles

[OT] Crosspost: LinkedIn iBATIS Group

Hi all, Just a note to let you know that there is a LinkedIn group created for iBATIS. It should not replace the mailing list for: A) User support B) Developer discussions C) Bug reports Joining will allow you to find and contact other members on LinkedIn that used iBATIS and show your interest

Re: Extending DataMapper from V3 to add support QueryForDataSet

I will think of that Did you know that you can do this select Account_ID, Account_FirstName, Account_LastName, Account_Email, Account_Banner_Option, Account_Cart_Option from Accounts where Account_ID = 1; select Category_ID,

Re: Next Release?

The iBatis future plan (.NET and Java) are described here Check out http://opensource.atlassian.com/confluence/oss/display/IBATIS/iBATIS+3.0+Whiteboard The .NET version is moving to the V3 and you can find the current V3 development in http://svn.apache.org/repos/asf/ibatis/trunk/cs/V3/

Re: problem with update sql generation

I expected to release the Beta in July. You can have a look of the V3 current source in http://svn.apache.org/repos/asf/ibatis/trunk/cs/V3/ -- Cheers, Gilles

Re: iBATIS read/write non-serialize cache

Yes it is -- Cheers, Gilles

Re: iBATIS read/write non-serialize cache

I have just commit a test on the current trunk and didn't see any problem. 2008/05/13 20:53:45:SSS [DEBUG] IBatisNet.DataMapper.Commands.DefaultPreparedCommand - Statement Id: [GetLruCachedAccountsViaResultMap] PreparedStatement : [select *from Accountsorder by Account_ID] 2008/05/

Re: problem with update sql generation

It's certainly a bug but sql generation in this version is a bit experimental. It will improve in the next major version, V3. -- Cheers, Gilles

Re: 答复: iBATIS looking on the wrong place for SqlMap.config SOLVED (for a part)

Funny, I used iBATIS with VS 2008 and I haven't noticed this bug -- Cheers, Gilles

Re: Add mapped statement through API

It will be possible in the next version. -- Cheers, Gilles

Re: VS2008/.net 3.5 and iBATIS not compatible?

The .NET v2 binaries are fully compatible with VS 2008/.NET 3.5 -- Cheers, Gilles

Re: BATIS (VS2008) looking on the wrong place for SqlMap.config

If you read the doc it will be better http://ibatis.apache.org/docs/dotnet/datamapper/ch04s03.html#id398273 -- Cheers, Gilles

Re: BATIS (VS2008) looking on the wrong place for SqlMap.config

http://ibatis.apache.org/docs/dotnet/datamapper/ch04s04.html -- Cheers, Gilles

Re: BATIS (VS2008) looking on the wrong place for SqlMap.config

How do you used the sqlmap.config file ? You are giving the good path to the file. -- Cheers, Gilles

Re: Wrong DataStream exception - Sybase + Ibatis

You should send your message to the list [EMAIL PROTECTED] and not user-cs@ibatis.apache.org -- Cheers, Gilles

Re: Escaping the question mark

I've got no exception with the current version !! where Account_ID between #?lowID# and #?hightID# [Test] public void TestDummy() { Hashtable param = new Hashtable(); param.Add("*?lowID*", 2); param.Add("*?hightID*", 4);

Re: multiple result sets

You can only get List, it makes more sense no ?! See unit test to have examples. -- Cheers, Gilles

Re: .net Framework 3.5 Ibatis

Take the 2.0 binaries release of iBATIS. There is no additionnal System.Data.* features in the .NET 3.* .NET framework so for now there will be no special iBATIS version for Framework 3.5 and the current release is compatible with .NET 3.*. If you want you can get a try to the next version of iBA

Re: How can I populate MembershipUserCollection instead of IList?

There's plenty of example in the unit tests. -- Cheers, Gilles

Re: How can I populate MembershipUserCollection instead of IList?

http://ibatis.apache.org/docs/dotnet/datamapper/ch03s03.html#id380148 -- Cheers,

Re: FW: How do I call a Stored Procedure with Input Parameters in .NET?

what is the error ? -- Cheers, Gilles

Re: NET Framwork 3.5

You ve got the message error *The error occurred while loading Providers.\r\n- initialize provider \r\n- Check the MySql. **Could not configure providers. Unable to load provider named \"MySql\" not found, failed. Cause: Could not load file or assembly 'MySql.Data, Version= 1.0.7.30072, Culture=n

Re: ResultMap

A typeHandler is a relation between a dotnet primitive type (int, string) and a dbtype so your config you be somelike ** -- Cheers, Gilles

Re: IBatis ASP.Net Security

You can use all config files as embedded resource in assembly -- Cheers, Gilles Join my network on LinkedIn

Re: Profiling Prepared Statements

Why don't you put your comment in the mappping file */* DynamicJIRA168*/* select Account_IDas Id, Account_FirstNameas FirstName, Account_LastNameas LastName, Account_Emailas EmailAddress from Accounts

Re: TypeHandler for Xml data type in Sql Server

There's a unit test showing how to use an XML input parameter, search in SVN a unit test named TestXMLParameter using the store procedure SelectAccountViaXML and have a look for inspiration. Here's a Java XML TypeHandler http://opensource.atlassian.com/confluence/oss/display/IBATIS/Type+Handler+Ca

Re: DataMapper 1.6.2 release date?

The last release is currently in bug-fix only maintenance, you can build it from subversion to get the last resolved issues. A new maintenance release 1.6.2 will be done near mid 2008. Version 2.0 Currently under development Estimated Final Release Date: When is ready in 2008 The 2.0 version wil

Re: Defects in iBATIS.NET

The first defect have been resolved and is in SVN. -- Cheers, Gilles Join my network on LinkedIn http://www.linkedin.com/in/sellig

Re: Defects in iBATIS.NET

For your issue 1. This is not an issue, you are not using the correct syntax, refer to http://ibatis.apache.org/docs/dotnet/datamapper/ch03s05.html#id384072 For the second problem can you give me an example (xml resultMap, statement setting) -- Cheers, Gilles Join my network on LinkedIn http:/

Re: Does IBatis.Net support command timeouts?

With Michael Schall solution, you have the 2 solutions to set the timeout. I have already mention those 2 solutions on older posts on the list http://www.nabble.com/SqlCommand.CommandTimeout-setter-or-similar--t2128819.html You can open a JIRA ticket for the port of the timeout as http://opensour

Re: Optional Stored Procedure Parameters breaks iBatis code

We recently had a portion of our iBatis code broken when the author of MS SQL Server stored procedure added 3 optional parameters. We had assumed that iBatis.net would handle this more gracefully. What is the recommended way for dealing with this? > Try to specify useDeriveParameters="false" on th

Re: Question About Complex Types

You can use cacheModel ... Adapt the cache model to your needs. -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: Enabling logging in NUnit

I not have this problem. -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: Enabling logging in NUnit

You have 2 solutions, - create an app.config in your test porject with this content or create an an MyNamespace.Test.dll.config in the bin/debug of your test project. You can have a look a the ibatis test project Cheers, Gilles http

Re: Problems extending statements from another map file.

For now, you can only use extends for statement in the same mapping file. This limitation will be removed in the DataMapper V2 version with a new configuration engine. This limitation does not apply for parameterMap. The extends parameterMap must have been already resolve in a previous mapping file

Re: Is it a bug of ibatis.net (Data Mapper1.6)?

Thanks corrected in SVN -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: DefaultPreparedCommand log not thread safe

Corrected in SVN -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: DataMapper connection string?

Look at http://ibatis.apache.org/SDK/dotnet/index.html and http://ibatis.apache.org/SDK/dotnet/index.html -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: Ibatis 1.6.1 SqlMap.xsd wrong or incomplete

Can you open a JIRA ticket, thanks -- Cheers, Gilles

Re: Multiple result sets and XML parameters for stored procedures

I have just commit a unit test showing how to use an XML input parameter, search a unit test named TestXMLParameter using the store procedure SelectAccountViaXML -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: Multiple result sets and XML parameters for stored procedures

Question a) IList list = sqlMap.QueryForList("GetMultipleResultClass", null); from Unit tests select Account_ID, Account_FirstName, Account_LastName, Account_Email, Account_Banner_Option, Account_Cart_Option from Accounts where Account_ID

Re: error

Before testing Spring+ibatis integration, test first ibatis alone to see if you have problems in your config/mapping files -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: About required internet connection

You dont' have to change it. -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: About required internet connection

The XML schemas are included as resources in the dll and the validation against them are only done if you explicit use the setting validateSqlMap="true" If you want IntelliSense help when writing your mapping file follows instruction as described in http://ibatis.apache.org/docs/dotnet/datamapper

Re: About required internet connection

iBATIS.NET doesn't require an internet connection !!! -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: nullValue in ResultMap simply does not work

Remove the AM ! I have used it without problem in Result and Parameter Map ... -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: Do not use with SCOPE_IDENTITY and MSSQL?

Not so strange (it's coherent with the selectKey execution) but good hack :-)) -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: Do not use with SCOPE_IDENTITY and MSSQL?

Yes but the selectKey is too restrict, and doing what you think it's more complicate to implement (just a wart). The other solution is more open, you can do the same as the selectKey + multiple update. And so selectKey can be remove and the insert statement will be compliant with other statement.

Re: Do not use with SCOPE_IDENTITY and MSSQL?

Agree, a new API like sqlMap.Insert("InsertCategoryScope", category, category) can do the work ? It will be genric so you can even uptade one or more field of the result object, any idea, suggestion ? -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: Do not use with SCOPE_IDENTITY and MSSQL?

You already have all at your finger, sample Category category = new Category(); category.Name = "toto"; category.Guid = Guid.NewGuid(); sqlMap.QueryForObject("InsertCategoryScope", category, category); with insert into C

Re: Do not use with SCOPE_IDENTITY and MSSQL?

SCOPE_IDENTITY / @@IDENTITY Returns the last identity value inserted into an identity column in the same scope. A scope is a module: a stored procedure, trigger, function, or batch. Therefore, two statements are in the same scope if they are in the same stored procedure, function, or batch. SCOPE_

Re: Lists of primitives in result maps doesn't work?

Correction in SVN -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: Generic PaginatedList

No, and the generic paginatedlist support will be removed in future version. -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: Inheritance issues

Fix in SVN (IBBATISNET-229) -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: GroupByStrategy and resultObject

Fix in SVN -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: GroupByStrategy and resultObject

Guess your are right, it's a miss -- Cheers, Gilles

Re: Return Results

Strange, guess that it's more a problem of the DbType of the return, I noted this to have a look Cheers -Gilles On 9/13/07, Lee Shinlever <[EMAIL PROTECTED]> wrote: > > It is the oddest thing. We actually modified the SPROC by removing the > RETURN statement and just allowing the results of the

Re: DataMapper Development Guide has the wrong link?

I will correct it -- Cheers, Gilles

[VOTE SUCCEEDED] Promote iBATIS.NET DataMapper 1.6.1 and DataAccess 1.9.1 to General Availability

iBATIS.NET DataMapper 1.6.1 and DataAccess 1.9.1 has been successfully promoted to General Availability Binding Gilles +1 Ted +1 Ron +1 The site will be updated to reflect this vote. --- Cheers, Gilles

[VOTE] Promote DataAccess V1.9.1 and DataMapper V1.6.1 to General Availability

Hi All, Sorry for the delay in calling the vote - lot of works ... preparing to changing job :) Since there have been no major issues reported , I propose that we promote DataAccess V1.9.1 and DataMapper V1.6.1 to GA status. I'm +1. Cheers, - Gilles

Re: More on multiple datasources

You could have one SqlMapper config file and change the datasource from 1 to 2 with someting as http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+set+the+ connection+string+per+user+in+Web+context On 3/16/07, Wei Cheng <[EMAIL PROTECTED]> wrote: This maybe discussed here b

Re: Default Schema Name

You can specify it in the properties.config and use it as ${schema} -- Cheers, Gilles

Re: default parameter mapping for stored procedures

iBATIS doesn't support it. -- Cheers, Gilles

Re: DataAccess, multiple contexts and session on the same thread

Fix in SVN -- Cheers, Gilles

[ANNOUNCE] iBATIS.NET DataMapper & DataAccess new BETA release

Hello, The iBATIS.NET team is pleased to announce that the BETA release of DataAccess V1.9.1 and DataMapper V1.6.1 are now available. This release includes mainly bug fixes and enhancements. I expect that there will be a vote to promote to General Availability status in two weeks. Thanks once a

Re: Supporting custom ILazyFactory

5 0005 * www.sungard.com/investran From: Gilles Bayon [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 2:46 PM To: user-cs@ibatis.apache.org Subject: Re: Supporting custom ILazyFactory In near term, no. somewhere in version 2.* On 2/28/07, Rogelio Baucells &

Re: Supporting custom ILazyFactory

In near term, no. somewhere in version 2.* On 2/28/07, Rogelio Baucells <[EMAIL PROTECTED]> wrote: Hi, Is there any plans to support custom ILazyFactory in a near future? I see the comments in LazyFactoryBuilder and the Register method but is not implemented. Thanks RJB CONFIDENTIALITY: Th

Re: Checking for Open Transactions

If you want to see your patch included in iBATIS, you can open a JIRA ticket and add a patch. -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: exception thrown while processing groupBy

If you give me a unit test I can give a look. Side question: I also noticed the comment "// temp ?, we don't support constructor tag with groupBy attribute". I assume that will change before 1.6 is released? This will not be changed for 1.6, perhaps in future version

Re: Checking for Open Transactions

On the ISqlMapper, you can access the ISqlMapSession (the current SqlMap session) which will give you access to the underlying IDbConnection and IDbTransaction.

Re: Couple of issues

The IBATISNET-206 that I just closed must fix your issue can you have a try. -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: Couple of issues

Issue 1: Possible fix for XSDs You're right. I have already noticed that the schema should be corrected to somthing like this Issue 2: Incorrect usage of groupBy attribute throws unhelpfull exception During the configurtaion process, a check which verify that's each element of groupBy att

Re: Ibatis from SVN tag problems

The generate tag is a bit messy and not guaranty to worked, fortunately you can avoid it. Basic statement generation will be improved in version 3.0. Have you tried to watch what is the generated SQL in the log ? -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: Writing a custom session store by implementing ISessionStore

Just a note, the current release will be the last to incorporate the DataAccess component. The next release will be versionned 2.0 and will only focus on DataMapper component. Custom store are rarely used and I try to keep the configuration file minimal and used code for advanced configuration.

Re: Writing a custom session store by implementing ISessionStore

Yes On 2/8/07, Greg Jackman <[EMAIL PROTECTED]> wrote: Thanks for that Gilles, I'll give it a go. Do I need to upgrade to the latest beta version to be able to set the session store? Cheers, Greg -- *From:* Gilles Bayon [mailto:[EMAIL PROTE

Re: Writing a custom session store by implementing ISessionStore

You can used the HybridWebThreadSessionStore ISqlMapper mapper = builder.Configure(...); mapper.SessionStore = new HybridWebThreadSessionStore( sqlMapper.Id ); Set the custom session store once you have build the ISqlMapper and before you use it. -- Cheers, Gilles http://www.amazon.com/gp/reg

Re: Writing a custom session store by implementing ISessionStore

You can find another implementation see http://ibatis.apache.org/SDK/dotnet/IBatisNet.DataAccess.SessionStore.html -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: Storing Connection Strings in the in .config files

The syntax was wrong but you got the idea :-) -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

[ANNOUNCE] iBATIS.NET DataMapper & DataAccess new BETA release

The iBATIS.NET team is proud to announce that the BETA release of DataAccess V1.9.0 and DataMapper V1.6.0 are now available. This release includes several bug fixes and enhancements. Additionally, the main new addition is the support to groupBy attribute on resultMap to resolve N+1 select issue.

Re: Storing Connection Strings in the in .config files

Today, you can used section in config file as DomSqlMapBuilder builder = new DomSqlMapBuilder(); builder.Properties.Add("connectionString", my connection string retrieve from the connectionString section app config); builder.Configure(...) -- Cheers, Gilles http://www.amazon.com/

Re: Exact type conversions

The default underlying type of the enumeration elements is *int* and as your enum don't have a type, iBATIS is right :-) -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: Storing Connection Strings in the in .config files

Good improvement, but I will do a BETA release Thursday and have no time to code it, if you want your patch included, open a JIRA ticket and attach a patch file, if not, it will only be in the V2 :-) -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: Case Sensitive Parameter Search

I think we will keep it as it is, it's cleaner. -- Cheers, Gilles http://www.amazon.com/gp/registry/6JCP7AORB0LE";>Wish List

Re: New ITypeHandler NullValue property

On 1/26/07, Michael Schall <[EMAIL PROTECTED]> wrote: I could do it on a resultMap/parameterMap basis, but a legacy database I'm using stores empty string rather than null for all string. The typeHandler seems like an easier solution as I can put it in the config file once and forget about it..

Re: New ITypeHandler NullValue property

It's always represent a .NET value. For example if I have a DateTime property with DateTime.Min as value, I will set paremeterMap property attribute nullValue="01/01/0001 00:00:00" to save null in db On a resultMap property the same nullValue="01/01/0001 00:00:00", will transform a database value

Re: Oracle/Ibatis Decimal error

For calculation, decimal is more appropriate in .NET code. The Oracle driver are a bit messed in .NET world. The unit test have been done against an Oracle Database by Roberto. As I see, a .NET decimal type is map to a number in oracle. The dbType are different if you used the MS or Oracle driver

  1   2   3   >