title: JHipster Spring boot : org.hibernate.HibernateException: Unable to access lob stream
body: <p>I created my app using JHipster. When i try to get list of tournaments via TournamentQueryService i get this error : </p>
  
  <blockquote>
    <p>Exception in TournamentQueryService.findByCriteria() with cause =
    'org.hibernate.HibernateException: Unable to access lob stream' and
    exception = 'Unable to access lob stream; nested exception is
    org.hibernate.HibernateException: Unable to access lob stream'</p>
  </blockquote>
  
  <p>This is filter and Page object :</p>
  
  <blockquote>
    <p>find by criteria : TournamentCriteria{}, page: Page request [number:
    0, size 8, sort: startDate: DESC]</p>
  </blockquote>
  
  <p>So it just gets 8 first tournaments. </p>
  
  <p>This is tournament class : </p>
  
  <pre><code>@Entity
  @Table(name = "tournament")
  @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
  @Document(indexName = "tournament")
  public class Tournament extends AbstractAuditingEntity implements Serializable {
  
      private static final long serialVersionUID = 1L;
  
      @Id
      @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "sequenceGenerator")
      @SequenceGenerator(name = "sequenceGenerator")
      private Long id;
  
      @Column(name = "name")
      private String name;
  
      @Column(name = "location")
      private String location;
  
      @Column(name = "url")
      private String url;
  
      @Column(name = "start_date")
      private ZonedDateTime startDate;
  
      @Column(name = "end_date")
      private ZonedDateTime endDate;
  
      @Column(name = "entry_fee")
      private Double entryFee;
  
      @Column(name = "prize")
      private Double prize;
  
      @Column(name = "goods")
      private String goods;
  
      @Column(name = "favorite_rating")
      private Long favoriteRating;
  
      @Column(name = "participants_number")
      private Integer participantsNumber;
  
      @Column(name = "finished")
      private Boolean finished;
  
      @Column(name = "view_only")
      private Boolean viewOnly;
  
      @Column(name = "image")
      private String image;
  
      @Column(name = "description")
      private String description;
  
      @Column(name = "teams_applied")
      private String teamsApplied;
  
      @Lob
      @Column(name = "schedule")
      private String schedule;
  
      @Lob
      @Column(name = "prize_distribution")
      private String prizeDistribution;
  
      @Lob
      @Column(name = "contacts")
      private String contacts;
  
      @Lob
      @Column(name = "rules")
      private String rules;
  
      @OneToMany(mappedBy = "tournament", fetch = FetchType.LAZY)
      @JsonIgnore
      @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
      private Set&lt;Stream&gt; streams = new HashSet&lt;&gt;();
  
      @ManyToMany(fetch = FetchType.EAGER)
      @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
      @JoinTable(name = "tournament_platforms", joinColumns = @JoinColumn(name = "tournaments_id", referencedColumnName = "id"), inverseJoinColumns = @JoinColumn(name = "platforms_id", referencedColumnName = "id"))
      private Set&lt;Platform&gt; platforms = new HashSet&lt;&gt;();
  
      @ManyToOne
      private Game game;
  
      @ManyToOne
      private TournamentStatus status;
  
      @ManyToOne(fetch = FetchType.LAZY)
      private EntryType entryType;
  
      @ManyToOne(fetch = FetchType.LAZY)
      private TournamentFormat format;
  
      @ManyToOne
      private Region region;
  
      @ManyToOne(fetch = FetchType.LAZY)
      private GameMode gameMode;
  
      @ManyToOne(fetch = FetchType.LAZY)
      private PrizeType prizeType;
  
      @ManyToOne
      private Organizer organizer;
  
      @ManyToOne(fetch = FetchType.LAZY)
      private TournamentStage stage;
  
      @ManyToOne
      private HostPlatform hostPlatforms;
  
      @ManyToOne(fetch = FetchType.LAZY)
      private TournamentType type;
  
      @ManyToOne
      private PlayType playType;
  
      @ManyToOne
      private Currency currency;
  
      @ManyToOne
      private Country country;
  </code></pre>
  
  <p>Here is the method that calls hibernate :</p>
  
  <pre><code>@Transactional(readOnly = true)
  public Page&lt;Tournament&gt; findByCriteria(TournamentCriteria criteria, Pageable page) {
      log.info("find by criteria : {}, page: {}", criteria, page);
      final Specifications&lt;Tournament&gt; specification = createSpecification(criteria);
      Page&lt;Tournament&gt; result = tournamentRepository.findAll(specification, page);
      return result;
  }
  </code></pre>