connectivity/source/drivers/ado/ADatabaseMetaData.cxx

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