Java tutorial
/* * Copyright 2011, Mysema Ltd * * 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. */ package com.mysema.query.jpa.support; import java.util.Arrays; import java.util.List; import org.hibernate.dialect.DerbyDialect; import org.hibernate.dialect.function.CastFunction; import org.hibernate.dialect.function.VarArgsSQLFunction; import org.hibernate.engine.spi.SessionFactoryImplementor; import org.hibernate.type.StandardBasicTypes; import org.hibernate.type.Type; /** * @author tiwe * */ public class ExtendedDerbyDialect extends DerbyDialect { private static final CastFunction castFunction = new CastFunction() { @Override public String render(Type columnType, List args, SessionFactoryImplementor factory) { if (args.get(1).equals("string")) { return super.render(columnType, Arrays.<Object>asList("char(" + args.get(0) + ")", args.get(1)), factory); } else { return super.render(columnType, args, factory); } } }; public ExtendedDerbyDialect() { registerFunction("concat", new VarArgsSQLFunction(StandardBasicTypes.STRING, "cast ((", "||", ") as varchar(128))")); registerFunction("cast", castFunction); } }