Fixed
Details
Assignee
Andrea BorieroAndrea BorieroReporter
Former userFormer user(Deactivated)Time tracking
5.55h loggedComponents
Fix versions
Affects versions
Priority
Major
Details
Details
Assignee
Andrea Boriero
Andrea BorieroReporter
Former user
Former user(Deactivated)Time tracking
5.55h logged
Components
Fix versions
Affects versions
Priority
Created September 13, 2005 at 4:40 PM
Updated August 20, 2015 at 8:32 PM
Resolved August 20, 2015 at 5:39 PM
when create criteria with associations, i get this error:
ORA-00918: column ambiguously defined
mapping:
<class name="User" table="FRAME_USER" dynamic-update="true" dynamic-insert="true">
<id name="id" type="long" unsaved-value="null">
<column name="ID" not-null="true"/>
<generator class="sequence">
<param name="sequence">frame_user_seq</param>
</generator>
</id>
<version type="timestamp" column="stamp" name="timestamp" unsaved-value="null"/>
<property name="user_name" type="string" not-null="true"/>
<property name="blocked" type="yes_no" not-null="true"/>
<property name="access_logon" type="timestamp"/>
<property name="denied_logon" type="timestamp"/>
<property name="inactivity_time" type="long"/>
<property name="session_count" type="long"/>
<idbag name="terminalGroups" table="FRAME_USER_TERMINAL" fetch="join" outer-join="true">
<collection-id column="ID" type="long">
<generator class="sequence">
<param name="sequence">frame_user_terminal_seq</param>
</generator>
</collection-id>
<key column="id_user"/>
<many-to-many column="id_terminal_groups" class="TerminalGroup" fetch="join" outer-join="true"/>
</idbag>
</class>
<class name="TerminalGroup" table="FRAME_TERMINAL_GROUPS" dynamic-update="true" dynamic-insert="true">
<id name="id" type="long" unsaved-value="null">
<column name="ID" not-null="true"/>
<generator class="sequence">
<param name="sequence">frame_terminal_groups_seq</param>
</generator>
</id>
<version type="timestamp" column="stamp" name="timestamp" unsaved-value="null"/>
<property name="name" column="group_name" type="string" not-null="true"/>
<idbag name="terminals" table="FRAME_TERMINAL_REL" fetch="join" outer-join="true">
<collection-id column="ID" type="long" >
<generator class="sequence">
<param name="sequence">frame_terminal_rel_seq</param>
</generator>
</collection-id>
<key column="id_term_group"/>
<many-to-many column="id_term" class="Terminal" fetch="join" outer-join="true"/>
</idbag>
</class>
<class name="Terminal" table="FRAME_TERMINAL" where="status != 'D'" dynamic-update="true" dynamic-insert="true">
<id name="id" type="long" unsaved-value="null">
<column name="ID" not-null="true"/>
<generator class="sequence">
<param name="sequence">frame_terminal_seq</param>
</generator>
</id>
<version type="timestamp" column="stamp" name="timestamp" unsaved-value="null"/>
<property name="status" type="char" not-null="true"/>
<property name="mac" type="string" not-null="true"/>
<property name="name" column="ident" type="string" not-null="true"/>
<property name="description" type="string"/>
code:
session.createCriteria(User.class)
.add(Restrictions.like("user_name", "%")
.createCriteria("terminalGroups")
.add( Restrictions.like("group_name", "%").
.setProjection(Projections.rowCount())
.uniqueResult();