content: /*
   * Copyright (C) 2012-2023 52°North Spatial Information Research GmbH
   *
   * This program is free software; you can redistribute it and/or modify it
   * under the terms of the GNU General Public License version 2 as published
   * by the Free Software Foundation.
   *
   * If the program is linked with libraries which are licensed under one of
   * the following licenses, the combination of the program with the linked
   * library is not considered a "derivative work" of the program:
   *
   *     - Apache License, version 2.0
   *     - Apache Software License, version 1.0
   *     - GNU Lesser General Public License, version 3
   *     - Mozilla Public License, versions 1.0, 1.1 and 2.0
   *     - Common Development and Distribution License (CDDL), version 1.0
   *
   * Therefore the distribution of the program linked with libraries licensed
   * under the aforementioned licenses, is permitted by the copyright holders
   * if the distribution is compliant with both the GNU General Public
   * License version 2 and the aforementioned licenses.
   *
   * This program 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 General
   * Public License for more details.
   */
  package org.n52.sos.ds.datasource;
  
  import java.lang.reflect.InvocationHandler;
  import java.lang.reflect.Method;
  import java.lang.reflect.Proxy;
  import java.sql.Connection;
  
  import org.geolatte.geom.codec.db.oracle.ConnectionFinder;
  
  import com.mchange.v2.c3p0.C3P0ProxyConnection;
  import com.zaxxer.hikari.pool.ProxyConnection;
  
  import oracle.jdbc.OracleConnection;
  
  /**
   * @since 4.0.0
   *
   */
  public class OracleConnectionFinder implements ConnectionFinder {
      private static final long serialVersionUID = 1L;
  
      public static Connection getRawConnection(Connection con) {
          return con;
      }
  
      @Override
      public OracleConnection find(Connection con) {
          Connection conn = con;
          if (con instanceof Proxy) {
              try {
                  InvocationHandler handler = Proxy.getInvocationHandler(con);
                  conn = (Connection) handler.invoke(con, con.getClass().getMethod("getWrappedObject"), null);
              } catch (Throwable e) {
                  throw new RuntimeException(e.getMessage());
              }
          }
  
          if (conn instanceof OracleConnection) {
              return (OracleConnection) conn;
          }
  
          if (conn instanceof C3P0ProxyConnection) {
              C3P0ProxyConnection cpCon = (C3P0ProxyConnection) conn;
              Connection unwrappedCon = null;
              try {
                  Method rawConnectionMethod =
                          getClass().getMethod("getRawConnection", new Class[] { Connection.class });
                  unwrappedCon = (Connection) cpCon.rawConnectionOperation(rawConnectionMethod, null,
                          new Object[] { C3P0ProxyConnection.RAW_CONNECTION });
              } catch (Throwable ex) {
                  throw new RuntimeException(ex.getMessage());
              }
              if (unwrappedCon != null && unwrappedCon instanceof OracleConnection) {
                  return (OracleConnection) unwrappedCon;
              }
          }
  
          if (conn instanceof ProxyConnection) {
              ProxyConnection cpCon = (ProxyConnection) conn;
              Connection unwrappedCon = null;
              try {
                  unwrappedCon = cpCon.unwrap(ProxyConnection.class);
                  // Field delegate = ((HikariProxyConnection)
                  // con).getClass().getSuperclass().getDeclaredField("delegate");
                  // delegate.setAccessible(true);
                  // return (Connection) delegate.get(con);
              } catch (Throwable ex) {
                  throw new RuntimeException(ex.getMessage());
              }
              if (unwrappedCon != null && unwrappedCon instanceof OracleConnection) {
                  return (OracleConnection) unwrappedCon;
              }
          }
          throw new RuntimeException("Couldn't get Oracle Connection in OracleConnectionFinder");
      }
  }
  