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}