Spring data join with specifications - join data from referenced column
I have a table which stores the orders. The orders table has an 'One to Many' mapping to another table, which stores ordered item, orderItems. For each row of the orderItems, it refers to a row in the Product table. And I have another table which stores product image, the product image table has a foreign key which points to the product. How can I use JPA specifications to join the product image in the query result of the orders?
Something like:
Order -> [orderId, ... orderItems,...]
OrderItem -> [orderitemId, ... product,...]
Product -> [productId, productname... ]
ProductImage -> [producdImageId, .... productId...]
I am searching on Order table.
thanks!
java mysql jpa spring-data-jpa spring-data
asked Nov 14 '18 at 22:12
The MWThe MW
285
add a comment |
I have a table which stores the orders. The orders table has an 'One to Many' mapping to another table, which stores ordered item, orderItems. For each row of the orderItems, it refers to a row in the Product table. And I have another table which stores product image, the product image table has a foreign key which points to the product. How can I use JPA specifications to join the product image in the query result of the orders?
Something like:
Order -> [orderId, ... orderItems,...]
OrderItem -> [orderitemId, ... product,...]
Product -> [productId, productname... ]
ProductImage -> [producdImageId, .... productId...]
I am searching on Order table.
thanks!
java mysql jpa spring-data-jpa spring-data
asked Nov 14 '18 at 22:12
The MWThe MW
285
Show as the code you have so far, and in what way it fails to do what you want.
– Jens Schauder
Nov 15 '18 at 6:58
I don't know how to write the specification for it, e.g searching on the order table, and also fetches the product images
– The MW
Nov 15 '18 at 10:03
add a comment |
I have a table which stores the orders. The orders table has an 'One to Many' mapping to another table, which stores ordered item, orderItems. For each row of the orderItems, it refers to a row in the Product table. And I have another table which stores product image, the product image table has a foreign key which points to the product. How can I use JPA specifications to join the product image in the query result of the orders?
Something like:
Order -> [orderId, ... orderItems,...]
OrderItem -> [orderitemId, ... product,...]
Product -> [productId, productname... ]
ProductImage -> [producdImageId, .... productId...]
I am searching on Order table.
thanks!
java mysql jpa spring-data-jpa spring-data
asked Nov 14 '18 at 22:12
The MWThe MW
285
I have a table which stores the orders. The orders table has an 'One to Many' mapping to another table, which stores ordered item, orderItems. For each row of the orderItems, it refers to a row in the Product table. And I have another table which stores product image, the product image table has a foreign key which points to the product. How can I use JPA specifications to join the product image in the query result of the orders?
Something like:
Order -> [orderId, ... orderItems,...]
OrderItem -> [orderitemId, ... product,...]
Product -> [productId, productname... ]
ProductImage -> [producdImageId, .... productId...]
I am searching on Order table.
thanks!
java mysql jpa spring-data-jpa spring-data
java mysql jpa spring-data-jpa spring-data
asked Nov 14 '18 at 22:12
The MWThe MW
285
asked Nov 14 '18 at 22:12
The MWThe MW
285
edited Nov 15 '18 at 9:22
The MW
asked Nov 14 '18 at 22:12
The MWThe MW
285
asked Nov 14 '18 at 22:12
The MWThe MW
285
asked Nov 14 '18 at 22:12
The MWThe MW
285
285
Show as the code you have so far, and in what way it fails to do what you want.
– Jens Schauder
Nov 15 '18 at 6:58
I don't know how to write the specification for it, e.g searching on the order table, and also fetches the product images
– The MW
Nov 15 '18 at 10:03
add a comment |
Show as the code you have so far, and in what way it fails to do what you want.
– Jens Schauder
Nov 15 '18 at 6:58
I don't know how to write the specification for it, e.g searching on the order table, and also fetches the product images
– The MW
Nov 15 '18 at 10:03
Show as the code you have so far, and in what way it fails to do what you want.
– Jens Schauder
Nov 15 '18 at 6:58
Show as the code you have so far, and in what way it fails to do what you want.
– Jens Schauder
Nov 15 '18 at 6:58
I don't know how to write the specification for it, e.g searching on the order table, and also fetches the product images
– The MW
Nov 15 '18 at 10:03
I don't know how to write the specification for it, e.g searching on the order table, and also fetches the product images
– The MW
Nov 15 '18 at 10:03
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53309520%2fspring-data-join-with-specifications-join-data-from-referenced-column%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53309520%2fspring-data-join-with-specifications-join-data-from-referenced-column%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Show as the code you have so far, and in what way it fails to do what you want.
– Jens Schauder
Nov 15 '18 at 6:58
I don't know how to write the specification for it, e.g searching on the order table, and also fetches the product images
– The MW
Nov 15 '18 at 10:03