Hi
I am trying to create SqlMapClient using Properties object
I am getting following error, please see my code below

Exception in thread "main" java.lang.NullPointerException
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapExecutorDelegate.java:782)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSessionImpl.java:176)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.endTransaction(SqlMapClientImpl.java:154)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.autoEndTransaction(SqlMapExecutorDelegate.java:883)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:622)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)

        Properties prop = new Properties();
        prop.setProperty("url", "jdbc:as400:myas400/EXTDB6301;naming=system;date format=iso;time format=hms;prompt=false");
        prop.setProperty("driver", "com.ibm.as400.access.AS400JDBCDriver");
        prop.setProperty("username", "userid");
        prop.setProperty("password", "password");
        
        String resource = "com/ashishk/test/sql/SQLMapConfigWeb.xml";
        Reader reader = Resources.getResourceAsReader(resource);
        
        SqlMapClient sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader, prop);
        
        Map map = new Hashtable();
map.put("SYSTEM", "system");
map.put("AS400USER", "user");
map.put("ENVNAME", "MAPS6305F3");
map.put("P204PORD", 10000122);
        List poDataList =  sqlMapClient.queryForList("getPOData",map);

My SQLMapConfigWeb.xml is as below

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
    <sqlMap resource="com/ashishk/test/sql/PODataExternalTable.xml" />
 </sqlMapConfig>

What may be issue, when i create SqlMapClient using Properties file, it works, but for some reason when i use Properties object i dont get connection

Ash