You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Ashish Kulkarni <as...@gmail.com> on 2006/12/18 17:03:39 UTC
Issue with Ibatis in Websphere
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
Re: Issue with Ibatis in Websphere
Posted by Ashish Kulkarni <as...@gmail.com>.
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 <cl...@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 <je...@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
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
Re: Issue with Ibatis in Websphere
Posted by Clinton Begin <cl...@gmail.com>.
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 <je...@gmail.com> wrote:
>
> SqlMapSession session = sqlMapClient.openSession(conn);
> try {
> session.queryForList("getItemFormat","myname");
> } finally {
> session.close ();
> }
>
> Jeff Butler
>
>
>
> On 12/18/06, Ashish Kulkarni <as...@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
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> >
>
Re: Issue with Ibatis in Websphere
Posted by Jeff Butler <je...@gmail.com>.
SqlMapSession session = sqlMapClient.openSession(conn);
try {
session.queryForList("getItemFormat","myname");
} finally {
session.close ();
}
Jeff Butler
On 12/18/06, Ashish Kulkarni <as...@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 <cl...@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
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> >
>
Re: Issue with Ibatis in Websphere
Posted by Ashish Kulkarni <as...@gmail.com>.
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 <cl...@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 <je...@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
> > > > >
> > > > >
> > > >
> > >
> > >
> > >
> >
>
Re: Issue with Ibatis in Websphere
Posted by Clinton Begin <cl...@gmail.com>.
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 <je...@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 <as...@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
> > > >
> > > >
> > >
> >
> >
> >
>
Re: Issue with Ibatis in Websphere
Posted by Jeff Butler <je...@gmail.com>.
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 <as...@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 <lm...@apache.org> wrote:
> >
> > Can you post your configuration (database and sqlmap)?
> >
> > Larry
> >
> >
> > On 12/18/06, Ashish Kulkarni <as...@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
> > >
> > >
> >
>
>
>
Re: Issue with Ibatis in Websphere
Posted by Ashish Kulkarni <as...@gmail.com>.
Hi
I have attached the sqlmap and xml file with all the sql statements along
this mail.
On 12/18/06, Larry Meadors <lm...@apache.org> wrote:
>
> Can you post your configuration (database and sqlmap)?
>
> Larry
>
>
> On 12/18/06, Ashish Kulkarni <as...@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
> >
> >
>
Re: Issue with Ibatis in Websphere
Posted by Larry Meadors <lm...@apache.org>.
Can you post your configuration (database and sqlmap)?
Larry
On 12/18/06, Ashish Kulkarni <as...@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
>
>