t*********i
发帖数: 217 | 1 请问有没有班上的同学熟悉JBOSS+Oracle 的环境? 我们的这里connections in the
connection pool总是出现 "IO exception, broken pipe", 或者time out 的错。我找
到网上有人说加一个valication query, 但是说已经加了。他们现在认定是database的
问题。哪位帮帮我吧，快要被逼疯了。 | s****y
发帖数: 581 | 2 Oracle's Listener Works fine? | s****y
发帖数: 581 | 3 If you can connect to database and query successfully remotely instead of
locally. you will be fine. It must be JBOSSS configuration issue.
【在 s****y 的大作中提到】
: Oracle's Listener Works fine?
| t*********i
发帖数: 217 | 4 Yes, everything on db server side works fine. I also believe it is
configuration in middleware. I hope I can help them to figure out the reason
, so I can be dismissed from the endless monitoring... testing...explaining... | v*****r
发帖数: 1119 | 5 by default, oracle never timeout connections, but dba might change the
default setting.
from jboss to db, anywhere along the communication path could caused this,
you will want to go through the whole environment including jboss config,
network firewall setting, db etc.
reason
explaining...
【在 t*********i 的大作中提到】
: Yes, everything on db server side works fine. I also believe it is
: configuration in middleware. I hope I can help them to figure out the reason
: , so I can be dismissed from the endless monitoring... testing...explaining...
| t*********i
发帖数: 217 | 6 you are right, but that is beyond my ability/responsibility. I was wondering
if there is a quick trick.
anyway, Thank you both for reply/suggest.
【在 v*****r 的大作中提到】
: by default, oracle never timeout connections, but dba might change the
: default setting.
: from jboss to db, anywhere along the communication path could caused this,
: you will want to go through the whole environment including jboss config,
: network firewall setting, db etc.
:
: reason
: explaining...
| g*******g
发帖数: 108 | 7
google/bing oracle "dead connection detection" , it keeps your idle
connection alive.(being swiped by firewall)
【在 t*********i 的大作中提到】
: 请问有没有班上的同学熟悉JBOSS+Oracle 的环境? 我们的这里connections in the
: connection pool总是出现 "IO exception, broken pipe", 或者time out 的错。我找
: 到网上有人说加一个valication query, 但是说已经加了。他们现在认定是database的
: 问题。哪位帮帮我吧，快要被逼疯了。
| t*********i
发帖数: 217 | 8 sounds like a good idea. I used DCD before to kill dead connections. the
side effect can be really used to keep connections alive.
Will give it a try, will update when I have result. Thank you!
【在 g*******g 的大作中提到】
:
: google/bing oracle "dead connection detection" , it keeps your idle
: connection alive.(being swiped by firewall)
| t*********i
发帖数: 217 | 9 那帮家伙闷住不吭气了。老板帮我问都不回话。看来是告一段落，谢谢大家帮忙。我数
数我有多少包子，请版主帮忙发一下. |
|
