dbaccess/source/core/api/preparedstatement.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
  21 #include <com/sun/star/lang/DisposedException.hpp>
  22 #include <com/sun/star/sdbc/XConnection.hpp>
  23 #include <com/sun/star/sdbc/XDatabaseMetaData.hpp>
  24 #include <com/sun/star/sdbc/SQLException.hpp>
  25
  26 #include <connectivity/dbtools.hxx>
  27 #include <cppuhelper/supportsservice.hxx>
  28 #include <cppuhelper/queryinterface.hxx>
  29 #include <cppuhelper/typeprovider.hxx>
  30 #include <preparedstatement.hxx>
  31 #include <strings.hxx>
  32 #include "resultcolumn.hxx"
  33 #include "resultset.hxx"
  34 #include <connection.hxx>
  35 #include <comphelper/diagnose_ex.hxx>
  36
  37 using namespace ::com::sun::star::sdbc;
  38 using namespace ::com::sun::star::sdbcx;
  39 using namespace ::com::sun::star::uno;
  40 using namespace ::com::sun::star::lang;
  41 using namespace ::cppu;
  42 using namespace ::osl;
  43 using namespace dbaccess;
  44
  45
  46 OPreparedStatement::OPreparedStatement(const rtl::Reference< OConnection > & _xConn,
  47                                       const Reference< XInterface > & _xStatement)
  48                    :OStatementBase(_xConn, _xStatement)
  49 {
  50     m_xAggregateAsParameters.set( m_xAggregateAsSet, UNO_QUERY_THROW );
  51
  52     Reference<XDatabaseMetaData> xMeta = _xConn->getMetaData();
  53     m_pColumns.reset( new OColumns(*this, m_aMutex, xMeta.is() && xMeta->supportsMixedCaseQuotedIdentifiers(),std::vector< OUString>(), nullptr,nullptr) );
  54 }
  55
  56 OPreparedStatement::~OPreparedStatement()
  57 {
  58     m_pColumns->acquire();
  59     m_pColumns->disposing();
  60 }
  61
  62 // css::lang::XTypeProvider
  63 Sequence< Type > OPreparedStatement::getTypes()
  64 {
  65     OTypeCollection aTypes(cppu::UnoType<XServiceInfo>::get(),
  66                            cppu::UnoType<XPreparedStatement>::get(),
  67                            cppu::UnoType<XParameters>::get(),
  68                            cppu::UnoType<XResultSetMetaDataSupplier>::get(),
  69                            cppu::UnoType<XColumnsSupplier>::get(),
  70                             OStatementBase::getTypes() );
  71
  72     return aTypes.getTypes();
  73 }
  74
  75 Sequence< sal_Int8 > OPreparedStatement::getImplementationId()
  76 {
  77     return css::uno::Sequence<sal_Int8>();
  78 }
  79
  80 // css::uno::XInterface
  81 Any OPreparedStatement::queryInterface( const Type & rType )
  82 {
  83     Any aIface = OStatementBase::queryInterface( rType );
  84     if (!aIface.hasValue())
  85         aIface = ::cppu::queryInterface(
  86                     rType,
  87                     static_cast< XServiceInfo * >( this ),
  88                     static_cast< XParameters * >( this ),
  89                     static_cast< XColumnsSupplier * >( this ),
  90                     static_cast< XResultSetMetaDataSupplier * >( this ),
  91                     static_cast< XPreparedBatchExecution * >( this ),
  92                     static_cast< XMultipleResults * >( this ),
  93                     static_cast< XPreparedStatement * >( this ));
  94     return aIface;
  95 }
  96
  97 void OPreparedStatement::acquire() noexcept
  98 {
  99     OStatementBase::acquire();
 100 }
 101
 102 void OPreparedStatement::release() noexcept
 103 {
 104     OStatementBase::release();
 105 }
 106
 107 // XServiceInfo
 108 OUString OPreparedStatement::getImplementationName(  )
 109 {
 110     return u"com.sun.star.sdb.OPreparedStatement"_ustr;
 111 }
 112
 113 sal_Bool OPreparedStatement::supportsService( const OUString& _rServiceName )
 114 {
 115     return cppu::supportsService(this, _rServiceName);
 116 }
 117
 118 Sequence< OUString > OPreparedStatement::getSupportedServiceNames(  )
 119 {
 120     return { SERVICE_SDBC_PREPAREDSTATEMENT, SERVICE_SDB_PREPAREDSTATEMENT };
 121 }
 122
 123 // OComponentHelper
 124 void OPreparedStatement::disposing()
 125 {
 126     {
 127         MutexGuard aGuard(m_aMutex);
 128         m_pColumns->disposing();
 129         m_xAggregateAsParameters = nullptr;
 130     }
 131     OStatementBase::disposing();
 132 }
 133
 134 // css::sdbcx::XColumnsSupplier
 135 Reference< css::container::XNameAccess > OPreparedStatement::getColumns()
 136 {
 137     MutexGuard aGuard(m_aMutex);
 138     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 139
 140     // do we have to populate the columns
 141     if (!m_pColumns->isInitialized())
 142     {
 143         try
 144         {
 145             Reference< XResultSetMetaDataSupplier > xSuppMeta( m_xAggregateAsSet, UNO_QUERY_THROW );
 146             Reference< XResultSetMetaData > xMetaData( xSuppMeta->getMetaData(), UNO_SET_THROW );
 147
 148             Reference< XConnection > xConn( getConnection(), UNO_SET_THROW );
 149             Reference< XDatabaseMetaData > xDBMeta( xConn->getMetaData(), UNO_SET_THROW );
 150
 151             for (sal_Int32 i = 0, nCount = xMetaData->getColumnCount(); i < nCount; ++i)
 152             {
 153                 // retrieve the name of the column
 154                 OUString aName = xMetaData->getColumnName(i + 1);
 155                 rtl::Reference<OResultColumn> pColumn = new OResultColumn(xMetaData, i + 1, xDBMeta);
 156                 // don't silently assume that the name is unique - preparedStatement implementations
 157                 // are allowed to return duplicate names, but we are required to have
 158                 // unique column names
 159                 if ( m_pColumns->hasByName( aName ) )
 160                     aName = ::dbtools::createUniqueName( m_pColumns.get(), aName );
 161
 162                 m_pColumns->append(aName, pColumn.get());
 163             }
 164         }
 165         catch (const SQLException& )
 166         {
 167             DBG_UNHANDLED_EXCEPTION("dbaccess");
 168         }
 169         m_pColumns->setInitialized();
 170     }
 171     return m_pColumns.get();
 172 }
 173
 174 // XResultSetMetaDataSupplier
 175 Reference< XResultSetMetaData > OPreparedStatement::getMetaData()
 176 {
 177     MutexGuard aGuard(m_aMutex);
 178     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 179     return Reference< XResultSetMetaDataSupplier >( m_xAggregateAsSet, UNO_QUERY_THROW )->getMetaData();
 180 }
 181
 182 // XPreparedStatement
 183 Reference< XResultSet >  OPreparedStatement::executeQuery()
 184 {
 185     MutexGuard aGuard(m_aMutex);
 186     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 187
 188     disposeResultSet();
 189
 190     Reference< XResultSet > xResultSet;
 191     Reference< XResultSet > xDrvResultSet = Reference< XPreparedStatement >( m_xAggregateAsSet, UNO_QUERY_THROW )->executeQuery();
 192     if (xDrvResultSet.is())
 193     {
 194         xResultSet = new OResultSet(xDrvResultSet, *this, m_pColumns->isCaseSensitive());
 195
 196         // keep the resultset weak
 197         m_aResultSet = xResultSet;
 198     }
 199     return xResultSet;
 200 }
 201
 202 sal_Int32 OPreparedStatement::executeUpdate()
 203 {
 204     MutexGuard aGuard(m_aMutex);
 205     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 206
 207     disposeResultSet();
 208
 209     return Reference< XPreparedStatement >( m_xAggregateAsSet, UNO_QUERY_THROW )->executeUpdate();
 210 }
 211
 212 sal_Bool OPreparedStatement::execute()
 213 {
 214     MutexGuard aGuard(m_aMutex);
 215     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 216
 217     disposeResultSet();
 218
 219     return Reference< XPreparedStatement >( m_xAggregateAsSet, UNO_QUERY_THROW )->execute();
 220 }
 221
 222 Reference< XConnection > OPreparedStatement::getConnection()
 223 {
 224     return m_xParent.get();
 225 }
 226
 227 // XParameters
 228 void SAL_CALL OPreparedStatement::setNull( sal_Int32 parameterIndex, sal_Int32 sqlType )
 229 {
 230     MutexGuard aGuard(m_aMutex);
 231     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 232
 233     m_xAggregateAsParameters->setNull(parameterIndex, sqlType);
 234 }
 235
 236 void SAL_CALL OPreparedStatement::setObjectNull( sal_Int32 parameterIndex, sal_Int32 sqlType, const OUString& typeName )
 237 {
 238     MutexGuard aGuard(m_aMutex);
 239     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 240
 241     m_xAggregateAsParameters->setObjectNull(parameterIndex, sqlType, typeName);
 242 }
 243
 244 void SAL_CALL OPreparedStatement::setBoolean( sal_Int32 parameterIndex, sal_Bool x )
 245 {
 246     MutexGuard aGuard(m_aMutex);
 247     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 248
 249     m_xAggregateAsParameters->setBoolean(parameterIndex, x);
 250 }
 251
 252 void SAL_CALL OPreparedStatement::setByte( sal_Int32 parameterIndex, sal_Int8 x )
 253 {
 254     MutexGuard aGuard(m_aMutex);
 255     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 256
 257     m_xAggregateAsParameters->setByte(parameterIndex, x);
 258 }
 259
 260 void SAL_CALL OPreparedStatement::setShort( sal_Int32 parameterIndex, sal_Int16 x )
 261 {
 262     MutexGuard aGuard(m_aMutex);
 263     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 264
 265     m_xAggregateAsParameters->setShort(parameterIndex, x);
 266 }
 267
 268 void SAL_CALL OPreparedStatement::setInt( sal_Int32 parameterIndex, sal_Int32 x )
 269 {
 270     MutexGuard aGuard(m_aMutex);
 271     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 272
 273     m_xAggregateAsParameters->setInt(parameterIndex, x);
 274 }
 275
 276 void SAL_CALL OPreparedStatement::setLong( sal_Int32 parameterIndex, sal_Int64 x )
 277 {
 278     MutexGuard aGuard(m_aMutex);
 279     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 280
 281     m_xAggregateAsParameters->setLong(parameterIndex, x);
 282 }
 283
 284 void SAL_CALL OPreparedStatement::setFloat( sal_Int32 parameterIndex, float x )
 285 {
 286     MutexGuard aGuard(m_aMutex);
 287     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 288
 289     m_xAggregateAsParameters->setFloat(parameterIndex, x);
 290 }
 291
 292 void SAL_CALL OPreparedStatement::setDouble( sal_Int32 parameterIndex, double x )
 293 {
 294     MutexGuard aGuard(m_aMutex);
 295     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 296
 297     m_xAggregateAsParameters->setDouble(parameterIndex, x);
 298 }
 299
 300 void SAL_CALL OPreparedStatement::setString( sal_Int32 parameterIndex, const OUString& x )
 301 {
 302     MutexGuard aGuard(m_aMutex);
 303     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 304
 305     m_xAggregateAsParameters->setString(parameterIndex, x);
 306 }
 307
 308 void SAL_CALL OPreparedStatement::setBytes( sal_Int32 parameterIndex, const Sequence< sal_Int8 >& x )
 309 {
 310     MutexGuard aGuard(m_aMutex);
 311     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 312
 313     m_xAggregateAsParameters->setBytes(parameterIndex, x);
 314 }
 315
 316 void SAL_CALL OPreparedStatement::setDate( sal_Int32 parameterIndex, const css::util::Date& x )
 317 {
 318     MutexGuard aGuard(m_aMutex);
 319     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 320
 321     m_xAggregateAsParameters->setDate(parameterIndex, x);
 322 }
 323
 324 void SAL_CALL OPreparedStatement::setTime( sal_Int32 parameterIndex, const css::util::Time& x )
 325 {
 326     MutexGuard aGuard(m_aMutex);
 327     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 328
 329     m_xAggregateAsParameters->setTime(parameterIndex, x);
 330 }
 331
 332 void SAL_CALL OPreparedStatement::setTimestamp( sal_Int32 parameterIndex, const css::util::DateTime& x )
 333 {
 334     MutexGuard aGuard(m_aMutex);
 335     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 336
 337     m_xAggregateAsParameters->setTimestamp(parameterIndex, x);
 338 }
 339
 340 void SAL_CALL OPreparedStatement::setBinaryStream( sal_Int32 parameterIndex, const Reference< css::io::XInputStream >& x, sal_Int32 length )
 341 {
 342     MutexGuard aGuard(m_aMutex);
 343     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 344
 345     m_xAggregateAsParameters->setBinaryStream(parameterIndex, x, length);
 346 }
 347
 348 void SAL_CALL OPreparedStatement::setCharacterStream( sal_Int32 parameterIndex, const Reference< css::io::XInputStream >& x, sal_Int32 length )
 349 {
 350     MutexGuard aGuard(m_aMutex);
 351     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 352
 353     m_xAggregateAsParameters->setCharacterStream(parameterIndex, x, length);
 354 }
 355
 356 void SAL_CALL OPreparedStatement::setObject( sal_Int32 parameterIndex, const Any& x )
 357 {
 358     MutexGuard aGuard(m_aMutex);
 359     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 360
 361     m_xAggregateAsParameters->setObject(parameterIndex, x);
 362 }
 363
 364 void SAL_CALL OPreparedStatement::setObjectWithInfo( sal_Int32 parameterIndex, const Any& x, sal_Int32 targetSqlType, sal_Int32 scale )
 365 {
 366     MutexGuard aGuard(m_aMutex);
 367     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 368
 369     m_xAggregateAsParameters->setObjectWithInfo(parameterIndex, x, targetSqlType, scale);
 370 }
 371
 372 void SAL_CALL OPreparedStatement::setRef( sal_Int32 parameterIndex, const Reference< XRef >& x )
 373 {
 374     MutexGuard aGuard(m_aMutex);
 375     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 376
 377     m_xAggregateAsParameters->setRef(parameterIndex, x);
 378 }
 379
 380 void SAL_CALL OPreparedStatement::setBlob( sal_Int32 parameterIndex, const Reference< XBlob >& x )
 381 {
 382     MutexGuard aGuard(m_aMutex);
 383     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 384
 385     m_xAggregateAsParameters->setBlob(parameterIndex, x);
 386 }
 387
 388 void SAL_CALL OPreparedStatement::setClob( sal_Int32 parameterIndex, const Reference< XClob >& x )
 389 {
 390     MutexGuard aGuard(m_aMutex);
 391     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 392
 393     m_xAggregateAsParameters->setClob(parameterIndex, x);
 394 }
 395
 396 void SAL_CALL OPreparedStatement::setArray( sal_Int32 parameterIndex, const Reference< XArray >& x )
 397 {
 398     MutexGuard aGuard(m_aMutex);
 399     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 400
 401     m_xAggregateAsParameters->setArray(parameterIndex, x);
 402 }
 403
 404 void SAL_CALL OPreparedStatement::clearParameters(  )
 405 {
 406     MutexGuard aGuard(m_aMutex);
 407     ::connectivity::checkDisposed(WeakComponentImplHelper::rBHelper.bDisposed);
 408
 409     m_xAggregateAsParameters->clearParameters();
 410 }
 411
 412 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */