Re: Column names with spaces

I would use the torque-generator to migrate the database to a new schema
where column names with spaces don't exist. Then, I would use that
database instead. Takes approximately 10 minutes to do.



-- 
Leo Przybylski
Application Systems Analyst, Senior
Department of Sponsored Projects Services 
The University of Arizona
Tucson, AZ 85701

Office: 520.626.6997
E-mail: przybyls [at] u.arizona.edu
URL: http://www.u.arizona.edu/~przybyls/, https://test.kuali.org/confluence/display/~lprzybylski



Thoralf Rickert wrote:
> Hi,
>
> Of course the list of problems with mssql doesn't stop...
>
> I've got now a xml schema from the existing database. Some "lovely boy" decided years ago that it would be nice to use spaces inside the column names of the database scheme. For example: "Time after". This is not a problem if you use the special syntax "[Time after]" in a select. But I don't have this kind of access with Torque (prove me wrong, if not). If I try to make a Criteria, Torque quits this selection with
>
> Malformed column name in Criteria getTableName: 'T_Stammdaten.Time after' is not of the form 'table.column'
>
> Okay, actually this is an error that doesn't have something to do with the real problem. Is there a way to setup a database specific syntax for column names. So in MySQL it would be "`" or in MSSQL/Sybase it would be "[" and "]".
>
> Additionally - I think the "torque" task that generates the classes should escape the spaces if it uses the database column names to generate column constants (currently it produces
>
> public static String TIME AFTER = "...".
>
> Has somebody an idea, how to get around this problem?
>
>
> Bye
> Thoralf
>