[jboss-user] [JBoss Portal] - CMS - UnsupportedOperationException: Blobs are not cacheable

[rharari]

Hi Folks,

The CMS module is throwing the exception below when deploying the portal-cms.sar for the first time. 

03:00:35,933 ERROR [STDERR] Caused by: java.lang.UnsupportedOperationException: Blobs are not cacheable
03:00:35,933 ERROR [STDERR]     at org.hibernate.type.BlobType.disassemble(BlobType.java:83)
03:00:35,933 ERROR [STDERR]     at org.hibernate.cache.StandardQueryCache.put(StandardQueryCache.java:80)
03:00:35,933 ERROR [STDERR]     at org.hibernate.loader.Loader.putResultInQueryCache(Loader.java:2118)
03:00:35,964 ERROR [STDERR]     at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2062)
03:00:35,964 ERROR [STDERR]     at org.hibernate.loader.Loader.list(Loader.java:2020)
03:00:35,964 ERROR [STDERR]     at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
03:00:35,964 ERROR [STDERR]     at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
03:00:35,964 ERROR [STDERR]     at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
03:00:35,995 ERROR [STDERR]     at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
03:00:35,995 ERROR [STDERR]     at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
03:00:35,995 ERROR [STDERR]     at org.jboss.portal.cms.hibernate.state.HibernatePersistenceManager$DbBLOBStore.get(Hibe
rnatePersistenceManager.java:1033)

To avoid this exception I´ve changed the default caching attributes in hibernate.cfg.xml to false as follows:

  | <property name="cache.use_second_level_cache">false</property>
  | <property name="cache.use_query_cache">false</property>
  | 

The environment is:
- PortalDS is pointing to a MySQL 5.0 database 
- Jboss-Portal 2.6.0 CR2 
- jdk1.6

I think another solution is changing setCacheable to false in this line (haven´t try yet):

            List rs = session.createQuery(blobSelectData).setCacheable(false)
                  .setString(0, blobId).list();


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4042295#4042295

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4042295