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 <[email protected]> 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 <[email protected]> > 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 <[email protected]> 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 <[email protected]> > >> 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 <[email protected]> > 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 < > [email protected]> > >> >> wrote: > >> >> > unfortunately it is not writing anything catalina.out :-( > >> >> > > >> >> > Thanks > >> >> > Pradeep > >> >> > > >> >> > On Mon, May 16, 2016 at 3:47 PM, Christopher Schultz < > >> >> > [email protected]> 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: [email protected] > >> >> >> For additional commands, e-mail: [email protected] > >> >> >> > >> >> >> > >> >> > >> >> --------------------------------------------------------------------- > >> >> To unsubscribe, e-mail: [email protected] > >> >> For additional commands, e-mail: [email protected] > >> >> > >> >> > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [email protected] > >> For additional commands, e-mail: [email protected] > >> > >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
