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 <woon...@apache.org> 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 <pradeep....@gmail.com>
> 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 <woon...@apache.org> 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 <Resource/> 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 <pradeep....@gmail.com>
> >> 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 <woon...@apache.org>
> 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=0x00007fbd3061f800
> nid=0x59d0
> >> >> >> > in Object.wait() [0x00007fbbe124f000] 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 <0x000000072b18f320> (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.
> >> >> >>
> >> >> >> > <Resource name="jdbc/XXXXXDataSource" auth="Container"
> >> >> >> > type="javax.sql.DataSource"
> >> >> >> > driverClassName="oracle.jdbc.OracleDriver" url="XXXXXXXXXXX"
> >> >> >> > username="XXXXXX" password="XXXXXX" 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=XXXXX" 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
> >> >>
> >> >>
> >>
> >> ---------------------------------------------------------------------
> >> 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
>
>
