Rating update not executing a commit

[bnutsch]

This statement is holding up other sessions of this application because it is not executing a commit until much later:

UPDATE Metadata SET popularity = popularity +1 WHERE id = :1 AND isHarvested='n'”

We are using Oracle 10g, load testing with Loadrunner, and can only run 30 users for ~25 min until we start getting hung threads. The fix is to add a commit after setting the metadata popularity update.

[simonp]

Fixed by the addition of the IncreasePopularityTask in src/org/fao/geonet/services/metadata/Show.java?

Maybe the increasePopularity calls in Download.java and DownloadArchive.java (see src/org/fao/geonet/services/resources) need attention too?

[simonp]

Finally fixed by adding a new method so that any thread request a database connection that they can close when complete. Otherwise database connections in use by the thread would be closed by jeeves when the service completed.