Tomasz Serafin wrote:
including upgrade to current versions of Hibernate (3.6.4 -> 4.3.11), Spring, CXF, etc.
Current hibernate in wildfly 10 is 5.0.10.Final ....
For some reasons we user Hibernate 4.x. We have solved the problem of slow database operations by setting hibernate batch size property.
After that we still have another problem. Our database operations (now quite fast) are permormed inside a web service we make accessible to client applications. This web service is exposed by CXF library. After we get request from client to the web service, when job is done, for unknown reasons the answer doesn't get to the client. Our WildFly instance /web service is not accessible directly by the client, but throught Apache load balancer. After some time (sometimes seconds, sometimes minutes) apache detects timeout and our web service throws "Stream is closed" IO exception. When client application requests our web service directly rather then by Apache load balancer, it works fine.