Win a copy of Practical SVG this week in the HTML/CSS/JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Application hangs with prior J2CA0086W warning messages

 
Anand Gondhiya
Ranch Hand
Posts: 155
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
my application hangs while executing a Stored proc or select/insert/update SQL statements. I am using WebSphere App server 5.1 and WSAD

Case 1 ata Source/Connection pool
I had set up sharable Data source.and It always worked fine.I am making sure that I am closing connections after using them. Suddenly , application started hanging. I increased max connections from 10 to 100 but no diffrence.Application hangs with prior J2CA0086W warning messages.
for more info: http://www-1.ibm.com/support/docview.wss?uid=swg21121449
There is no diffrence in behaviour if I restart WebSphere App server or restart WSAD. However ,after rebooting application works fine for first time. and then onwards , It hangs.

Case 2: DriverManager
Before I set up connection pool/Data Source ,Application worked fine with Driver manager. But after switching back from DataSource/Conn Pool , my application hangs even if I use DriverManager.

Can anyone advise ?
Thanks
-Anand
 
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper
Posts: 4968
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are there any firewalls between the app server and the database?

Can you post your datasource settings? Are there anything peculiar there?


-Cameron McKenzie
 
You have to be odd to be #1 - Seuss. An odd little ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!