|
Hibernate example source code file (AvgWithArgumentCastFunction.java)
The Hibernate AvgWithArgumentCastFunction.java source code/* * Hibernate, Relational Persistence for Idiomatic Java * * Copyright (c) 2010, Red Hat Inc. or third-party contributors as * indicated by the @author tags or express copyright attribution * statements applied by the authors. All third-party contributions are * distributed under license by Red Hat Inc. * * This copyrighted material is made available to anyone wishing to use, modify, * copy, or redistribute it subject to the terms and conditions of the GNU * Lesser General Public License, as published by the Free Software Foundation. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License * for more details. * * You should have received a copy of the GNU Lesser General Public License * along with this distribution; if not, write to: * Free Software Foundation, Inc. * 51 Franklin Street, Fifth Floor * Boston, MA 02110-1301 USA */ package org.hibernate.dialect.function; import java.sql.Types; /** * Some databases strictly return the type of the of the aggregation value for <tt>AVG which is * problematic in the case of averaging integers because the decimals will be dropped. The usual workaround * is to cast the integer argument as some form of double/decimal. * * @author Steve Ebersole */ public class AvgWithArgumentCastFunction extends StandardAnsiSqlAggregationFunctions.AvgFunction { private final String castType; public AvgWithArgumentCastFunction(String castType) { this.castType = castType; } @Override protected String renderArgument(String argument, int firstArgumentJdbcType) { if ( firstArgumentJdbcType == Types.DOUBLE || firstArgumentJdbcType == Types.FLOAT ) { return argument; } else { return "cast(" + argument + " as " + castType + ")"; } } } Other Hibernate examples (source code examples)Here is a short list of links related to this Hibernate AvgWithArgumentCastFunction.java source code file: |
... this post is sponsored by my books ... | |
#1 New Release! |
FP Best Seller |
Copyright 1998-2021 Alvin Alexander, alvinalexander.com
All Rights Reserved.
A percentage of advertising revenue from
pages under the /java/jwarehouse
URI on this website is
paid back to open source projects.