Version 7 by Kai Grabfelder on May 31, 2009 14:10. << Changes from 6 to 7 compared with Current by Justin Koke on Jan 18, 2010 19:38. (show comment) (hide comment)

Key These lines were removed. This word was removed. These lines were added. This word was added. View page history

There are 1 changes. View first change.

		{info:title=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/trunk/java/ibatis-3/]
		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/]
		{info}
		h1. 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.
		h2. create maven project
		Create a new maven project using the quickstart archetype
		{code}
		mvn archetype:create -DarchetypeGroupId=org.apache.maven.archetypes -DgroupId=org.apache.ibatis -DartifactId=ibatis3-tutorial
		{code}
		This will create the following directory layout:
		{code}
		└───src
		├───main
		│ └───java
		│ └───org
		│ └───apache
		│ └───ibatis
		└───test
		└───java
		└───org
		└───apache
		└───ibatis
		{code}
		Add the ibatis and h2 dependencies to the pom.xml and change the default sorce version to 1.5 so it looks like:
		{code:xml|title=/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>
		{code}
		Run a maven build to see if the dependencies can be properly resolved:
		{code}
		[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] ------------------------------------------------------------------------
		{code}
		h2. 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
		{code:sql|title=/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)
		);
		);
		{code}