                        課程
                    
                        /后端開發
                        
                            /Java
                        
                        /SpringBoot構建電商基礎秒殺項目

無法連接數據庫

[ERROR] Failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.5:generate (default-cli) on project miaosha: Communications link failure

幕布斯6739812

2019-01-23

源自：SpringBoot構建電商基礎秒殺項目 2-4

關注問題我要回答

1129

操作

收起

2 回答

龍蝦三少回答被采納 +2 積分
2019-01-23

查看下jdbc連接串的配置，mysql maven的版本是5.1的，用mysql 6的server就會有問題

0 回復有任何疑惑可以回復我~

收起回答

幕布斯6739812 提問者

用的mysql8.0.14，更換為5.1.41后解決了

2019-01-24 回復有任何疑惑可以回復我~

許安強
2020-10-05

請問能出一個mysql8的配置嗎，我也報的這個問題，不知道哪的問題了，jdbc.driver都替換了

1、這是我的mybatis-generator.xml

<?xml?version="1.0"?encoding="UTF-8"?>
<!DOCTYPE?generatorConfiguration
????????PUBLIC?"-//mybatis.org//DTD?MyBatis?Generator?Configuration?1.0//EN"
????????"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
????<context?id="DB2Tables"????targetRuntime="MyBatis3">
????????<commentGenerator>
????????????<property?name="suppressDate"?value="true"/>
????????????<property?name="suppressAllComments"?value="true"/>
????????</commentGenerator>
????????<!--數據庫鏈接地址賬號密碼-->
????????<jdbcConnection?driverClass="com.mysql.cj.jdbc.Driver"?connectionURL="jdbc:mysql://localhost:3306/miaosha?useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=false&amp;serverTimezone=GMT&amp;nullCatalogMeansCurrent=true"
????????????????????????userId="root"?password="123456">
????????</jdbcConnection>
????????<javaTypeResolver>
????????????<property?name="forceBigDecimals"?value="false"/>
????????</javaTypeResolver>
????????<!--生成DataObject類存放位置-->
????????<javaModelGenerator?targetPackage="com.miaoshaoproject.dataobject"
????????????????????????????targetProject="src/main/java">
????????????<property?name="enableSubPackages"?value="true"?/>
????????????<property?name="trimStrings"?value="true"?/>
????????</javaModelGenerator>
????????<!--生成映射文件存放位置?-->
????????<sqlMapGenerator?targetPackage="mapping"
?????????????????????????targetProject="src/main/resources">
????????????<property?name="enableSubPackages"?value="true"?/>
????????</sqlMapGenerator>
????????<!--生成DAO類型的文件-->
????????<javaClientGenerator?targetPackage="com.miaoshaoproject.dao"
?????????????????????????????targetProject="src/main/java"
?????????????????????????????type="XMLMAPPER">
????????????<property?name="enableSubPackages"?value="false"?/>
????????</javaClientGenerator>
????????<!--生成對應表及類名-->
????????<!--<table?tableName="user_info"?domainObjectName="UserDO"?enableCountByExample="false"?enableUpdateByExample="false"?enableDeleteByExample="false"?enableSelectByExample="false"?selectByExampleQueryId="false"></table>-->
????????<table?tableName="user_info"?domainObjectName="UserDO"></table>
????????<table?tableName="user_password"?domainObjectName="UserPasswordDO"></table>
????</context>
</generatorConfiguration>

2、這是我的pom.xml

<?xml?version="1.0"?encoding="UTF-8"?>

<project?xmlns="http://maven.apache.org/POM/4.0.0"?xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
??xsi:schemaLocation="http://maven.apache.org/POM/4.0.0?http://maven.apache.org/xsd/maven-4.0.0.xsd">
??<modelVersion>4.0.0</modelVersion>

??<groupId>com.miaoshaoproject</groupId>
??<artifactId>miaoshao</artifactId>
??<version>1.0-SNAPSHOT</version>

??<name>miaoshao</name>
??<!--?FIXME?change?it?to?the?project's?website?-->
??<url>http://www.example.com</url>

??<parent>
????<groupId>org.springframework.boot</groupId>
????<artifactId>spring-boot-starter-parent</artifactId>
????<version>2.3.3.RELEASE</version>
????<relativePath/>?<!--?lookup?parent?from?repository?-->
??</parent>

??<properties>
????<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
????<maven.compiler.source>1.7</maven.compiler.source>
????<maven.compiler.target>1.7</maven.compiler.target>
??</properties>

