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

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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...