1 package org.apache.ojb.broker.accesslayer.conversions; 2 3 /* Copyright 2002-2005 The Apache Software Foundation 4 * 5 * Licensed under the Apache License, Version 2.0 (the "License"); 6 * you may not use this file except in compliance with the License. 7 * You may obtain a copy of the License at 8 * 9 * http://www.apache.org/licenses/LICENSE-2.0 10 * 11 * Unless required by applicable law or agreed to in writing, software 12 * distributed under the License is distributed on an "AS IS" BASIS, 13 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 14 * See the License for the specific language governing permissions and 15 * limitations under the License. 16 */ 17 18 /** 19 * this implementation of the FieldConversion interface converts 20 * between blank strings ("") and nulls values in the rdbms. This is to make 21 * oracle and SQL Server compatible, as Oracle stores blank strings as nulls, 22 * which makes comparisons on re-materialized objects problematic. 23 * @author Matthew Baird 24 * @version $Id: BlankString2NullFieldConversion.java,v 1.1 2007-08-24 22:17:31 ewestfal Exp $ 25 */ 26 public class BlankString2NullFieldConversion implements FieldConversion 27 { 28 29 /* 30 * @see FieldConversion#javaToSql(Object) 31 */ 32 public Object javaToSql(Object source) 33 { 34 if (source instanceof String) 35 { 36 if (((String)source).trim().length() == 0) 37 return null; 38 } 39 return source; 40 } 41 42 /* 43 * @see FieldConversion#sqlToJava(Object) 44 */ 45 public Object sqlToJava(Object source) 46 { 47 return source; 48 } 49 50 }