Configuring with Ibatis

Need following following jars: Ibatis-db , commons-dbcp, dom4j, jta


Java class for connection
import com.ibatis.db.sqlmap.SqlMap;
import java.io.Reader;
import com.ibatis.db.sqlmap.XmlSqlMapBuilder;
import com.ibatis.common.resources.Resources;

public class Connection {
private static SqlMap sqlMap=null;
static{
try{
String resource="ibdb/connection.xml";
Reader reader=Resources.getResourceAsReader(resource);
sqlMap=XmlSqlMapBuilder.buildSqlMap(reader); }
catch (Exception e)
{System.out.println("exception: "+e);
throw new RuntimeException(
"Error initializing Connection class. Cause: " + e);
}
}
public SqlMap getConnection(){
return sqlMap;
}
}

Connection.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sql-map-config PUBLIC "-//iBATIS.com//DTD SQL Map Config 1.0//EN" <"http://www.ibatis.com/dtd/sql-map-config.dtd">
<sql-map-config>
<properties resource="ibdb/connection.properties" />
<settings maxExecute="400" maxExecutePerConnection="5" maxTransactions="30" <statementCacheSize="150" />
<datasource name="basic" default = "true" factory-class="com.ibatis.db.sqlmap.datasource.DbcpDataSourceFactory">
<property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
<property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost/databasename?autoReconnect=true"/>
<property name="JDBC.Username" value="root"/>
<property name="JDBC.Password" value="mysql"/>
<property name="Pool.MaximumActiveConnections" value="1"/>
<property name="Pool.MaximumIdleConnections" value="1"/>
<property name="Pool.MaximumWait" value="60000"/>
</datasource>
<sql-map resource="/ibdb/query.xml" / >
</sql-map-config>