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?
