Re: Tomcat DS question

2016-05-18 Thread Woonsan Ko
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

Re: Tomcat DS question

2016-05-17 Thread pradeep reddy
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

Re: Tomcat DS question

2016-05-17 Thread Woonsan Ko
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 configurati

Re: Tomcat DS question

2016-05-17 Thread pradeep reddy
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: > > T

Re: Tomcat DS question

2016-05-17 Thread Christopher Schultz
-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 conf

Re: Tomcat DS question

2016-05-17 Thread pradeep reddy
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: Tomcat DS question

2016-05-17 Thread Woonsan Ko
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 i

Re: Tomcat DS question

2016-05-16 Thread pradeep reddy
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 thre

Re: Tomcat DS question

2016-05-16 Thread Woonsan Ko
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, Woon

Re: Tomcat DS question

2016-05-16 Thread pradeep reddy
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

Re: Tomcat DS question

2016-05-16 Thread Christopher Schultz
-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() [0x00

Re: Tomcat DS question

2016-05-16 Thread pradeep reddy
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 Meth

Re: Tomcat DS question

2016-05-16 Thread Christopher Schultz
-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 servic