One-to-many association between Category and Product entities

6 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$49.99
List Price:  $69.99
You save:  $20
€46.40
List Price:  €64.96
You save:  €18.56
£39.83
List Price:  £55.77
You save:  £15.93
CA$68.34
List Price:  CA$95.68
You save:  CA$27.34
A$75.73
List Price:  A$106.02
You save:  A$30.29
S$67.43
List Price:  S$94.41
You save:  S$26.98
HK$390.55
List Price:  HK$546.80
You save:  HK$156.25
CHF 45.24
List Price:  CHF 63.34
You save:  CHF 18.10
NOK kr543.62
List Price:  NOK kr761.11
You save:  NOK kr217.49
DKK kr346.42
List Price:  DKK kr485.02
You save:  DKK kr138.59
NZ$83.15
List Price:  NZ$116.42
You save:  NZ$33.26
د.إ183.60
List Price:  د.إ257.06
You save:  د.إ73.45
৳5,471.12
List Price:  ৳7,660.01
You save:  ৳2,188.88
₹4,168.17
List Price:  ₹5,835.78
You save:  ₹1,667.60
RM236.95
List Price:  RM331.75
You save:  RM94.80
₦61,737.65
List Price:  ₦86,437.65
You save:  ₦24,700
₨13,868
List Price:  ₨19,416.31
You save:  ₨5,548.31
฿1,837.56
List Price:  ฿2,572.74
You save:  ฿735.17
₺1,617.36
List Price:  ₺2,264.43
You save:  ₺647.07
B$254.77
List Price:  B$356.70
You save:  B$101.93
R925.26
List Price:  R1,295.44
You save:  R370.18
Лв90.75
List Price:  Лв127.05
You save:  Лв36.30
₩67,788.68
List Price:  ₩94,909.58
You save:  ₩27,120.90
₪185.35
List Price:  ₪259.50
You save:  ₪74.15
₱2,852.60
List Price:  ₱3,993.87
You save:  ₱1,141.27
¥7,651.21
List Price:  ¥10,712.31
You save:  ¥3,061.10
MX$848.45
List Price:  MX$1,187.89
You save:  MX$339.44
QR181.83
List Price:  QR254.57
You save:  QR72.74
P679.12
List Price:  P950.82
You save:  P271.70
KSh6,605.16
List Price:  KSh9,247.76
You save:  KSh2,642.59
E£2,394.23
List Price:  E£3,352.12
You save:  E£957.88
ብር2,861.57
List Price:  ብር4,006.43
You save:  ብር1,144.85
Kz41,791.64
List Price:  Kz58,511.64
You save:  Kz16,720
CLP$47,104.79
List Price:  CLP$65,950.47
You save:  CLP$18,845.68
CN¥361.78
List Price:  CN¥506.53
You save:  CN¥144.74
RD$2,896.80
List Price:  RD$4,055.76
You save:  RD$1,158.95
DA6,728.30
List Price:  DA9,420.16
You save:  DA2,691.86
FJ$112.64
List Price:  FJ$157.70
You save:  FJ$45.06
Q387.49
List Price:  Q542.52
You save:  Q155.02
GY$10,429.06
List Price:  GY$14,601.52
You save:  GY$4,172.46
ISK kr6,974.05
List Price:  ISK kr9,764.23
You save:  ISK kr2,790.17
DH502.81
List Price:  DH703.98
You save:  DH201.16
L883.05
List Price:  L1,236.34
You save:  L353.29
ден2,855.97
List Price:  ден3,998.59
You save:  ден1,142.61
MOP$401.24
List Price:  MOP$561.77
You save:  MOP$160.53
N$922.79
List Price:  N$1,291.99
You save:  N$369.19
C$1,835.15
List Price:  C$2,569.36
You save:  C$734.20
रु6,656.11
List Price:  रु9,319.09
You save:  रु2,662.97
S/186.09
List Price:  S/260.54
You save:  S/74.45
K192.70
List Price:  K269.79
You save:  K77.09
SAR187.49
List Price:  SAR262.50
You save:  SAR75.01
ZK1,344.69
List Price:  ZK1,882.68
You save:  ZK537.98
L230.99
List Price:  L323.40
You save:  L92.41
Kč1,163.34
List Price:  Kč1,628.77
You save:  Kč465.43
Ft18,074.53
List Price:  Ft25,305.79
You save:  Ft7,231.25
SEK kr539.27
List Price:  SEK kr755.02
You save:  SEK kr215.75
ARS$43,903.33
List Price:  ARS$61,468.17
You save:  ARS$17,564.84
Bs345.22
List Price:  Bs483.33
You save:  Bs138.11
COP$194,164.52
List Price:  COP$271,845.87
You save:  COP$77,681.34
₡25,478.72
List Price:  ₡35,672.25
You save:  ₡10,193.53
L1,231.47
List Price:  L1,724.16
You save:  L492.69
₲373,200.63
List Price:  ₲522,510.75
You save:  ₲149,310.11
$U1,910.59
List Price:  $U2,674.97
You save:  $U764.38
zł200.97
List Price:  zł281.37
You save:  zł80.40
Already have an account? Log In

