for me combining Spring with iBATIS is pretty much my standard way for using
iBATIS in web applications. The
webframework differs (may it be Wicket, Stripes or Struts) but iBATIS and
Spring dependency injection always
stays the same ;-). See the jpetstore (an example contained in the Spring
download) for an example.
Regards Kai
Kai
--- Original Nachricht ---
Absender: Ashish Kulkarni
Datum: 02.12.2008 21:34
> HiAny ideas on the mail below
>
> On Fri, Nov 7, 2008 at 10:17 AM, Ashish Kulkarni <
> [EMAIL PROTECTED]> wrote:
>
>> HiIs there any standard way or best practice for of using Ibatis in web
>> application,
>> This is how i use it
>> In my InitServlet which is loaded when the application starts, i create
>> instance SqlMapClient and save it in ServletContext.
>> And in other servlets where i need to get data from database, i get the
>> SqlMapClient from ServletConext and use it
>>
>> I think by doing this, SqlMapClient will automatically create
>> ConnectionPool and use this connection pool for running queries
>>
>> public class InitServlet extends javax.servlet.http.HttpServlet
>> {
>> public void init(ServletConfig config)
>> {
>> super.init(config);
>> ServletContext oCtx = config.getServletContext();
>> String resource = "SQLMapConfigWeb.xml";
>> Reader reader = Resources.getResourceAsReader(resource);
>> SqlMapClient sqlMap =
>> SqlMapClientBuilder.buildSqlMapClient(reader);
>> oCtx.setAttribute("SQLMAPCLIENT", sqlMap );
>> }
>> }
>>
>>
>> public class DataAccessServlet extends javax.servlet.http.HttpServlet
>> {
>> public void doGet(javax.servlet.http.HttpServletRequest request,
>> javax.servlet.http.HttpServletResponse response)
>> throws javax.servlet.ServletException, java.io.IOException
>> {
>> SqlMapClient sqlMap
>> = oCtx.getAttribute("SQLMAPCLIENT", sqlMap );
>> sqlMap.queryForObject("getPerson", personId);
>> }
>>
>>
>> }
>>
>> //This is my "SQLMapConfigWeb.xml"
>>
>> <?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>
>>
>> file (e.g. "${driver}". The file is usually relative to the classpath and
>> is optional. -->
>> <properties resource="SqlMapConfigAS400.properties" />
>> <settings cacheModelsEnabled="true" enhancementEnabled="true"
>> lazyLoadingEnabled="true" maxRequests="32" maxSessions="10"
>> maxTransactions="5" useStatementNamespaces="false" />
>> <transactionManager type="JDBC">
>> <dataSource type="SIMPLE">
>> <property name="JDBC.Driver" value="${driver}" />
>>
>> <property name="JDBC.ConnectionURL" value="${url}" />
>>
>> <property name="JDBC.Username" value="${username}" />
>>
>> <property name="JDBC.Password" value="${password}" />
>>
>> </dataSource>
>> </transactionManager>
>> <sqlMap resource="ExternalTable.xml" />
>>
>> </sqlMapConfig>
>>
>>
>>
>>
>>
>
