Ibator: disable aliases for update and delete statements?

Using SQL Server, I get syntax errors from Ibator generated deleteByExample and updateByExample* for tables which I give an alias. Neither deleteByPrimaryKey, updateByPrimaryKey, nor updateByPrimaryKeySelective use of the alias, and work, but deleteByExample, updateByExample, and updateByExampleSel

Re: Ibator: disable aliases for update and delete statements?

There's no support for this in Ibator now. It will take a rewrite of the example class generator at the very least - with support from new SQL element generators too. It also presents a bit of a usage problem for the iBATIS3 interface mapper generator. I haven't released this yet, but will soon.

Re: Ibator: disable aliases for update and delete statements?

I actually have experienced a similar problem with MySql; the deleteByExample results in an syntax error when 'alias' is specified. Fortunately, there was an easy workaround that allows me to use alias in DELETE statement and I could write a plugin to tweak Ibator's default syntax. http://h

Re: Ibator: disable aliases for update and delete statements?

Thanks Iwao, that syntax works in sql server as well! Indeed, what a strange beast this SQL is... On Sun, Aug 9, 2009 at 1:25 PM, Iwao AVE! wrote: > I actually have experienced a similar problem with MySql; the > deleteByExample results in an syntax error when 'alias' is specified. > Fortunately