Bobby, I was able to do it by listing field names in a ReportQuery object. It also won't append table alias in front of the column name in this case.
Max. -----Original Message----- From: Bobby Lawrence [mailto:[EMAIL PROTECTED] Sent: Thursday, January 20, 2005 5:38 PM To: [email protected] Subject: remove table alias in generated SQL? Is there a way to tell OJB to not use the table alias in front of the column names when it generates SQL? Currently, when you specifiy that a class comes from <tableA> and a field of that class comes from <fieldA>, OJB executes the following SQL: SELECT A0.<fieldA> FROM <tableA> A0 If you can't map one class to multiple tables, I don't see why this is necessary. Is there any way around this? Instead of mapping a field to a specific column, I want to map it to a string literal so that it always has the same value for the class. Ex. <field-descriptor column= 'some literal' AS myColumn"> -- Bobby --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
