connectivity/source/commontools/FDatabaseMetaDataResultSet.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: FDatabaseMetaDataResultSet.cxx,v $
  10  * $Revision: 1.24 $
  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
  34 #include "ParameterSubstitution.hxx"
  35 #include "FDatabaseMetaDataResultSet.hxx"
  36 #include "FDatabaseMetaDataResultSetMetaData.hxx"
  37 #include <com/sun/star/sdbc/DataType.hpp>
  38 #include <com/sun/star/sdbc/ColumnSearch.hpp>
  39 #include <com/sun/star/sdbc/KeyRule.hpp>
  40 #include <com/sun/star/sdbc/ProcedureResult.hpp>
  41 #include <com/sun/star/sdbc/IndexType.hpp>
  42 #include <comphelper/property.hxx>
  43 #include <com/sun/star/lang/DisposedException.hpp>
  44 #include <com/sun/star/sdbc/ResultSetConcurrency.hpp>
  45 #include <com/sun/star/sdbc/ResultSetType.hpp>
  46 #include <com/sun/star/sdbc/FetchDirection.hpp>
  47 #include <com/sun/star/beans/PropertyAttribute.hpp>
  48 #include <cppuhelper/typeprovider.hxx>
  49 #include <comphelper/sequence.hxx>
  50 #include <cppuhelper/factory.hxx>
  51 #include <cppuhelper/implementationentry.hxx>
  52 #include "connectivity/dbexception.hxx"
  53 #include "TConnection.hxx"
  54
  55 using namespace connectivity;
  56 using namespace dbtools;
  57 using namespace cppu;
  58 //------------------------------------------------------------------------------
  59 using namespace ::com::sun::star::beans;
  60 using namespace ::com::sun::star::uno;
  61 using namespace ::com::sun::star::sdbcx;
  62 using namespace ::com::sun::star::sdbc;
  63 using namespace ::com::sun::star::container;
  64 using namespace ::com::sun::star::lang;
  65 // -------------------------------------------------------------------------
  66 ODatabaseMetaDataResultSet::ODatabaseMetaDataResultSet()
  67     :ODatabaseMetaDataResultSet_BASE(m_aMutex)
  68     ,::comphelper::OPropertyContainer(ODatabaseMetaDataResultSet_BASE::rBHelper)
  69     ,m_aStatement(NULL)
  70     ,m_xMetaData(NULL)
  71     ,m_bBOF(sal_True)
  72     ,m_bEOF(sal_True)
  73 {
  74     construct();
  75 }
  76
  77 // -------------------------------------------------------------------------
  78 ODatabaseMetaDataResultSet::ODatabaseMetaDataResultSet( MetaDataResultSetType _eType )
  79     :ODatabaseMetaDataResultSet_BASE(m_aMutex)
  80     ,::comphelper::OPropertyContainer(ODatabaseMetaDataResultSet_BASE::rBHelper)
  81     ,m_aStatement(NULL)
  82     ,m_xMetaData(NULL)
  83     ,m_bBOF(sal_True)
  84     ,m_bEOF(sal_True)
  85 {
  86     construct();
  87
  88     setType(_eType);
  89 }
  90
  91 // -------------------------------------------------------------------------
  92 ODatabaseMetaDataResultSet::~ODatabaseMetaDataResultSet()
  93 {
  94 }
  95 // -------------------------------------------------------------------------
  96 void ODatabaseMetaDataResultSet::construct()
  97 {
  98     registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_FETCHSIZE),                       PROPERTY_ID_FETCHSIZE,                  0,&m_nFetchSize,                ::getCppuType(reinterpret_cast<sal_Int32*>(NULL)));
  99     registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_RESULTSETTYPE),        PROPERTY_ID_RESULTSETTYPE,          PropertyAttribute::READONLY,&m_nResultSetType,       ::getCppuType(reinterpret_cast<sal_Int32*>(NULL)));
 100     registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_FETCHDIRECTION),          PROPERTY_ID_FETCHDIRECTION,             0,      &m_nFetchDirection,     ::getCppuType(reinterpret_cast<sal_Int32*>(NULL)));
 101     registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_RESULTSETCONCURRENCY), PROPERTY_ID_RESULTSETCONCURRENCY,   PropertyAttribute::READONLY,&m_nResultSetConcurrency,                ::getCppuType(reinterpret_cast<sal_Int32*>(NULL)));
 102 }
 103 // -----------------------------------------------------------------------------
 104 void ODatabaseMetaDataResultSet::setType(MetaDataResultSetType _eType)
 105 {
 106     switch( _eType )
 107     {
 108         case eCatalogs:             setCatalogsMap(); break;
 109         case eSchemas:              setSchemasMap(); break;
 110         case eColumnPrivileges:     setColumnPrivilegesMap(); break;
 111         case eColumns:              setColumnsMap(); break;
 112         case eTables:               setTablesMap(); break;
 113         case eTableTypes:           setTableTypes(); break;
 114         case eProcedureColumns:     setProcedureColumnsMap(); break;
 115         case eProcedures:           setProceduresMap(); break;
 116         case eExportedKeys:         setExportedKeysMap(); break;
 117         case eImportedKeys:         setImportedKeysMap(); break;
 118         case ePrimaryKeys:          setPrimaryKeysMap(); break;
 119         case eIndexInfo:            setIndexInfoMap(); break;
 120         case eTablePrivileges:      setTablePrivilegesMap(); break;
 121         case eCrossReference:       setCrossReferenceMap(); break;
 122         case eTypeInfo:             setTypeInfoMap(); break;
 123         case eBestRowIdentifier:    setBestRowIdentifierMap(); break;
 124         case eVersionColumns:       setVersionColumnsMap(); break;
 125         default:
 126             OSL_ENSURE(0,"Wrong type!");
 127     }
 128 }
 129 // -------------------------------------------------------------------------
 130 void ODatabaseMetaDataResultSet::disposing(void)
 131 {
 132     OPropertySetHelper::disposing();
 133
 134     ::osl::MutexGuard aGuard(m_aMutex);
 135     m_aStatement        = NULL;
 136 m_xMetaData.clear();
 137     m_aRowsIter = m_aRows.end();
 138     m_aRows.clear();
 139     m_aRowsIter = m_aRows.end();
 140 }
 141 // -----------------------------------------------------------------------------
 142 void SAL_CALL ODatabaseMetaDataResultSet::acquire() throw()
 143 {
 144     ODatabaseMetaDataResultSet_BASE::acquire();
 145 }
 146 // -----------------------------------------------------------------------------
 147 void SAL_CALL ODatabaseMetaDataResultSet::release() throw()
 148 {
 149     ODatabaseMetaDataResultSet_BASE::release();
 150 }
 151 // -------------------------------------------------------------------------
 152 Any SAL_CALL ODatabaseMetaDataResultSet::queryInterface( const Type & rType ) throw(RuntimeException)
 153 {
 154     Any aRet = OPropertySetHelper::queryInterface(rType);
 155     return aRet.hasValue() ? aRet : ODatabaseMetaDataResultSet_BASE::queryInterface(rType);
 156 }
 157 // -------------------------------------------------------------------------
 158 Sequence< Type > SAL_CALL ODatabaseMetaDataResultSet::getTypes(  ) throw(RuntimeException)
 159 {
 160     ::cppu::OTypeCollection aTypes(     ::getCppuType( (const Reference< ::com::sun::star::beans::XMultiPropertySet > *)0 ),
 161                                     ::getCppuType( (const Reference< ::com::sun::star::beans::XFastPropertySet > *)0 ),
 162                                     ::getCppuType( (const Reference< ::com::sun::star::beans::XPropertySet > *)0 ));
 163
 164     return ::comphelper::concatSequences(aTypes.getTypes(),ODatabaseMetaDataResultSet_BASE::getTypes());
 165 }
 166 // -----------------------------------------------------------------------------
 167 void ODatabaseMetaDataResultSet::setRows(const ORows& _rRows)
 168 {
 169     m_aRows = _rRows;
 170     m_bBOF = sal_True;
 171     m_bEOF = m_aRows.empty();
 172 }
 173 // -------------------------------------------------------------------------
 174 sal_Int32 SAL_CALL ODatabaseMetaDataResultSet::findColumn( const ::rtl::OUString& columnName ) throw(SQLException, RuntimeException)
 175 {
 176     ::osl::MutexGuard aGuard( m_aMutex );
 177     checkDisposed(ODatabaseMetaDataResultSet_BASE::rBHelper.bDisposed );
 178
 179
 180     Reference< XResultSetMetaData > xMeta = getMetaData();
 181     sal_Int32 nLen = xMeta->getColumnCount();
 182     sal_Int32 i = 1;
 183     for(;i<=nLen;++i)
 184         if(xMeta->isCaseSensitive(i) ? columnName == xMeta->getColumnName(i) :
 185             columnName.equalsIgnoreAsciiCase(xMeta->getColumnName(i))
 186             )
 187             break;
 188     return i;
 189 }
 190 // -----------------------------------------------------------------------------
 191 void ODatabaseMetaDataResultSet::checkIndex(sal_Int32 columnIndex ) throw(::com::sun::star::sdbc::SQLException)
 192 {
 193     if(columnIndex >= (sal_Int32)(*m_aRowsIter).size() || columnIndex < 1)
 194         ::dbtools::throwInvalidIndexException(*this);
 195 }
 196 // -------------------------------------------------------------------------
 197 Reference< ::com::sun::star::io::XInputStream > SAL_CALL ODatabaseMetaDataResultSet::getBinaryStream( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException)
 198 {
 199     return NULL;
 200 }
 201 // -------------------------------------------------------------------------
 202 Reference< ::com::sun::star::io::XInputStream > SAL_CALL ODatabaseMetaDataResultSet::getCharacterStream( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException)
 203 {
 204     return NULL;
 205 }
 206
 207 // -------------------------------------------------------------------------
 208 sal_Bool SAL_CALL ODatabaseMetaDataResultSet::getBoolean( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
 209 {
 210     return getValue(columnIndex);
 211 }
 212 // -------------------------------------------------------------------------
 213
 214 sal_Int8 SAL_CALL ODatabaseMetaDataResultSet::getByte( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
 215 {
 216     return getValue(columnIndex);
 217 }
 218 // -------------------------------------------------------------------------
 219
 220 Sequence< sal_Int8 > SAL_CALL ODatabaseMetaDataResultSet::getBytes( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
 221 {
 222     return getValue(columnIndex);
 223 }
 224 // -------------------------------------------------------------------------
 225
 226 ::com::sun::star::util::Date SAL_CALL ODatabaseMetaDataResultSet::getDate( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
 227 {
 228     return getValue(columnIndex);
 229 }
 230 // -------------------------------------------------------------------------
 231
 232 double SAL_CALL ODatabaseMetaDataResultSet::getDouble( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
 233 {
 234     return getValue(columnIndex);
 235 }
 236 // -------------------------------------------------------------------------
 237
 238 float SAL_CALL ODatabaseMetaDataResultSet::getFloat( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
 239 {
 240     return getValue(columnIndex);
 241 }
 242 // -------------------------------------------------------------------------
 243
 244 sal_Int32 SAL_CALL ODatabaseMetaDataResultSet::getInt( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
 245 {
 246     return getValue(columnIndex);
 247 }
 248
 249 // -------------------------------------------------------------------------
 250
 251 sal_Int32 SAL_CALL ODatabaseMetaDataResultSet::getRow(  ) throw(SQLException, RuntimeException)
 252 {
 253     return 0;
 254 }
 255 // -------------------------------------------------------------------------
 256
 257 sal_Int64 SAL_CALL ODatabaseMetaDataResultSet::getLong( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
 258 {
 259     return getValue(columnIndex);
 260 }
 261 // -------------------------------------------------------------------------
 262
 263 Reference< XResultSetMetaData > SAL_CALL ODatabaseMetaDataResultSet::getMetaData(  ) throw(SQLException, RuntimeException)
 264 {
 265     ::osl::MutexGuard aGuard( m_aMutex );
 266     checkDisposed(ODatabaseMetaDataResultSet_BASE::rBHelper.bDisposed );
 267
 268
 269     if(!m_xMetaData.is())
 270         m_xMetaData = new ODatabaseMetaDataResultSetMetaData();
 271
 272     return m_xMetaData;
 273 }
 274 // -------------------------------------------------------------------------
 275 Reference< XArray > SAL_CALL ODatabaseMetaDataResultSet::getArray( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException)
 276 {
 277     return NULL;
 278 }
 279
 280 // -------------------------------------------------------------------------
 281
 282 Reference< XClob > SAL_CALL ODatabaseMetaDataResultSet::getClob( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException)
 283 {
 284     return NULL;
 285 }
 286 // -------------------------------------------------------------------------
 287 Reference< XBlob > SAL_CALL ODatabaseMetaDataResultSet::getBlob( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException)
 288 {
 289     return NULL;
 290 }
 291 // -------------------------------------------------------------------------
 292
 293 Reference< XRef > SAL_CALL ODatabaseMetaDataResultSet::getRef( sal_Int32 /*columnIndex*/ ) throw(SQLException, RuntimeException)
 294 {
 295     return NULL;
 296 }
 297 // -------------------------------------------------------------------------
 298
 299 Any SAL_CALL ODatabaseMetaDataResultSet::getObject( sal_Int32 columnIndex, const Reference< ::com::sun::star::container::XNameAccess >& /*typeMap*/ ) throw(SQLException, RuntimeException)
 300 {
 301     return getValue(columnIndex).makeAny();
 302 }
 303 // -------------------------------------------------------------------------
 304
 305 sal_Int16 SAL_CALL ODatabaseMetaDataResultSet::getShort( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
 306 {
 307     return getValue(columnIndex);
 308 }
 309 // -------------------------------------------------------------------------
 310
 311 ::rtl::OUString SAL_CALL ODatabaseMetaDataResultSet::getString( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
 312 {
 313     return getValue(columnIndex);
 314 }
 315
 316 // -------------------------------------------------------------------------
 317
 318
 319 ::com::sun::star::util::Time SAL_CALL ODatabaseMetaDataResultSet::getTime( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
 320 {
 321     return getValue(columnIndex);
 322 }
 323 // -------------------------------------------------------------------------
 324
 325
 326 ::com::sun::star::util::DateTime SAL_CALL ODatabaseMetaDataResultSet::getTimestamp( sal_Int32 columnIndex ) throw(SQLException, RuntimeException)
 327 {
 328     return getValue(columnIndex);
 329 }
 330 // -------------------------------------------------------------------------
 331
 332 sal_Bool SAL_CALL ODatabaseMetaDataResultSet::isAfterLast(  ) throw(SQLException, RuntimeException)
 333 {
 334     return m_bEOF;
 335 }
 336 // -------------------------------------------------------------------------
 337 sal_Bool SAL_CALL ODatabaseMetaDataResultSet::isFirst(  ) throw(SQLException, RuntimeException)
 338 {
 339     ::dbtools::throwFunctionSequenceException(*this);
 340     return sal_False;
 341 }
 342 // -------------------------------------------------------------------------
 343 sal_Bool SAL_CALL ODatabaseMetaDataResultSet::isLast(  ) throw(SQLException, RuntimeException)
 344 {
 345     ::dbtools::throwFunctionSequenceException(*this);
 346     return sal_False;
 347 }
 348 // -------------------------------------------------------------------------
 349 void SAL_CALL ODatabaseMetaDataResultSet::beforeFirst(  ) throw(SQLException, RuntimeException)
 350 {
 351     ::dbtools::throwFunctionSequenceException(*this);
 352 }
 353 // -------------------------------------------------------------------------
 354 void SAL_CALL ODatabaseMetaDataResultSet::afterLast(  ) throw(SQLException, RuntimeException)
 355 {
 356     ::dbtools::throwFunctionSequenceException(*this);
 357 }
 358 // -------------------------------------------------------------------------
 359
 360 void SAL_CALL ODatabaseMetaDataResultSet::close(  ) throw(SQLException, RuntimeException)
 361 {
 362     {
 363         ::osl::MutexGuard aGuard( m_aMutex );
 364         checkDisposed(ODatabaseMetaDataResultSet_BASE::rBHelper.bDisposed );
 365
 366     }
 367     dispose();
 368 }
 369 // -------------------------------------------------------------------------
 370
 371 sal_Bool SAL_CALL ODatabaseMetaDataResultSet::first(  ) throw(SQLException, RuntimeException)
 372 {
 373     ::dbtools::throwFunctionSequenceException(*this);
 374     return sal_False;
 375 }
 376 // -------------------------------------------------------------------------
 377
 378 sal_Bool SAL_CALL ODatabaseMetaDataResultSet::last(  ) throw(SQLException, RuntimeException)
 379 {
 380     ::dbtools::throwFunctionSequenceException(*this);
 381     return sal_False;
 382 }
 383 // -------------------------------------------------------------------------
 384 sal_Bool SAL_CALL ODatabaseMetaDataResultSet::absolute( sal_Int32 /*row*/ ) throw(SQLException, RuntimeException)
 385 {
 386     ::dbtools::throwFunctionSequenceException(*this);
 387     return sal_False;
 388 }
 389 // -------------------------------------------------------------------------
 390 sal_Bool SAL_CALL ODatabaseMetaDataResultSet::relative( sal_Int32 /*row*/ ) throw(SQLException, RuntimeException)
 391 {
 392     ::dbtools::throwFunctionSequenceException(*this);
 393     return sal_False;
 394 }
 395 // -------------------------------------------------------------------------
 396 sal_Bool SAL_CALL ODatabaseMetaDataResultSet::previous(  ) throw(SQLException, RuntimeException)
 397 {
 398     ::dbtools::throwFunctionSequenceException(*this);
 399     return sal_False;
 400 }
 401 // -------------------------------------------------------------------------
 402 Reference< XInterface > SAL_CALL ODatabaseMetaDataResultSet::getStatement(  ) throw(SQLException, RuntimeException)
 403 {
 404     return m_aStatement.get();
 405 }
 406 // -------------------------------------------------------------------------
 407
 408 sal_Bool SAL_CALL ODatabaseMetaDataResultSet::rowDeleted(  ) throw(SQLException, RuntimeException)
 409 {
 410     ::dbtools::throwFunctionSequenceException(*this);
 411     return sal_False;
 412 }
 413 // -------------------------------------------------------------------------
 414 sal_Bool SAL_CALL ODatabaseMetaDataResultSet::rowInserted(  ) throw(SQLException, RuntimeException)
 415 {
 416     ::dbtools::throwFunctionSequenceException(*this);
 417     return sal_False;
 418 }
 419 // -------------------------------------------------------------------------
 420 sal_Bool SAL_CALL ODatabaseMetaDataResultSet::rowUpdated(  ) throw(SQLException, RuntimeException)
 421 {
 422     ::dbtools::throwFunctionSequenceException(*this);
 423     return sal_False;
 424 }
 425 // -------------------------------------------------------------------------
 426
 427 sal_Bool SAL_CALL ODatabaseMetaDataResultSet::isBeforeFirst(  ) throw(SQLException, RuntimeException)
 428 {
 429     return m_bBOF;
 430 }
 431 // -------------------------------------------------------------------------
 432
 433 sal_Bool SAL_CALL ODatabaseMetaDataResultSet::next(  ) throw(SQLException, RuntimeException)
 434 {
 435     ::osl::MutexGuard aGuard( m_aMutex );
 436     checkDisposed(ODatabaseMetaDataResultSet_BASE::rBHelper.bDisposed );
 437
 438     if ( m_bBOF )
 439     {
 440        m_aRowsIter = m_aRows.begin();
 441        m_bBOF = sal_False;
 442     }
 443     else
 444     {
 445         if ( m_bEOF )
 446             throwFunctionSequenceException( *this );
 447         else
 448             if ( m_aRowsIter != m_aRows.end() )
 449                 ++m_aRowsIter;
 450     }
 451
 452     bool bSuccess = m_aRowsIter != m_aRows.end();
 453     if ( !bSuccess )
 454     {
 455         m_bEOF = sal_True;
 456         m_bBOF = m_aRows.empty();
 457     }
 458     return bSuccess;
 459 }
 460 // -------------------------------------------------------------------------
 461
 462 sal_Bool SAL_CALL ODatabaseMetaDataResultSet::wasNull(  ) throw(SQLException, RuntimeException)
 463 {
 464     ::osl::MutexGuard aGuard( m_aMutex );
 465     checkDisposed(ODatabaseMetaDataResultSet_BASE::rBHelper.bDisposed );
 466
 467
 468     if(m_aRowsIter == m_aRows.end() || !(*m_aRowsIter)[m_nColPos].isValid())
 469         return sal_True;
 470
 471     return (*m_aRowsIter)[m_nColPos]->getValue().isNull();
 472 }
 473 // -------------------------------------------------------------------------
 474 void SAL_CALL ODatabaseMetaDataResultSet::refreshRow(  ) throw(SQLException, RuntimeException)
 475 {
 476 }
 477 // -------------------------------------------------------------------------
 478
 479 void SAL_CALL ODatabaseMetaDataResultSet::cancel(  ) throw(RuntimeException)
 480 {
 481 }
 482 // -------------------------------------------------------------------------
 483 void SAL_CALL ODatabaseMetaDataResultSet::clearWarnings(  ) throw(SQLException, RuntimeException)
 484 {
 485 }
 486 // -------------------------------------------------------------------------
 487 Any SAL_CALL ODatabaseMetaDataResultSet::getWarnings(  ) throw(SQLException, RuntimeException)
 488 {
 489     return Any();
 490 }
 491 // -------------------------------------------------------------------------
 492 ::cppu::IPropertyArrayHelper* ODatabaseMetaDataResultSet::createArrayHelper( ) const
 493 {
 494     Sequence< Property > aProps;
 495     describeProperties(aProps);
 496     return new ::cppu::OPropertyArrayHelper(aProps);
 497 }
 498 // -------------------------------------------------------------------------
 499 ::cppu::IPropertyArrayHelper & ODatabaseMetaDataResultSet::getInfoHelper()
 500 {
 501     return *const_cast<ODatabaseMetaDataResultSet*>(this)->getArrayHelper();
 502 }
 503 // -------------------------------------------------------------------------
 504 void ODatabaseMetaDataResultSet::setProceduresMap()
 505 {
 506     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 507     pMetaData->setProceduresMap();
 508     m_xMetaData = pMetaData;
 509 }
 510 // -------------------------------------------------------------------------
 511 void ODatabaseMetaDataResultSet::setCatalogsMap()
 512 {
 513     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 514     pMetaData->setCatalogsMap();
 515     m_xMetaData = pMetaData;
 516 }
 517 // -------------------------------------------------------------------------
 518 void ODatabaseMetaDataResultSet::setSchemasMap()
 519 {
 520     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 521     pMetaData->setSchemasMap();
 522     m_xMetaData = pMetaData;
 523 }
 524 // -------------------------------------------------------------------------
 525 void ODatabaseMetaDataResultSet::setColumnPrivilegesMap()
 526 {
 527     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 528     pMetaData->setColumnPrivilegesMap();
 529     m_xMetaData = pMetaData;
 530 }
 531 // -------------------------------------------------------------------------
 532 void ODatabaseMetaDataResultSet::setColumnsMap()
 533 {
 534
 535     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 536     pMetaData->setColumnsMap();
 537     m_xMetaData = pMetaData;
 538 }
 539 // -------------------------------------------------------------------------
 540 void ODatabaseMetaDataResultSet::setTablesMap()
 541 {
 542
 543     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 544     pMetaData->setTablesMap();
 545     m_xMetaData = pMetaData;
 546 }
 547 // -------------------------------------------------------------------------
 548 void ODatabaseMetaDataResultSet::setProcedureColumnsMap()
 549 {
 550     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 551     pMetaData->setProcedureColumnsMap();
 552     m_xMetaData = pMetaData;
 553 }
 554 // -------------------------------------------------------------------------
 555 void ODatabaseMetaDataResultSet::setPrimaryKeysMap()
 556 {
 557     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 558     pMetaData->setPrimaryKeysMap();
 559     m_xMetaData = pMetaData;
 560 }
 561 // -------------------------------------------------------------------------
 562 void ODatabaseMetaDataResultSet::setIndexInfoMap()
 563 {
 564     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 565     pMetaData->setIndexInfoMap();
 566     m_xMetaData = pMetaData;
 567 }
 568 // -------------------------------------------------------------------------
 569 void ODatabaseMetaDataResultSet::setTablePrivilegesMap()
 570 {
 571     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 572     pMetaData->setTablePrivilegesMap();
 573     m_xMetaData = pMetaData;
 574 }
 575 // -------------------------------------------------------------------------
 576 void ODatabaseMetaDataResultSet::setCrossReferenceMap()
 577 {
 578     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 579     pMetaData->setCrossReferenceMap();
 580     m_xMetaData = pMetaData;
 581 }
 582 // -------------------------------------------------------------------------
 583 void ODatabaseMetaDataResultSet::setVersionColumnsMap()
 584 {
 585     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 586     pMetaData->setVersionColumnsMap();
 587     m_xMetaData = pMetaData;
 588 }
 589 // -------------------------------------------------------------------------
 590 void ODatabaseMetaDataResultSet::setBestRowIdentifierMap()
 591 {
 592     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 593     pMetaData->setBestRowIdentifierMap();
 594     m_xMetaData = pMetaData;
 595 }
 596 // -------------------------------------------------------------------------
 597 void ODatabaseMetaDataResultSet::setTypeInfoMap()
 598 {
 599     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 600     pMetaData->setTypeInfoMap();
 601     m_xMetaData = pMetaData;
 602 }
 603 // -------------------------------------------------------------------------
 604 void ODatabaseMetaDataResultSet::setTableTypes()
 605 {
 606     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 607     pMetaData->setTableTypes();
 608     m_xMetaData = pMetaData;
 609 }
 610 // -------------------------------------------------------------------------
 611 void ODatabaseMetaDataResultSet::setExportedKeysMap()
 612 {
 613     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 614     pMetaData->setExportedKeysMap();
 615     m_xMetaData = pMetaData;
 616 }
 617 // -------------------------------------------------------------------------
 618 void ODatabaseMetaDataResultSet::setImportedKeysMap()
 619 {
 620     ODatabaseMetaDataResultSetMetaData* pMetaData = new ODatabaseMetaDataResultSetMetaData();
 621     pMetaData->setImportedKeysMap();
 622     m_xMetaData = pMetaData;
 623 }
 624 // -----------------------------------------------------------------------------
 625 Reference< ::com::sun::star::beans::XPropertySetInfo > SAL_CALL ODatabaseMetaDataResultSet::getPropertySetInfo(  ) throw(RuntimeException)
 626 {
 627     return ::cppu::OPropertySetHelper::createPropertySetInfo(getInfoHelper());
 628 }
 629 // -----------------------------------------------------------------------------
 630 ORowSetValueDecorator& ORowSetValueDecorator::operator=(const ORowSetValue& _aValue)
 631 {
 632     m_aValue = _aValue;
 633     return *this;
 634 }
 635 // -----------------------------------------------------------------------------
 636 const ORowSetValue& ODatabaseMetaDataResultSet::getValue(sal_Int32 columnIndex)
 637 {
 638     ::osl::MutexGuard aGuard( m_aMutex );
 639     checkDisposed(ODatabaseMetaDataResultSet_BASE::rBHelper.bDisposed );
 640
 641     if ( isBeforeFirst() || isAfterLast() )
 642         ::dbtools::throwFunctionSequenceException( *this );
 643
 644     checkIndex(columnIndex );
 645     m_nColPos = columnIndex;
 646
 647     if(m_aRowsIter != m_aRows.end() && (*m_aRowsIter)[columnIndex].isValid())
 648         return *(*m_aRowsIter)[columnIndex];
 649     return m_aEmptyValue;
 650 }
 651 // -----------------------------------------------------------------------------
 652 /// return an empty ORowSetValueDecorator
 653 ORowSetValueDecoratorRef ODatabaseMetaDataResultSet::getEmptyValue()
 654 {
 655     static ORowSetValueDecoratorRef aEmptyValueRef = new ORowSetValueDecorator();
 656     return aEmptyValueRef;
 657 }
 658 // -----------------------------------------------------------------------------
 659 /// return an ORowSetValueDecorator with 0 as value
 660 ORowSetValueDecoratorRef ODatabaseMetaDataResultSet::get0Value()
 661 {
 662     static ORowSetValueDecoratorRef a0ValueRef = new ORowSetValueDecorator((sal_Int32)0);
 663     return a0ValueRef;
 664 }
 665 // -----------------------------------------------------------------------------
 666 /// return an ORowSetValueDecorator with 1 as value
 667 ORowSetValueDecoratorRef ODatabaseMetaDataResultSet::get1Value()
 668 {
 669     static ORowSetValueDecoratorRef a1ValueRef = new ORowSetValueDecorator((sal_Int32)1);
 670     return a1ValueRef;
 671 }
 672 // -----------------------------------------------------------------------------
 673 /// return an ORowSetValueDecorator with ColumnSearch::BASIC as value
 674 ORowSetValueDecoratorRef ODatabaseMetaDataResultSet::getBasicValue()
 675 {
 676     static ORowSetValueDecoratorRef aValueRef = new ORowSetValueDecorator(ColumnSearch::BASIC);
 677     return aValueRef;
 678 }
 679 // -----------------------------------------------------------------------------
 680 ORowSetValueDecoratorRef ODatabaseMetaDataResultSet::getSelectValue()
 681 {
 682     static ORowSetValueDecoratorRef aValueRef = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("SELECT"));
 683     return aValueRef;
 684 }
 685 // -----------------------------------------------------------------------------
 686 ORowSetValueDecoratorRef ODatabaseMetaDataResultSet::getInsertValue()
 687 {
 688     static ORowSetValueDecoratorRef aValueRef = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("INSERT"));
 689     return aValueRef;
 690 }
 691 // -----------------------------------------------------------------------------
 692 ORowSetValueDecoratorRef ODatabaseMetaDataResultSet::getDeleteValue()
 693 {
 694     static ORowSetValueDecoratorRef aValueRef = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("DELETE"));
 695     return aValueRef;
 696 }
 697 // -----------------------------------------------------------------------------
 698 ORowSetValueDecoratorRef ODatabaseMetaDataResultSet::getUpdateValue()
 699 {
 700     static ORowSetValueDecoratorRef aValueRef = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("UPDATE"));
 701     return aValueRef;
 702 }
 703 // -----------------------------------------------------------------------------
 704 ORowSetValueDecoratorRef ODatabaseMetaDataResultSet::getCreateValue()
 705 {
 706     static ORowSetValueDecoratorRef aValueRef = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("CREATE"));
 707     return aValueRef;
 708 }
 709 // -----------------------------------------------------------------------------
 710 ORowSetValueDecoratorRef ODatabaseMetaDataResultSet::getReadValue()
 711 {
 712     static ORowSetValueDecoratorRef aValueRef = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("READ"));
 713     return aValueRef;
 714 }
 715 // -----------------------------------------------------------------------------
 716 ORowSetValueDecoratorRef ODatabaseMetaDataResultSet::getAlterValue()
 717 {
 718     static ORowSetValueDecoratorRef aValueRef = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("ALTER"));
 719     return aValueRef;
 720 }
 721 // -----------------------------------------------------------------------------
 722 ORowSetValueDecoratorRef ODatabaseMetaDataResultSet::getDropValue()
 723 {
 724     static ORowSetValueDecoratorRef aValueRef = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("DROP"));
 725     return aValueRef;
 726 }
 727 // -----------------------------------------------------------------------------
 728 ORowSetValueDecoratorRef ODatabaseMetaDataResultSet::getQuoteValue()
 729 {
 730     static ORowSetValueDecoratorRef aValueRef = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("'"));
 731     return aValueRef;
 732 }
 733 // -----------------------------------------------------------------------------
 734 void SAL_CALL ODatabaseMetaDataResultSet::initialize( const Sequence< Any >& _aArguments ) throw (Exception, RuntimeException)
 735 {
 736     if ( _aArguments.getLength() == 2 )
 737     {
 738         sal_Int32 nResultSetType = 0;
 739         if ( _aArguments[0] >>= nResultSetType)
 740         {
 741             setType(static_cast<MetaDataResultSetType>(nResultSetType));
 742             Sequence< Sequence<Any> > aRows;
 743             if ( _aArguments[1] >>= aRows )
 744             {
 745                 ORows aRowsToSet;
 746                 const Sequence<Any>* pRowsIter = aRows.getConstArray();
 747                 const Sequence<Any>* pRowsEnd  = pRowsIter + aRows.getLength();
 748                 for (; pRowsIter != pRowsEnd;++pRowsIter)
 749                 {
 750                     ORow aRowToSet;
 751                     const Any* pRowIter = pRowsIter->getConstArray();
 752                     const Any* pRowEnd = pRowIter + pRowsIter->getLength();
 753                     for (; pRowIter != pRowEnd;++pRowIter)
 754                     {
 755                         ORowSetValueDecoratorRef aValue;
 756                         switch( pRowIter->getValueTypeClass() )
 757                         {
 758                             case TypeClass_BOOLEAN:
 759                                 {
 760                                     sal_Bool bValue = sal_False;
 761                                     *pRowIter >>= bValue;
 762                                     aValue = new ORowSetValueDecorator(ORowSetValue(bValue));
 763                                 }
 764                                 break;
 765                             case TypeClass_BYTE:
 766                                 {
 767                                     sal_Int8 nValue;
 768                                     *pRowIter >>= nValue;
 769                                     aValue = new ORowSetValueDecorator(ORowSetValue(nValue));
 770                                 }
 771                                 break;
 772                             case TypeClass_SHORT:
 773                             case TypeClass_UNSIGNED_SHORT:
 774                                 {
 775                                     sal_Int16 nValue;
 776                                     *pRowIter >>= nValue;
 777                                     aValue = new ORowSetValueDecorator(ORowSetValue(nValue));
 778                                 }
 779                                 break;
 780                             case TypeClass_LONG:
 781                             case TypeClass_UNSIGNED_LONG:
 782                                 {
 783                                     sal_Int32 nValue;
 784                                     *pRowIter >>= nValue;
 785                                     aValue = new ORowSetValueDecorator(ORowSetValue(nValue));
 786                                 }
 787                                 break;
 788                             case TypeClass_HYPER:
 789                             case TypeClass_UNSIGNED_HYPER:
 790                                 {
 791                                     sal_Int64 nValue;
 792                                     *pRowIter >>= nValue;
 793                                     aValue = new ORowSetValueDecorator(ORowSetValue(nValue));
 794                                 }
 795                                 break;
 796                             case TypeClass_FLOAT:
 797                                 {
 798                                     float nValue;
 799                                     *pRowIter >>= nValue;
 800                                     aValue = new ORowSetValueDecorator(ORowSetValue(nValue));
 801                                 }
 802                                 break;
 803                             case TypeClass_DOUBLE:
 804                                 {
 805                                     double nValue;
 806                                     *pRowIter >>= nValue;
 807                                     aValue = new ORowSetValueDecorator(ORowSetValue(nValue));
 808                                 }
 809                                 break;
 810                             case TypeClass_STRING:
 811                                 {
 812                                     ::rtl::OUString sValue;
 813                                     *pRowIter >>= sValue;
 814                                     aValue = new ORowSetValueDecorator(ORowSetValue(sValue));
 815                                 }
 816                                 break;
 817                             default:
 818                                 break;
 819                         }
 820                         aRowToSet.push_back(aValue);
 821                     }
 822                     aRowsToSet.push_back(aRowToSet);
 823                 } // for (; pRowsIter != pRowsEnd;++pRowsIter
 824                 setRows(aRowsToSet);
 825             }
 826         }
 827     }
 828 }
 829 // XServiceInfo
 830     // --------------------------------------------------------------------------------
 831     //------------------------------------------------------------------------------
 832     rtl::OUString ODatabaseMetaDataResultSet::getImplementationName_Static(  ) throw(RuntimeException)
 833     {
 834         return ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("org.openoffice.comp.helper.DatabaseMetaDataResultSet"));
 835     }
 836     //------------------------------------------------------------------------------
 837     Sequence< ::rtl::OUString > ODatabaseMetaDataResultSet::getSupportedServiceNames_Static(  ) throw (RuntimeException)
 838     {
 839         Sequence< ::rtl::OUString > aSNS( 1 );
 840         aSNS[0] = ::rtl::OUString::createFromAscii("com.sun.star.sdbc.ResultSet");
 841         return aSNS;
 842     }
 843     //------------------------------------------------------------------
 844     ::rtl::OUString SAL_CALL ODatabaseMetaDataResultSet::getImplementationName(  ) throw(RuntimeException)
 845     {
 846         return getImplementationName_Static();
 847     }
 848
 849     //------------------------------------------------------------------
 850     sal_Bool SAL_CALL ODatabaseMetaDataResultSet::supportsService( const ::rtl::OUString& _rServiceName ) throw(RuntimeException)
 851     {
 852         Sequence< ::rtl::OUString > aSupported(getSupportedServiceNames());
 853         const ::rtl::OUString* pSupported = aSupported.getConstArray();
 854         const ::rtl::OUString* pEnd = pSupported + aSupported.getLength();
 855         for (;pSupported != pEnd && !pSupported->equals(_rServiceName); ++pSupported)
 856             ;
 857
 858         return pSupported != pEnd;
 859     }
 860     //------------------------------------------------------------------
 861     Sequence< ::rtl::OUString > SAL_CALL ODatabaseMetaDataResultSet::getSupportedServiceNames(  ) throw(RuntimeException)
 862     {
 863         return getSupportedServiceNames_Static();
 864     }
 865     // -------------------------------------------------------------------------
 866     namespace connectivity
 867     {
 868         Reference< XInterface >  SAL_CALL ODatabaseMetaDataResultSet_CreateInstance(const Reference< XComponentContext >& ) throw( Exception )
 869         {
 870             return *(new ODatabaseMetaDataResultSet());
 871         }
 872     }
 873
 874 // -----------------------------------------------------------------------------
 875 namespace
 876 {
 877     cppu::ImplementationEntry entries[] = {
 878         { &ODatabaseMetaDataResultSet_CreateInstance, &ODatabaseMetaDataResultSet::getImplementationName_Static, &ODatabaseMetaDataResultSet::getSupportedServiceNames_Static,
 879             &cppu::createSingleComponentFactory, 0, 0 },
 880         { &ParameterSubstitution::create, &ParameterSubstitution::getImplementationName_Static, &ParameterSubstitution::getSupportedServiceNames_Static,
 881             &cppu::createSingleComponentFactory, 0, 0 },
 882         { 0, 0, 0, 0, 0, 0 }
 883     };
 884 }
 885 using ::rtl::OUString;
 886 using ::com::sun::star::uno::Reference;
 887 using ::com::sun::star::uno::Sequence;
 888 using ::com::sun::star::registry::XRegistryKey;
 889 using ::com::sun::star::registry::InvalidRegistryException;
 890 using ::com::sun::star::registry::InvalidValueException;
 891 using ::com::sun::star::lang::XMultiServiceFactory;
 892
 893 //==========================================================================
 894 //= registration
 895 //==========================================================================
 896 extern "C"
 897 {
 898
 899 //---------------------------------------------------------------------------------------
 900 SAL_DLLPUBLIC_EXPORT void SAL_CALL component_getImplementationEnvironment(const sal_Char** _ppEnvTypeName, uno_Environment** /*_ppEnv*/)
 901 {
 902     *_ppEnvTypeName = CPPU_CURRENT_LANGUAGE_BINDING_NAME;
 903 }
 904
 905 //---------------------------------------------------------------------------------------
 906 SAL_DLLPUBLIC_EXPORT sal_Bool SAL_CALL component_writeInfo(void* serviceManager, com::sun::star::registry::XRegistryKey* registryKey)
 907 {
 908     return cppu::component_writeInfoHelper(serviceManager, registryKey, entries);
 909 }
 910 //---------------------------------------------------------------------------------------
 911 SAL_DLLPUBLIC_EXPORT void* SAL_CALL component_getFactory(const sal_Char* implName, ::com::sun::star::lang::XMultiServiceFactory* serviceManager, void* registryKey)
 912 {
 913     return cppu::component_getFactoryHelper(implName, serviceManager, registryKey, entries);
 914 }
 915
 916 }       // extern "C"