Ejemplo n.º 1
0
 public function getAttribute($attribute, &$source = null, $func = 'PDO::getAttribute', &$last_error = null)
 {
     switch ($attribute) {
         case PDO::ATTR_AUTOCOMMIT:
             return $this->autocommit;
             break;
         case PDO::ATTR_PREFETCH:
             break;
         case PDO::ATTR_CLIENT_VERSION:
             return oci_server_version($this->link);
             break;
         case PDO::ATTR_SERVER_VERSION:
             $ver = oci_server_version($this->link);
             if (preg_match('/([0-9]+\\.[0-9]+\\.[0-9]+\\.[0-9]+\\.[0-9]+)/', $ver, $match)) {
                 return $match[1];
             }
             return $ver;
             break;
         case PDO::ATTR_SERVER_INFO:
             return oci_server_version($this->link);
             break;
         default:
             return parent::getAttribute($attribute, $source, $func, $last_error);
             break;
     }
 }
Ejemplo n.º 2
0
 /**
  * {@inheritdoc}
  *
  * @throws \UnexpectedValueException if the version string returned by the database server
  *                                   does not contain a parsable version number.
  */
 public function getServerVersion()
 {
     if (!preg_match('/\\s+(\\d+\\.\\d+\\.\\d+\\.\\d+\\.\\d+)\\s+/', oci_server_version($this->dbh), $version)) {
         throw new \UnexpectedValueException(sprintf('Unexpected database version string "%s". Cannot parse an appropriate version number from it. ' . 'Please report this database version string to the Doctrine team.', oci_server_version($this->dbh)));
     }
     return $version[1];
 }
 /**
  * Returns oracle version.
  *
  * @throws \UnexpectedValueException if the version string returned by the database server does not parsed
  * @return int Version number
  */
 public function getServerVersion()
 {
     $versionData = oci_server_version($this->dbh);
     if (!preg_match('/\\s+(\\d+\\.\\d+\\.\\d+\\.\\d+\\.\\d+)\\s+/', $versionData, $version)) {
         throw new \UnexpectedValueException(__('Unexpected database version string "{0}" that not parsed.', $versionData));
     }
     return $version[1];
 }
Ejemplo n.º 4
0
 /**
 +----------------------------------------------------------
 * 连接数据库方法
 +----------------------------------------------------------
 * @access public
 +----------------------------------------------------------
 * @throws ThinkExecption
 +----------------------------------------------------------
 */
 public function connect($config = '', $linkNum = 0)
 {
     if (!isset($this->linkID[$linkNum])) {
         if (empty($config)) {
             $config = $this->config;
         }
         $conn = $this->pconnect ? 'oci_pconnect' : 'oci_new_connect';
         $this->linkID[$linkNum] = $conn($config['username'], $config['password'], "//{$config['hostname']}:{$config['hostport']}/{$config['database']}");
         //modify by wyfeng at 2008.12.19
         if (!$this->linkID[$linkNum]) {
             $error = $this->error(false);
             throw_exception($error["message"], '', $error["code"]);
             return false;
         }
         $this->dbVersion = oci_server_version($this->linkID[$linkNum]);
         // 标记连接成功
         $this->connected = true;
         //注销数据库安全信息
         if (1 != C('DB_DEPLOY_TYPE')) {
             unset($this->config);
         }
     }
     return $this->linkID[$linkNum];
 }
Ejemplo n.º 5
0
	/**
	* Version information about used database
	* @param bool $raw if true, only return the fetched sql_server_version
	* @return string sql server version
	*/
	function sql_server_info($raw = false) {
		$this->sql_server_version = @oci_server_version($this->connect);

		return $this->sql_server_version;
	}
Ejemplo n.º 6
0
 public function getServerVersion()
 {
     set_error_handler(static::getErrorHandler());
     $serverVersion = oci_server_version($this->resource);
     restore_error_handler();
     return $serverVersion;
 }
Ejemplo n.º 7
0
 /**
  * @return string Version information from the database
  */
 function getServerVersion()
 {
     //better version number, fallback on driver
     $rset = $this->doQuery('SELECT version FROM product_component_version WHERE UPPER(product) LIKE \'ORACLE DATABASE%\'');
     if (!($row = $rset->fetchRow())) {
         return oci_server_version($this->mConn);
     }
     return $row['version'];
 }
Ejemplo n.º 8
0
 /**
  * @return array|mixed
  */
 public function getDbInfo()
 {
     $arrReturn = array();
     $arrReturn["dbdriver"] = "oci8-oracle-extension";
     $arrReturn["dbserver"] = oci_server_version($this->linkDB);
     $arrReturn["dbclient"] = function_exists("oci_client_version") ? oci_client_version($this->linkDB) : "";
     return $arrReturn;
 }
 /**
  * Version number query string
  *
  * @access  protected
  * @return  string
  */
 protected function _version()
 {
     return oci_server_version($this->conn_id);
 }
Ejemplo n.º 10
0
function versionOracle()
{
    ///////////////////////
    ///////////////////////
    //////////////////////
    // TODO EN PDO
    $conn = oci_connect('scott', 'tiger', '10.0.220.100:1521/ORAPROF');
    $version = oci_server_version($conn);
    oci_close($conn);
    return $version;
}
Ejemplo n.º 11
0
 public function version()
 {
     if (!empty($this->connect)) {
         return oci_server_version($this->connect);
     } else {
         return false;
     }
 }
Ejemplo n.º 12
0
 /**
  * 获取服务器信息
  *
  * @return string 服务器信息
  */
 public function server_info()
 {
     return oci_server_version($this->db_link);
 }
