ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashish Kulkarni" <ashish.kulkarn...@gmail.com>
Subject Re: Issue with Ibatis in Websphere
Date Thu, 21 Dec 2006 21:16:00 GMT
Hi
Thanks, for now i have changed my code as Jeff suggested and testing it,
still now not seen any major issues, and hope it continues that way.

Ashish

On 12/19/06, Clinton Begin <clinton.begin@gmail.com> wrote:
>
> Exactly.
>
> This interface isn't perfect either though...I have better ideas.  It's
> fine until you need transactions, then you have to nest try/finally blocks
> for the session and transaction.  Session never did work out how I expected
> in iBATIS, and really it's just a higher level abstraction for a
> transaction.  So I'd like to see:  client.startTransaction(myConnection)
> implemented that basically does the same thing.  But until then, it's how
> Jeff said.
>
> cheers,
> Clinton
>
> On 12/18/06, Jeff Butler <jeffgbutler@gmail.com> wrote:
> >
> > SqlMapSession session = sqlMapClient.openSession(conn);
> > try {
> >   session.queryForList("getItemFormat","myname");
> > } finally {
> >   session.close ();
> > }
> >
> > Jeff Butler
> >
> >
> >
> > On 12/18/06, Ashish Kulkarni <ashish.kulkarni13@gmail.com > wrote:
> > >
> > > Hi
> > >
> > > How do i replace my existing code with
> > > sqlMapClient.openSession(myConnection);
> > >
> > > My excisting code is as below
> > >
> > > client.setUserConnection(conn);
> > >
> > > client.queryForList("getItemFormat","myname" );
> > >
> > > Regards
> > > Ashish
> > >
> > >
> > >
> > > On 12/18/06, Clinton Begin <clinton.begin@gmail.com > wrote:
> > > >
> > > > GACK.. setUserConnection() is another API we should deprecate.
> > > >
> > > > A cleaner way to do it is:
> > > >
> > > > SqlMapSession session = sqlMapClient.openSession(myConnection);
> > > > try {
> > > >   //....do work.....
> > > > } finally {
> > > >   session.close ();
> > > > }
> > > >
> > > > Cheers,
> > > > Clinton
> > > >
> > > > On 12/18/06, Jeff Butler < jeffgbutler@gmail.com > wrote:
> > > > >
> > > > > This is very similar to this issue:
> > > > >
> > > > > http://issues.apache.org/jira/browse/IBATIS-66
> > > > >
> > > > > Make sure you're calling client.setUserConnection(null) after
> > > > > processing each query.
> > > > >
> > > > > Jeff Butler
> > > > >
> > > > >
> > > > >
> > > > > On 12/18/06, Ashish Kulkarni <ashish.kulkarni13@gmail.com >
wrote:
> > > > > >
> > > > > > Hi
> > > > > > I have attached the sqlmap and xml file with all the sql
> > > > > > statements along this mail.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > On 12/18/06, Larry Meadors <lmeadors@apache.org > wrote:
> > > > > > >
> > > > > > > Can you post your configuration (database and sqlmap)?
> > > > > > >
> > > > > > > Larry
> > > > > > >
> > > > > > >
> > > > > > > On 12/18/06, Ashish Kulkarni < ashish.kulkarni13@gmail.com>
> > > > > > > wrote:
> > > > > > > > Hi
> > > > > > > >  We have a web application running in websphere, and
for a
> > > > > > > while we are
> > > > > > > > seeing some hung threads in websphere,
> > > > > > > >  do we did some java dump as insturcted by IBM and
we are
> > > > > > > seeing some of the
> > > > > > > > following messages in the dump.
> > > > > > > >
> > > > > > > >  In our java program before calling SQL statemenet
we do the
> > > > > > > following
> > > > > > > >  SqlMapClient client =// get connection client from
servlet
> > > > > > > context
> > > > > > > >  client.setUserConnection(conn);
> > > > > > > >  // do furthr processing of calling SQL statements.
> > > > > > > >
> > > > > > > >  I am not sure if this is the issue, but this is the
> > > > > > > messsage in the dump
> > > > > > > >
> > > > > > > >    com.ibatis.common.util.Throttle.increment seems
to be
> > > > > > > > currently executing on
> > > > > > > >               11 servlet threads.
> > > > > > > >           Since 100% (11 out of 11) of the threads
doing
> > > > > > > servlet work seem
> > > > > > > > to be
> > > > > > > >               executing this method, it would seem
that
> > > > > > > there
> > > > > > > >               is some possibility that this method
and its
> > > > > > > call path
> > > > > > > >               may warrant investigation.
> > > > > > > >           Servlets affected:
> > > > > > > >              com.pfizer.maps.servlet.MapsBaseServlet
[11
> > > > > > > > occurrances]
> > > > > > > >           Callers (servlet threads only):
> > > > > > > >              com.ibm.ws.util.ThreadPool$Worker.run
[5]
> > > > > > > >
> > > > > > > > com.pfizer.maps.data.planning.GetPlanningData.getTotalData
> > > > > > > > [2]
> > > > > > > >
> > > > > > > > com.pfizer.maps.data.planning.GetProductionData.getTotalData
> > > > > > > > [2]
> > > > > > > >
> > > > > > > >
> > > > > > > com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI
> > > > > > > > [1]
> > > > > > > >
> > > > > > > >
> > > > > > > com.ibm.ws.webcontainer.servlet.ServicingServletState.service
> > > > > > > > [1]
> > > > > > > >
> > > > > > > >  This is ibaits version
> > > > > > > >
> > > > > > > >  Implementation-Title: iBatis sql map
> > > > > > > >  Implementation-Version: 2.1.5 build# 582
> > > > > > > >
> > > > > > > >  Can anyone explain what this is, and how can we fix
this
> > > > > > > >
> > > > > > > >  Ashish
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>

Mime
View raw message