/*
 *    GeoTools - The Open Source Java GIS Toolkit
 *    http://geotools.org
 *
 *    (C) 2002-2008, Open Source Geospatial Foundation (OSGeo)
 *
 *    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;
 *    version 2.1 of the License.
 *
 *    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.
 */
package org.geotools.data.oracle;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;

import org.geotools.jdbc.JDBCDataStore;

import com.vividsolutions.jts.geom.Geometry;
import com.vividsolutions.jts.geom.GeometryFactory;

/**
 * This dialect uses the Oracle 10 specific sdoapi.jar API, which is touted to
 * be faster than then standard JGeometry one. Benchmarking shows that it's no
 * match for the standard GeometryConverter thought, and only adds a nasty
 * dependency that cannot be redistributed, so it lays here inactive only
 * for historical purposes. Un comment here and in OracleDialect if you 
 * want to try it out.
 * @author Andrea Aime
 */
class SDOOracleDialect extends OracleDialect {

    protected SDOOracleDialect(JDBCDataStore dataStore) {
        super(dataStore);
    }

    @Override
    Geometry readGeometry(ResultSet rs, String column, GeometryFactory factory, Connection cx)
            throws IOException, SQLException {
        return readGeometry(rs.getObject(column), factory, cx);
    }

    @Override
    Geometry readGeometry(ResultSet rs, int column, GeometryFactory factory, Connection cx)
            throws IOException, SQLException {
        return readGeometry(rs.getObject(column), factory, cx);
    }

    public Geometry readGeometry(Object object, GeometryFactory factory, Connection cx) throws SQLException {
        if(object == null)
            return null;
        
//        JGeometry geom = JGeometry.load((oracle.sql.STRUCT) object);
//        return JGeometryConverter.toJTS(factory, geom);
        throw new UnsupportedOperationException("Due to licensing issues the code depending to " +
           "JGeometry has been commented out");
    }

    @Override
    public void setGeometryValue(Geometry g, int srid, Class binding, PreparedStatement ps,
            int column) throws SQLException {
        // Handle the null geometry case.
        // Surprisingly, using setNull(column, Types.OTHER) does not work...
        if (g == null) {
            ps.setNull(column, Types.STRUCT, "MDSYS.SDO_GEOMETRY");
            return;
        }
        
        throw new UnsupportedOperationException("Due to licensing issues the code depending to " +
        "JGeometry has been commented out");

//        OracleConnection ocx = unwrapConnection(ps.getConnection());
//
//        JGeometry geom = JGeometryConverter.toJGeometry(g, srid);
//        STRUCT s = JGeometry.store(geom, ocx);
//        ps.setObject(column, s);
//
//        if (LOGGER.isLoggable(Level.FINE)) {
//            String sdo = SDOSqlDumper.toSDOGeom(g, srid);
//            LOGGER.fine("Setting paramtetr " + column + " as " + sdo);
//        }
    }

}