??<dependencies>
????<dependency>
??????<groupId>org.springframework.boot</groupId>
??????<artifactId>spring-boot-starter-web</artifactId>
????</dependency>

????<dependency>
??????<groupId>mysql</groupId>
??????<artifactId>mysql-connector-java</artifactId>
??????<version>8.0.11</version>
????</dependency>

????<dependency>
??????<groupId>com.alibaba</groupId>
??????<artifactId>druid</artifactId>
??????<version>1.1.3</version>
????</dependency>

????<dependency>
??????<groupId>org.mybatis.spring.boot</groupId>
??????<artifactId>mybatis-spring-boot-starter</artifactId>
??????<version>1.3.1</version>
????</dependency>

????<dependency>
??????<groupId>org.mybatis.generator</groupId>
??????<artifactId>mybatis-generator-core</artifactId>
??????<version>1.3.5</version>
????</dependency>

????<dependency>
??????<groupId>junit</groupId>
??????<artifactId>junit</artifactId>
??????<version>4.11</version>
??????<scope>test</scope>
????</dependency>
??</dependencies>

??<build>
????<pluginManagement><!--?lock?down?plugins?versions?to?avoid?using?Maven?defaults?(may?be?moved?to?parent?pom)?-->
??????<plugins>
????????<!--?clean?lifecycle,?see?https://maven.apache.org/ref/current/maven-core/lifecycles.html#clean_Lifecycle?-->
????????<plugin>
??????????<artifactId>maven-clean-plugin</artifactId>
??????????<version>3.1.0</version>
????????</plugin>
????????<!--?default?lifecycle,?jar?packaging:?see?https://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_jar_packaging?-->
????????<plugin>
??????????<artifactId>maven-resources-plugin</artifactId>
??????????<version>3.0.2</version>
????????</plugin>
????????<plugin>
??????????<artifactId>maven-compiler-plugin</artifactId>
??????????<version>3.8.0</version>
????????</plugin>
????????<plugin>
??????????<artifactId>maven-surefire-plugin</artifactId>
??????????<version>2.22.1</version>
????????</plugin>
????????<plugin>
??????????<artifactId>maven-jar-plugin</artifactId>
??????????<version>3.0.2</version>
????????</plugin>
????????<plugin>
??????????<artifactId>maven-install-plugin</artifactId>
??????????<version>2.5.2</version>
????????</plugin>
????????<plugin>
??????????<artifactId>maven-deploy-plugin</artifactId>
??????????<version>2.8.2</version>
????????</plugin>
????????<!--?site?lifecycle,?see?https://maven.apache.org/ref/current/maven-core/lifecycles.html#site_Lifecycle?-->
????????<plugin>
??????????<artifactId>maven-site-plugin</artifactId>
??????????<version>3.7.1</version>
????????</plugin>
????????<plugin>
??????????<artifactId>maven-project-info-reports-plugin</artifactId>
??????????<version>3.0.0</version>
????????</plugin>

????????<plugin>
??????????<groupId>org.mybatis.generator</groupId>
??????????<artifactId>mybatis-generator-maven-plugin</artifactId>
??????????<version>1.3.5</version>
??????????<dependencies>
????????????<dependency>
??????????????<groupId>org.mybatis.generator</groupId>
??????????????<artifactId>mybatis-generator-core</artifactId>
??????????????<version>1.3.5</version>
????????????</dependency>
????????????<dependency>
??????????????<groupId>mysql</groupId>
??????????????<artifactId>mysql-connector-java</artifactId>
??????????????<version>8.0.11</version>
????????????</dependency>
??????????</dependencies>
??????????<executions>
????????????<execution>
??????????????<id>mybatis?generator</id>
??????????????<phase>package</phase>
??????????????<goals>
????????????????<goal>generate</goal>
??????????????</goals>
????????????</execution>
??????????</executions>
??????????<configuration>
????????????<!--?允許移動生成的文件-->
????????????<verbose>true</verbose>
????????????<!--不允許覆蓋文件-->
????????????<overwrite>true</overwrite>
????????????<configurationFile>src/main/resources/mybatis-generator.xml</configurationFile>
??????????</configuration>
????????</plugin>

??????</plugins>
????</pluginManagement>
????<plugins>
??????<plugin>
????????<groupId>org.apache.maven.plugins</groupId>
????????<artifactId>maven-compiler-plugin</artifactId>
????????<configuration>
??????????<source>8</source>
??????????<target>8</target>
????????</configuration>
??????</plugin>
????</plugins>

??</build>
</project>

0 回復有任何疑惑可以回復我~

收起回答