Spring Boot Data JPA - 不将实体保存到数据库

Question

我有一个使用 JPA 的 Spring Boot 应用程序，它有 2 个数据源，1 个用于 DB2，1 个用于 SQL Server。

当我尝试将实体保存到 SQL Server 时，不会引发任何错误，但实体不会持久保存到数据库中。我没有看到在日志中生成插入。

提前致谢

这是我为尝试保存实体而执行的代码。
@零件

public class TestSave {

    @Autowired
    private BeercupMessageLogRepository repository;


    @Scheduled(fixedRate = 500000)
    public void reportCurrentTime() {
        System.out.println("Testing Save ... ");

        // Save the message in the transaction log - TypeId = 1 for Quote
        BeercupMessageLog beercupMessage = new BeercupMessageLog(1,"THIS IS A TEST ...", false);
        beercupMessage = repository.save(beercupMessage);
        System.out.println("Testing save complete ....");

    }
}

这是sql服务器配置。

@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(basePackages="com.xxx.beverage.repository.sqlserver",entityManagerFactoryRef = "entityManagerFactory", transactionManagerRef = "transactionManager")
public class sqlserverConfiguration {

    @Bean(name="datasource")
    @Primary
    @ConfigurationProperties(prefix = "sqlserver.datasource")
    public DataSource sqlserverDataSource() {
        return DataSourceBuilder.create().build();
    }

    @PersistenceContext(unitName="primary")
    @Primary
    @Bean(name = "entityManagerFactory")
    public LocalContainerEntityManagerFactoryBean sqlserverEntityManagerFactory(EntityManagerFactoryBuilder builder) {
         return builder.dataSource(sqlserverDataSource()).persistenceUnit("sqlServer").properties(jpaProperties())
                   .packages("com.boelter.beverage.model.sqlserver").build();     }

    private Map<String, Object> jpaProperties() {
         Map<String, Object> props = new HashMap<>();
         props.put("spring.jpa.hibernate.naming-strategy","org.hibernate.cfg.DefaultNamingStrategy");
         props.put("hibernate.default_schema","dbo");
         return props;
     }
}

这是 SQL Server 存储库

公共(public)接口(interface) BeercupMessageLogRepository 扩展

CrudRepository<BeercupMessageLog, Long> {

    BeercupMessageLog findOne(Long id);
    List<BeercupMessageLog> findByMessageTypeId(Long messageTypeId);
    List<BeercupMessageLog> findAll();

这是 DB2 配置。

@Configuration
@EnableTransactionManagement
@EnableJpaRepositories(basePackages="com.boelter.beverage.repository.db2",entityManagerFactoryRef = "entityManagerFactory
2", transactionManagerRef = "transactionManager2")
public class db2Configuration {

    @Bean(name="db2DataSource")
    @ConfigurationProperties(prefix = "db2.datasource")
    public DataSource db2DataSource() {
        return DataSourceBuilder.create().build();
    }

    @PersistenceContext(unitName="secondary")
    @Bean(name = "entityManagerFactory2")
    public LocalContainerEntityManagerFactoryBean db2EntityManagerFactory(EntityManagerFactoryBuilder builder) {
         return builder.dataSource(db2DataSource()).persistenceUnit("db2").properties(jpaProperties())
                   .packages("com.boelter.beverage.model.db2").build();     }

    private Map<String, Object> jpaProperties() {
         Map<String, Object> props = new HashMap<>();
         props.put("spring.jpa.hibernate.naming-strategy","org.hibernate.cfg.DefaultNamingStrategy");
         //props.put("spring.jpa.hibernate.naming-strategy","org.hibernate.cfg.ImprovedNamingStrategy");
         //props.put("spring.jpa.properties.hibernate.default_schema","R3QASDATA");
         //props.put("spring.jpa.show-sql","true");
         return props;
     }
}

这里是实体。

package com.boelter.beverage.model.sqlserver;

import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

import org.springframework.transaction.annotation.Transactional;
@Table (name="[BeercupMessageLog]")
@Entity
@Transactional
public class BeercupMessageLog {

    @Id
    @GeneratedValue(strategy=GenerationType.AUTO)
    private long    messageId;

    @Column(name="MessageTypeId", nullable = false)
    private long    messageTypeId;

    @Column(name="Processed", nullable = false)
    private boolean processed;

    // Set updatable and insertable to false so JPA does not try to pass a value.  The DB has a default
    // of the current date if no value is passed
    @Column(name="MessageDate", updatable=false, insertable=false)
    private Date    messageDate;

    @Column(name="MessageText", nullable = false)
    private String  messageText;

    protected BeercupMessageLog() {}

    public BeercupMessageLog(long messageTypeId, String messageText, boolean processed) {
        this.messageTypeId = messageTypeId;
        this.messageText = messageText;
        this.processed = processed;
    }

    /**
     * @return the messageId
     */
    public long getMessageId() {
        return messageId;
    }

    /**
     * @param messageId the messageId to set
     */
    public void setMessageId(long messageId) {
        this.messageId = messageId;
    }

    /**
     * @return the messageTypeId
     */
    public long getMessageTypeId() {
        return messageTypeId;
    }

    /**
     * @param messageTypeId the messageTypeId to set
     */
    public void setMessageTypeId(long messageTypeId) {
        this.messageTypeId = messageTypeId;
    }

    /**
     * @return the messageDate
     */
    public Date getMessageDate() {
        return messageDate;
    }

    /**
     * @param messageDate the messageDate to set
     */
    public void setMessageDate(Date messageDate) {
        this.messageDate = messageDate;
    }

    /**
     * @return the processed
     */
    public boolean isProcessed() {
        return processed;
    }

    /**
     * @param processed the processed to set
     */
    public void setProcessed(boolean processed) {
        this.processed = processed;
    }

    /**
     * @return the messageText
     */
    public String getMessageText() {
        return messageText;
    }

    /**
     * @param messageText the messageText to set
     */
    public void setMessageText(String messageText) {
        this.messageText = messageText;
    }

    @Override
    public String toString() {
        return String.format(
                "BeercupMessage[id=%d, typeId=%d, message='%s']",
                messageId, messageTypeId, messageText);
    }

}

Answer 1

我想更多的是您的 DB2 数据库没有保存，因为问题是您需要设置自定义 transactionManagerRef对于未标记数据源、实体管理器工厂和事务管理器的数据库@Primary .
这里你配置了transactionManagerRef = "transactionManager2"但是您没有将它注入(inject)到配置 bean 中。

只需添加到 db2Configuration就像是 :

@Bean(name = "transactionManager2")
public PlatformTransactionManager accountTransactionManager(EntityManagerFactoryBuilder builder) {
    JpaTransactionManager tm = new JpaTransactionManager();
    tm.setEntityManagerFactory(db2EntityManagerFactory(builder).getObject());
    tm.setDataSource(db2DataSource());
    return tm;
}