無法連接數(shù)據(jù)庫 [ERROR] Failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.5:generate (default-cli) on project miaosha: Communications link failure
我用的mysql8的數(shù)據(jù)庫，無法連接上去，對應(yīng)的配置也換成8.0的還是不好使呀
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> ????????<!--數(shù)據(jù)庫鏈接地址賬號密碼--> ????????<jdbcConnection?driverClass="com.mysql.cj.jdbc.Driver"?connectionURL="jdbc:mysql://localhost:3306/miaosha?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=GMT&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> ????????<!--生成對應(yīng)表及類名--> ????????<!--<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>
2022-04-01