Get Hibernate single iteration values only in an entity












0














I need to get values from user table, in that user have an manager id,
Manager is an user so again manager id is mapped with user entity.



This will cause continuous iteration until the manager ID get null.

The entity get more on inside on it > User entity > manager id> --> user entity ....



Is there any possible to get single entity with single manager using hibernate query?



 USER_NAME (PK)
CREATE_DATE
UPDATED_DATE
ROLE_ID
USER_ID
MANAGER_ID
REGION_ID
USER_GROUP
Created_By


User class

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "USER_ID", unique = true, nullable = false)
private Long userId;


@ManyToOne( targetEntity = User.class, cascade = CascadeType.ALL)
@JoinColumn(name = "MANAGER_ID", referencedColumnName = "USER_ID")
private User managerId;









share|improve this question



























    0














    I need to get values from user table, in that user have an manager id,
    Manager is an user so again manager id is mapped with user entity.



    This will cause continuous iteration until the manager ID get null.

    The entity get more on inside on it > User entity > manager id> --> user entity ....



    Is there any possible to get single entity with single manager using hibernate query?



     USER_NAME (PK)
    CREATE_DATE
    UPDATED_DATE
    ROLE_ID
    USER_ID
    MANAGER_ID
    REGION_ID
    USER_GROUP
    Created_By


    User class

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "USER_ID", unique = true, nullable = false)
    private Long userId;


    @ManyToOne( targetEntity = User.class, cascade = CascadeType.ALL)
    @JoinColumn(name = "MANAGER_ID", referencedColumnName = "USER_ID")
    private User managerId;









    share|improve this question

























      0












      0








      0







      I need to get values from user table, in that user have an manager id,
      Manager is an user so again manager id is mapped with user entity.



      This will cause continuous iteration until the manager ID get null.

      The entity get more on inside on it > User entity > manager id> --> user entity ....



      Is there any possible to get single entity with single manager using hibernate query?



       USER_NAME (PK)
      CREATE_DATE
      UPDATED_DATE
      ROLE_ID
      USER_ID
      MANAGER_ID
      REGION_ID
      USER_GROUP
      Created_By


      User class

      @Id
      @GeneratedValue(strategy = GenerationType.IDENTITY)
      @Column(name = "USER_ID", unique = true, nullable = false)
      private Long userId;


      @ManyToOne( targetEntity = User.class, cascade = CascadeType.ALL)
      @JoinColumn(name = "MANAGER_ID", referencedColumnName = "USER_ID")
      private User managerId;









      share|improve this question













      I need to get values from user table, in that user have an manager id,
      Manager is an user so again manager id is mapped with user entity.



      This will cause continuous iteration until the manager ID get null.

      The entity get more on inside on it > User entity > manager id> --> user entity ....



      Is there any possible to get single entity with single manager using hibernate query?



       USER_NAME (PK)
      CREATE_DATE
      UPDATED_DATE
      ROLE_ID
      USER_ID
      MANAGER_ID
      REGION_ID
      USER_GROUP
      Created_By


      User class

      @Id
      @GeneratedValue(strategy = GenerationType.IDENTITY)
      @Column(name = "USER_ID", unique = true, nullable = false)
      private Long userId;


      @ManyToOne( targetEntity = User.class, cascade = CascadeType.ALL)
      @JoinColumn(name = "MANAGER_ID", referencedColumnName = "USER_ID")
      private User managerId;






      spring hibernate






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 23 at 9:51









      Prabu M

      213




      213
























          1 Answer
          1






          active

          oldest

          votes


















          0














          You can relate to entity only managerId(I mean Long type), or you can mark Many to one relation with fetch = FetchType.LAZY and call this field only if needed.






          share|improve this answer





















          • Yes I have done same thing in my application, but the issue is stable application working on final stage, they called it in more 1200 references, once change it need to check the entire flow of the application it not possible at pre prod stage.
            – Prabu M
            Nov 23 at 13:10










          • I am in the stage of performance issue fixation, so the performance we are doing should not affect the actual flow.
            – Prabu M
            Nov 23 at 13:11










          • Thanks for your valuable reply
            – Prabu M
            Nov 23 at 13:12











          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
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53444256%2fget-hibernate-single-iteration-values-only-in-an-entity%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          You can relate to entity only managerId(I mean Long type), or you can mark Many to one relation with fetch = FetchType.LAZY and call this field only if needed.






          share|improve this answer





















          • Yes I have done same thing in my application, but the issue is stable application working on final stage, they called it in more 1200 references, once change it need to check the entire flow of the application it not possible at pre prod stage.
            – Prabu M
            Nov 23 at 13:10










          • I am in the stage of performance issue fixation, so the performance we are doing should not affect the actual flow.
            – Prabu M
            Nov 23 at 13:11










          • Thanks for your valuable reply
            – Prabu M
            Nov 23 at 13:12
















          0














          You can relate to entity only managerId(I mean Long type), or you can mark Many to one relation with fetch = FetchType.LAZY and call this field only if needed.






          share|improve this answer





















          • Yes I have done same thing in my application, but the issue is stable application working on final stage, they called it in more 1200 references, once change it need to check the entire flow of the application it not possible at pre prod stage.
            – Prabu M
            Nov 23 at 13:10










          • I am in the stage of performance issue fixation, so the performance we are doing should not affect the actual flow.
            – Prabu M
            Nov 23 at 13:11










          • Thanks for your valuable reply
            – Prabu M
            Nov 23 at 13:12














          0












          0








          0






          You can relate to entity only managerId(I mean Long type), or you can mark Many to one relation with fetch = FetchType.LAZY and call this field only if needed.






          share|improve this answer












          You can relate to entity only managerId(I mean Long type), or you can mark Many to one relation with fetch = FetchType.LAZY and call this field only if needed.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 23 at 9:56









          Vlad Martinkov

          1




          1












          • Yes I have done same thing in my application, but the issue is stable application working on final stage, they called it in more 1200 references, once change it need to check the entire flow of the application it not possible at pre prod stage.
            – Prabu M
            Nov 23 at 13:10










          • I am in the stage of performance issue fixation, so the performance we are doing should not affect the actual flow.
            – Prabu M
            Nov 23 at 13:11










          • Thanks for your valuable reply
            – Prabu M
            Nov 23 at 13:12


















          • Yes I have done same thing in my application, but the issue is stable application working on final stage, they called it in more 1200 references, once change it need to check the entire flow of the application it not possible at pre prod stage.
            – Prabu M
            Nov 23 at 13:10










          • I am in the stage of performance issue fixation, so the performance we are doing should not affect the actual flow.
            – Prabu M
            Nov 23 at 13:11










          • Thanks for your valuable reply
            – Prabu M
            Nov 23 at 13:12
















          Yes I have done same thing in my application, but the issue is stable application working on final stage, they called it in more 1200 references, once change it need to check the entire flow of the application it not possible at pre prod stage.
          – Prabu M
          Nov 23 at 13:10




          Yes I have done same thing in my application, but the issue is stable application working on final stage, they called it in more 1200 references, once change it need to check the entire flow of the application it not possible at pre prod stage.
          – Prabu M
          Nov 23 at 13:10












          I am in the stage of performance issue fixation, so the performance we are doing should not affect the actual flow.
          – Prabu M
          Nov 23 at 13:11




          I am in the stage of performance issue fixation, so the performance we are doing should not affect the actual flow.
          – Prabu M
          Nov 23 at 13:11












          Thanks for your valuable reply
          – Prabu M
          Nov 23 at 13:12




          Thanks for your valuable reply
          – Prabu M
          Nov 23 at 13:12


















          draft saved

          draft discarded




















































          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.





          Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


          Please pay close attention to the following guidance:


          • 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.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53444256%2fget-hibernate-single-iteration-values-only-in-an-entity%23new-answer', 'question_page');
          }
          );

          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







          Popular posts from this blog

          A CLEAN and SIMPLE way to add appendices to Table of Contents and bookmarks

          Calculate evaluation metrics using cross_val_predict sklearn

          Insert data from modal to MySQL (multiple modal on website)