Ejemplo n.º 13
0
 public function getDbInfo()
 {
     return array("Server version" => @oci_server_version($this->database), "Express" => $this->isExpress());
 }
Ejemplo n.º 14
0
 function php_sql()
 {
     $get_version = explode("-", oci_server_version($this->dbh));
     return "ENV: php " . phpversion() . "[Oracle " . $get_version[0] . "]";
 }
Ejemplo n.º 15
0
 function ServerInfo()
 {
     $arr['compat'] = $this->GetOne('select value from sys.database_compatible_level');
     $arr['description'] = @oci_server_version($this->_connectionID);
     $arr['version'] = ADOConnection::_findvers($arr['description']);
     return $arr;
 }
Ejemplo n.º 16
0
 /**
  * @return string Version information from the database
  */
 function getServerVersion()
 {
     return oci_server_version($this->mConn);
 }
Ejemplo n.º 17
0
//var_dump(get_loaded_extensions());
if (!extension_loaded("oci8")) {
    die("Extenstion oci8 is not loaded");
}
$db = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.99.100)(PORT = 49161)))(CONNECT_DATA=(SID=XE)))";
$username = "******";
$password = "******";
if ($vcap_service_env = getenv("VCAP_SERVICES")) {
    $vcap = json_decode($vcap_service_env, true);
    $userProvidedTypes = !empty($vcap['user-provided']) ? $vcap['user-provided'] : array();
    foreach ($userProvidedTypes as $userProvided) {
        if (stripos($userProvided['name'], 'oracle-11-docker') !== false) {
            $credentials = $userProvided['credentials'];
            $db = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)";
            $db .= "(HOST =" . $credentials['host'] . " )(PORT = " . $credentials['port'] . ")))";
            $db .= "(CONNECT_DATA=(SID=" . $credentials['sid'] . ")))";
            $username = $credentials['username'];
            $password = $credentials['password'];
            break;
        }
    }
}
//Simple connexion test
$oci_connect = oci_connect($username, $password, $db);
if (!$oci_connect) {
    $e = oci_error();
    die(print_r($e));
}
echo "Connected to Oracle Using OCI8" . "<br />";
echo "Server Version: " . oci_server_version($oci_connect);
Ejemplo n.º 18
0
 /**
  * Returns database server info array
  * @return array Array containing 'description' and 'version' info
  */
 public function get_server_info()
 {
     static $info = null;
     // TODO: move to real object property
     if (is_null($info)) {
         $this->query_start("--oci_server_version()", null, SQL_QUERY_AUX);
         $description = oci_server_version($this->oci);
         $this->query_end(true);
         preg_match('/(\\d+\\.)+\\d+/', $description, $matches);
         $info = array('description' => $description, 'version' => $matches[0]);
     }
     return $info;
 }
 function version()
 {
     return oci_server_version($this->link);
 }
Ejemplo n.º 20
0
 /**
  * Database version number.
  *
  * @return string
  */
 public function version()
 {
     if (isset($this->data_cache['version'])) {
         return $this->data_cache['version'];
     }
     if (!$this->conn_id or ($version_string = oci_server_version($this->conn_id)) === false) {
         return false;
     } elseif (preg_match('#Release\\s(\\d+(?:\\.\\d+)+)#', $version_string, $match)) {
         return $this->data_cache['version'] = $match[1];
     }
     return false;
 }
Ejemplo n.º 21
0
function PMA_DBI_server_version($link)
{
    return oci_server_version($link);
    //return oci_field_flags($result, $i);
}
Ejemplo n.º 22
0
 /**
  * Database version number
  *
  * @return	string
  */
 public function version()
 {
     return isset($this->data_cache['version']) ? $this->data_cache['version'] : ($this->data_cache['version'] = oci_server_version($this->conn_id));
 }
Ejemplo n.º 23
0
 public function ServerVer()
 {
     if (is_resource($this->conn_handle)) {
         return @oci_server_version($this->conn_handle);
     } else {
         return false;
     }
 }
Ejemplo n.º 24
0
 /**
  * Retrieve server version in PHP style
  *
  * @return string
  */
 public function getServerVersion()
 {
     $this->_connect();
     $version = oci_server_version($this->_connection);
     if ($version !== false) {
         $matches = null;
         if (preg_match('/((?:[0-9]{1,2}\\.){1,3}[0-9]{1,2})/', $version, $matches)) {
             return $matches[1];
         } else {
             return null;
         }
     } else {
         return null;
     }
 }
Ejemplo n.º 25
0
 /**
  * Returns the server version string.
  *
  * @return  string
  * @access  public
  * @author  Thorsten Rinne <*****@*****.**>
  * @since   2005-09-20
  */
 public function server_version()
 {
     return oci_server_version($this->conn);
 }
Ejemplo n.º 26
0
 /**
  * Database version number
  *
  * @return	string
  */
 public function version()
 {
     if (isset($this->data_cache['version'])) {
         return $this->data_cache['version'];
     }
     if (!$this->conn_id or ($version = oci_server_version($this->conn_id)) === FALSE) {
         return FALSE;
     }
     return $this->data_cache['version'] = $version;
 }
Ejemplo n.º 27
0
 /**
  * Retrieve a database connection attribute
  *
  * @param integer $attribute
  * @return mixed
  */
 public function getAttribute($attribute)
 {
     if ($attribute === PDO::ATTR_SERVER_VERSION && !isset($this->options[$attribute])) {
         return $this->options[$attribute] = oci_server_version($this->dbh);
     }
     if (isset($this->options[$attribute])) {
         return $this->options[$attribute];
     }
     return null;
 }