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 "]".
I'm afraid even if you solved this, there would remain a Village
problem, too. I found that for example updates to columns fail if these
happen to have names which are "reserved words" for this type of
database (example: KEY, for MySQL). That is because Village does not
use proper escaping when generating SQL for these statements.
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?
I don't remember exactly, but does JavaName="time_after" help?
Bye, Thomas.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
