Discussions

News: Adding Hibernate native SQL features into your Spring data repository

Bookmark and Share Get thread feed

  1. Adding Hibernate native SQL features into your Spring data repository (5 messages)

    • Posted by: Boris Lam
    • Posted on: August 08 2012 03:48 EDT

    JPA provides @NamedNativeQuery for you to use native SQL. However, the usage is not so convenient, especially when you need to map multiple entities in your native SQL. You have to define a set of SqlResultSetMapping mapping which is quite error prone.


    For those who have used Hibernate native SQL features before, you will find that it is much more easier to use than JPA's @NamedNativeQuery. In recent projects, I am using Spring Data JPA. I have added hibernate native query features to my Spring Data base repostory. You can now perform native query in JPA without SqlResultSetMapping.

    http://borislam.blogspot.hk/2012/07/adding-hibernate-native-sql-features.html

    Reply to this

    Threaded Messages (5)

  2. Adding Hibernate native SQL features into your Spring data repository[ Go to top ]

    and make it more complicated ....   

    most people dont need hibernate and here we are putting spring to hibernate. why not add some more crap like transaction managers in jdbc, spring and hibernate working together.....

    what happpned to simple architecture.

    jdbc dao not good enough. ok add spring jdbc template if u have the itch...b ut this crazy ....

    Reply to this Reply to original

  3. Adding Hibernate native SQL features into your Spring data repository[ Go to top ]

    Hi Spencer,

    Thanks for your comment. :)   

    The target audience of this post is for those who have try to use "Spring data - JPA" module. Using JDBC template could not retrieve entity objects for JPA. That's why some need JPA and also the "Spring data - JPA" module.

    Reply to this Reply to original

  4. SqlResultSetMapping[ Go to top ]

    Yes, I have encountered lot of errors while using SqlResultSetMapping. Thanks for your new feature.

    _______

    Inroads

    Reply to this Reply to original

  5. good day[ Go to top ]

    good to know this information

    stork club newsreel

     

    Reply to this Reply to original

  6. I will try Hibernate native SQL[ Go to top ]

    I usually use  JPA's @NamedNativeQuery and I think I will try your suggestion to use Hibernate native SQL features and I willl observe the differences.

    Samsung the Series 7 Chronos

    Reply to this Reply to original