Hi Jakob,
do you think that I have the same problem?
It appears only with m-n.
##################
### 1. mapping ###
##################
<!-- m - n -->
<collection-descriptor
name="table_n"
collection-class="org.apache.ojb.broker.util.collections.ManageableArrayList
"
element-class-ref="de.on_ergy.lakon.data.model.TableN"
auto-retrieve="true"
auto-update="object"
auto-delete="link"
proxy="true"
indirection-table="table_m_table_n"
>
<fk-pointing-to-this-class column="table_m_obj_id"/>
<fk-pointing-to-element-class column="table_n_obj_id"/>
</collection-descriptor>
#############################
### 2. javacode for query ###
#############################
crit.addEqualTo("table_n.obj_id", 1);
#########################
### 3. ojb sql output ###
#########################
SELECT A0.obj_id,....
FROM table_m A0
LEFT OUTER JOIN
(
table_m_table_n A1 LEFT OUTER JOIN table_n A2
ON A1.table_n_obj_id=A2.obj_id
)
ON A0.obj_id=A1.table_m_obj_id
WHERE obj_id = 1
##################
### 4. the bug ###
##################
Now, the problem is the incorrect obj_id without A2 as prefix :o(.
So, I get the following logical exception:
org.postgresql.util.PSQLException: ERROR: column reference "obj_id" is
ambiguous
Thanks a lot!
Josef Wagner
-------- Original-Nachricht --------
Betreff: Re: AW: Problem joining two tables with same column name
Datum: Fri, 03 Mar 2006 19:03:50 +0100
Von: Jakob Braeuchi <[EMAIL PROTECTED]>
Antwort an: OJB Users List <[email protected]>
An: OJB Users List <[email protected]>, [EMAIL PROTECTED]
Referenzen:
<[EMAIL PROTECTED]>
hi markus,
ojb 1.0.5 should be released this month.
you should always use 'attributes' not 'columns' in your queries and let
ojb translate the attribut-name into a column-name.
hth
jakob
ps: what do you use ojb for in bedag ?
Lauber Markus, Bedag schrieb:
> Hi Jakob
>
> Thank you for the explanation. When will OJB 1.0.5 be released?
>
> What do you suggest, is it better to use the method addEqualTo() or
> addColumnEqualTo() in a project? In our project we used both methods and
> we want to refactor our code.
>
> Greetings
> Markus
>
>
>
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.375 / Virus Database: 268.1.2/274 - Release Date: 03.03.2006
---------------------------------------------------------------------
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]
