[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [Newsgroup Home]
[news.eclipse.rt.eclipselink] escaping table names

I've been trying to find the correct location to extend a database platform, in order to escape table names. Some databases have reserved tables, like user or group. Often such tables can still be used, if they are escaped in some way.

In this case a database schema written for MySql (which does not have a reserved user table) must be migrated to a Postgres. Postgres allows escaping the reserved table:

	select * from user
vs
	select * from "user"

The first one accesses the reserved table, the second accesses the custom table.

Now, I found the classes where SQL statements are constructed, but I cannot seem to find a place where the SQL identifiers or statements are "pulled through" a method in a DatabasePlatform to allow such tweaking (since DatabasePlatform is the only thing that is extendable from a ecliplink-user perspective).