Transcript

In Java objects associations are unidirectional. Which means if product has a many to one association with category, it does not imply that category also has an association with product. On the contrary, in our DBMS, if you have a foreign key in one table, you can traverse in both the direction. In order to have this bi directional Association here, we have to go to the category Java, and then create a variable here that represents all the products that belong to a single category. So when a single category object is obtained, for example, beverages, I would like to get all the products corresponding to this. For this, let's come here and then create a variable called list of product and then call it us products.

Make sure that you import list from Java dot util and then add a corresponding getter setters. You can move the cursor on these products and then Create getter and setter for products. Or alternatively select this, go to source menu, generate getters and setters. Automatically it is selected. And I will say that add after the last one here, I say, okay, it's been added. But again, if you do not map this with any at the rate column or anything, hibernate automatically assumes that products is going to be a new column in category.

But it fails because this is not a scalar type again. And we know that this is not going to be a new column anyway in the category because we already have a column corresponding to this association in the products table. So we want to use the same thing. All we have to do is to add an annotation here called one to many. And then we say here, join column with the name of category underscore ID. Now it is important to note that the join column here does not mean that the giant column is going to be in the category dot java, this column is going to be looked in the products table.

And if it doesn't exist, it's going to create a new one. Alternatively, we can skip this and then say that the product already has a many to one Association. And we want to use the same join information for this association. Also, for that, you may have to say your math to by equals to the name of the member that has the many to one Association. So if we go to the product dot java there, you will see that the many to one association is on a variable called category. So this is the name that we have to give here as map device.

So I'm going to save this now we have one to many Association. Before we write a program to check if this is working. Let's go to our dB. I already have added some data into my products table. I also have added few values to categories table also with eight different categories. Now I can write my program to fetch one category and then get all the products corresponding to the same.

So to do so, let's go back to our code. Create a new program here. So I'm going to call the package name as seventh one here. Make it as mean, add the main function as well, fullscreen this and then remove the to do here and then paste the snippet that we have been using so far. import the appropriate packages, I don't need the begin transaction and commit. So let's get a category first see one equals two session dot get category dot class.

And then the ID is that a one which corresponds to beverages, import the category and declare that c one. Now I have the C one. I can print the details of C one by typing category equals to C one dot get category name. can say category description is equals to C one dot get description will also say here, products in this category. And then I want to loop through and print the names of the products. For that I will use a for loop as a product p in C one dot get products, which is our list that we have created and mapped.

Let's import the product also. And then I'm going to type your P dot get product name probably along with the price of the product p dot get unit price. Before we run this let's also go to hibernate util dot get session factory. change this to false so that we don't see an SQL statements because it will be very complex output. I'm going to run this code right now and you can see that it should say beverages has around 12 different products. So as you can see that this is beverages And you've got the description and then these are the different products in that particular category.

So retrieving one category has retrieved other corresponding products also. But if I go to the program and then close the session after retrieving the category here, at this point in time, hibernate has brought the category corresponding to this ID. I have no problem in printing these details over here. But when I start accessing the products in that category, products have not been retrieved yet because by default, one to many is lazy fetch. Now hibernate tries to go back to the DB, but DB connection has been closed because connections are represented using session. This is where you get an exception saying that lazy initialization exception so I'm going to run this fullscreen the console.

You will see that we are able to get the beverages name and description but when I tried to access the products it says Lazy initialization exception. The solution to this is you go to the category dot java and then variable defined is one too many, you can always say here, fetch equals to eager. I save this go back to the program run this, I should now see that all the products have been returned without any problem. However, this is not recommended, as it might pollute the JVM with lots and lots of objects.

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.