Win a copy of Mesos in Action this week in the Cloud/Virtualizaton 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic