ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: Abator: column override (@ in column names in MSSQL Server DB)
Date Wed, 01 Nov 2006 00:30:38 GMT
There's no solution for this now in Abator.  I'll work on something.

Jeff Butler



On 10/31/06, Mark Cooke <markcooke666@yahoo.co.uk> wrote:
>
> Hi,
> I've tried using abator against a MSSQL server, where
> some of the tables' column names begin with a @.
> I've put a column override for each of the columns to
> force the java property name (i.e. drop the @), which
> works fine.  The problem comes with the generated
> SQL...the bad column names are interpreted as
> variables (that's what MSSQL's error says it thinks it
> is).
> For MSSQL - The column name should be delimited with
> either a single or double quote (I Think).
>
> I don't suppose there are any undocumented options on
> the column or SQL generator elements with which I can
> force the column names to be delimited in the SQL?
>
> Thanks in Advance,
> Mark.
>
> Send instant messages to your online friends http://uk.messenger.yahoo.com
>

Mime
View raw message