I agree with Kai,
for me Spring and Ibatis are the better way to use Ibatis in a web
Application.
Regards
--
Rinaldo Bonazzo
Il giorno mar, 02/12/2008 alle 22.24 +0100, Kai Grabfelder ha scritto:
> 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>
> >>
> >>
> >>
> >>
> >>
> >
>
