|
I posted earlier regarding problems with the
connection pooling in JBOss. I believe I
have it narrowed down to the PreparedStatement caching. I have set my PSCacheSize to 0 in hopes it
avoids the problem, but doesn't feel like the right solution. It looks as if after a while, the
preparedstatements are no longer valid, and a client using one gets the
error. The cache tosses the statement,
but takes at least PSCacheSize number of tries before everything works
again. Any thoughts on
this? Thanks! James Birchfield Development Manager (502) 583-2298 (o) (502) 639-3136 (c) |
