Spring Boot LazyInitializationException在事务中

Question

我在Spring Boot中有一个服务层类。这个类允许获取我的模型。我正在将所有模型对象转换为响应对象(DTO)。问题是我在事务中得到了一个LazyLoadException。在我看来，这不应该发生，因为数据库连接仍然是打开的。还是这样做错了？提前感谢！

@Cacheable
@Transactional(propagation = Propagation.REQUIRED)
public List<DatabaseServerResponse> getDatabaseServers(Pageable pageable){
    System.err.println(TransactionSynchronizationManager.isActualTransactionActive());
    List<DatabaseServerResponse> databaseServerResponses= databaseServerRepository
            .findAll(pageable)
            .get()
            .map(databaseServer -> databaseServerConverter.convertToDatabaseServerResponse(databaseServer))
            .collect(Collectors.toList());
    System.err.println(TransactionSynchronizationManager.isActualTransactionActive());
    return databaseServerResponses;
}

原因：org.hibernate.lazyInitializationException：无法初始化代理[com.sportradar.promt.domain.promt.environment#1]-在org.hibernate.proxy.abstractlazyInitializer.initializer.initializer(abstractlazyInitializer.java:169)在org.hibernate.proxy.abstractlazyInitializer.getimplementation（abstractlazyInitializer.java:309)在在com.sportradar.promt.domain.promt.environment$hibernateProxy$znab0ju2.getname（未知源）在sun.reflect.nativeMethodAccessorImpl.invoke0（原生方法）在sun.reflect.nativeMethodAccessorImpl.invoke（原生方法）在sun.reflect.nativeMethodAccessorImpl.invoke（原生方法）在sun.reflect.nativeMethodAccessorImpl.java:62)在ertyWriter.java:688)在com.fasterxml.jackson.databind.ser.std.beanSerializerBase.SerializeFields(BeanSerializerBase.java:719)...109个常见帧被省略

@Entity
@Table(name = "databaseservers")
@Getter
@Setter
public class DatabaseServer {

@Id
private Integer id;

@Column(name = "name")
private String name;

@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "environment_id", referencedColumnName = "id", columnDefinition = "TINYINT(3)")
private Environment environment;

@Column(name = "host")
private String host;

@Column(name = "dbuser")
private String dbUser;

@Column(name = "dbpasswd")
private String dbPassword;

}

已禁用视图中打开设置。

  jpa:
    open-in-view: false

Answer 1

好的，我找到了解决方案，Environment.class被注入到DTO中，这根本不起作用。我只是忘了将Environment.class映射到EnvironmentResponse.class