Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Message-ID: <406A8DD6.4020904@ifit.uni-klu.ac.at>
Date: Wed, 31 Mar 2004 11:22:30 +0200
From: Kostyantyn Shchekotykhin <kostya@ifit.uni-klu.ac.at>
User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207)
MIME-Version: 1.0
To: Apache Torque Users List <torque-user@db.apache.org>
Subject: Re: MSSQL problems with reserved words
References: <001401c41700$c9518be0$7eeff2a3@ro1cv02d>
In-Reply-To: <001401c41700$c9518be0$7eeff2a3@ro1cv02d>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Hi Alex,
Why table name schema is so important for you? Can you name a table somehow else, and if you need class named Schema, 
then specify a javaName="Schema" in your my-schema.xml.

Regards,
Kostya

Alexandru Dovlecel wrote:

> Hi all,
> 
> Pls need help ASAP. I have a database that contains tables that are reserved
> words for mssql. E.g. one table is called SCHEMA. When I generate the code
> from my-schema.xml, it generates the my-schema.sql file. When running the
> sql file in the mssql I get an error: SCHEMA keyword not expected after
> CREATE TABLE (or something like this). I can do this by generating
> CREATE TABLE [SCHEMA]. But if I put the table name as "[SCHEMA]" then the
> primary key triggers are not correct (e.g. [SCHEMA]_PK is not a valid name).
> 
> How can I overcome this problem? Does anyone have some patched mssql
> templates for generating the sql and the OM classes?
> 
> Any suggestions? Pls help.
> 
> Thanks alot,
> Alex
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org