Sqlite catalog and schema settings (for MyBatis generator)
- by user1769754
I have been trying to use the MyBatis generator on a Sqlite database but can't seem to find what settings to use for the XML attributes catalog and schema.
The generator errors with "Generation Warnings Occured: Table configuration with catalog main, schema sqlite_master, and table testTable did not resolve to any tables"
I can't find much from the sqlite website other than this which gives something like catalog = main, schema = sqlite or sqlite_master
My generator XML file is
<?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="context">
<jdbcConnection driverClass="org.sqlite.JDBC" connectionURL="jdbc:sqlite:testDB.sqlite" userId="" password="" ></jdbcConnection>
<javaModelGenerator targetPackage="model" targetProject="test/src" ></javaModelGenerator>
<sqlMapGenerator targetPackage="model" targetProject="test/src" ></sqlMapGenerator>
<javaClientGenerator targetPackage="model" targetProject="test" type="XMLMAPPER" ></javaClientGenerator>
<table catalog="main" schema="sqlite_master" tableName="testTable" >
<property name="useActualColumnNames" value="true"/>
</table>
</context>
</generatorConfiguration>
I have also tried other combinations like
<table catalog="main" schema="sqlite" tableName="testTable" >
<table schema="sqlite" tableName="testTable" >
<table schema="sqlite_master" tableName="testTable" >
<table schema="main.testTable" tableName="testTable" >
Anyone here know the right settings?
