this looks like a problem in your mapping. if ojb finds descriptors for the fields it prefixes them with a table alias (a.name).
if no field is found the name from the criteria is used.
hth jakob
Viczián István wrote:
Hi,
I would like to join two table, and they are in 1:n relation, and they have a field with same name. If I add a criteria to this, I get an exception. This exception says, that the field is _ambiguous_. I've logged the SQL query with P6Spy, and it is true, the name of the field appears in the select statement without qualification, so the name of the field is really ambiguous. I've tried qualify with the table name, but it is not good, it should be qualified with the alias.
Concretely symbolically: table A (a_id, samename); table B (b_id, a_id, samename, prop);
A:B = 1:N
Criteria c1; c.addEquals("samename", "blahblah"); // criteria for the Criteria c1; c.addEquals("b.prop", 1); // join Query for table A, request for A objects
So the exception says, that the samename is ambiguous. The generated sql is something like this:
select a_id, samename from A a0 INNER JOIN B a1 WHERE samename = 'blahblah' and a0.a_id = a1.b_id and a1.prop = 1;
So the samename field appears without alias qualification. How should I correct my code without renaming columns to individual name?
Thank you,
Istvan
--- Viczián István [Viczi] ([EMAIL PROTECTED]) Honlap: http://dragon.unideb.hu/~vicziani Mobil#: +36(30)3656804 ICQ#: 15803584
--------------------------------------------------------------------- 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]
