connectivity/source/drivers/ado/ADatabaseMetaData.cxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: ADatabaseMetaData.cxx,v $
  10  * $Revision: 1.23 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 // MARKER(update_precomp.py): autogen include statement, do not remove
  32 #include "precompiled_connectivity.hxx"
  33 #include "ado/ADatabaseMetaData.hxx"
  34 #include "ado/ADatabaseMetaDataResultSet.hxx"
  35 #include <com/sun/star/sdbc/DataType.hpp>
  36 #include <com/sun/star/sdbc/ResultSetType.hpp>
  37 #include <com/sun/star/sdbc/ResultSetConcurrency.hpp>
  38 #include <com/sun/star/sdbc/TransactionIsolation.hpp>
  39 #include "ado/AConnection.hxx"
  40 #include "ado/adoimp.hxx"
  41 #include "FDatabaseMetaDataResultSet.hxx"
  42 #include <comphelper/types.hxx>
  43 #include <connectivity/dbexception.hxx>
  44
  45 using namespace ::comphelper;
  46
  47 using namespace connectivity;
  48 using namespace connectivity::ado;
  49 using namespace com::sun::star::uno;
  50 using namespace com::sun::star::lang;
  51 using namespace com::sun::star::beans;
  52 using namespace com::sun::star::sdbc;
  53
  54
  55 //      using namespace connectivity;
  56
  57 ODatabaseMetaData::ODatabaseMetaData(OConnection* _pCon)
  58     : ::connectivity::ODatabaseMetaDataBase(_pCon,_pCon->getConnectionInfo())
  59     ,m_pADOConnection(_pCon->getConnection())
  60     ,m_pConnection(_pCon)
  61 {
  62 }
  63 // -------------------------------------------------------------------------
  64 sal_Int32 ODatabaseMetaData::getInt32Property(const ::rtl::OUString& _aProperty)  throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException)
  65 {
  66     connectivity::ado::WpADOProperties aProps(m_pADOConnection->get_Properties());
  67     //  ADOS::ThrowException(*m_pADOConnection,*this);
  68     OSL_ENSURE(aProps.IsValid(),"There are no properties at the connection");
  69     ADO_PROP(_aProperty);
  70     sal_Int32 nValue(0);
  71     if(!aVar.isNull() && !aVar.isEmpty())
  72         nValue = aVar;
  73     return nValue;
  74 }
  75
  76 // -------------------------------------------------------------------------
  77 sal_Bool ODatabaseMetaData::getBoolProperty(const ::rtl::OUString& _aProperty)  throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException)
  78 {
  79     connectivity::ado::WpADOProperties aProps(m_pADOConnection->get_Properties());
  80     ADOS::ThrowException(*m_pADOConnection,*this);
  81     OSL_ENSURE(aProps.IsValid(),"There are no properties at the connection");
  82     ADO_PROP(_aProperty);
  83     return (!aVar.isNull() && !aVar.isEmpty() ? aVar.getBool() : sal_False);
  84 }
  85 // -------------------------------------------------------------------------
  86 ::rtl::OUString ODatabaseMetaData::getStringProperty(const ::rtl::OUString& _aProperty)  throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException)
  87 {
  88     connectivity::ado::WpADOProperties aProps(m_pADOConnection->get_Properties());
  89     ADOS::ThrowException(*m_pADOConnection,*this);
  90     OSL_ENSURE(aProps.IsValid(),"There are no properties at the connection");
  91
  92     ADO_PROP(_aProperty);
  93     ::rtl::OUString aValue;
  94     if(!aVar.isNull() && !aVar.isEmpty() && aVar.getType() == VT_BSTR)
  95         aValue = aVar;
  96
  97     return aValue;
  98 }
  99 // -------------------------------------------------------------------------
 100 Reference< XResultSet > ODatabaseMetaData::impl_getTypeInfo_throw(  )
 101 {
 102     ADORecordset *pRecordset = m_pADOConnection->getTypeInfo();
 103     //  ADOS::ThrowException(*m_pADOConnection,*this);
 104
 105     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(pRecordset);
 106     pResult->setTypeInfoMap(ADOS::isJetEngine(m_pConnection->getEngineType()));
 107     Reference< XResultSet > xRef = pResult;
 108     return xRef;
 109 }
 110 // -------------------------------------------------------------------------
 111 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getCatalogs(  ) throw(SQLException, RuntimeException)
 112 {
 113     OLEVariant  vtEmpty;
 114     vtEmpty.setNoArg();
 115
 116     ADORecordset *pRecordset = NULL;
 117     m_pADOConnection->OpenSchema(adSchemaCatalogs,vtEmpty,vtEmpty,&pRecordset);
 118     ADOS::ThrowException(*m_pADOConnection,*this);
 119
 120     Reference< XResultSet > xRef;
 121
 122     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(pRecordset);
 123     pResult->setCatalogsMap();
 124     xRef = pResult;
 125
 126     return xRef;
 127 }
 128 // -------------------------------------------------------------------------
 129 ::rtl::OUString ODatabaseMetaData::impl_getCatalogSeparator_throw(  )
 130 {
 131     return getLiteral(DBLITERAL_CATALOG_SEPARATOR);
 132 }
 133 // -------------------------------------------------------------------------
 134 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getSchemas(  ) throw(SQLException, RuntimeException)
 135 {
 136     OLEVariant  vtEmpty;
 137     vtEmpty.setNoArg();
 138
 139     ADORecordset *pRecordset = NULL;
 140     m_pADOConnection->OpenSchema(adSchemaSchemata,vtEmpty,vtEmpty,&pRecordset);
 141     ADOS::ThrowException(*m_pADOConnection,*this);
 142
 143     Reference< XResultSet > xRef;
 144
 145     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(pRecordset);
 146     pResult->setSchemasMap();
 147     xRef = pResult;
 148     return xRef;
 149 }
 150 // -------------------------------------------------------------------------
 151 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getColumnPrivileges(
 152     const Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table,
 153     const ::rtl::OUString& columnNamePattern ) throw(SQLException, RuntimeException)
 154 {
 155     ADORecordset *pRecordset = m_pADOConnection->getColumnPrivileges(catalog,schema,table,columnNamePattern);
 156     ADOS::ThrowException(*m_pADOConnection,*this);
 157
 158     Reference< XResultSet > xRef;
 159
 160     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(pRecordset);
 161     pResult->setColumnPrivilegesMap();
 162     xRef = pResult;
 163     return xRef;
 164 }
 165 // -------------------------------------------------------------------------
 166 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getColumns(
 167     const Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& tableNamePattern,
 168     const ::rtl::OUString& columnNamePattern ) throw(SQLException, RuntimeException)
 169 {
 170     ADORecordset *pRecordset = m_pADOConnection->getColumns(catalog,schemaPattern,tableNamePattern,columnNamePattern);
 171     ADOS::ThrowException(*m_pADOConnection,*this);
 172
 173     Reference< XResultSet > xRef;
 174
 175     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(pRecordset);
 176     pResult->setColumnsMap();
 177     xRef = pResult;
 178
 179     return xRef;
 180 }
 181 // -------------------------------------------------------------------------
 182 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getTables(
 183     const Any& catalog, const ::rtl::OUString& schemaPattern,
 184     const ::rtl::OUString& tableNamePattern, const Sequence< ::rtl::OUString >& types ) throw(SQLException, RuntimeException)
 185 {
 186     ADORecordset *pRecordset = m_pADOConnection->getTables(catalog,schemaPattern,tableNamePattern,types);
 187     ADOS::ThrowException(*m_pADOConnection,*this);
 188
 189     Reference< XResultSet > xRef;
 190
 191     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(pRecordset);
 192     pResult->setTablesMap();
 193     xRef = pResult;
 194
 195     return xRef;
 196 }
 197 // -------------------------------------------------------------------------
 198 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getProcedureColumns(
 199     const Any& catalog, const ::rtl::OUString& schemaPattern,
 200     const ::rtl::OUString& procedureNamePattern, const ::rtl::OUString& columnNamePattern ) throw(SQLException, RuntimeException)
 201 {
 202     ADORecordset *pRecordset = m_pADOConnection->getProcedureColumns(catalog,schemaPattern,procedureNamePattern,columnNamePattern);
 203     ADOS::ThrowException(*m_pADOConnection,*this);
 204
 205     Reference< XResultSet > xRef;
 206
 207     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(pRecordset);
 208     pResult->setProcedureColumnsMap();
 209     xRef = pResult;
 210
 211     return xRef;
 212 }
 213 // -------------------------------------------------------------------------
 214 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getProcedures(
 215     const Any& catalog, const ::rtl::OUString& schemaPattern,
 216     const ::rtl::OUString& procedureNamePattern ) throw(SQLException, RuntimeException)
 217 {
 218     // Create elements used in the array
 219     ADORecordset *pRecordset = m_pADOConnection->getProcedures(catalog,schemaPattern,procedureNamePattern);
 220     ADOS::ThrowException(*m_pADOConnection,*this);
 221
 222     Reference< XResultSet > xRef;
 223
 224     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(pRecordset);
 225     pResult->setProceduresMap();
 226     xRef = pResult;
 227
 228     return xRef;
 229 }
 230 // -------------------------------------------------------------------------
 231 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxBinaryLiteralLength(  ) throw(SQLException, RuntimeException)
 232 {
 233     return getMaxSize(DBLITERAL_BINARY_LITERAL);
 234 }
 235 // -------------------------------------------------------------------------
 236 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxRowSize(  ) throw(SQLException, RuntimeException)
 237 {
 238     return getInt32Property(::rtl::OUString::createFromAscii("Maximum Row Size"));
 239 }
 240 // -------------------------------------------------------------------------
 241 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxCatalogNameLength(  ) throw(SQLException, RuntimeException)
 242 {
 243     return getMaxSize(DBLITERAL_CATALOG_NAME);
 244 }
 245 // -------------------------------------------------------------------------
 246 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxCharLiteralLength(  ) throw(SQLException, RuntimeException)
 247 {
 248     return getMaxSize(DBLITERAL_CHAR_LITERAL);
 249 }
 250 // -------------------------------------------------------------------------
 251 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnNameLength(  ) throw(SQLException, RuntimeException)
 252 {
 253     return getMaxSize(DBLITERAL_COLUMN_NAME);
 254 }
 255 // -------------------------------------------------------------------------
 256 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInIndex(  ) throw(SQLException, RuntimeException)
 257 {
 258     //  return getInt32Property(::rtl::OUString::createFromAscii("Max Columns in Index"));
 259     return 0;
 260 }
 261 // -------------------------------------------------------------------------
 262 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxCursorNameLength(  ) throw(SQLException, RuntimeException)
 263 {
 264     return getMaxSize(DBLITERAL_CURSOR_NAME);
 265 }
 266 // -------------------------------------------------------------------------
 267 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxConnections(  ) throw(SQLException, RuntimeException)
 268 {
 269     return getInt32Property(::rtl::OUString::createFromAscii("Active Sessions"));
 270 }
 271 // -------------------------------------------------------------------------
 272 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInTable(  ) throw(SQLException, RuntimeException)
 273 {
 274     return getInt32Property(::rtl::OUString::createFromAscii("Max Columns in Table"));
 275 }
 276 // -------------------------------------------------------------------------
 277 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxStatementLength(  ) throw(SQLException, RuntimeException)
 278 {
 279     return getMaxSize(DBLITERAL_TEXT_COMMAND);
 280 }
 281 // -------------------------------------------------------------------------
 282 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxTableNameLength(  ) throw(SQLException, RuntimeException)
 283 {
 284     return getMaxSize(DBLITERAL_TABLE_NAME);
 285 }
 286 // -------------------------------------------------------------------------
 287 sal_Int32 ODatabaseMetaData::impl_getMaxTablesInSelect_throw(  )
 288 {
 289     return getInt32Property(::rtl::OUString::createFromAscii("Maximum Tables in SELECT"));
 290 }
 291 // -------------------------------------------------------------------------
 292 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getExportedKeys(
 293     const Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table ) throw(SQLException, RuntimeException)
 294 {
 295     ADORecordset *pRecordset = m_pADOConnection->getExportedKeys(catalog,schema,table);
 296     ADOS::ThrowException(*m_pADOConnection,*this);
 297
 298     Reference< XResultSet > xRef;
 299     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(pRecordset);
 300     pResult->setCrossReferenceMap();
 301     xRef = pResult;
 302
 303     return xRef;
 304 }
 305 // -------------------------------------------------------------------------
 306 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getImportedKeys(
 307     const Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table ) throw(SQLException, RuntimeException)
 308 {
 309     ADORecordset *pRecordset = m_pADOConnection->getImportedKeys(catalog,schema,table);
 310     ADOS::ThrowException(*m_pADOConnection,*this);
 311
 312     Reference< XResultSet > xRef;
 313
 314     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(pRecordset);
 315     pResult->setCrossReferenceMap();
 316     xRef = pResult;
 317
 318     return xRef;
 319 }
 320 // -------------------------------------------------------------------------
 321 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getPrimaryKeys(
 322     const Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table ) throw(SQLException, RuntimeException)
 323 {
 324     ADORecordset *pRecordset = m_pADOConnection->getPrimaryKeys(catalog,schema,table);
 325     ADOS::ThrowException(*m_pADOConnection,*this);
 326
 327     Reference< XResultSet > xRef;
 328
 329     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(pRecordset);
 330     pResult->setPrimaryKeysMap();
 331     xRef = pResult;
 332
 333     return xRef;
 334 }
 335 // -------------------------------------------------------------------------
 336 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getIndexInfo(
 337     const Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table,
 338     sal_Bool unique, sal_Bool approximate ) throw(SQLException, RuntimeException)
 339 {
 340     ADORecordset *pRecordset = m_pADOConnection->getIndexInfo(catalog,schema,table,unique,approximate);
 341     ADOS::ThrowException(*m_pADOConnection,*this);
 342
 343     Reference< XResultSet > xRef;
 344
 345     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(pRecordset);
 346     pResult->setIndexInfoMap();
 347     xRef = pResult;
 348
 349     return xRef;
 350 }
 351 // -------------------------------------------------------------------------
 352 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getTablePrivileges(
 353     const Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& tableNamePattern ) throw(SQLException, RuntimeException)
 354 {
 355     Reference< XResultSet > xRef;
 356     if(!ADOS::isJetEngine(m_pConnection->getEngineType()))
 357     {   // the jet provider doesn't support this method
 358         // Create elements used in the array
 359
 360         ADORecordset *pRecordset = m_pADOConnection->getTablePrivileges(catalog,schemaPattern,tableNamePattern);
 361         ADOS::ThrowException(*m_pADOConnection,*this);
 362
 363         ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(pRecordset);
 364         pResult->setTablePrivilegesMap();
 365         xRef = pResult;
 366     }
 367     else
 368     {
 369         ::connectivity::ODatabaseMetaDataResultSet* pResult = new ::connectivity::ODatabaseMetaDataResultSet(::connectivity::ODatabaseMetaDataResultSet::eTablePrivileges);
 370         xRef = pResult;
 371         ::connectivity::ODatabaseMetaDataResultSet::ORows aRows;
 372         ::connectivity::ODatabaseMetaDataResultSet::ORow aRow(8);
 373         aRows.reserve(8);
 374
 375         aRow[0] = ::connectivity::ODatabaseMetaDataResultSet::getEmptyValue();
 376         aRow[1] = ::connectivity::ODatabaseMetaDataResultSet::getEmptyValue();
 377         aRow[2] = new ::connectivity::ORowSetValueDecorator(tableNamePattern);
 378         aRow[3] = ::connectivity::ODatabaseMetaDataResultSet::getEmptyValue();
 379         aRow[4] = ::connectivity::ODatabaseMetaDataResultSet::getEmptyValue();
 380         aRow[5] = new ::connectivity::ORowSetValueDecorator(getUserName());
 381         aRow[6] = ::connectivity::ODatabaseMetaDataResultSet::getSelectValue();
 382         aRow[7] = new ::connectivity::ORowSetValueDecorator(::rtl::OUString::createFromAscii("NO"));
 383
 384         aRows.push_back(aRow);
 385         aRow[6] = ::connectivity::ODatabaseMetaDataResultSet::getInsertValue();
 386         aRows.push_back(aRow);
 387         aRow[6] = ::connectivity::ODatabaseMetaDataResultSet::getDeleteValue();
 388         aRows.push_back(aRow);
 389         aRow[6] = ::connectivity::ODatabaseMetaDataResultSet::getUpdateValue();
 390         aRows.push_back(aRow);
 391         aRow[6] = ::connectivity::ODatabaseMetaDataResultSet::getCreateValue();
 392         aRows.push_back(aRow);
 393         aRow[6] = ::connectivity::ODatabaseMetaDataResultSet::getReadValue();
 394         aRows.push_back(aRow);
 395         aRow[6] = ::connectivity::ODatabaseMetaDataResultSet::getAlterValue();
 396         aRows.push_back(aRow);
 397         aRow[6] = ::connectivity::ODatabaseMetaDataResultSet::getDropValue();
 398         aRows.push_back(aRow);
 399         pResult->setRows(aRows);
 400     }
 401
 402     return xRef;
 403 }
 404 // -------------------------------------------------------------------------
 405 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getCrossReference(
 406     const Any& primaryCatalog, const ::rtl::OUString& primarySchema,
 407     const ::rtl::OUString& primaryTable, const Any& foreignCatalog,
 408     const ::rtl::OUString& foreignSchema, const ::rtl::OUString& foreignTable ) throw(SQLException, RuntimeException)
 409 {
 410     ADORecordset *pRecordset = m_pADOConnection->getCrossReference(primaryCatalog,primarySchema,primaryTable,foreignCatalog,foreignSchema,foreignTable);
 411     ADOS::ThrowException(*m_pADOConnection,*this);
 412
 413     Reference< XResultSet > xRef;
 414
 415     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(pRecordset);
 416     pResult->setCrossReferenceMap();
 417     xRef = pResult;
 418
 419     return xRef;
 420 }
 421 // -------------------------------------------------------------------------
 422 sal_Bool SAL_CALL ODatabaseMetaData::doesMaxRowSizeIncludeBlobs(  ) throw(SQLException, RuntimeException)
 423 {
 424     return getBoolProperty(::rtl::OUString::createFromAscii("Maximum Row Size Includes BLOB"));
 425 }
 426 // -------------------------------------------------------------------------
 427 sal_Bool SAL_CALL ODatabaseMetaData::storesLowerCaseQuotedIdentifiers(  ) throw(SQLException, RuntimeException)
 428 {
 429     return (getInt32Property(::rtl::OUString::createFromAscii("Identifier Case Sensitivity")) & DBPROPVAL_IC_LOWER) == DBPROPVAL_IC_LOWER ;
 430 }
 431 // -------------------------------------------------------------------------
 432 sal_Bool SAL_CALL ODatabaseMetaData::storesLowerCaseIdentifiers(  ) throw(SQLException, RuntimeException)
 433 {
 434     return (getInt32Property(::rtl::OUString::createFromAscii("Identifier Case Sensitivity")) & DBPROPVAL_IC_LOWER) == DBPROPVAL_IC_LOWER ;
 435 }
 436 // -------------------------------------------------------------------------
 437 sal_Bool ODatabaseMetaData::impl_storesMixedCaseQuotedIdentifiers_throw(  )
 438 {
 439     return (getInt32Property(::rtl::OUString::createFromAscii("Identifier Case Sensitivity")) & DBPROPVAL_IC_MIXED) == DBPROPVAL_IC_MIXED ;
 440 }
 441 // -------------------------------------------------------------------------
 442 sal_Bool SAL_CALL ODatabaseMetaData::storesMixedCaseIdentifiers(  ) throw(SQLException, RuntimeException)
 443 {
 444     return (getInt32Property(::rtl::OUString::createFromAscii("Identifier Case Sensitivity")) & DBPROPVAL_IC_MIXED) == DBPROPVAL_IC_MIXED ;
 445 }
 446 // -------------------------------------------------------------------------
 447 sal_Bool SAL_CALL ODatabaseMetaData::storesUpperCaseQuotedIdentifiers(  ) throw(SQLException, RuntimeException)
 448 {
 449     return (getInt32Property(::rtl::OUString::createFromAscii("Identifier Case Sensitivity")) & DBPROPVAL_IC_UPPER) == DBPROPVAL_IC_UPPER ;
 450 }
 451 // -------------------------------------------------------------------------
 452 sal_Bool SAL_CALL ODatabaseMetaData::storesUpperCaseIdentifiers(  ) throw(SQLException, RuntimeException)
 453 {
 454     return (getInt32Property(::rtl::OUString::createFromAscii("Identifier Case Sensitivity")) & DBPROPVAL_IC_UPPER) == DBPROPVAL_IC_UPPER ;
 455 }
 456 // -------------------------------------------------------------------------
 457 sal_Bool ODatabaseMetaData::impl_supportsAlterTableWithAddColumn_throw(  )
 458 {
 459     return sal_True;
 460 }
 461 // -------------------------------------------------------------------------
 462 sal_Bool ODatabaseMetaData::impl_supportsAlterTableWithDropColumn_throw(  )
 463 {
 464     return sal_True;
 465 }
 466 // -------------------------------------------------------------------------
 467 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxIndexLength(  ) throw(SQLException, RuntimeException)
 468 {
 469     return getInt32Property(::rtl::OUString::createFromAscii("Maximum Index Size"));
 470 }
 471 // -------------------------------------------------------------------------
 472 sal_Bool SAL_CALL ODatabaseMetaData::supportsNonNullableColumns(  ) throw(SQLException, RuntimeException)
 473 {
 474     return getInt32Property(::rtl::OUString::createFromAscii("NULL Concatenation Behavior")) == DBPROPVAL_CB_NON_NULL;
 475 }
 476 // -------------------------------------------------------------------------
 477 ::rtl::OUString SAL_CALL ODatabaseMetaData::getCatalogTerm(  ) throw(SQLException, RuntimeException)
 478 {
 479     return getStringProperty(::rtl::OUString::createFromAscii("Catalog Term"));
 480 }
 481 // -------------------------------------------------------------------------
 482 ::rtl::OUString ODatabaseMetaData::impl_getIdentifierQuoteString_throw(  )
 483 {
 484     return getLiteral(DBLITERAL_QUOTE_PREFIX);
 485
 486 }
 487 // -------------------------------------------------------------------------
 488 ::rtl::OUString SAL_CALL ODatabaseMetaData::getExtraNameCharacters(  ) throw(SQLException, RuntimeException)
 489 {
 490     //  return getStringProperty(::rtl::OUString::createFromAscii("Special Characters"));
 491     return ::rtl::OUString();
 492 }
 493 // -------------------------------------------------------------------------
 494 sal_Bool SAL_CALL ODatabaseMetaData::supportsDifferentTableCorrelationNames(  ) throw(SQLException, RuntimeException)
 495 {
 496     return isCapable(DBLITERAL_CORRELATION_NAME);
 497 }
 498 // -------------------------------------------------------------------------
 499 sal_Bool ODatabaseMetaData::impl_isCatalogAtStart_throw(  )
 500 {
 501     return getInt32Property(::rtl::OUString::createFromAscii("Catalog Location")) == DBPROPVAL_CL_START;
 502 }
 503 // -------------------------------------------------------------------------
 504 sal_Bool SAL_CALL ODatabaseMetaData::dataDefinitionIgnoredInTransactions(  ) throw(SQLException, RuntimeException)
 505 {
 506     return getInt32Property(::rtl::OUString::createFromAscii("Transaction DDL")) == DBPROPVAL_TC_DDL_IGNORE;
 507 }
 508 // -------------------------------------------------------------------------
 509 sal_Bool SAL_CALL ODatabaseMetaData::dataDefinitionCausesTransactionCommit(  ) throw(SQLException, RuntimeException)
 510 {
 511     return getInt32Property(::rtl::OUString::createFromAscii("Transaction DDL")) == DBPROPVAL_TC_DDL_COMMIT;
 512 }
 513 // -------------------------------------------------------------------------
 514 sal_Bool SAL_CALL ODatabaseMetaData::supportsDataManipulationTransactionsOnly(  ) throw(SQLException, RuntimeException)
 515 {
 516     return getInt32Property(::rtl::OUString::createFromAscii("Transaction DDL")) == DBPROPVAL_TC_DML;
 517 }
 518 // -------------------------------------------------------------------------
 519 sal_Bool SAL_CALL ODatabaseMetaData::supportsDataDefinitionAndDataManipulationTransactions(  ) throw(SQLException, RuntimeException)
 520 {
 521     return getInt32Property(::rtl::OUString::createFromAscii("Transaction DDL")) == DBPROPVAL_TC_ALL;
 522 }
 523 // -------------------------------------------------------------------------
 524 sal_Bool SAL_CALL ODatabaseMetaData::supportsPositionedDelete(  ) throw(SQLException, RuntimeException)
 525 {
 526     return sal_True;
 527 }
 528 // -------------------------------------------------------------------------
 529 sal_Bool SAL_CALL ODatabaseMetaData::supportsPositionedUpdate(  ) throw(SQLException, RuntimeException)
 530 {
 531     return sal_True;
 532 }
 533 // -------------------------------------------------------------------------
 534 sal_Bool SAL_CALL ODatabaseMetaData::supportsOpenStatementsAcrossRollback(  ) throw(SQLException, RuntimeException)
 535 {
 536     return getInt32Property(::rtl::OUString::createFromAscii("Prepare Abort Behavior")) == DBPROPVAL_CB_PRESERVE;
 537 }
 538 // -------------------------------------------------------------------------
 539 sal_Bool SAL_CALL ODatabaseMetaData::supportsOpenStatementsAcrossCommit(  ) throw(SQLException, RuntimeException)
 540 {
 541     return getInt32Property(::rtl::OUString::createFromAscii("Prepare Commit Behavior")) == DBPROPVAL_CB_PRESERVE;
 542 }
 543 // -------------------------------------------------------------------------
 544 sal_Bool SAL_CALL ODatabaseMetaData::supportsOpenCursorsAcrossCommit(  ) throw(SQLException, RuntimeException)
 545 {
 546     return (getInt32Property(::rtl::OUString::createFromAscii("Isolation Retention")) & DBPROPVAL_TR_COMMIT) == DBPROPVAL_TR_COMMIT;
 547 }
 548 // -------------------------------------------------------------------------
 549 sal_Bool SAL_CALL ODatabaseMetaData::supportsOpenCursorsAcrossRollback(  ) throw(SQLException, RuntimeException)
 550 {
 551     return (getInt32Property(::rtl::OUString::createFromAscii("Isolation Retention")) & DBPROPVAL_TR_ABORT) == DBPROPVAL_TR_ABORT;
 552 }
 553 // -------------------------------------------------------------------------
 554 sal_Bool SAL_CALL ODatabaseMetaData::supportsTransactionIsolationLevel( sal_Int32 level ) throw(SQLException, RuntimeException)
 555 {
 556     sal_Bool bValue(sal_False);
 557
 558     sal_Int32 nTxn = getInt32Property(::rtl::OUString::createFromAscii("Isolation Levels"));
 559     if(level == TransactionIsolation::NONE)
 560         bValue = sal_True;
 561     else if(level == TransactionIsolation::READ_UNCOMMITTED)
 562         bValue = (nTxn & DBPROPVAL_TI_READUNCOMMITTED) == DBPROPVAL_TI_READUNCOMMITTED;
 563     else if(level == TransactionIsolation::READ_COMMITTED)
 564         bValue = (nTxn & DBPROPVAL_TI_READCOMMITTED) == DBPROPVAL_TI_READCOMMITTED;
 565     else if(level == TransactionIsolation::REPEATABLE_READ)
 566         bValue = (nTxn & DBPROPVAL_TI_REPEATABLEREAD) == DBPROPVAL_TI_REPEATABLEREAD;
 567     else if(level == TransactionIsolation::SERIALIZABLE)
 568         bValue = (nTxn & DBPROPVAL_TI_SERIALIZABLE) == DBPROPVAL_TI_SERIALIZABLE;
 569
 570     return bValue;
 571 }
 572 // -------------------------------------------------------------------------
 573 sal_Bool ODatabaseMetaData::impl_supportsSchemasInDataManipulation_throw(  )
 574 {
 575     return (getInt32Property(::rtl::OUString::createFromAscii("Schema Usage")) & DBPROPVAL_SU_DML_STATEMENTS) == DBPROPVAL_SU_DML_STATEMENTS;
 576 }
 577 // -------------------------------------------------------------------------
 578 sal_Bool SAL_CALL ODatabaseMetaData::supportsANSI92FullSQL(  ) throw(SQLException, RuntimeException)
 579 {
 580     sal_Int32 nProp = getInt32Property(::rtl::OUString::createFromAscii("SQL Support"));
 581     return (nProp == 512) || ((nProp & DBPROPVAL_SQL_ANSI92_FULL) == DBPROPVAL_SQL_ANSI92_FULL);
 582 }
 583 // -------------------------------------------------------------------------
 584 sal_Bool SAL_CALL ODatabaseMetaData::supportsANSI92EntryLevelSQL(  ) throw(SQLException, RuntimeException)
 585 {
 586     sal_Int32 nProp = getInt32Property(::rtl::OUString::createFromAscii("SQL Support"));
 587     return (nProp == 512) || ((nProp & DBPROPVAL_SQL_ANSI92_ENTRY) == DBPROPVAL_SQL_ANSI92_ENTRY);
 588 }
 589 // -------------------------------------------------------------------------
 590 sal_Bool SAL_CALL ODatabaseMetaData::supportsIntegrityEnhancementFacility(  ) throw(SQLException, RuntimeException)
 591 {
 592     sal_Int32 nProp = getInt32Property(::rtl::OUString::createFromAscii("SQL Support"));
 593     return (nProp == 512) || ((nProp & DBPROPVAL_SQL_ANSI89_IEF) == DBPROPVAL_SQL_ANSI89_IEF);
 594 }
 595 // -------------------------------------------------------------------------
 596 sal_Bool SAL_CALL ODatabaseMetaData::supportsSchemasInIndexDefinitions(  ) throw(SQLException, RuntimeException)
 597 {
 598     return (getInt32Property(::rtl::OUString::createFromAscii("Schema Usage")) & DBPROPVAL_SU_INDEX_DEFINITION) == DBPROPVAL_SU_INDEX_DEFINITION;
 599 }
 600 // -------------------------------------------------------------------------
 601 sal_Bool ODatabaseMetaData::impl_supportsSchemasInTableDefinitions_throw(  )
 602 {
 603     return (getInt32Property(::rtl::OUString::createFromAscii("Schema Usage")) & DBPROPVAL_SU_TABLE_DEFINITION) == DBPROPVAL_SU_TABLE_DEFINITION;
 604 }
 605 // -------------------------------------------------------------------------
 606 sal_Bool ODatabaseMetaData::impl_supportsCatalogsInTableDefinitions_throw(  )
 607 {
 608     //  return (getInt32Property(::rtl::OUString::createFromAscii("Catalog Usage")) & DBPROPVAL_CU_TABLE_DEFINITION) == DBPROPVAL_CU_TABLE_DEFINITION;
 609     return sal_False;
 610 }
 611 // -------------------------------------------------------------------------
 612 sal_Bool SAL_CALL ODatabaseMetaData::supportsCatalogsInIndexDefinitions(  ) throw(SQLException, RuntimeException)
 613 {
 614     //  return (getInt32Property(::rtl::OUString::createFromAscii("Catalog Usage")) & DBPROPVAL_CU_INDEX_DEFINITION) == DBPROPVAL_CU_INDEX_DEFINITION;
 615     return sal_False;
 616 }
 617 // -------------------------------------------------------------------------
 618 sal_Bool ODatabaseMetaData::impl_supportsCatalogsInDataManipulation_throw(  )
 619 {
 620     //  return (getInt32Property(::rtl::OUString::createFromAscii("Catalog Usage")) & DBPROPVAL_CU_DML_STATEMENTS) == DBPROPVAL_CU_DML_STATEMENTS;
 621     return sal_False;
 622 }
 623 // -------------------------------------------------------------------------
 624 sal_Bool SAL_CALL ODatabaseMetaData::supportsOuterJoins(  ) throw(SQLException, RuntimeException)
 625 {
 626     if ( ADOS::isJetEngine(m_pConnection->getEngineType()) )
 627         return sal_True;
 628     return getBoolProperty(::rtl::OUString::createFromAscii("Outer Join Capabilities"));
 629 }
 630 // -------------------------------------------------------------------------
 631 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getTableTypes(  ) throw(SQLException, RuntimeException)
 632 {
 633     return new ::connectivity::ODatabaseMetaDataResultSet(::connectivity::ODatabaseMetaDataResultSet::eTableTypes);
 634 }
 635 // -------------------------------------------------------------------------
 636 sal_Int32 ODatabaseMetaData::impl_getMaxStatements_throw(  )
 637 {
 638     return 0;
 639 }
 640 // -------------------------------------------------------------------------
 641 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxProcedureNameLength(  ) throw(SQLException, RuntimeException)
 642 {
 643     return getMaxSize(DBLITERAL_PROCEDURE_NAME);
 644 }
 645 // -------------------------------------------------------------------------
 646 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxSchemaNameLength(  ) throw(SQLException, RuntimeException)
 647 {
 648     return getMaxSize(DBLITERAL_SCHEMA_NAME);
 649 }
 650 // -------------------------------------------------------------------------
 651 sal_Bool SAL_CALL ODatabaseMetaData::supportsTransactions(  ) throw(SQLException, RuntimeException)
 652 {
 653     return getInt32Property(::rtl::OUString::createFromAscii("Transaction DDL")) == DBPROPVAL_TC_NONE;
 654 }
 655 // -------------------------------------------------------------------------
 656 sal_Bool SAL_CALL ODatabaseMetaData::allProceduresAreCallable(  ) throw(SQLException, RuntimeException)
 657 {
 658     return sal_True;
 659 }
 660 // -------------------------------------------------------------------------
 661 sal_Bool SAL_CALL ODatabaseMetaData::supportsStoredProcedures(  ) throw(SQLException, RuntimeException)
 662 {
 663     return sal_True;
 664 }
 665 // -------------------------------------------------------------------------
 666 sal_Bool SAL_CALL ODatabaseMetaData::supportsSelectForUpdate(  ) throw(SQLException, RuntimeException)
 667 {
 668     return sal_True;
 669 }
 670 // -------------------------------------------------------------------------
 671 sal_Bool SAL_CALL ODatabaseMetaData::allTablesAreSelectable(  ) throw(SQLException, RuntimeException)
 672 {
 673     return sal_True;
 674 }
 675 // -------------------------------------------------------------------------
 676 sal_Bool SAL_CALL ODatabaseMetaData::isReadOnly(  ) throw(SQLException, RuntimeException)
 677 {
 678     return getBoolProperty(::rtl::OUString::createFromAscii("Read-Only Data Source"));
 679 }
 680 // -------------------------------------------------------------------------
 681 sal_Bool SAL_CALL ODatabaseMetaData::usesLocalFiles(  ) throw(SQLException, RuntimeException)
 682 {
 683     return sal_False;
 684 }
 685 // -------------------------------------------------------------------------
 686 sal_Bool SAL_CALL ODatabaseMetaData::usesLocalFilePerTable(  ) throw(SQLException, RuntimeException)
 687 {
 688     return sal_False;
 689 }
 690 // -------------------------------------------------------------------------
 691 sal_Bool SAL_CALL ODatabaseMetaData::supportsTypeConversion(  ) throw(SQLException, RuntimeException)
 692 {
 693     return sal_True;
 694 }
 695 // -------------------------------------------------------------------------
 696 sal_Bool SAL_CALL ODatabaseMetaData::nullPlusNonNullIsNull(  ) throw(SQLException, RuntimeException)
 697 {
 698     return getInt32Property(::rtl::OUString::createFromAscii("NULL Concatenation Behavior")) == DBPROPVAL_CB_NULL;
 699 }
 700 // -------------------------------------------------------------------------
 701 sal_Bool SAL_CALL ODatabaseMetaData::supportsColumnAliasing(  ) throw(SQLException, RuntimeException)
 702 {
 703     return isCapable(DBLITERAL_COLUMN_ALIAS);
 704 }
 705 // -------------------------------------------------------------------------
 706 sal_Bool SAL_CALL ODatabaseMetaData::supportsTableCorrelationNames(  ) throw(SQLException, RuntimeException)
 707 {
 708     return isCapable(DBLITERAL_CORRELATION_NAME);
 709 }
 710 // -------------------------------------------------------------------------
 711 sal_Bool SAL_CALL ODatabaseMetaData::supportsConvert( sal_Int32 /*fromType*/, sal_Int32 /*toType*/ ) throw(SQLException, RuntimeException)
 712 {
 713     return getBoolProperty(::rtl::OUString::createFromAscii("Rowset Conversions on Command"));
 714 }
 715 // -------------------------------------------------------------------------
 716 sal_Bool SAL_CALL ODatabaseMetaData::supportsExpressionsInOrderBy(  ) throw(SQLException, RuntimeException)
 717 {
 718     return getBoolProperty(::rtl::OUString::createFromAscii("ORDER BY Columns in Select List"));
 719 }
 720 // -------------------------------------------------------------------------
 721 sal_Bool SAL_CALL ODatabaseMetaData::supportsGroupBy(  ) throw(SQLException, RuntimeException)
 722 {
 723     return getInt32Property(::rtl::OUString::createFromAscii("GROUP BY Support")) != DBPROPVAL_GB_NOT_SUPPORTED;
 724 }
 725 // -------------------------------------------------------------------------
 726 sal_Bool SAL_CALL ODatabaseMetaData::supportsGroupByBeyondSelect(  ) throw(SQLException, RuntimeException)
 727 {
 728     return getInt32Property(::rtl::OUString::createFromAscii("GROUP BY Support")) != DBPROPVAL_GB_CONTAINS_SELECT;
 729 }
 730 // -------------------------------------------------------------------------
 731 sal_Bool SAL_CALL ODatabaseMetaData::supportsGroupByUnrelated(  ) throw(SQLException, RuntimeException)
 732 {
 733     return getInt32Property(::rtl::OUString::createFromAscii("GROUP BY Support")) == DBPROPVAL_GB_NO_RELATION;
 734 }
 735 // -------------------------------------------------------------------------
 736 sal_Bool SAL_CALL ODatabaseMetaData::supportsMultipleTransactions(  ) throw(SQLException, RuntimeException)
 737 {
 738     return sal_True;
 739 }
 740 // -------------------------------------------------------------------------
 741 sal_Bool SAL_CALL ODatabaseMetaData::supportsMultipleResultSets(  ) throw(SQLException, RuntimeException)
 742 {
 743     return sal_False;
 744 }
 745 // -------------------------------------------------------------------------
 746 sal_Bool SAL_CALL ODatabaseMetaData::supportsLikeEscapeClause(  ) throw(SQLException, RuntimeException)
 747 {
 748     return isCapable(DBLITERAL_ESCAPE_PERCENT);
 749 }
 750 // -------------------------------------------------------------------------
 751 sal_Bool SAL_CALL ODatabaseMetaData::supportsOrderByUnrelated(  ) throw(SQLException, RuntimeException)
 752 {
 753     return getBoolProperty(::rtl::OUString::createFromAscii("ORDER BY Columns in Select List"));
 754 }
 755 // -------------------------------------------------------------------------
 756 sal_Bool SAL_CALL ODatabaseMetaData::supportsUnion(  ) throw(SQLException, RuntimeException)
 757 {
 758     return sal_True;
 759 }
 760 // -------------------------------------------------------------------------
 761 sal_Bool SAL_CALL ODatabaseMetaData::supportsUnionAll(  ) throw(SQLException, RuntimeException)
 762 {
 763     return sal_True;
 764 }
 765 // -------------------------------------------------------------------------
 766 sal_Bool SAL_CALL ODatabaseMetaData::supportsMixedCaseIdentifiers(  ) throw(SQLException, RuntimeException)
 767 {
 768     return (getInt32Property(::rtl::OUString::createFromAscii("Identifier Case Sensitivity")) & DBPROPVAL_IC_MIXED) == DBPROPVAL_IC_MIXED;
 769 }
 770 // -------------------------------------------------------------------------
 771 sal_Bool ODatabaseMetaData::impl_supportsMixedCaseQuotedIdentifiers_throw(  )
 772 {
 773     return (getInt32Property(::rtl::OUString::createFromAscii("Identifier Case Sensitivity")) & DBPROPVAL_IC_MIXED) == DBPROPVAL_IC_MIXED;
 774 }
 775 // -------------------------------------------------------------------------
 776 sal_Bool SAL_CALL ODatabaseMetaData::nullsAreSortedAtEnd(  ) throw(SQLException, RuntimeException)
 777 {
 778     return (getInt32Property(::rtl::OUString::createFromAscii("NULL Collation Order")) & DBPROPVAL_NC_END) == DBPROPVAL_NC_END;
 779 }
 780 // -------------------------------------------------------------------------
 781 sal_Bool SAL_CALL ODatabaseMetaData::nullsAreSortedAtStart(  ) throw(SQLException, RuntimeException)
 782 {
 783     return (getInt32Property(::rtl::OUString::createFromAscii("NULL Collation Order")) & DBPROPVAL_NC_START) == DBPROPVAL_NC_START;
 784 }
 785 // -------------------------------------------------------------------------
 786 sal_Bool SAL_CALL ODatabaseMetaData::nullsAreSortedHigh(  ) throw(SQLException, RuntimeException)
 787 {
 788     return (getInt32Property(::rtl::OUString::createFromAscii("NULL Collation Order")) & DBPROPVAL_NC_HIGH) == DBPROPVAL_NC_HIGH;
 789 }
 790 // -------------------------------------------------------------------------
 791 sal_Bool SAL_CALL ODatabaseMetaData::nullsAreSortedLow(  ) throw(SQLException, RuntimeException)
 792 {
 793     return (getInt32Property(::rtl::OUString::createFromAscii("NULL Collation Order")) & DBPROPVAL_NC_LOW) == DBPROPVAL_NC_LOW;
 794 }
 795 // -------------------------------------------------------------------------
 796 sal_Bool SAL_CALL ODatabaseMetaData::supportsSchemasInProcedureCalls(  ) throw(SQLException, RuntimeException)
 797 {
 798     return sal_False;
 799 }
 800 // -------------------------------------------------------------------------
 801 sal_Bool SAL_CALL ODatabaseMetaData::supportsSchemasInPrivilegeDefinitions(  ) throw(SQLException, RuntimeException)
 802 {
 803     return (getInt32Property(::rtl::OUString::createFromAscii("Schema Usage")) & DBPROPVAL_SU_PRIVILEGE_DEFINITION) == DBPROPVAL_SU_PRIVILEGE_DEFINITION;
 804 }
 805 // -------------------------------------------------------------------------
 806 sal_Bool SAL_CALL ODatabaseMetaData::supportsCatalogsInProcedureCalls(  ) throw(SQLException, RuntimeException)
 807 {
 808     return sal_False;
 809 }
 810 // -------------------------------------------------------------------------
 811 sal_Bool SAL_CALL ODatabaseMetaData::supportsCatalogsInPrivilegeDefinitions(  ) throw(SQLException, RuntimeException)
 812 {
 813     //  return (getInt32Property(::rtl::OUString::createFromAscii("Catalog Usage")) & DBPROPVAL_CU_PRIVILEGE_DEFINITION) == DBPROPVAL_CU_PRIVILEGE_DEFINITION;
 814     return sal_False;
 815 }
 816 // -------------------------------------------------------------------------
 817 sal_Bool SAL_CALL ODatabaseMetaData::supportsCorrelatedSubqueries(  ) throw(SQLException, RuntimeException)
 818 {
 819     return (getInt32Property(::rtl::OUString::createFromAscii("Subquery Support")) & DBPROPVAL_SQ_CORRELATEDSUBQUERIES) == DBPROPVAL_SQ_CORRELATEDSUBQUERIES;
 820 }
 821 // -------------------------------------------------------------------------
 822 sal_Bool SAL_CALL ODatabaseMetaData::supportsSubqueriesInComparisons(  ) throw(SQLException, RuntimeException)
 823 {
 824     return (getInt32Property(::rtl::OUString::createFromAscii("Subquery Support")) & DBPROPVAL_SQ_COMPARISON) == DBPROPVAL_SQ_COMPARISON;
 825 }
 826 // -------------------------------------------------------------------------
 827 sal_Bool SAL_CALL ODatabaseMetaData::supportsSubqueriesInExists(  ) throw(SQLException, RuntimeException)
 828 {
 829     return (getInt32Property(::rtl::OUString::createFromAscii("Subquery Support")) & DBPROPVAL_SQ_EXISTS) == DBPROPVAL_SQ_EXISTS;
 830 }
 831 // -------------------------------------------------------------------------
 832 sal_Bool SAL_CALL ODatabaseMetaData::supportsSubqueriesInIns(  ) throw(SQLException, RuntimeException)
 833 {
 834     return (getInt32Property(::rtl::OUString::createFromAscii("Subquery Support")) & DBPROPVAL_SQ_IN) == DBPROPVAL_SQ_IN;
 835 }
 836 // -------------------------------------------------------------------------
 837 sal_Bool SAL_CALL ODatabaseMetaData::supportsSubqueriesInQuantifieds(  ) throw(SQLException, RuntimeException)
 838 {
 839     return (getInt32Property(::rtl::OUString::createFromAscii("Subquery Support")) & DBPROPVAL_SQ_QUANTIFIED) == DBPROPVAL_SQ_QUANTIFIED;
 840 }
 841 // -------------------------------------------------------------------------
 842 sal_Bool SAL_CALL ODatabaseMetaData::supportsANSI92IntermediateSQL(  ) throw(SQLException, RuntimeException)
 843 {
 844     sal_Int32 nProp = getInt32Property(::rtl::OUString::createFromAscii("SQL Support"));
 845     return (nProp == 512) || ((nProp & DBPROPVAL_SQL_ANSI92_INTERMEDIATE) == DBPROPVAL_SQL_ANSI92_INTERMEDIATE);
 846 }
 847 // -------------------------------------------------------------------------
 848 ::rtl::OUString SAL_CALL ODatabaseMetaData::getURL(  ) throw(SQLException, RuntimeException)
 849 {
 850     return ::rtl::OUString::createFromAscii("sdbc:ado:")+ m_pADOConnection->GetConnectionString();
 851 }
 852 // -------------------------------------------------------------------------
 853 ::rtl::OUString SAL_CALL ODatabaseMetaData::getUserName(  ) throw(SQLException, RuntimeException)
 854 {
 855     return getStringProperty(::rtl::OUString::createFromAscii("User Name"));
 856 }
 857 // -------------------------------------------------------------------------
 858 ::rtl::OUString SAL_CALL ODatabaseMetaData::getDriverName(  ) throw(SQLException, RuntimeException)
 859 {
 860     return getStringProperty(::rtl::OUString::createFromAscii("Provider Friendly Name"));
 861 }
 862 // -------------------------------------------------------------------------
 863 ::rtl::OUString SAL_CALL ODatabaseMetaData::getDriverVersion(  ) throw(SQLException, RuntimeException)
 864 {
 865     return getStringProperty(::rtl::OUString::createFromAscii("Provider Version"));
 866 }
 867 // -------------------------------------------------------------------------
 868 ::rtl::OUString SAL_CALL ODatabaseMetaData::getDatabaseProductVersion(  ) throw(SQLException, RuntimeException)
 869 {
 870     return getStringProperty(::rtl::OUString::createFromAscii("DBMS Version"));
 871 }
 872 // -------------------------------------------------------------------------
 873 ::rtl::OUString SAL_CALL ODatabaseMetaData::getDatabaseProductName(  ) throw(SQLException, RuntimeException)
 874 {
 875     return getStringProperty(::rtl::OUString::createFromAscii("DBMS Name"));
 876 }
 877 // -------------------------------------------------------------------------
 878 ::rtl::OUString SAL_CALL ODatabaseMetaData::getProcedureTerm(  ) throw(SQLException, RuntimeException)
 879 {
 880     return getStringProperty(::rtl::OUString::createFromAscii("Procedure Term"));
 881 }
 882 // -------------------------------------------------------------------------
 883 ::rtl::OUString SAL_CALL ODatabaseMetaData::getSchemaTerm(  ) throw(SQLException, RuntimeException)
 884 {
 885     return getStringProperty(::rtl::OUString::createFromAscii("Schema Term"));
 886 }
 887 // -------------------------------------------------------------------------
 888 sal_Int32 SAL_CALL ODatabaseMetaData::getDriverMajorVersion(  ) throw(RuntimeException)
 889 {
 890     return 1;
 891 }
 892 // -------------------------------------------------------------------------
 893 sal_Int32 SAL_CALL ODatabaseMetaData::getDefaultTransactionIsolation(  ) throw(SQLException, RuntimeException)
 894 {
 895     sal_Int32 nRet = TransactionIsolation::NONE;
 896     switch(m_pADOConnection->get_IsolationLevel())
 897     {
 898         case adXactReadCommitted:
 899             nRet = TransactionIsolation::READ_COMMITTED;
 900             break;
 901         case adXactRepeatableRead:
 902             nRet = TransactionIsolation::REPEATABLE_READ;
 903             break;
 904         case adXactSerializable:
 905             nRet = TransactionIsolation::SERIALIZABLE;
 906             break;
 907         case adXactReadUncommitted:
 908             nRet = TransactionIsolation::READ_UNCOMMITTED;
 909             break;
 910         default:
 911             ;
 912     }
 913     return nRet;
 914 }
 915 // -------------------------------------------------------------------------
 916 sal_Int32 SAL_CALL ODatabaseMetaData::getDriverMinorVersion(  ) throw(RuntimeException)
 917 {
 918     return 0;
 919 }
 920 // -------------------------------------------------------------------------
 921 ::rtl::OUString SAL_CALL ODatabaseMetaData::getSQLKeywords(  ) throw(SQLException, RuntimeException)
 922 {
 923     ADORecordset *pRecordset = NULL;
 924     OLEVariant  vtEmpty;
 925     vtEmpty.setNoArg();
 926     m_pADOConnection->OpenSchema(adSchemaDBInfoKeywords,vtEmpty,vtEmpty,&pRecordset);
 927     OSL_ENSURE(pRecordset,"getSQLKeywords: no resultset!");
 928     ADOS::ThrowException(*m_pADOConnection,*this);
 929     if ( pRecordset )
 930     {
 931         WpADORecordset aRecordset(pRecordset);
 932
 933         aRecordset.MoveFirst();
 934         OLEVariant  aValue;
 935         ::rtl::OUString aRet,aComma = ::rtl::OUString::createFromAscii(",");
 936         while(!aRecordset.IsAtEOF())
 937         {
 938             WpOLEAppendCollection<ADOFields, ADOField, WpADOField>      aFields(aRecordset.GetFields());
 939             WpADOField aField(aFields.GetItem(0));
 940             aField.get_Value(aValue);
 941             aRet = aRet + aValue + aComma;
 942             aRecordset.MoveNext();
 943         }
 944         aRecordset.Close();
 945         if ( aRet.getLength() )
 946             return aRet.copy(0,aRet.lastIndexOf(','));
 947     }
 948     return ::rtl::OUString();
 949 }
 950 // -------------------------------------------------------------------------
 951 ::rtl::OUString SAL_CALL ODatabaseMetaData::getSearchStringEscape(  ) throw(SQLException, RuntimeException)
 952 {
 953     return getLiteral(DBLITERAL_ESCAPE_PERCENT);
 954 }
 955 // -------------------------------------------------------------------------
 956 ::rtl::OUString SAL_CALL ODatabaseMetaData::getStringFunctions(  ) throw(SQLException, RuntimeException)
 957 {
 958     ::rtl::OUString aValue;
 959     return aValue.copy(0,aValue.lastIndexOf(','));
 960 }
 961 // -------------------------------------------------------------------------
 962 ::rtl::OUString SAL_CALL ODatabaseMetaData::getTimeDateFunctions(  ) throw(SQLException, RuntimeException)
 963 {
 964     ::rtl::OUString aValue;
 965     return aValue;
 966 }
 967 // -------------------------------------------------------------------------
 968 ::rtl::OUString SAL_CALL ODatabaseMetaData::getSystemFunctions(  ) throw(SQLException, RuntimeException)
 969 {
 970     ::rtl::OUString aValue;
 971     return aValue.copy(0,aValue.lastIndexOf(','));
 972 }
 973 // -------------------------------------------------------------------------
 974 ::rtl::OUString SAL_CALL ODatabaseMetaData::getNumericFunctions(  ) throw(SQLException, RuntimeException)
 975 {
 976     ::rtl::OUString aValue;
 977     return aValue;
 978 }
 979 // -------------------------------------------------------------------------
 980 sal_Bool SAL_CALL ODatabaseMetaData::supportsExtendedSQLGrammar(  ) throw(SQLException, RuntimeException)
 981 {
 982     sal_Int32 nProp = getInt32Property(::rtl::OUString::createFromAscii("SQL Support"));
 983     return (nProp == 512) || ((nProp & DBPROPVAL_SQL_ODBC_EXTENDED) == DBPROPVAL_SQL_ODBC_EXTENDED);
 984 }
 985 // -------------------------------------------------------------------------
 986 sal_Bool SAL_CALL ODatabaseMetaData::supportsCoreSQLGrammar(  ) throw(SQLException, RuntimeException)
 987 {
 988     sal_Int32 nProp = getInt32Property(::rtl::OUString::createFromAscii("SQL Support"));
 989     return (nProp == 512) || ((nProp & DBPROPVAL_SQL_ODBC_CORE) == DBPROPVAL_SQL_ODBC_CORE);
 990 }
 991 // -------------------------------------------------------------------------
 992 sal_Bool SAL_CALL ODatabaseMetaData::supportsMinimumSQLGrammar(  ) throw(SQLException, RuntimeException)
 993 {
 994     sal_Int32 nProp = getInt32Property(::rtl::OUString::createFromAscii("SQL Support"));
 995     return (nProp == 512) || ((nProp & DBPROPVAL_SQL_ODBC_MINIMUM) == DBPROPVAL_SQL_ODBC_MINIMUM);
 996 }
 997 // -------------------------------------------------------------------------
 998 sal_Bool SAL_CALL ODatabaseMetaData::supportsFullOuterJoins(  ) throw(SQLException, RuntimeException)
 999 {
1000     if ( ADOS::isJetEngine(m_pConnection->getEngineType()) )
1001         return sal_True;
1002     return (getInt32Property(::rtl::OUString::createFromAscii("Outer Join Capabilities")) & 0x00000004L) == 0x00000004L;
1003 }
1004 // -------------------------------------------------------------------------
1005 sal_Bool SAL_CALL ODatabaseMetaData::supportsLimitedOuterJoins(  ) throw(SQLException, RuntimeException)
1006 {
1007     return supportsFullOuterJoins(  );
1008 }
1009 // -------------------------------------------------------------------------
1010 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInGroupBy(  ) throw(SQLException, RuntimeException)
1011 {
1012     return getInt32Property(::rtl::OUString::createFromAscii("Max Columns in GROUP BY"));
1013 }
1014 // -------------------------------------------------------------------------
1015 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInOrderBy(  ) throw(SQLException, RuntimeException)
1016 {
1017     return getInt32Property(::rtl::OUString::createFromAscii("Max Columns in ORDER BY"));
1018 }
1019 // -------------------------------------------------------------------------
1020 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInSelect(  ) throw(SQLException, RuntimeException)
1021 {
1022     return 0; // getInt32Property(::rtl::OUString::createFromAscii("Max Columns in Select"));
1023 }
1024 // -------------------------------------------------------------------------
1025 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxUserNameLength(  ) throw(SQLException, RuntimeException)
1026 {
1027     return getMaxSize(DBLITERAL_USER_NAME);
1028 }
1029 // -------------------------------------------------------------------------
1030 sal_Bool SAL_CALL ODatabaseMetaData::supportsResultSetType( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException)
1031 {
1032     return sal_True;
1033 }
1034 // -------------------------------------------------------------------------
1035 sal_Bool SAL_CALL ODatabaseMetaData::supportsResultSetConcurrency( sal_Int32 /*setType*/, sal_Int32 /*concurrency*/ ) throw(SQLException, RuntimeException)
1036 {
1037     return sal_True;
1038 }
1039 // -------------------------------------------------------------------------
1040 sal_Bool SAL_CALL ODatabaseMetaData::ownUpdatesAreVisible( sal_Int32 setType ) throw(SQLException, RuntimeException)
1041 {
1042     return ResultSetType::FORWARD_ONLY != setType;
1043 }
1044 // -------------------------------------------------------------------------
1045 sal_Bool SAL_CALL ODatabaseMetaData::ownDeletesAreVisible( sal_Int32 setType ) throw(SQLException, RuntimeException)
1046 {
1047     return ResultSetType::FORWARD_ONLY != setType;
1048 }
1049 // -------------------------------------------------------------------------
1050 sal_Bool SAL_CALL ODatabaseMetaData::ownInsertsAreVisible( sal_Int32 setType ) throw(SQLException, RuntimeException)
1051 {
1052     return ResultSetType::FORWARD_ONLY != setType;
1053 }
1054 // -------------------------------------------------------------------------
1055 sal_Bool SAL_CALL ODatabaseMetaData::othersUpdatesAreVisible( sal_Int32 setType ) throw(SQLException, RuntimeException)
1056 {
1057     return ResultSetType::FORWARD_ONLY != setType;
1058 }
1059 // -------------------------------------------------------------------------
1060 sal_Bool SAL_CALL ODatabaseMetaData::othersDeletesAreVisible( sal_Int32 setType ) throw(SQLException, RuntimeException)
1061 {
1062     return ResultSetType::FORWARD_ONLY != setType;
1063 }
1064 // -------------------------------------------------------------------------
1065 sal_Bool SAL_CALL ODatabaseMetaData::othersInsertsAreVisible( sal_Int32 setType ) throw(SQLException, RuntimeException)
1066 {
1067     return ResultSetType::FORWARD_ONLY != setType;
1068 }
1069 // -------------------------------------------------------------------------
1070 sal_Bool SAL_CALL ODatabaseMetaData::updatesAreDetected( sal_Int32 setType ) throw(SQLException, RuntimeException)
1071 {
1072     return ResultSetType::FORWARD_ONLY != setType;
1073 }
1074 // -------------------------------------------------------------------------
1075 sal_Bool SAL_CALL ODatabaseMetaData::deletesAreDetected( sal_Int32 setType ) throw(SQLException, RuntimeException)
1076 {
1077     return ResultSetType::FORWARD_ONLY != setType;
1078 }
1079 // -------------------------------------------------------------------------
1080 sal_Bool SAL_CALL ODatabaseMetaData::insertsAreDetected( sal_Int32 setType ) throw(SQLException, RuntimeException)
1081 {
1082     return ResultSetType::FORWARD_ONLY != setType;
1083 }
1084 // -------------------------------------------------------------------------
1085 sal_Bool SAL_CALL ODatabaseMetaData::supportsBatchUpdates(  ) throw(SQLException, RuntimeException)
1086 {
1087     return sal_True;
1088 }
1089 // -------------------------------------------------------------------------
1090 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getUDTs( const Any& /*catalog*/, const ::rtl::OUString& /*schemaPattern*/, const ::rtl::OUString& /*typeNamePattern*/, const Sequence< sal_Int32 >& /*types*/ ) throw(SQLException, RuntimeException)
1091 {
1092     ::dbtools::throwFeatureNotImplementedException( "XDatabaseMetaData::getUDTs", *this );
1093     return Reference< XResultSet >();
1094 }
1095 // -------------------------------------------------------------------------
1096