public function initialize(DataSourceHandler $handler, DataSourceMetaData $datasource)
{
if (!isset($datasource->database)) {
throw new IllegalStateException(t('Entry name from tnsnames.ora is not provided'));
}
$connection = OCIImplHelper::oci_connect($datasource->username, $datasource->password, $datasource->database);
$sql = array('ALTER SESSION SET NLS_SORT=ASCII7_AI', 'ALTER SESSION SET NLS_COMP=LINGUISTIC');
$statementExecutor = new OCIExecuteStatementImpl();
$statementExecutor->execute($handler, $connection, $sql);
return $connection;
}
public function initialize(DataSourceHandler $handler, DataSourceMetaData $datasource) {
if (!isset($datasource->database)) {
throw new IllegalStateException(t('Entry name from tnsnames.ora is not provided'));
}
$connection = OCIImplHelper::oci_connect($datasource->username, $datasource->password, $datasource->database);
$oracleDateTimeFormat = $handler->getExtension('formatDateValue')->prepareFormat(DateTimeDataTypeHandler::$FORMAT_DEFAULT, FALSE);
$oracleDateTimeTZFormat = $handler->getExtension('formatDateValue')->prepareFormat(DateTimeDataTypeHandler::$FORMAT_DEFAULT, TRUE);
$sql = array(
'ALTER SESSION SET NLS_SORT=ASCII7_AI',
'ALTER SESSION SET NLS_COMP=LINGUISTIC',
"ALTER SESSION SET NLS_DATE_FORMAT='$oracleDateTimeFormat'",
"ALTER SESSION SET NLS_TIMESTAMP_FORMAT='$oracleDateTimeFormat'",
"ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT='$oracleDateTimeTZFormat'");
$statementExecutor = new OCIExecuteStatementImpl();
$statementExecutor->execute($handler, $connection, $sql);
return $connection;
}
