JPA EntityManager

[Angus Ferguson]

Hi all,

I am working with JPA, web services and PostgresSQL.

The thing is that when the service goes down and then restarts, I cant access the database because of a probem with the initialization of the  Entity Manager. It should restart together with the service.


Any idea, please?

[Angus Ferguson]

The database and the service are down. I start them:
At first I start the service. It gets an exception because the database is not available ( -> thats right behaviour)
Then I start the database.
When I want to access the database we get an exception – because the EntityManager thinks that the database was down when the service was initialized, so it must still be down, even if the database is available (-> thats wrong behaviour: I want to be able to use the database even if it was down when my service started).

Any idea, please?

[Tim Holloway]

I don't think that's a JPA issue. If you're running JPA on a webapp, you should be sourcing connections from a server Connection Pool and what I'd expect to be happening is that the pool couldn't supply live Connections while the DBMS was down, but it should be able to as soon as the DBMS comes back up.

You may need to adjust some pool configuration attributes to make that happen properly for you, though.