Dashboard > iBATIS DataMapper > Home > iBATIS 3
Added by Kai Grabfelder, last edited by Justin Koke on Jan 18, 2010  (view change)
Labels: 
(None)


Useful Information

iBATIS 3 is currently in development. Once iBATIS 3 is released the information from this page will be moved to the official documentation. Until iBATIS 3 is released feel free to download the sources directly from the source repository http://svn.apache.org/repos/asf/ibatis/java/ibatis-3/trunk/

getting started

During this tutorial we will create a small maven project with a testcase showing the basic functionality of iBATIS 3 using the in memory h2 database.

create maven project

Create a new maven project using the quickstart archetype

mvn archetype:create -DarchetypeGroupId=org.apache.maven.archetypes -DgroupId=org.apache.ibatis -DartifactId=ibatis3-tutorial

This will create the following directory layout:

└───src
    ├───main
    │   └───java
    │       └───org
    │           └───apache
    │               └───ibatis
    └───test
    └───java
    └───org
    └───apache
    └───ibatis

Add the ibatis and h2 dependencies to the pom.xml and change the default sorce version to 1.5 so it looks like:

/pom.xml
<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/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>org.apache.ibatis</groupId>
    <artifactId>ibatis3-tutorial</artifactId>
    <packaging>jar</packaging>
    <version>1.0-SNAPSHOT</version>
    <name>ibatis3-tutorial</name>
    <url>http://maven.apache.org</url>
    <build>
    <plugins>
    <plugin>
    <groupId>org.apache.maven.plugins</groupId>
    <artifactId>maven-compiler-plugin</artifactId>
    <version>2.0.2</version>
    <configuration>
    <source>1.5</source>
    <target>1.5</target>
    <encoding>UTF-8</encoding>
    </configuration>
    </plugin>
    </plugins>
    </build>
    <dependencies>
    <dependency>
    <groupId>org.apache.ibatis</groupId>
    <artifactId>ibatis-3-core</artifactId>
    <version>3.0-SNAPSHOT</version>
    </dependency>
    <dependency>
    <groupId>com.h2database</groupId>
    <artifactId>h2</artifactId>
    <version>1.1.113</version>
    </dependency>
    <dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.6</version>
    <scope>test</scope>
    </dependency>
    </dependencies>
    </project>

Run a maven build to see if the dependencies can be properly resolved:

[INFO] ------------------------------------------------------------------------
    [INFO] BUILD SUCCESSFUL
    [INFO] ------------------------------------------------------------------------
    [INFO] Total time: 5 seconds
    [INFO] Finished at: Sun May 31 20:43:08 CEST 2009
    [INFO] Final Memory: 11M/20M
    [INFO] ------------------------------------------------------------------------

database schema

In this example we will assume that we have an existing database structure that we want query and manipulate using iBATIS. For this tutorial we will use the following database structure described in

/src/test/resources/database.ddl
CREATE TABLE PERSON(
    PER_ID NUMBER (5, 0) NOT NULL,
    PER_FIRST_NAME VARCHAR (40) NOT NULL,
    PER_LAST_NAME VARCHAR (40) NOT NULL,
    PER_BIRTH_DATE DATETIME ,
    PER_WEIGHT_KG NUMBER (4, 2) NOT NULL,
    PER_HEIGHT_M NUMBER (4, 2) NOT NULL,
    PRIMARY KEY (PER_ID)
    );
    );

Site running on a free Atlassian Confluence Open Source Project License granted to OSS. Evaluate Confluence today.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.5.5 Build:#811 Jul 25, 2007) - Bug/feature request - Contact Administrators