|EclipseLink get stuck [message #1733597]
||Mon, 30 May 2016 11:15
| Nn Ii
Registered: May 2016
creating this post is my last hope to solve my problem. Where to start....
I developed an desktop application (Fat Client) based on Java using newest EclipseLink framework. That client is connecting with an Microsoft SQL Database. Now the problem: sometimes the application freezes with no particular reason and without any Exception. The debug shows, that it freezes at getting some property of an entity like "student.getName()". The Getter is really simple and just has to return the value. But EclipseLink is unable to get that value from the database. When this problem occurs all other clients have the same problem. Only restarting the MS-SQL Database Service on the server helps. After that the application works again like a charm, without restarting it.
What I do not understand: When the database get stuck it is still possible to make "SQL SELECTS" on the database itself. But EclipseLink is not able to get the data. Also there is a Test-Database on the same server running on the same service. EclipseLink can still access that test-database.
On my machine at home I never experienced that kind of problem. Only the customer has this problem. I guess it has something to do with the amount of users using this database.
Actually I am familiar with the best-practises with using JPA. Keeping transactions as short as possible. Creating a new EntityManager for a new context to keep it small and to let the GC do its work. But I do not understand why EclipseLink hangs the database.
You have any hints? Why I get no Exception or Error. Why restarting the database helps? Are there any kinds of locks?
Thank you for any help
Powered by FUDForum
. Page generated in 0.01406 seconds