Tasks After Running Ibator

After you run Ibator, you will need to create or modify other iBATIS configuration artifacts. The main tasks are as follows:

Each task is described in detail below.

Updating the SqlMapConfig.xml File

iBATIS uses an XML file, commonly named SqlMapConfig.xml, to specify information for a database connection, a transaction management scheme, and SQL map XML files that will be used in an iBATIS session. Ibator cannot create this file for you because Ibator knows nothing about your execution environment. However, some of the items in this file relate directly to Ibator generated items. Please refer to the standard iBATIS data mapper developer guide for details about the different configuration options.

Ibator specific needs in the configuration file are as follows:

For example, suppose that Ibator has generated an SQL Map XML file called MyTable_SqlMap.xml, and that the file has been placed in the test.xml package of your project. The SqlMapConfig.xml file should have these entries:

  <?xml version="1.0" encoding="UTF-8"?>
  <!DOCTYPE sqlMapConfig
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"

    <!-- Statement namespaces are required for Ibator -->
    <settings useStatementNamespaces="true" />

    <!-- Setup the transaction manager and data source that are
         appropriate for your environment
    <transactionManager type="...">
      <dataSource type="...">

    <!-- SQL Map XML files should be listed here -->
    <sqlMap resource="test/xml/MyTable_SqlMap.xml" />


If there is more than one SQL Map XML file (as is quite common), then the files can be listed in any order with repeated <sqlMap> elements after the <transactionManager> element.

Version 1.2 New Enhancement With Ibator version 1.2 and later, You may ask Ibator to generate a skeleton SQL Map Configuration file with the SqlMapConfigPlugin. See the <ibatorPlugin> page for more information.

Updating the dao.xml File

Important Note: this step is only required if you generated DAOs for the iBATIS DAO framework.

The iBATIS DAO framework is configured by an xml file commonly called dao.xml. The iBATIS DAO framework uses this file to control the database connection information for DAOs, and also to list the DAO implementation classes and DAO interfaces. In this file you should specify the path to your SqlMapConfig.xml file, and all the Ibator generated DAO interfaces and implementation classes.

For example, suppose that Ibator has generated a DAO interface called MyTableDAO and a implementation class called MyTableDAOImpl, and that the files have been placed in the test.dao package of your project. The dao.xml file should have these entries:

  <?xml version="1.0" encoding="UTF-8"?>
  <!DOCTYPE daoConfig
   PUBLIC "-//ibatis.apache.org//DTD DAO Configuration 2.0//EN"

      <transactionManager type="SQLMAP">
        <property name="SqlMapConfigResource"

      <!-- DAO interfaces and implementations should be listed here -->
      <dao interface="test.dao.MyTableDAO"
           implementation="test.dao.MyTableDAOImpl" />