spring-jpa 整合

[TarryHoo]

@liuyangming 大佬,有个问题请教下.

最近在做springcloud 和 Jpa 整合. 请求后报错

Caused by: java.sql.SQLException: Illegal operation!
    at org.bytesoft.bytejta.supports.jdbc.LogicalConnection.setAutoCommit(LogicalConnection.java:83) ~[bytejta-core-0.5.0-BETA8.jar:na]
    at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.begin(AbstractLogicalConnectionImplementor.java:67) ~[hibernate-core-5.3.10.Final.jar:5.3.10.Final]
    ... 204 common frames omitted

配置如下

  jpa:
    hibernate:
      ddl-auto: update
    show-sql: true
    properties.hibernate.format_sql: true
    database-platform: org.hibernate.dialect.MySQL5InnoDBDialect  
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    type: org.apache.commons.dbcp2.BasicDataSource

版本如下

<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.1.6.RELEASE</version>
</parent>

<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-core</artifactId>
    <version>5.3.10.Final</version>
</dependency>

报错的代码是AbstractLogicalConnectionImplementor.begin()

@Override
public void begin() {
    try {
        if ( !doConnectionsFromProviderHaveAutoCommitDisabled() ) {
            log.trace( "Preparing to begin transaction via JDBC Connection.setAutoCommit(false)" );
            getConnectionForTransactionManagement().setAutoCommit( false );
            log.trace( "Transaction begun via JDBC Connection.setAutoCommit(false)" );
        }
        status = TransactionStatus.ACTIVE;
    }
    catch( SQLException e ) {
        throw new TransactionException( "JDBC begin transaction failed: ", e );
    }
}

[liuyangming]

你这个事务走的不是byteTCC的事务管理器，可能走了HibernateTransactionManager。byteTCC针对jpa的集成，请参考ByteTCC-sample/springboot-sample/sample-provider，具体配置看一下这几个类： 1、SpringBootProviderBootstrap: 留意一下@EnableJpaRepositories注解的配置; 2、ProviderConfig: 留意LocalContainerEntityManagerFactoryBean的配置; 3、META-INF/persistence.xml;

[TarryHoo]

你这个事务走的不是byteTCC的事务管理器，可能走了HibernateTransactionManager。byteTCC针对jpa的集成，请参考ByteTCC-sample/springboot-sample/sample-provider，具体配置看一下这几个类： 1、SpringBootProviderBootstrap: 留意一下@EnableJpaRepositories注解的配置; 2、ProviderConfig: 留意LocalContainerEntityManagerFactoryBean的配置; 3、META-INF/persistence.xml;

好的,多谢大佬解答.我去看下

[TarryHoo]

@liuyangming 大佬 昨晚测试了下, 不支持springboot 2.1.X 2.1.X的springboot DataSourceInitializedPublisher 做了些改动. 如下是我整合到2.1.X sb 的修改

[liuyangming]

好的，感谢反馈。