BasicMapping.java

@Entity
public class Author {

	@Id
	private Long id;

	…
}

BasicMapping.xml

<entity-mappings>
    <entity class="org.thoughts.on.java.model.Author" name="Author">        
        <attributes>
            <id name="id">
            </id>
        </attributes>
   </entity>
</entity-mappings>

CustomizedMapping.java

@Entity
@Table(name = “author”, schema = “bookstore”)
public class Author {

	@Id
	@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = “author_generator”)
	@SequenceGenerator(name=”author_generator”, sequenceName = “author_seq”)
	@Column(name = “author_id”)
	private Long id;

	…
}

CustomizedMapping.xml

<entity-mappings>
    <entity class="org.thoughts.on.java.model.Author" name="Author">
    	<table name="author" />
    	<schema name="bookstore" />   
        <attributes>
            <id name="id">
            	<generated-value strategy="sequence" generator="author_generator"/>
            	<column name="author_id"/>
            </id>
        </attributes>
   </entity>
   <sequence-generator name="author_generator" sequence-name="author_seq"/>
</entity-mappings>

Mapping.java

@SqlResultSetMapping(
        name = "AuthorMapping",
        entities = @EntityResult(
                entityClass = Author.class,
                fields = {
                    @FieldResult(name = "id", column = "authorId"),
                    @FieldResult(name = "name", column = "name")}))

Mapping.xml

<?xml version="1.0" encoding="UTF-8" ?>
<entity-mappings>
	<entity class="org.thoughts.on.java.model.Author" name="Author">
		...
    
		<sql-result-set-mapping name="AuthorMappingXml">
			<entity-result entity-class="org.thoughts.on.java.model.Author">
				<field-result name="id" column="authorId" />
				<field-result name="name" column="name" />
			</entity-result>
		</sql-result-set-mapping>
	</entity>
	...
</entity-mappings>

NamedEntityGraph.java

@Entity
@NamedEntityGraph(name = "graph.Author.books", 
      attributeNodes = @NamedAttributeNode("books"))
public class Author {

  ...
  
  private List<Book> books = new ArrayList<Book>();
  
  ...
}

NamedEntityGraph.xml

<entity-mappings>
  <entity class="org.thoughts.on.java.model.Author" name="Author">
    ...

    <named-entity-graph name="graph.Author.books">
            <named-attribute-node name="books" />
        </named-entity-graph>
  </entity>
  ...
</entity-mappings>

NamedQuery.java

@Entity
@NamedQuery(name = Author.QUERY_SELECT_BY_ID, query = “SELECT a FROM Author a WHERE a.id = :” + Author.PARAM_ID)
public class Author {
	public static final String QUERY_SELECT_BY_ID = “Author.selectById”;
	public static final String PARAM_ID = “id”;

	…
}

NamedQuery.xml

<entity-mappings>
  <entity class="org.thoughts.on.java.model.Author" name="Author">
    ...
    <named-query name="Author.selectById">
        <query><![CDATA[
        SELECT a FROM Author a WHERE a.id = :id
        ]]></query>
    </named-query>
  </entity>
  ...
</entity-mappings>

persistence.xml

<persistence xmlns="http://xmlns.jcp.org/xml/ns/persistence"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence
             http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd"
             version="2.1">
  <persistence-unit name="my-persistence-unit">
    <description>Thougths on Java</description>
    <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
    <mapping-file>file:\\\C:\dev\wrk\XmlMapping\XmlMappings\myMappings.xml</mapping-file>
    <properties>
      <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect" />

      <property name="javax.persistence.jdbc.driver" value="org.postgresql.Driver" />
      <property name="javax.persistence.jdbc.url" value="jdbc:postgresql://localhost:5432/test" />
      <property name="javax.persistence.jdbc.user" value="postgres" />
      <property name="javax.persistence.jdbc.password" value="postgres" />

      <property name="javax.persistence.schema-generation.database.action" value="drop-and-create"/>        
    </properties>
  </persistence-unit>
</persistence>