Could you give an answer on my question first? Maybe you can create a jsp page
printing out the sys prop like this.
<%
out.println("javax.sql.DataSource.Factory: " +
System.getProperty("javax.sql.DataSource.Factory"));
%>
Let me know what you get there.
Regards,
Woonsan
> On May 17, 2016, at 10:40 PM, pradeep reddy <[email protected]> wrote:
>
> 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]
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
