Spring boot hibernate schema validation

Question

I am trying to validate database schema before running any queries using jdbc template. So is there any way to identify schema changes before making any queries in spring programmatically?? Currently I am using spring boot 2 and hibernate 5.

stackoverflow.com/questions/2327423/…. I have tried this but this not working. — prakash pichaimuthu
– prakash pichaimuthu, Commented Nov 19, 2019 at 17:16
Did you try stackoverflow.com/a/8927578/3519504 from the above solution? That could be a programmatic way to do what you want, or you can use hibernate.hbm2ddl.auto=validate in the configuration file. — Sandeep Kumar
– Sandeep Kumar, Commented Nov 20, 2019 at 7:08
I Have tried that too. But Since I am using the latest version the annotation session factory has been deprecated. In Spring I am using jdbc template to make a query — prakash pichaimuthu
– prakash pichaimuthu, Commented Nov 20, 2019 at 13:21

Atul Jain · Accepted Answer · 2019-11-20 07:00:18Z

3

Add this to the configuration file.

hibernate.hbm2ddl.auto=validate

If the value is validated then hibernate only validates the table structure- whether the table and columns have existed or not. If the table doesn’t exist then hibernate throws an exception.

Validate is the default value for hbm2ddl.auto.

answered Nov 20, 2019 at 7:00

Atul Jain

1,0852 gold badges16 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

prakash pichaimuthu Over a year ago

This will only work if you start the application first time. I need a way to validate the schema before making query to database. Like a function will validate the schema using java.

Collectives™ on Stack Overflow

Spring boot hibernate schema validation

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related