001/**
002 *
003 * Copyright (c) 2014, the Railo Company Ltd. All rights reserved.
004 *
005 * This library is free software; you can redistribute it and/or
006 * modify it under the terms of the GNU Lesser General Public
007 * License as published by the Free Software Foundation; either 
008 * version 2.1 of the License, or (at your option) any later version.
009 * 
010 * This library is distributed in the hope that it will be useful,
011 * but WITHOUT ANY WARRANTY; without even the implied warranty of
012 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
013 * Lesser General Public License for more details.
014 * 
015 * You should have received a copy of the GNU Lesser General Public 
016 * License along with this library.  If not, see <http://www.gnu.org/licenses/>.
017 * 
018 **/
019package lucee.runtime.query.caster;
020
021import java.sql.ResultSet;
022import java.sql.SQLException;
023import java.sql.Types;
024import java.util.TimeZone;
025
026public class OtherCast implements Cast {
027
028
029        @Override
030        public Object toCFType(TimeZone tz, int type, ResultSet rst, int columnIndex) throws SQLException {
031                if(type!=Types.SMALLINT) return rst.getObject(columnIndex);
032                
033                
034                try{
035                        return rst.getObject(columnIndex);
036                }
037                // workaround for MSSQL Driver, in some situation getObject throws a cast exception using getString avoids this
038                catch(SQLException e){
039                        try{
040                                return rst.getString(columnIndex);
041                        }
042                        catch(SQLException e2){
043                                throw e;
044                        }
045                }
046        }
047
048}