Menu
How to check database is connected or not in JPA , when the database connection is on or off after deployed application ie(While running the application)
282
asked Jul 03 '12 10:07
If we want to use JPA with MySQL database, we need the mysql-connector-java dependency. We'll also need to define the DataSource configuration. We can do this in a @Configuration class or by using standard Spring Boot properties. Spring Boot will automatically configure a data source based on these properties.
The easiest way to test the database connection from Spring boot is to start the application and by checking to debug logs.
Entity: The entities are the persistence objects stores as a record in the database. Persistence Unit: It defines a set of all entity classes. In an application, EntityManager instances manage it. The set of entity classes represents the data contained within a single data store.
The easiest way is to execute a query, such as
em.createNativeQuery("select 1 from dual").getSingleResult();
Normally the DataSource/connection pool or JPA provider will provide some sort of connection testing or dead connection resolution.
If you are using EclipseLink's connection pooling it will automatically detect dead connections and retry queries.
103
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
