[hibernate-issues] [Hibernate-JIRA] Created: (ANN-654) Generated SQL includes a column named "null" when referencing a map entry by key and using @LazyCollection(LazyCollectionOption.EXTRA)

[Paul Roe (JIRA)]

Generated SQL includes a column named "null" when referencing a map entry by key and using @LazyCollection(LazyCollectionOption.EXTRA)
--------------------------------------------------------------------------------------------------------------------------------------

                 Key: ANN-654
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-654
             Project: Hibernate Annotations
          Issue Type: Bug
          Components: binder
    Affects Versions: 3.2.0.ga
         Environment: Oracle 10g, hibernate 3.2
            Reporter: Paul Roe


We have an Product entity with a map of RegionProduct by Region.  

    @MapKey(name="region")
    @OneToMany(mappedBy="product", targetEntity= RegionProductImpl.class, fetch = FetchType.LAZY)
    @LazyCollection(LazyCollectionOption.EXTRA)
    private Map<Region, RegionProduct> regionProducts = new HashMap<Region, RegionProduct>();

When accessing an element of the map by key, the SQL that is generated includes a "null" column in the WHERE condition.

    where regionprod0_.PROD_ID=? and regionprod0_.null=?

resulting in the stack trace

org.hibernate.exception.SQLGrammarException: could not collection element by index
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.loader.Loader.loadEntity(Loader.java:1841)
	at org.hibernate.loader.entity.CollectionElementLoader.loadElement(CollectionElementLoader.java:72)
	at org.hibernate.persister.collection.OneToManyPersister.getElementByIndex(OneToManyPersister.java:360)
	at org.hibernate.collection.AbstractPersistentCollection.readElementByIndex(AbstractPersistentCollection.java:158)
	at org.hibernate.collection.PersistentMap.get(PersistentMap.java:146)

Iterating over the collection works successfully, but populates the entire collection, which is what Extra-Lazy is meant to avoid.




-- 
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