{"id":1648,"date":"2012-08-22T10:00:00","date_gmt":"2012-08-22T10:00:00","guid":{"rendered":"http:\/\/www.javacodegeeks.com\/2012\/10\/hibernate-native-sql-features-into-your-spring-data-repository.html"},"modified":"2012-10-22T06:23:30","modified_gmt":"2012-10-22T06:23:30","slug":"hibernate-native-sql-features-into-your","status":"publish","type":"post","link":"https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html","title":{"rendered":"Hibernate native SQL features into your Spring Data Repository"},"content":{"rendered":"<div dir=\"ltr\" style=\"text-align: left\">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.                    <\/p>\n<p>For those who have used Hibernate native SQL features before, you will find that it is much more easier to use than JPA&#8217;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.                    <\/p>\n<p>1. Add you cusomt annotation @NativeQueries and @NativeQuery                    <\/p>\n<pre class=\"brush:java\">@Target(ElementType.TYPE)\r\n@Retention(RetentionPolicy.RUNTIME)\r\npublic @interface NativeQueries {\r\n NativeQuery[] queries() default  {};\r\n}\r\n<\/pre>\n<pre class=\"brush:java\">@Retention(RetentionPolicy.RUNTIME)\r\npublic @interface NativeQuery {\r\n String name()  default \"\";\r\n String sql()  default \"\";\r\n}\r\n<\/pre>\n<p>2. Add the method &#8220;queryNatively&#8221; in base Spring Data Repository.                    <\/p>\n<p>If you do not know how to add custom behaviour to your Spring data JPA base repository, please see my previous post for                     <a href=\"http:\/\/borislam.blogspot.hk\/2012\/07\/customizing-spring-data-jpa-repository.html\">how to customize your Spring data JPA base repository for detail<\/a>. You can see in previous post that I intentionally expose the repository interface (i.e. the springDataRepositoryInterface property) in the GenericRepositoryImpl. This small tricks enable me to access the annotation in the repository interface easily.                    <div style=\"display:inline-block; margin: 15px 0;\"> <div id=\"adngin-JavaCodeGeeks_incontent_video-0\" style=\"display:inline-block;\"><\/div> <\/div><\/p>\n<pre class=\"brush:java\">public List queryNatively(String nativeQueryName, LinkedHashMap&lt;String,Class&lt;?&gt;&gt; inEntityClasses, Map inParams ){\r\n SQLQuery query =  this.createHibernateNativeQuery( nativeQueryName,  inParams );\r\n     \/\/add entities\r\n     if (inEntityClasses!=null) {      \r\n      for (Object key: inEntityClasses.keySet()) {\r\n    String entityClassAlias = key.toString();\r\n    Class&lt;?&gt; entityClass = (Class&lt;?&gt;)inEntityClasses.get(key);  \r\n    query.addEntity(entityClassAlias,entityClass);\r\n         }    \r\n     }\r\n             \r\n     \/\/add parameter\r\n     if (inParams != null){\r\n      for (Object key: inParams.keySet()) {\r\n    String queryParamName = key.toString();\r\n    Object queryParamValue = inParams.get(key);\r\n    query.setParameter(queryParamName, queryParamValue);\r\n         }\r\n     }  \r\n     return (query!=null)? query.list() : null ;\r\n  }\r\n    \r\n\r\n  private SQLQuery createHibernateNativeQuery (String nativeQueryName, Map inParams ){\r\n     if (GenericRepository.class.isAssignableFrom(getSpringDataRepositoryInterface())) {\r\n      \r\n      Annotation nativeQueryAnn = getSpringDataRepositoryInterface().getAnnotation(NativeQueries.class);\r\n      if(nativeQueryAnn != null){\r\n       NativeQueries nativeQueries = (NativeQueries)nativeQueryAnn;\r\n       NativeQuery[] queries  = nativeQueries.queries();\r\n    for (NativeQuery sqlquery : queries) { \r\n          \r\n     if (StringUtils.equals(nativeQueryName, sqlquery.name())) {\r\n      String sql  = sqlquery.sql();\r\n      \r\n      Session hiernateSess = em.unwrap(Session.class);\r\n         SQLQuery query = hiernateSess.createSQLQuery(sql);\r\n         \r\n         \/\/add parameter\r\n         if (inParams != null){\r\n          for (Object key: inParams.keySet()) {\r\n        String queryParamName = key.toString();\r\n        Object queryParamValue = inParams.get(key);\r\n        query.setParameter(queryParamName, queryParamValue);\r\n             }\r\n         }  \r\n         \r\n         return query;\r\n     }    \r\n    }\r\n      }\r\n     \r\n     }\r\n     return null;\r\n  }\r\n<\/pre>\n<p>3. Example Usage                    <\/p>\n<p>In your repositry interface, define which native SQL queries you want to use through your @NativeQueries and @NativeQuery annotation. The usage is just similar to calling hibernate native query features. You could just see the                     <a href=\"http:\/\/docs.jboss.org\/hibernate\/orm\/4.1\/devguide\/en-US\/html\/ch13.html\">hibernate alias and property references<\/a>.                    <\/p>\n<pre class=\"brush:java\">@NativeQueries (\r\n queries = {\r\n   @NativeQuery(name=\"query1\", \r\n         sql=\"SELECT {cat.*}, {mother.*}  FROM CATS c, CATS m WHERE c.MOTHER_ID = c.ID and c.name =  :catName \"),\r\n   @NativeQuery(name=\"query2\", \r\n         sql=\"SELECT {cat.*} FROM CATS where c.ID =  :catName\")       \r\n }\r\n)\r\npublic interface CatRepository extends GenericRepository&lt;Cat, Long&gt; {\r\n}\r\n<\/pre>\n<p>In your service or business class that inject your repository, you could just simply call the queryNatively() method to perform native SQL query.                    <\/p>\n<pre class=\"brush:java\">@Service\r\npublic class CatService {\r\n \r\n @Inject\r\n private CatRepository catRepository;\r\n \r\n public List&lt;Cat&gt; searchCat( String catName) {\r\n    \r\n  List&lt;Cat&gt; catList;\r\n \r\n  \/\/ Add entity mapping for your query\r\n  HashMap&lt;String, Object&gt; inParams = new HashMap&lt;String, Object&gt;();\r\n  inParams.put(\"catName\", \"Felix\");\r\n  \r\n  \r\n  \/\/ Prepare parameters for your native sql\r\n  LinkedHashMap&lt;String, Object&gt; entityMap = new LinkedHashMap&lt;String, Object&gt;();\r\n  entityMap.put(\"cat\", Cat.class);\r\n  entityMap.put(\"mother\",Mother.class);\r\n \r\n\r\n \r\n  catList = catRepository.queryNatively(\r\n    \"query1\", \"\",entityParam);\r\n \r\n  return catList;\r\n }\r\n}\r\n<\/pre>\n<p><strong><i>Reference: <\/i><\/strong><a href=\"http:\/\/borislam.blogspot.gr\/2012\/07\/adding-hibernate-native-sql-features.html\">Adding Hibernate native SQL features into your Spring Data Repository <\/a> from our <a href=\"http:\/\/www.javacodegeeks.com\/p\/jcg.html\">JCG partner<\/a> Boris Lam at the <a href=\"http:\/\/borislam.blogspot.gr\/\">Programming Peacefully<\/a> blog.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>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 &hellip;<\/p>\n","protected":false},"author":275,"featured_media":238,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[31,30,321],"class_list":["post-1648","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-enterprise-java","tag-jboss-hibernate","tag-spring","tag-spring-data"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Hibernate native SQL features into your Spring Data Repository - Java Code Geeks<\/title>\n<meta name=\"description\" content=\"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\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hibernate native SQL features into your Spring Data Repository - Java Code Geeks\" \/>\n<meta property=\"og:description\" content=\"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\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html\" \/>\n<meta property=\"og:site_name\" content=\"Java Code Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/javacodegeeks\" \/>\n<meta property=\"article:published_time\" content=\"2012-08-22T10:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2012-10-22T06:23:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/spring-data-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Boris Lam\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:site\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Boris Lam\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/08\\\/hibernate-native-sql-features-into-your.html#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/08\\\/hibernate-native-sql-features-into-your.html\"},\"author\":{\"name\":\"Boris Lam\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/person\\\/d959042669d4f98aaacb5f92a0bd277f\"},\"headline\":\"Hibernate native SQL features into your Spring Data Repository\",\"datePublished\":\"2012-08-22T10:00:00+00:00\",\"dateModified\":\"2012-10-22T06:23:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/08\\\/hibernate-native-sql-features-into-your.html\"},\"wordCount\":280,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/08\\\/hibernate-native-sql-features-into-your.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2012\\\/10\\\/spring-data-logo.jpg\",\"keywords\":[\"JBoss Hibernate\",\"Spring\",\"Spring Data\"],\"articleSection\":[\"Enterprise Java\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/08\\\/hibernate-native-sql-features-into-your.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/08\\\/hibernate-native-sql-features-into-your.html\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/08\\\/hibernate-native-sql-features-into-your.html\",\"name\":\"Hibernate native SQL features into your Spring Data Repository - Java Code Geeks\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/08\\\/hibernate-native-sql-features-into-your.html#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/08\\\/hibernate-native-sql-features-into-your.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2012\\\/10\\\/spring-data-logo.jpg\",\"datePublished\":\"2012-08-22T10:00:00+00:00\",\"dateModified\":\"2012-10-22T06:23:30+00:00\",\"description\":\"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\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/08\\\/hibernate-native-sql-features-into-your.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/08\\\/hibernate-native-sql-features-into-your.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/08\\\/hibernate-native-sql-features-into-your.html#primaryimage\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2012\\\/10\\\/spring-data-logo.jpg\",\"contentUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2012\\\/10\\\/spring-data-logo.jpg\",\"width\":150,\"height\":150},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/08\\\/hibernate-native-sql-features-into-your.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.javacodegeeks.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Java\",\"item\":\"https:\\\/\\\/www.javacodegeeks.com\\\/category\\\/java\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Enterprise Java\",\"item\":\"https:\\\/\\\/www.javacodegeeks.com\\\/category\\\/java\\\/enterprise-java\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Hibernate native SQL features into your Spring Data Repository\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#website\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/\",\"name\":\"Java Code Geeks\",\"description\":\"Java Developers Resource Center\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#organization\"},\"alternateName\":\"JCG\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.javacodegeeks.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#organization\",\"name\":\"Exelixis Media P.C.\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/exelixis-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/exelixis-logo.png\",\"width\":864,\"height\":246,\"caption\":\"Exelixis Media P.C.\"},\"image\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/javacodegeeks\",\"https:\\\/\\\/x.com\\\/javacodegeeks\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/person\\\/d959042669d4f98aaacb5f92a0bd277f\",\"name\":\"Boris Lam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0e3a5b1ffe3875cdbcdd5b8023d8e6f2a850a43915f33a8d3501a6973e7dda86?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0e3a5b1ffe3875cdbcdd5b8023d8e6f2a850a43915f33a8d3501a6973e7dda86?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0e3a5b1ffe3875cdbcdd5b8023d8e6f2a850a43915f33a8d3501a6973e7dda86?s=96&d=mm&r=g\",\"caption\":\"Boris Lam\"},\"description\":\"Boris is an experienced Java developer with in Hong Kong. His expertise is in Java EE technology, object-oriented application development, and the use of open source frameworks (e.g. Spring , Apache MyFaces). In recent years, he is primarily involved in framework development and architectural design in serveral Government related software development projects.\",\"sameAs\":[\"http:\\\/\\\/www.borislam.com\\\/\"],\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/author\\\/boris-lam\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hibernate native SQL features into your Spring Data Repository - Java Code Geeks","description":"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","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html","og_locale":"en_US","og_type":"article","og_title":"Hibernate native SQL features into your Spring Data Repository - Java Code Geeks","og_description":"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","og_url":"https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html","og_site_name":"Java Code Geeks","article_publisher":"https:\/\/www.facebook.com\/javacodegeeks","article_published_time":"2012-08-22T10:00:00+00:00","article_modified_time":"2012-10-22T06:23:30+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/spring-data-logo.jpg","type":"image\/jpeg"}],"author":"Boris Lam","twitter_card":"summary_large_image","twitter_creator":"@javacodegeeks","twitter_site":"@javacodegeeks","twitter_misc":{"Written by":"Boris Lam","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html#article","isPartOf":{"@id":"https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html"},"author":{"name":"Boris Lam","@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/person\/d959042669d4f98aaacb5f92a0bd277f"},"headline":"Hibernate native SQL features into your Spring Data Repository","datePublished":"2012-08-22T10:00:00+00:00","dateModified":"2012-10-22T06:23:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html"},"wordCount":280,"commentCount":2,"publisher":{"@id":"https:\/\/www.javacodegeeks.com\/#organization"},"image":{"@id":"https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html#primaryimage"},"thumbnailUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/spring-data-logo.jpg","keywords":["JBoss Hibernate","Spring","Spring Data"],"articleSection":["Enterprise Java"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html","url":"https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html","name":"Hibernate native SQL features into your Spring Data Repository - Java Code Geeks","isPartOf":{"@id":"https:\/\/www.javacodegeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html#primaryimage"},"image":{"@id":"https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html#primaryimage"},"thumbnailUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/spring-data-logo.jpg","datePublished":"2012-08-22T10:00:00+00:00","dateModified":"2012-10-22T06:23:30+00:00","description":"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","breadcrumb":{"@id":"https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html#primaryimage","url":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/spring-data-logo.jpg","contentUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/spring-data-logo.jpg","width":150,"height":150},{"@type":"BreadcrumbList","@id":"https:\/\/www.javacodegeeks.com\/2012\/08\/hibernate-native-sql-features-into-your.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.javacodegeeks.com\/"},{"@type":"ListItem","position":2,"name":"Java","item":"https:\/\/www.javacodegeeks.com\/category\/java"},{"@type":"ListItem","position":3,"name":"Enterprise Java","item":"https:\/\/www.javacodegeeks.com\/category\/java\/enterprise-java"},{"@type":"ListItem","position":4,"name":"Hibernate native SQL features into your Spring Data Repository"}]},{"@type":"WebSite","@id":"https:\/\/www.javacodegeeks.com\/#website","url":"https:\/\/www.javacodegeeks.com\/","name":"Java Code Geeks","description":"Java Developers Resource Center","publisher":{"@id":"https:\/\/www.javacodegeeks.com\/#organization"},"alternateName":"JCG","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.javacodegeeks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.javacodegeeks.com\/#organization","name":"Exelixis Media P.C.","url":"https:\/\/www.javacodegeeks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","contentUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","width":864,"height":246,"caption":"Exelixis Media P.C."},"image":{"@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/javacodegeeks","https:\/\/x.com\/javacodegeeks"]},{"@type":"Person","@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/person\/d959042669d4f98aaacb5f92a0bd277f","name":"Boris Lam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0e3a5b1ffe3875cdbcdd5b8023d8e6f2a850a43915f33a8d3501a6973e7dda86?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0e3a5b1ffe3875cdbcdd5b8023d8e6f2a850a43915f33a8d3501a6973e7dda86?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0e3a5b1ffe3875cdbcdd5b8023d8e6f2a850a43915f33a8d3501a6973e7dda86?s=96&d=mm&r=g","caption":"Boris Lam"},"description":"Boris is an experienced Java developer with in Hong Kong. His expertise is in Java EE technology, object-oriented application development, and the use of open source frameworks (e.g. Spring , Apache MyFaces). In recent years, he is primarily involved in framework development and architectural design in serveral Government related software development projects.","sameAs":["http:\/\/www.borislam.com\/"],"url":"https:\/\/www.javacodegeeks.com\/author\/boris-lam"}]}},"_links":{"self":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/1648","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/users\/275"}],"replies":[{"embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/comments?post=1648"}],"version-history":[{"count":0,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/1648\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/media\/238"}],"wp:attachment":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/media?parent=1648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/categories?post=1648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/tags?post=1648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}