我正在尝试将我的spring boot应用程序部署到Google app Engine Flex Environment和G Cloud MySQL DB上。
我在连接数据库时遇到问题。
已经尝试了一些变体,但都不成功。spring-boot-with-google-cloud-datastore-api-fails-to-run
我的属性:
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我的pom.xml (仅适用于db依赖项):
<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>使用这个配置,我得到了:
正在加载类com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver‘。驱动程序是通过SPI自动注册的,通常不需要手动加载驱动程序类。
原因: java.lang.ClassNotFoundException: com.mysql.jdbc.SocketFactory
...Error正在创建存储库beans...
java.lang.NoClassDefFoundError: com/mysql/jdbc/SocketFactory
发布于 2017-05-11 06:22:19
您可以阅读有关从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>https://stackoverflow.com/questions/43897810
复制相似问题