<dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>

                <property name="poolMaximumActiveConnections" value="10" />
                <property name="poolMaximumIdleConnections" value="2" />
                <property name="poolMaximumCheckoutTime" value="120000" />
                <property name="poolTimeToWait" value="10000" />
                <property name="poolPingQuery" value="select 1" />
                <property name="poolPingEnabled" value="true" />
                <property name="poolPingConnectionsNotUsedFor" value="900000" />
            </dataSource>

Waiting as long as 10000 milliseconds for connection

   SqlSession sqlSession = SqlMapHelper.getSqlSessionFactory().openSession();
   try {
      HashMap insertMap = new HashMap();
      insertMap.put("id", id);
      insertMap.put("name", "First name");
      sqlSession.insert("insertElementaryMessage", insertMap);
      sqlSession.commit();
   } catch (Exception e) {
      sqlSession.rollback();
   } finally {
      sqlSession.close();
   }