ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kai Grabfelder <nos...@kinokai.de>
Subject Re: Best practice for using Ibatis in Web application
Date Tue, 02 Dec 2008 21:24:12 GMT
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 <
> ashish.kulkarni13@gmail.com> 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>
>>
>>
>>
>>
>>
> 


Mime
View raw message