Call : (+91) 99 8080 3767
Mail :


( Duration: 1 Day )

The iBATIS training course is designed to expose developers to the open source framework while also exploring real-world memory, performance and other issues that are associated to any persistence framework. After taking this course, you should be able to persist the data in Java objects faster and build applications that are more flexible and easier to maintain.

By attending iBATIS workshop, delegates will learn to:

  • Gain an understanding of iBATIS as a data mapper and how it differs from other persistent frameworks like Hibernate and JPA in Java
  • Retrieve relational data into Java objects using the iBATIS framework
  • Explore methods of inserting, updating, and removing data from the database using iBATIS and Java objects
  • See how to relate objects and automatically have iBATIS retrieve data for associated objects
  • Explore performance and memory issues associated with object relationships
  • See how to utilize lazy loading in iBATIS to reduce the number of objects in memory
  • Understand how to solve the N+1 selects issue in iBATIS
  • Study how iBATIS handles class inheritance
  • Understand the four different levels or scopes of transactions that iBATIS supports
  • See and use iBATIS Dynamic SQL tags for generating SQL at runtime

  • A solid understanding of Java is required
  • An understanding of relational databases, SQL and JDBC is helpful

This iBATIS class is suitable for Java programmers who have interest in learning how to persist Java object data using the iBATIS open source data mapper.



iBATIS Overview

  • What is iBATIS?
  • Why use iBATIS?
  • Why not use iBATIS?
  • iBATIS Setup
  • Central Configuration File
  • General iBATIS Resources


  • SqlMap API
  • SqlMap file
  • Result Mapping
  • In-line Parameters
  • External Parameter Maps
  • The SqlMapClient interface
  • Scalar results
  • SQL Map Namespaces
  • Naming Conventions

Non-query Statements in iBATIS

  • SQL Map Statements for non-query
  • More on the SqlMap API
  • In-line and External Parameters Revisited
  • Updates
  • Autogenerated Keys


  • Setting up relationships in iBATIS
  • Relationship Issues
  • Lazy Loading
  • Dealing with N+1
  • Inheritance


  • What’s a Transaction?
  • Automatic Transactions
  • Local Transactions
  • Global Transactions
  • Custom Transactions

Dynamic SQL

  • What is Dynamic SQL?
  • The dynamic tag
  • Binary Tags
  • Unary tags
  • Parameter tags
  • The iterate tag

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.