jakarta.persistence.ColumnResult Maven / Gradle / Ivy

Go to download
/*
 * Copyright (c) 2008, 2020 Oracle and/or its affiliates. All rights reserved.
 *
 * This program and the accompanying materials are made available under the
 * terms of the Eclipse Public License v. 2.0 which is available at
 * http://www.eclipse.org/legal/epl-2.0,
 * or the Eclipse Distribution License v. 1.0 which is available at
 * http://www.eclipse.org/org/documents/edl-v10.php.
 *
 * SPDX-License-Identifier: EPL-2.0 OR BSD-3-Clause
 */

// Contributors:
//     Linda DeMichiel - 2.1
//     Linda DeMichiel - 2.0

package jakarta.persistence;

import java.lang.annotation.Target;
import java.lang.annotation.Retention;
import static java.lang.annotation.RetentionPolicy.RUNTIME;

/**
 * Used in conjunction with the {@link SqlResultSetMapping} annotation or
 * {@link ConstructorResult} annotation to map a column of the SELECT
 * list of a SQL query.
 *
 *  The name element references the name of a column in the SELECT list
 *  — i.e., column alias, if applicable. Scalar result types can be 
 * included in the query result by specifying this annotation in 
 * the metadata.
 *
 * 
 *
 * Example:
 *   Query q = em.createNativeQuery(
 *       "SELECT o.id AS order_id, " +
 *           "o.quantity AS order_quantity, " +
 *           "o.item AS order_item, " + 
 *           "i.name AS item_name, " +
 *         "FROM Order o, Item i " +
 *         "WHERE (order_quantity > 25) AND (order_item = i.id)",
 *       "OrderResults");
 *
 *   @SqlResultSetMapping(name="OrderResults",
 *       entities={
 *           @EntityResult(entityClass=com.acme.Order.class, fields={
 *               @FieldResult(name="id", column="order_id"),
 *               @FieldResult(name="quantity", column="order_quantity"),
 *               @FieldResult(name="item", column="order_item")})},
 *       columns={
 *           @ColumnResult(name="item_name")}
 *       )
 * 
 *
 * @see SqlResultSetMapping
 *
 * @since 1.0
 */
@Target({}) 
@Retention(RUNTIME)

public @interface ColumnResult { 

    /** (Required) The name of a column in the SELECT clause of a SQL query */
    String name();

    /** 
     *  (Optional) The Java type to which the column type is to be mapped.
     *  If the type element is not specified, the default JDBC type 
     *  mapping for the column will be used.
     *  @since 2.1
     */
    Class type() default void.class;
}