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.io.IOException;
022import java.sql.ResultSet;
023import java.sql.SQLException;
024
025import lucee.commons.lang.ExceptionUtil;
026import oracle.sql.OPAQUE;
027
028public class _OracleOpaqueCast {
029        public static Object toCFType(ResultSet rst, int columnIndex) throws SQLException, IOException {
030                validateClasses();
031                
032                Object o = rst.getObject(columnIndex);
033                if(o==null) return null;
034                
035                OPAQUE opaque = ((oracle.sql.OPAQUE)o);
036                if(opaque.getSQLTypeName().equals("SYS.XMLTYPE")){
037                        return oracle.xdb.XMLType.createXML(opaque).getStringVal();
038                }
039                return o;
040        }
041
042        private static void validateClasses() throws IOException {
043                try {
044                        if(oracle.xdb.XMLType.class==null);
045                        if(oracle.xml.parser.v2.XMLParseException.class==null);
046                }
047                catch(Throwable t) {
048                        ExceptionUtil.rethrowIfNecessary(t);
049                        throw new IOException("the xdb.jar/xmlparserv2.jar is missing, please download at " +
050                                        "http://www.oracle.com/technology/tech/xml/xdk/xdk_java.html and copy it into the lucee lib directory");
051                }
052        }
053}