CODEWITHSUNDEEP
mybatismybatis-generator
danny
danny

Reputation: 457

Mybatis Generator: How to generate all tables for a specified schema

Mysql database totally has 4 schemas, and I just want to generate a specified schema named 'booking'. But it always generate all tables for all schemas. So I need your help. Below is my generatorConfig.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="MySqlContext" targetRuntime="MyBatis3Simple" defaultModelType="flat">
        <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
                        connectionURL="jdbc:mysql://localhost:3306/booking?useSSL=false"
                        userId="root"
                        password="123456">
        </jdbcConnection>

        <javaModelGenerator targetPackage="com.clycle.booking.entity" targetProject="C:\Users\a243903\projects\booking\webapi\src\main\java">
            <property name="enableSubPackages" value="true" />
            <property name="trimStrings" value="true" />
        </javaModelGenerator>

        <sqlMapGenerator targetPackage="entity-mapper"  targetProject="C:\Users\a243903\projects\booking\webapi\src\main\resources">
            <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>

        <javaClientGenerator type="XMLMAPPER" targetPackage="dao"  targetProject="C:\Users\a243903\projects\booking\webapi\src\main\java">
            <property name="enableSubPackages" value="true" />
        </javaClientGenerator>

        <table schema="booking" tableName="%">
        </table>

    </context>
</generatorConfiguration>

Upvotes: 4

Views: 8591

Answers (2)

Mr.True
Mr.True

Reputation: 339

You should rewrite your generatorConfig.xml like this:

<table tableName="yourTableName" domainObjectName="JavaBeanName"
   enableCountByExample="false" 
   enableUpdateByExample="false"
   enableDeleteByExample="false" 
   enableSelectByExample="false"
   selectByExampleQueryId="false" 
   enableDeleteByPrimaryKey="false"
   enableInsert="false" 
   enableUpdateByPrimaryKey="false">
</table>

If you use MySQL, The crucial point is this:
{property name="nullCatalogMeansCurrent" value="true"}
reference: http://www.mybatis.org/generator/usage/intro.html

    <jdbcConnection
            driverClass="${driverClassName}"
            connectionURL="${url}"
            userId="${username}"
            password="${password}">
        <property name="nullCatalogMeansCurrent" value="true" />
    </jdbcConnection>

For example:

<generatorConfiguration>
<properties resource="mybatis-generator/generator.properties"></properties>
<classPathEntry location="${driverLocation}"/>
<context id="default" targetRuntime="MyBatis3">
    <commentGenerator>
        <property name="suppressDate" value="true"/>
        <property name="suppressAllComments" value="true"/>
    </commentGenerator>

    <jdbcConnection
            driverClass="${driverClassName}"
            connectionURL="${url}"
            userId="${username}"
            password="${password}">
       **<property name="nullCatalogMeansCurrent" value="true" />**
    </jdbcConnection>

    <javaTypeResolver>
        <property name="forceBigDecimals" value="false"/>
    </javaTypeResolver>

    <javaModelGenerator targetPackage="com.entity" targetProject="src/main/java">

        <property name="enableSubPackages" value="true"/>
    </javaModelGenerator>


    <sqlMapGenerator targetPackage="com.daoMappers" targetProject="src/main/resources">
        <property name="enableSubPackages" value="true"/>
    </sqlMapGenerator>


    <javaClientGenerator targetPackage="com.dao" targetProject="src/main/java" type="XMLMAPPER">
        <property name="enableSubPackages" value="true"/>
    </javaClientGenerator>


    <table tableName="student" domainObjectName="Student"
           enableCountByExample="false" 
           enableUpdateByExample="false"
           enableDeleteByExample="false" 
           enableSelectByExample="false"
           selectByExampleQueryId="false" 
           enableDeleteByPrimaryKey="false"
           enableInsert="false" 
           enableUpdateByPrimaryKey="false">
    </table>
</context>

Notes those should set by yourself

<properties resource="mybatis-generator/generator.properties"></properties>
<classPathEntry location="${driverLocation}"/>

The file of generator.properties coding like this:

driverClassName=com.mysql.cj.jdbc.Driver

driverLocation=/Users/mac/.m2/repository/mysql/mysql-connector-java/6.0.6/mysql-connector-java-6.0.6.jar

url=jdbc:mysql://localhost:3306/student?useSSL=false&useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&autoReconnect=true
username=xxx
password=xxx

Upvotes: 0

Jeff Butler
Jeff Butler

Reputation: 991

  1. Make your table configuration look like this: <table tableName="%"/>
  2. Add <property name="nullCatalogMeansCurrent" value=true" /> under the <jdbcConnection>

See this reference page for more information: http://www.mybatis.org/generator/usage/mysql.html

Upvotes: 7

Related Questions