ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: Issue with Ibatis in Websphere
Date Mon, 18 Dec 2006 16:49:36 GMT
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