/**
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library. If not, see <http://www.gnu.org/licenses/>.
*
**/
package lucee.runtime.query.caster;
import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.TimeZone;
import lucee.commons.date.JREDateTimeUtil;
import lucee.commons.lang.ExceptionUtil;
import lucee.runtime.exp.PageException;
import lucee.runtime.reflection.Reflector;
import lucee.runtime.type.dt.DateTimeImpl;
public class OracleTimestampLTZ implements Cast {
@Override
public Object toCFType(TimeZone tz, ResultSet rst, int columnIndex) throws SQLException, IOException {
Object o = rst.getObject(columnIndex);
if(o==null) return null;
// we do not have oracle.sql.TIMESTAMPTZ in the core, so we need reflection for this
try{
Timestamp ts=(Timestamp) Reflector.callMethod(o, "timestampValue",
new Object[]{
rst.getStatement().getConnection()
,JREDateTimeUtil.getThreadCalendar(tz)});
return new DateTimeImpl(ts.getTime(),false);
}
catch(PageException pe){
throw ExceptionUtil.toIOException(pe);
}
}
}