[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5858) Cannot load entities with Clob or Lob properties into stateless sessions

[ https://hibernate.onjira.com/browse/HHH-5858?page=com.atlassian.jira.plug... ] Ralf Huthmann commented on HHH-5858: ------------------------------------ Sorry it took me so long to come back to this issue. The code shown below is in use for reading CLOBs with a stateless session and i have not encountered any issues. Please perform additional tests for your usecase. To use my replacement-class, i construct a stateless session this way: {code} Connection con = session.connection(); SessionFactory sf = session.getSessionFactory(); StatelessSessionWithLobImpl sls = new StatelessSessionWithLobImpl(con, (SessionFactoryImpl) sf); {code} Finally, this is the replacement for StatelessSessionImpl: {code} package org.hibernate.impl; import org.apache.log4j.Logger; import org.hibernate.Session; import org.hibernate.StatelessSession; import org.hibernate.engine.jdbc.LobCreationContext; import org.hibernate.exception.JDBCExceptionHelper; import java.sql.Connection; import java.sql.SQLException; /** * Replacement for StatelessSessionImpl implementing LobCreationContext, * this enables the use of LOBs with a stateless session. * The execute-method in this class was copied from SessionImpl. * @see http://opensource.atlassian.com/projects/hibernate/browse/HHH-5858 */ public class StatelessSessionWithLobImpl extends StatelessSessionImpl implements LobCreationContext { private static final long serialVersionUID = 6444431664782394430L; private static final Logger LOGGER = Logger.getLogger(StatelessSessionWithLobImpl.class); public StatelessSessionWithLobImpl(Connection connection, SessionFactoryImpl factory) { super(connection, factory); } @Override public Object execute(Callback callback) { Object result; Connection connection = super.connection(); boolean success = false; try { result = callback.executeOnConnection( connection ); success = true; } catch ( SQLException e ) { throw JDBCExceptionHelper.convert( getFactory().getSQLExceptionConverter(), e, "Error creating contextual LOB : " + e.getMessage() ); } finally { afterOperation(success); } try { connection.close(); } catch (SQLException e) { LOGGER.error("Kann man nichts machen", e); } return result; } } {code} -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira