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
