[Hibernate-JIRA] Commented: (HHH-951) setMaxResults causes "ORA-00918: column ambiguously defined" exception
3:05 p.m.
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-951?page=co...
]
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5809
days inactive
5809
days old
hibernate-issues@lists.jboss.org
0 comments
1 participants
participants (1)
-
Shawn Kerstetter (JIRA)