sql-map-config.d/PosixGroup.xml

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">

<sqlMap namespace="PosixGroup">

        <SELECT id="getPosixGroupList" resultClass="java.util.HashMap">
                SELECT  unix_group_name AS cn,
                        group_id+1000 AS gidNumber
                FROM groups
        </select>

        <SELECT id="getPosixGroup" resultClass="java.util.HashMap" parameterClass="java.util.Map">
                <!-- To get group membership -->
                SELECT  GROUP_CONCAT(user_name SEPARATOR ',') AS memberUid,
                        ug.group_id+1000 AS gidNumber,
                        g.unix_group_name AS cn,
                        g.short_description AS description
                FROM user_group ug, USER u, groups g
                WHERE ug.group_id = #gidNumber#
                AND ug.user_id = u.user_id
                AND g.group_id = #gidNumber#


        </select>


        <SELECT id="getPosixGroupClean" resultClass="java.util.HashMap" parameterClass="java.util.Map">
                SELECT group_id+1000 AS gidNumber,
                        unix_group_name AS cn
                FROM groups
                WHERE group_id = #gidNumber#
        </select>

</sqlMap>