[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-951) setMaxResults causes "ORA-00918: column ambiguously defined" exception

[Shawn Kerstetter (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=32210#action_32210 ] 

Shawn Kerstetter commented on HHH-951:
--------------------------------------

+1

This is really not all that hard to reproduce.  

1.  You need to map the same column 2x
2.  You need to have a case mismatch between the columns in the mappings
3.  You need to use setMaxResults()
4.  You need to be using ORA (works fine on MSSQL)

Here's some code from which I think  it should be trivial to derive a test case in your favorite framework:

<code>
@Entity
public class TestHHH951 extends BaseEntity {
    
    @Id
    private Integer primaryKey;
    
   //note case and column name
    @Column(name="TRANID", nullable=false)
    private Integer tranID;
    
   //note duplicate column name/mapping and mismatched case
    @Column(name="tranid", nullable=false, insertable=false, updatable=false)
    private Integer duplicateTranID;
</code>

<code>
	public void testHHH951() {
	    TestHHH951 entity = new TestHHH951();
	    entity.setPrimaryKey(IdGenerator.nextId(TestHHH951.class));
	    entity.setTranID(IdGenerator.nextId(TestHHH951.class));
	    
	    //CRUD works fine:
	    entity = create(entity);
	    entity = read(entity);
	    entity.setTranID(IdGenerator.nextId(TestHHH951.class));
	    entity = update(entity);
	    
	    //expected to fail (and does)
	    assertCollectionsEqual(Arrays.asList(entity), getService().listAll(TestHHH951.class, null));
	    
	}
</code>

Where list all is essentially:

<code>
        return getEntityManager().createQuery("From TestHHH951").setMaxResults(MAX_RESULTS).getResultList();
</code>

> setMaxResults causes "ORA-00918: column ambiguously defined" exception 
> -----------------------------------------------------------------------
>
>                 Key: HHH-951
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-951
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.0.5, 3.1 beta 2
>         Environment: hibernate3.0.5, hibernate3.1b2, Oracle 9
>            Reporter: Karel Sommer
>
> 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();

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira