带有Google Cloud SQL的Spring Boot

Question

spring:
profiles: googlecloud
  jpa:
    database: MYSQL
    show-sql: false
    hibernate:
      ddl-auto: update
  datasource:
    url: jdbc:mysql://google/myproject?cloudSqlInstance=XXXX&user=xxx&password=xxx

    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>6.0.6</version>
    </dependency>
    <dependency>
        <groupId>com.google.cloud.sql</groupId>
        <artifactId>mysql-socket-factory</artifactId>
        <version>1.0.2</version>
    </dependency>
    <dependency>
        <groupId>javax.persistence</groupId>
        <artifactId>persistence-api</artifactId>
        <version>1.0.2</version>
    </dependency>

...创建存储库bean时出错...

noClassDefoundError：com/mysql/jdbc/socketFactory

Answer 1

您可以阅读更多关于从5X到6X连接器更改的详细信息：https://dev.mysql.com/doc/connector-j/6.0/en/connector-j-api-changes.html

对于NCDF异常，根据本问题:https://github.com/googleCloudplatform/cloud-sql-mysql-socket-factory/issues/18

我认为你必须改变你的依赖关系：

<dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>6.0.6</version>
    </dependency>

    <dependency>
        <groupId>com.google.cloud.sql</groupId>
        <artifactId>mysql-socket-factory-connector-j-6</artifactId>
        <version>1.0.2</version>
    </dependency>