About spring.jpa.hibernate.ddl-auto

5 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€94.79
List Price:  €132.71
You save:  €37.92
£78.97
List Price:  £110.56
You save:  £31.59
CA$139.89
List Price:  CA$195.85
You save:  CA$55.96
A$153.73
List Price:  A$215.23
You save:  A$61.50
S$134.32
List Price:  S$188.05
You save:  S$53.73
HK$778.26
List Price:  HK$1,089.59
You save:  HK$311.33
CHF 88.57
List Price:  CHF 124
You save:  CHF 35.43
NOK kr1,105.08
List Price:  NOK kr1,547.16
You save:  NOK kr442.07
DKK kr706.99
List Price:  DKK kr989.82
You save:  DKK kr282.82
NZ$170.06
List Price:  NZ$238.10
You save:  NZ$68.03
د.إ367.26
List Price:  د.إ514.17
You save:  د.إ146.91
৳11,906.24
List Price:  ৳16,669.22
You save:  ৳4,762.97
₹8,436.24
List Price:  ₹11,811.08
You save:  ₹3,374.83
RM447.10
List Price:  RM625.96
You save:  RM178.86
₦167,464.25
List Price:  ₦234,456.65
You save:  ₦66,992.40
₨27,687.73
List Price:  ₨38,763.93
You save:  ₨11,076.20
฿3,470.35
List Price:  ฿4,858.63
You save:  ฿1,388.28
₺3,445.98
List Price:  ₺4,824.51
You save:  ₺1,378.53
B$578.68
List Price:  B$810.17
You save:  B$231.49
R1,810.53
List Price:  R2,534.81
You save:  R724.28
Лв185.34
List Price:  Лв259.49
You save:  Лв74.14
₩139,691.42
List Price:  ₩195,573.58
You save:  ₩55,882.15
₪373.67
List Price:  ₪523.15
You save:  ₪149.48
₱5,901.36
List Price:  ₱8,262.14
You save:  ₱2,360.78
¥15,574.86
List Price:  ¥21,805.43
You save:  ¥6,230.57
MX$2,020.46
List Price:  MX$2,828.72
You save:  MX$808.26
QR363.35
List Price:  QR508.71
You save:  QR145.35
P1,355.53
List Price:  P1,897.79
You save:  P542.26
KSh12,948.70
List Price:  KSh18,128.70
You save:  KSh5,180
E£4,969.50
List Price:  E£6,957.50
You save:  E£1,988
ብር12,262.61
List Price:  ብር17,168.15
You save:  ብር4,905.53
Kz91,256.94
List Price:  Kz127,763.36
You save:  Kz36,506.42
CLP$97,119.28
List Price:  CLP$135,970.88
You save:  CLP$38,851.60
CN¥724.58
List Price:  CN¥1,014.45
You save:  CN¥289.86
RD$6,000.34
List Price:  RD$8,400.72
You save:  RD$2,400.37
DA13,341.73
List Price:  DA18,678.95
You save:  DA5,337.22
FJ$227.04
List Price:  FJ$317.87
You save:  FJ$90.82
Q769.16
List Price:  Q1,076.85
You save:  Q307.69
GY$20,834.51
List Price:  GY$29,169.15
You save:  GY$8,334.63
ISK kr13,772.62
List Price:  ISK kr19,282.22
You save:  ISK kr5,509.60
DH995.44
List Price:  DH1,393.66
You save:  DH398.21
L1,819.82
List Price:  L2,547.83
You save:  L728
ден5,825.40
List Price:  ден8,155.79
You save:  ден2,330.39
MOP$798.74
List Price:  MOP$1,118.27
You save:  MOP$319.52
N$1,801.35
List Price:  N$2,521.97
You save:  N$720.61
C$3,666.61
List Price:  C$5,133.40
You save:  C$1,466.79
रु13,462.23
List Price:  रु18,847.67
You save:  रु5,385.43
S/378.10
List Price:  S/529.35
You save:  S/151.25
K400.90
List Price:  K561.28
You save:  K160.37
SAR375.38
List Price:  SAR525.55
You save:  SAR150.16
ZK2,752.36
List Price:  ZK3,853.42
You save:  ZK1,101.05
L471.69
List Price:  L660.38
You save:  L188.69
Kč2,395.79
List Price:  Kč3,354.20
You save:  Kč958.41
Ft38,840.72
List Price:  Ft54,378.57
You save:  Ft15,537.84
SEK kr1,099.74
List Price:  SEK kr1,539.68
You save:  SEK kr439.94
ARS$100,165.56
List Price:  ARS$140,235.79
You save:  ARS$40,070.23
Bs690.96
List Price:  Bs967.37
You save:  Bs276.41
COP$440,690.82
List Price:  COP$616,984.78
You save:  COP$176,293.95
₡50,645.88
List Price:  ₡70,906.26
You save:  ₡20,260.37
L2,517.41
List Price:  L3,524.47
You save:  L1,007.06
₲775,966.15
List Price:  ₲1,086,383.66
You save:  ₲310,417.50
$U4,274.58
List Price:  $U5,984.58
You save:  $U1,710
zł411.21
List Price:  zł575.71
You save:  zł164.50
Already have an account? Log In

