I am connecting to the database via the entity manager
In my bean i have injected the entity manager
My table has huge amountof data say 1,00,000 records
I am retrieving data fine for some time and later i am getting null pointer exception because of my connection to the database is closed
How can i solve this problem ?
You can start by providing some forensics and some insight into what you currently have. Full stacktrace, code, current configuration, etc? Are you using seam managed persistence context? What does your current EntityManager configuration look like? EJB/POJO? EAR/WAR? 1M records (assuming that's what you meant), in itself, isn't particularly concerning.