Injection of entitymanager using @ Persistencecontext in spring ,for saving, extraction of data cursor is open in database even after returning from @Transactional method in-service class from where I am calling methods in dao layer like em.merge() calling em.close() after each database operations in a finally block open cursors are not released in database.Due to which I am facing maximum open cursors exceeded exception
That sounds like a Spring problem. You need to contact the Spring framework team to check it out.
Okay Thank you.Can please reply to query reading renamed persistence.xml in application.for example persistence-test.xml in mave project.