Re: MSSQL, schema migrations format issue

2010-03-28 Thread Clinton Begin
Okay, I've just committed a change to preserve newline characters in scripts. You can wait for the next release, but I recommend trying it with the trunk build. It's a piece of cake... Check out: http://svn.apache.org/repos/asf/ibatis/java/ibatis-3/trunk/ Run: mvn assembly:assembly 1 minute an

Re: MSSQL, schema migrations format issue

2010-03-28 Thread Clinton Begin
Okay, then yes, it's migrations stripping the newlines. I'll have a look and see if I can add an option to not do so. Clinton On Sun, Mar 28, 2010 at 12:14 PM, chris oberle wrote: > Hi Clinton, > > I'm referring to the SQL Server Management Console. Our DBA's use it along > with a bunch of int

Re: MSSQL, schema migrations format issue

2010-03-28 Thread chris oberle
Hi Clinton, I'm referring to the SQL Server Management Console. Our DBA's use it along with a bunch of integrated Visual Studio packages. The DBA's are pretty particular about the text formatting on procedures and view definitions because they ultimately have to support them. When I use schema

Re: Question about how to use rollback

2010-03-28 Thread Clinton Begin
You don't even have to really... it will be called automatically if you don't call commit in most cases. Write a unit test for yourself to confirm this in your environment. But yes, what you wrote looks fine. My only recommendation would be to roll back regardless of the exception type (e.g. cat

Question about how to use rollback

2010-03-28 Thread 陈抒
Hello: My transactionManager type is JDBC. There is a sample in IBatis3 document: SqlSession session = sqlSessionFactory.openSession(); try { // following 3 lines pseudocod for “doing some work” session.insert(...); session.update(...); session.delete(...); session.commit();