hi markus,
in your original post i saw that you use addColumnEqualTo
// c.setAlias("a1");
c.addColumnEqualTo("COLUMN1","034");
c.addColumnEqualTo("COLUMN2","78777");
// Criteria c2 = new Criteria();
what's the reason no to use addEqualTo() ?
jakob
Lauber Markus, Bedag schrieb:
Hi Jakob
I switched to the new version of OJB (1.0.4). But the new release
brought no improvement in the generation of the SQL statement. It still
has no alias prefixes for the first table in the where clause.
SELECT A0.COLUMN1,A0.COLUMN2,A0.COLUMN3,A0.COLUMN4
FROM T1 A0,T2 A1 WHERE A0.ID=A1.T1ID AND (( (COLUMN1 = '034') AND
COLUMN2 = '78777') AND (A1.DATE >= '1900-12-12 12:00:00.0'))
Greetings
Markus
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.1.1/272 - Release Date: 01.03.2006
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
