Java tutorial
package org.csc.phynixx.sqlquery.config.h2; /* * #%L * querydsl * %% * Copyright (C) 2015 org.csc.phynixx * %% * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. * #L% */ import org.hibernate.dialect.H2Dialect; import org.hibernate.dialect.function.StandardSQLFunction; import org.hibernate.type.StandardBasicTypes; public class ExtendedH2Dialect extends H2Dialect { public ExtendedH2Dialect() { super(); this.registerFunction("person_name", new StandardSQLFunction("person_name", StandardBasicTypes.STRING)); this.registerFunction("PERSON_NAME", new StandardSQLFunction("PERSON_NAME", StandardBasicTypes.STRING)); } }