Tomcat DS question
Hello Community, I have a weird issue, which I am not able to figure it out and needed some help. I am a Web Administrator and in my organization we use Tomcat + CXF to run our commerce services. We are running on Tomcat-6.0.32 and jdk1.6.0_24, anyways we have recently started to see issues with our connection pool and from our monitoring tools its evident that we are running out of connections. Now I have read some manuals on Apache Tomcat Page to use below three settings to fail gracefully and to Log those sessions which are either causing connection leak or abandoned removeAbandoned - set to true if we want to detect leaked connections removeAbandonedTimeout logAbandoned="true" But unfortunately even after having configured those above three settings, I still see some sessions just hanging in and not releasing the connection and I need help in understanding what I am doing wrong. My DS cnfiguration Thanks Pradeep
Re: Tomcat DS question
nectionHandler.process(Http11Protocol.java:588)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
oracle.jdbc.driver.BlockSource.ThreadedCachingBlockSource.BlockReleaser"
daemon prio=10 tid=0x7fbd3cb13000 nid=0x762b in Object.wait()
[0x7fbcdf5fd000]
java.lang.Thread.State: TIMED_WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at
oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser.run(BlockSource.java:327)
- locked <0x0007000535d0> (a
oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser)
On Mon, May 16, 2016 at 2:42 PM, Christopher Schultz <
ch...@christopherschultz.net> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA256
>
> Pradeep,
>
> On 5/16/16 12:34 PM, pradeep reddy wrote:
> > Hello Community, I have a weird issue, which I am not able to
> > figure it out and needed some help. I am a Web Administrator and in
> > my organization we use Tomcat + CXF to run our commerce services.
> >
> > We are running on Tomcat-6.0.32 and jdk1.6.0_24, anyways we have
> > recently started to see issues with our connection pool and from
> > our monitoring tools its evident that we are running out of
> > connections. Now I have read some manuals on Apache Tomcat Page to
> > use below three settings to fail gracefully and to Log those
> > sessions which are either causing connection leak or abandoned
> >
> > removeAbandoned - set to true if we want to detect leaked
> > connections removeAbandonedTimeout logAbandoned="true"
> >
> >
> > But unfortunately even after having configured those above three
> > settings, I still see some sessions just hanging in and not
> > releasing the connection and I need help in understanding what I am
> > doing wrong.
> >
> > My DS cnfiguration > auth="Container" type="javax.sql.DataSource"
> > driverClassName="oracle.jdbc.OracleDriver" url="XXX"
> > username="XX" password="XX" initialSize="1" maxActive="10"
> > minIdle="1" maxIdle="1" connectionCachingEnabled="true"
> > fastConnectionFailoverEnabled="true"
> > connectionCacheProperties="{MinLimit=1, MaxLimit=20,
> > InitialLimit=1, oracle.net.ns.SQLnetDef.TCP_CONNTIMEOUT_STR=3000}"
> > ONSConfiguration="nodes=X" validationQuery="SELECT 1 from
> > DUAL" removeAbandoned="true" removeAbandonedTimeout="30"
> > logAbandoned="true" maxWait="-1"/>
>
> What do the stack traces look like or the hung threads?
>
> - -chris
> -BEGIN PGP SIGNATURE-
> Comment: GPGTools - http://gpgtools.org
> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
>
> iQIcBAEBCAAGBQJXOjC7AAoJEBzwKT+lPKRYl5oQAL+tSB6ZkBpMOqihbN79UHdG
> LAKsRdenKPhphA2yjahoXIx9nWvSd03jsFy8uzJYe3ztyRkJGW4h7VAm37gAHkKl
> sg/jtQzvtl4HYO6YI1v5OgljxR5GnK8CvGad5PhOg/s6/mLRZ9kfUdGgv6tCYHXe
> lpoEOA8Em6tMaTwg1u07gXAqMEJyqg5QA3tYR3MU+0RALhNeVWgXNoEULol0FEil
> PJVcAVN1WC6AX0qVa3JlXIK+PHHLDDZWLH7qrpo2nGVvcf/5oFf27N5AnnnarH87
> RtOWHjWgK4APRVkEEOSX8Pef7YAb2dj6E+6fgf+3v117eEwYJlkLWU5pS/6Q3zWm
> 23obZllDks1clyYzs7C96zJukFb60wSRRGPdbHoSiKspH1J3/GavebaG7Sbg2ADB
> DNLcWG0fd4FUmy+kbG+pPi3hdEdwOQ0c6kgaqH7ARDjdYtfVKV8kgCe6wpJlKx+k
> WXfDK3cE2jWhUT/zx9VMutM+38gYk9G6ArUIZvOg5qdhcv6LvX299so3x8dEaL7w
> D/NNz4+yTJGVfQMnJ4LTnZR+R6wCUdhpS0quSYo9ZJNpXGERo3NY0aV80g4S8MQJ
> HObHoGDSUHDw4lScKCpIJYT7ZZ+Ok25fqyrlx+JN1fhsq7PcPtDQz/7FrRuhKEGa
> z8kfsKuyduF8cW1gDj5h
> =s/bM
> -END PGP SIGNATURE-
>
> -
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
>
Re: Tomcat DS question
unfortunately it is not writing anything catalina.out :-(
Thanks
Pradeep
On Mon, May 16, 2016 at 3:47 PM, Christopher Schultz <
ch...@christopherschultz.net> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA256
>
> Pradeep,
>
> On 5/16/16 5:13 PM, pradeep reddy wrote:
> > Hello Christopher,
> >
> > Let me post my thread dump here.
> >
> > All HTTP threads are in WAITING state.
> >
> > "http-12453-346" daemon prio=10 tid=0x7fbd3061f800 nid=0x59d0
> > in Object.wait() [0x7fbbe124f000] java.lang.Thread.State:
> > WAITING (on object monitor) at java.lang.Object.wait(Native
> > Method) at java.lang.Object.wait(Object.java:485) at
> > org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(Generi
> cObjectPool.java:1104)
> >
> >
> - - locked <0x00072b18f320> (a
> > org.apache.tomcat.dbcp.pool.impl.GenericObjectPool$Latch) at
> > org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDat
> aSource.java:106)
> >
> >
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSourc
> e.java:1044)
> > at
> > org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.g
> etConnection(LocalDataSourceConnectionProvider.java:82)
>
> Yep,
> >
> that certainly looks like you are waiting for connections from
> Tomcat's DBCP-based pool.
>
> > > type="javax.sql.DataSource"
> > driverClassName="oracle.jdbc.OracleDriver" url="XXX"
> > username="XX" password="XX" initialSize="1" maxActive="10"
> > minIdle="1" maxIdle="1" connectionCachingEnabled="true"
> > fastConnectionFailoverEnabled="true"
> > connectionCacheProperties="{MinLimit=1, MaxLimit=20,
> > InitialLimit=1, oracle.net.ns.SQLnetDef.TCP_CONNTIMEOUT_STR=3000}"
> > ONSConfiguration="nodes=X" validationQuery="SELECT 1 from
> > DUAL" removeAbandoned="true" removeAbandonedTimeout="30"
> > logAbandoned="true" maxWait="-1"/>
>
> That configuration looks okay to me.
>
> The "abandoned" logs are logged to stdout, so they should show up in
> your catalina.out file (or stdout.log if you are using a Windows Service
> ).
>
> Are you getting no messages about the abandoned connections?
>
> - -chris
> -BEGIN PGP SIGNATURE-
> Comment: GPGTools - http://gpgtools.org
> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
>
> iQIcBAEBCAAGBQJXOj/gAAoJEBzwKT+lPKRYFVQP/RJKOl0QoU8/qcgMBtdrqwbr
> gddAEbqeDVT4nb8Bp/MWpWEoICBr75IGMgSir+qKASwTKXNsORceyxcSn+YxRJnK
> POZgIZfwti4vLYMBr9jU1kdUsxCGriettcBZ8pkwJAAtyVX9O0lZiwEZuCp7WwA5
> sbatkYHNtJQsjxQli1XA6NPNjQBS6y+WuQZQ0e/mf3CJUq9Rqa0uvsgAOK9XQTDB
> HBNfhF1sjIFy2ro5Vb6OagRHB+9CBxc01gM8V2d37hrbqmUVpiE4pKqO2sWZ6cz5
> yCwSBEcxyNKvDoeP2kz/1HGIhSwB7ifV1zkbhgZaB5eQZVZZubXVcdwgmRMswUgl
> RtzqCPF6rOHkgccoe5IqZLb89pQITibz6G3xTAoHhcvh2m7bADAkoN9Jq88DxUqT
> CqXEc/01A0AdC5zzqdGPToReLPEcaifLuAK0seGQsHIHAtOytYEY2E9rmoPtCrGp
> J4AshEzNtmVT+WUc40FS1+KeabolYBk0biXZiZG/mkVEmKf1DpzPtsBGFfYvo3/i
> 0IAOS4zBvluQT1xaqNO6bFJ4fyfIwyWE26FBEPWRpsju2CEg/9+uXw6YM3xYxdkc
> TmTTXqp4wvfE82fb2NMGQT3Av/q2fD4Yvzt7DiyHmWL0i0BlsnWBRdJD0dogKFRK
> oVun2+a1tFD7lvJnVoiu
> =AHDK
> -END PGP SIGNATURE-
>
> -
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
>
Re: Tomcat DS question
Hello Woonsan,
Via Jconsole I had validated all my changes that were made in
context.xml. But for some reason the logs doesn't show anything about
abandoned connections in catalina.out. I am not sure at this time if its a
bug in tomcat 6 or tomcat-dbcp.jar, but threaddumps clearly show that
threads are waiting on connections from connection pool.
Thanks
Pradeep
On Mon, May 16, 2016 at 4:38 PM, Woonsan Ko wrote:
> Hi Pradeep,
>
> Just in case, you might want to make sure your changes were really
> applied. For example, an effective context.xml could be in
> conf/Catalina/localhost/...
> If it was applied properly, the stack trace should have shown
> o.a.c.dbcp.AbandonedObjectPool#borrowObject() as well.
>
> Regards,
>
> Woonsan
>
>
> On Mon, May 16, 2016 at 5:54 PM, pradeep reddy
> wrote:
> > unfortunately it is not writing anything catalina.out :-(
> >
> > Thanks
> > Pradeep
> >
> > On Mon, May 16, 2016 at 3:47 PM, Christopher Schultz <
> > ch...@christopherschultz.net> wrote:
> >
> >> -----BEGIN PGP SIGNED MESSAGE-
> >> Hash: SHA256
> >>
> >> Pradeep,
> >>
> >> On 5/16/16 5:13 PM, pradeep reddy wrote:
> >> > Hello Christopher,
> >> >
> >> > Let me post my thread dump here.
> >> >
> >> > All HTTP threads are in WAITING state.
> >> >
> >> > "http-12453-346" daemon prio=10 tid=0x7fbd3061f800 nid=0x59d0
> >> > in Object.wait() [0x7fbbe124f000] java.lang.Thread.State:
> >> > WAITING (on object monitor) at java.lang.Object.wait(Native
> >> > Method) at java.lang.Object.wait(Object.java:485) at
> >> > org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(Generi
> >> cObjectPool.java:1104)
> >> >
> >> >
> >> - - locked <0x00072b18f320> (a
> >> > org.apache.tomcat.dbcp.pool.impl.GenericObjectPool$Latch) at
> >> > org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDat
> >> aSource.java:106)
> >> >
> >> >
> >> at
> >> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSourc
> >> e.java:1044)
> >> > at
> >> > org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.g
> >> etConnection(LocalDataSourceConnectionProvider.java:82)
> >>
> >> Yep,
> >> >
> >> that certainly looks like you are waiting for connections from
> >> Tomcat's DBCP-based pool.
> >>
> >> > >> > type="javax.sql.DataSource"
> >> > driverClassName="oracle.jdbc.OracleDriver" url="XXX"
> >> > username="XX" password="XX" initialSize="1" maxActive="10"
> >> > minIdle="1" maxIdle="1" connectionCachingEnabled="true"
> >> > fastConnectionFailoverEnabled="true"
> >> > connectionCacheProperties="{MinLimit=1, MaxLimit=20,
> >> > InitialLimit=1, oracle.net.ns.SQLnetDef.TCP_CONNTIMEOUT_STR=3000}"
> >> > ONSConfiguration="nodes=X" validationQuery="SELECT 1 from
> >> > DUAL" removeAbandoned="true" removeAbandonedTimeout="30"
> >> > logAbandoned="true" maxWait="-1"/>
> >>
> >> That configuration looks okay to me.
> >>
> >> The "abandoned" logs are logged to stdout, so they should show up in
> >> your catalina.out file (or stdout.log if you are using a Windows Service
> >> ).
> >>
> >> Are you getting no messages about the abandoned connections?
> >>
> >> - -chris
> >> -BEGIN PGP SIGNATURE-
> >> Comment: GPGTools - http://gpgtools.org
> >> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
> >>
> >> iQIcBAEBCAAGBQJXOj/gAAoJEBzwKT+lPKRYFVQP/RJKOl0QoU8/qcgMBtdrqwbr
> >> gddAEbqeDVT4nb8Bp/MWpWEoICBr75IGMgSir+qKASwTKXNsORceyxcSn+YxRJnK
> >> POZgIZfwti4vLYMBr9jU1kdUsxCGriettcBZ8pkwJAAtyVX9O0lZiwEZuCp7WwA5
> >> sbatkYHNtJQsjxQli1XA6NPNjQBS6y+WuQZQ0e/mf3CJUq9Rqa0uvsgAOK9XQTDB
> >> HBNfhF1sjIFy2ro5Vb6OagRHB+9CBxc01gM8V2d37hrbqmUVpiE4pKqO2sWZ6cz5
> >> yCwSBEcxyNKvDoeP2kz/1HGIhSwB7ifV1zkbhgZaB5eQZVZZubXVcdwgmRMswUgl
> >> RtzqCPF6rOHkgccoe5IqZLb89pQITibz6G3xTAoHhcvh2m7bADAkoN9Jq88DxUqT
> >> CqXEc/01A0AdC5zzqdGPToReLPEcaifLuAK0seGQsHIHAtOytYEY2E9rmoPtCrGp
> >> J4AshEzNtmVT+WUc40FS1+KeabolYBk0biXZiZG/mkVEmKf1DpzPtsBGFfYvo3/i
> >> 0IAOS4zBvluQT1xaqNO6bFJ4fyfIwyWE26FBEPWRpsju2CEg/9+uXw6YM3xYxdkc
> >> TmTTXqp4wvfE82fb2NMGQT3Av/q2fD4Yvzt7DiyHmWL0i0BlsnWBRdJD0dogKFRK
> >> oVun2+a1tFD7lvJnVoiu
> >> =AHDK
> >> -END PGP SIGNATURE-
> >>
> >> -
> >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> >> For additional commands, e-mail: users-h...@tomcat.apache.org
> >>
> >>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
>
Re: Tomcat DS question
Thanks for response, would you know if there is any recommended dbcp jar
that we need to use for Oracle 12 and Tomcat 6 ?
Thanks
Pradeep
On Tue, May 17, 2016 at 11:07 AM, Woonsan Ko wrote:
> Hi Pradeep,
>
> I saw you had Oracle specific settings such as
> connectionCachingEnabled. So, maybe you're using Oracle specific
> DataSourceFactory instead of the default dbcp one.
> As far as I know, the default factory
> (org.apache...BasicDataSourceFactory) can be overridden by either
> factory attribute in the element or
> javax.sql.DataSource.Factory system property.
> In that case, it might be an issue around the custom factory
> implementation, not tomcat.
>
> Regards,
>
> Woonsan
>
>
> On Mon, May 16, 2016 at 6:54 PM, pradeep reddy
> wrote:
> > Hello Woonsan,
> >Via Jconsole I had validated all my changes that were made in
> > context.xml. But for some reason the logs doesn't show anything about
> > abandoned connections in catalina.out. I am not sure at this time if its
> a
> > bug in tomcat 6 or tomcat-dbcp.jar, but threaddumps clearly show that
> > threads are waiting on connections from connection pool.
> >
> > Thanks
> > Pradeep
> >
> > On Mon, May 16, 2016 at 4:38 PM, Woonsan Ko wrote:
> >
> >> Hi Pradeep,
> >>
> >> Just in case, you might want to make sure your changes were really
> >> applied. For example, an effective context.xml could be in
> >> conf/Catalina/localhost/...
> >> If it was applied properly, the stack trace should have shown
> >> o.a.c.dbcp.AbandonedObjectPool#borrowObject() as well.
> >>
> >> Regards,
> >>
> >> Woonsan
> >>
> >>
> >> On Mon, May 16, 2016 at 5:54 PM, pradeep reddy
> >> wrote:
> >> > unfortunately it is not writing anything catalina.out :-(
> >> >
> >> > Thanks
> >> > Pradeep
> >> >
> >> > On Mon, May 16, 2016 at 3:47 PM, Christopher Schultz <
> >> > ch...@christopherschultz.net> wrote:
> >> >
> >> >> -BEGIN PGP SIGNED MESSAGE-
> >> >> Hash: SHA256
> >> >>
> >> >> Pradeep,
> >> >>
> >> >> On 5/16/16 5:13 PM, pradeep reddy wrote:
> >> >> > Hello Christopher,
> >> >> >
> >> >> > Let me post my thread dump here.
> >> >> >
> >> >> > All HTTP threads are in WAITING state.
> >> >> >
> >> >> > "http-12453-346" daemon prio=10 tid=0x7fbd3061f800 nid=0x59d0
> >> >> > in Object.wait() [0x7fbbe124f000] java.lang.Thread.State:
> >> >> > WAITING (on object monitor) at java.lang.Object.wait(Native
> >> >> > Method) at java.lang.Object.wait(Object.java:485) at
> >> >> >
> org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(Generi
> >> >> cObjectPool.java:1104)
> >> >> >
> >> >> >
> >> >> - - locked <0x00072b18f320> (a
> >> >> > org.apache.tomcat.dbcp.pool.impl.GenericObjectPool$Latch) at
> >> >> >
> org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDat
> >> >> aSource.java:106)
> >> >> >
> >> >> >
> >> >> at
> >> >>
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSourc
> >> >> e.java:1044)
> >> >> > at
> >> >> >
> org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.g
> >> >> etConnection(LocalDataSourceConnectionProvider.java:82)
> >> >>
> >> >> Yep,
> >> >> >
> >> >> that certainly looks like you are waiting for connections from
> >> >> Tomcat's DBCP-based pool.
> >> >>
> >> >> > >> >> > type="javax.sql.DataSource"
> >> >> > driverClassName="oracle.jdbc.OracleDriver" url="XXX"
> >> >> > username="XX" password="XX" initialSize="1" maxActive="10"
> >> >> > minIdle="1" maxIdle="1" connectionCachingEnabled="true"
> >> >> > fastConnectionFailoverEnabled="true"
> >> >> > connectionCacheProperties="{MinLimit=1, MaxLimit=20,
> >> >> > InitialLimit=1, oracle.net.ns.SQLnetDef.TCP_CONNTIMEOUT_STR=3000}&q
Re: Tomcat DS question
Hi Chris, It is not writing anything related to DBCP in catalina.out. Thanks Pradeep On Tue, May 17, 2016 at 1:49 PM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Pradeep, > > On 5/17/16 2:51 PM, pradeep reddy wrote: > > Thanks for response, would you know if there is any recommended > > dbcp jar that we need to use for Oracle 12 and Tomcat 6 ? > > You don't need anything special. Woonson did not read your original > configuration evidently, or the stack trace. Both of those show that > DBCP is in fact in use and no special factory is being used. > > When you say that "it is not writing anything catalina.out", do you > mean that catalina.out does not exist, is empty, or has log messages > in it but nothing about DBCP itself? > > - -chris > -BEGIN PGP SIGNATURE- > Comment: GPGTools - http://gpgtools.org > Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ > > iQIcBAEBCAAGBQJXO3XlAAoJEBzwKT+lPKRYoiIP/R5hPraVx3xDft+E4zLSPdon > SM+9nQcqdTRGfLvjbOHdsH1Yt+4cRIhTegxHdfSalsHvBV8iuh5xPdcn4epwKZl4 > Twu+s8LTaNK5PD3bhV3qJtlNpg+IyBAQoqk9weZcHsgaa/0tfZEeH3tIrJbBoZ+L > v///WExXCnviksBGxwk2w5iimYMcsyTVdADh/Pi8SgdinKtakxly+d0rfu0aUR2S > KFfBMaKr4bqf22PxVM5IhNxURzrGep73b18mT0kZ96yTjWpan7lOBzyx6w+2u5GK > +GIuwHGqqtoWDPxLEo9hG0JgNOCiLszNcdMGeyd3l3CXlPxp4vvMcj4LvUx7lqrs > oJ/UoPNFgPW2SfJNSagluvlIcqMzkFADLu7pfF15QoHJQsR2gNcoFn6xLq4E08WM > 0Igcyxn9+42Gkl5troeGnt0DOgMF4SzFATXg70263GwXELqLBHB6DYPBrugLmdCx > XBhPGh9PAy/mT3wJ1qEVlAQCAl7vY5jI0E6ZBl1ljLcQM9x1YQZ3sJhPlOgcqMCB > bERByGDx3DMls5/eWFwohPbVV2kG6xpDfvhW2ZLF1IP/+DHNyD/phyZZr9sPS164 > d7/eYEWL63qWCt1MR3AlXO37UDIRQ15kdcPuK9QCvR+nC/ULPqAGB50KeDe7YyLH > fBuVMTq84RA9M1pCYCRy > =W5lv > -END PGP SIGNATURE- > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
Re: Tomcat DS question
Also, how to determine if the application is using ojdbc6.jar or tomcat-dbcp.jar for connection pool. Apologies I am not a developer and want to understand the concept of connection pool. Thanks Pradeep On Tue, May 17, 2016 at 2:32 PM, Woonsan Ko wrote: > I don't know much about that for Oracle. What I was trying to mention > was simply that you can check if you have a system property > (-Djavax.sql.DataSource.Factory=...) to use a custom one. (Even though > it's not that common, but it's still possible to override it by system > property.) Your configuration doesn't have the factory attribute, so > if you don't have the specific system property, then you can rule out > my suspicion and focus on some other possibilities. > > Regards, > > Woonsan > > > On Tue, May 17, 2016 at 2:51 PM, pradeep reddy > wrote: > > Thanks for response, would you know if there is any recommended dbcp jar > > that we need to use for Oracle 12 and Tomcat 6 ? > > > > Thanks > > Pradeep > > > > On Tue, May 17, 2016 at 11:07 AM, Woonsan Ko wrote: > > > >> Hi Pradeep, > >> > >> I saw you had Oracle specific settings such as > >> connectionCachingEnabled. So, maybe you're using Oracle specific > >> DataSourceFactory instead of the default dbcp one. > >> As far as I know, the default factory > >> (org.apache...BasicDataSourceFactory) can be overridden by either > >> factory attribute in the element or > >> javax.sql.DataSource.Factory system property. > >> In that case, it might be an issue around the custom factory > >> implementation, not tomcat. > >> > >> Regards, > >> > >> Woonsan > >> > >> > >> On Mon, May 16, 2016 at 6:54 PM, pradeep reddy > >> wrote: > >> > Hello Woonsan, > >> >Via Jconsole I had validated all my changes that were made in > >> > context.xml. But for some reason the logs doesn't show anything about > >> > abandoned connections in catalina.out. I am not sure at this time if > its > >> a > >> > bug in tomcat 6 or tomcat-dbcp.jar, but threaddumps clearly show that > >> > threads are waiting on connections from connection pool. > >> > > >> > Thanks > >> > Pradeep > >> > > >> > On Mon, May 16, 2016 at 4:38 PM, Woonsan Ko > wrote: > >> > > >> >> Hi Pradeep, > >> >> > >> >> Just in case, you might want to make sure your changes were really > >> >> applied. For example, an effective context.xml could be in > >> >> conf/Catalina/localhost/... > >> >> If it was applied properly, the stack trace should have shown > >> >> o.a.c.dbcp.AbandonedObjectPool#borrowObject() as well. > >> >> > >> >> Regards, > >> >> > >> >> Woonsan > >> >> > >> >> > >> >> On Mon, May 16, 2016 at 5:54 PM, pradeep reddy < > pradeep@gmail.com> > >> >> wrote: > >> >> > unfortunately it is not writing anything catalina.out :-( > >> >> > > >> >> > Thanks > >> >> > Pradeep > >> >> > > >> >> > On Mon, May 16, 2016 at 3:47 PM, Christopher Schultz < > >> >> > ch...@christopherschultz.net> wrote: > >> >> > > >> >> >> -BEGIN PGP SIGNED MESSAGE- > >> >> >> Hash: SHA256 > >> >> >> > >> >> >> Pradeep, > >> >> >> > >> >> >> On 5/16/16 5:13 PM, pradeep reddy wrote: > >> >> >> > Hello Christopher, > >> >> >> > > >> >> >> > Let me post my thread dump here. > >> >> >> > > >> >> >> > All HTTP threads are in WAITING state. > >> >> >> > > >> >> >> > "http-12453-346" daemon prio=10 tid=0x7fbd3061f800 > nid=0x59d0 > >> >> >> > in Object.wait() [0x7fbbe124f000] java.lang.Thread.State: > >> >> >> > WAITING (on object monitor) at java.lang.Object.wait(Native > >> >> >> > Method) at java.lang.Object.wait(Object.java:485) at > >> >> >> > > >> org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(Generi > >> >> >> cObjectPool.java:1104) > >> >> >> > > &g