Transcript

Hey there, welcome back friends, let's check a couple of more things related to that database connectivity settings. Now, as of now, if I show you, we have four values in our database, and we can again check this by taking help of a workbench. So, information is present in the database, we are able to fetch the information everything is good enough. Now, let us quickly navigate to our sts and in here we have something known as application dot properties. Here is the file and we are making use of these three settings. Now, if I show you the article, which is given by spring.io in here there is this fourth setting right and for example, I use this setting then there are possible four values first value is nothing Which is the default value then there is the update value which says hibernate changes the database according to the given entity structure then we have create creates the database every time but don't drop it when close and then finally we also have this create and drop creates the database when drops to when the session factory closes.

Now there are these four options. Now these four options are for which property definitely the name of the property is a spring.jpa.hibernate.dd L dash auto. Now what does this DDL stands for this DDL stands for data Definition Language and this language. This part this category is science for the language the queries which help us to manipulate the structure of the database tables, right? So this is good enough. So this DDL Language will help us to drop table CREATE TABLE menu plate, table structure, things like that.

Whereas there is yet another category by the name of a DML data manipulation language, which helps us to manipulate the data for example, CRUD operations, create a row, delete a row, update a row or for example, read a row. So DML language is a yet another category. Now in here we will talk about this particular property. Let me copy this particular line. And let us navigate to our application dot property file. And let me save the changes.

Now, for example, I relaunched this application before that, let me also show you the values in the database table. We do have the values, but when we save the changes, and we use this property and we relaunch the application, something amazing will happen. Let me show you the console the application is up and running all the information the data inside this particular table will be lost there is nothing inside this table. Now, why this happens? This happens because when we give the DDL auto the value as create or update or create dash drop this will try to create a table based on your entity class right. So, in here we have this entity class right.

So, for example, we delete the database table directly. So, in here let me drop the table. Now, if I fire this query, there is no table there is nothing right. There is nothing. Now for example, I restart this application. In fact, because we have given the value for this property as create basis On our entity class, a new table would be created.

Let me show you. So in here, if I open up a workbench and if I fire the query that is this table right. So this particular property this particular property is very powerful. This can create tables in the database. This can truncate the information from the database. So do take a note of it, there are provisions using which we can also dump the data when we restart our web server.

So do the search on internet related to this file, do research how to handle scenario accordingly because this property can truncate data as well. All right, in our case, we are handling third data dumping thing manually. So definitely we will get rid of the setting. We Don't need it. We don't need a Spring Boot to create database table or a dump of data. We don't need it so we don't worry about it.

But when it comes to your application, your productions, your production environment, do take a note of this property. This is a very powerful property. All right, so this is it for today's video. This is a bonus video where I have just given you a high level information related to the property by the name of spring dot JPA dot hibernate dot DDL dash or toe? Alright, so that's it for today. I hope you guys enjoyed this video.

Thanks for watching. Have a nice day and take care

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.