[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6681) ArrayIndexOutOfBoundsException on enabling cache for a Native SQL query

[Samuel Mendenhall (JIRA)]

ArrayIndexOutOfBoundsException on enabling cache for a Native SQL query
-----------------------------------------------------------------------

                 Key: HHH-6681
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6681
             Project: Hibernate Core
          Issue Type: Bug
          Components: caching (L2)
    Affects Versions: 3.6.7
         Environment: Hibernate 3.6.7-Final
ehcache 2.4.5
            Reporter: Samuel Mendenhall
             Fix For: 3.6.8


String sql = "select (SELECT count(*) from kcs.dw_reports as k, kcs.dw_link_rate as lr where k.id = lr.master_report_id and k.kerberos_name = :username and k.active = true and k.span_identifier = :yearMonth) as total," +
				"(SELECT count(*) from kcs.dw_reports as k, kcs.dw_link_rate as lr where k.id = lr.master_report_id and k.kerberos_name = :username and k.active = true and k.span_identifier = :yearMonth  and lr.linked_to_doc_id IS NULL) as unlinked";
		
try 
{
	beginTransaction();
	results = getSession().createSQLQuery(sql)
		.setParameter("username", username)
		.setParameter("yearMonth", yearMonth)
		.setCacheable(true)
		.setReadOnly(true)
		.list();
	commitTransaction();
} 
catch (HibernateException e) 
{
	rollbackTransaction();
	e.printStackTrace();
	log.error(e.getMessage());
}

Console log:
Hibernate: 
    select
        (SELECT
            count(*) 
        from
            kcs.dw_reports as k,
            kcs.dw_link_rate as lr 
        where
            k.id = lr.master_report_id 
            and k.kerberos_name = ? 
            and k.active = true 
            and k.span_identifier = ?) as total,
        (SELECT
            count(*) 
        from
            kcs.dw_reports as k,
            kcs.dw_link_rate as lr 
        where
            k.id = lr.master_report_id 
            and k.kerberos_name = ? 
            and k.active = true 
            and k.span_identifier = ?  
            and lr.linked_to_doc_id IS NULL) as unlinked
21:01:42,284 ERROR ViewLinkRateService:40 - 0
java.lang.ArrayIndexOutOfBoundsException: 0
	at org.hibernate.type.TypeHelper.disassemble(TypeHelper.java:146)
	at org.hibernate.cache.StandardQueryCache.put(StandardQueryCache.java:106)
	at org.hibernate.loader.Loader.putResultInQueryCache(Loader.java:2434)
	at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2321)
	at org.hibernate.loader.Loader.list(Loader.java:2268)
	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
	at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
	at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
	at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
	at com.jboss.support.server.KcsDao.getDwLinkRateNative(KcsDao.java:69)
	at com.jboss.support.server.KcsDao.getLinkRateDataTable(KcsDao.java:128)
	at com.jboss.support.server.service.ViewLinkRateService$2.run(ViewLinkRateService.java:31)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:680)


--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira