Dashboard > iBATIS DataMapper > Home > iBATIS 3 > Information > Page Comparison
compared with
Current by Justin Koke
on Jan 18, 2010 19:38.

(show 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}
  
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