odk/examples/DevelopersGuide/Database/DriverSkeleton/SPreparedStatement.cxx

   1 /*************************************************************************
   2  *
   3  *  $RCSfile: SPreparedStatement.cxx,v $
   4  *
   5  *  $Revision: 1.6 $
   6  *
   7  *  last change: $Author: rt $ $Date: 2008-04-10 16:34:02 $
   8  *
   9  *  The Contents of this file are made available subject to the terms of
  10  *  the BSD license.
  11  *
  12  *  Copyright (c) 2003 by Sun Microsystems, Inc.
  13  *  All rights reserved.
  14  *
  15  *  Redistribution and use in source and binary forms, with or without
  16  *  modification, are permitted provided that the following conditions
  17  *  are met:
  18  *  1. Redistributions of source code must retain the above copyright
  19  *     notice, this list of conditions and the following disclaimer.
  20  *  2. Redistributions in binary form must reproduce the above copyright
  21  *     notice, this list of conditions and the following disclaimer in the
  22  *     documentation and/or other materials provided with the distribution.
  23  *  3. Neither the name of Sun Microsystems, Inc. nor the names of its
  24  *     contributors may be used to endorse or promote products derived
  25  *     from this software without specific prior written permission.
  26  *
  27  *  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
  28  *  "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
  29  *  LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
  30  *  FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
  31  *  COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
  32  *  INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
  33  *  BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS
  34  *  OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
  35  *  ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR
  36  *  TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE
  37  *  USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  38  *
  39  *************************************************************************/
  40
  41 #include <stdio.h>
  42 #include <osl/diagnose.h>
  43 #include "SPreparedStatement.hxx"
  44 #include <com/sun/star/sdbc/DataType.hpp>
  45 #include "SResultSetMetaData.hxx"
  46 #include <cppuhelper/typeprovider.hxx>
  47 #include <com/sun/star/lang/DisposedException.hpp>
  48 #include "propertyids.hxx"
  49
  50 using namespace connectivity::skeleton;
  51 using namespace com::sun::star::uno;
  52 using namespace com::sun::star::lang;
  53 using namespace com::sun::star::beans;
  54 using namespace com::sun::star::sdbc;
  55 using namespace com::sun::star::container;
  56 using namespace com::sun::star::io;
  57 using namespace com::sun::star::util;
  58
  59 IMPLEMENT_SERVICE_INFO(OPreparedStatement,"com.sun.star.sdbcx.skeleton.PreparedStatement","com.sun.star.sdbc.PreparedStatement");
  60
  61
  62 OPreparedStatement::OPreparedStatement( OConnection* _pConnection,const TTypeInfoVector& _TypeInfo,const ::rtl::OUString& sql)
  63     :OStatement_BASE2(_pConnection)
  64     ,m_aTypeInfo(_TypeInfo)
  65     ,m_bPrepared(sal_False)
  66     ,m_sSqlStatement(sql)
  67     ,m_nNumParams(0)
  68 {
  69 }
  70 // -----------------------------------------------------------------------------
  71 OPreparedStatement::~OPreparedStatement()
  72 {
  73 }
  74 // -----------------------------------------------------------------------------
  75 void SAL_CALL OPreparedStatement::acquire() throw()
  76 {
  77     OStatement_BASE2::acquire();
  78 }
  79 // -----------------------------------------------------------------------------
  80 void SAL_CALL OPreparedStatement::release() throw()
  81 {
  82     OStatement_BASE2::release();
  83 }
  84 // -----------------------------------------------------------------------------
  85 Any SAL_CALL OPreparedStatement::queryInterface( const Type & rType ) throw(RuntimeException)
  86 {
  87     Any aRet = OStatement_BASE2::queryInterface(rType);
  88     if(!aRet.hasValue())
  89         aRet = OPreparedStatement_BASE::queryInterface(rType);
  90     return aRet;
  91 }
  92 // -------------------------------------------------------------------------
  93 ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Type > SAL_CALL OPreparedStatement::getTypes(  ) throw(::com::sun::star::uno::RuntimeException)
  94 {
  95     return concatSequences(OPreparedStatement_BASE::getTypes(),OStatement_BASE2::getTypes());
  96 }
  97 // -------------------------------------------------------------------------
  98
  99 Reference< XResultSetMetaData > SAL_CALL OPreparedStatement::getMetaData(  ) throw(SQLException, RuntimeException)
 100 {
 101     ::osl::MutexGuard aGuard( m_aMutex );
 102     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 103
 104     if(!m_xMetaData.is())
 105         m_xMetaData = new OResultSetMetaData(getOwnConnection());
 106     return m_xMetaData;
 107 }
 108 // -------------------------------------------------------------------------
 109
 110 void SAL_CALL OPreparedStatement::close(  ) throw(SQLException, RuntimeException)
 111 {
 112     ::osl::MutexGuard aGuard( m_aMutex );
 113     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 114
 115
 116     // Reset last warning message
 117
 118     try {
 119         clearWarnings ();
 120         OStatement_BASE2::close();
 121     }
 122     catch (SQLException &) {
 123         // If we get an error, ignore
 124     }
 125
 126     // Remove this Statement object from the Connection object's
 127     // list
 128 }
 129 // -------------------------------------------------------------------------
 130
 131 sal_Bool SAL_CALL OPreparedStatement::execute(  ) throw(SQLException, RuntimeException)
 132 {
 133     ::osl::MutexGuard aGuard( m_aMutex );
 134     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 135
 136
 137     // same as in statement with the difference that this statement also can contain parameter
 138     return sal_False;
 139 }
 140 // -------------------------------------------------------------------------
 141
 142 sal_Int32 SAL_CALL OPreparedStatement::executeUpdate(  ) throw(SQLException, RuntimeException)
 143 {
 144     ::osl::MutexGuard aGuard( m_aMutex );
 145     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 146
 147     // same as in statement with the difference that this statement also can contain parameter
 148     return 0;
 149 }
 150 // -------------------------------------------------------------------------
 151
 152 void SAL_CALL OPreparedStatement::setString( sal_Int32 parameterIndex, const ::rtl::OUString& x ) throw(SQLException, RuntimeException)
 153 {
 154     ::osl::MutexGuard aGuard( m_aMutex );
 155     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 156 }
 157 // -------------------------------------------------------------------------
 158
 159 Reference< XConnection > SAL_CALL OPreparedStatement::getConnection(  ) throw(SQLException, RuntimeException)
 160 {
 161     ::osl::MutexGuard aGuard( m_aMutex );
 162     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 163
 164     return (Reference< XConnection >)m_pConnection;
 165 }
 166 // -------------------------------------------------------------------------
 167
 168 Reference< XResultSet > SAL_CALL OPreparedStatement::executeQuery(  ) throw(SQLException, RuntimeException)
 169 {
 170     ::osl::MutexGuard aGuard( m_aMutex );
 171     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 172
 173     Reference< XResultSet > rs = NULL;
 174
 175
 176     return rs;
 177 }
 178 // -------------------------------------------------------------------------
 179
 180 void SAL_CALL OPreparedStatement::setBoolean( sal_Int32 parameterIndex, sal_Bool x ) throw(SQLException, RuntimeException)
 181 {
 182     ::osl::MutexGuard aGuard( m_aMutex );
 183     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 184
 185 }
 186 // -------------------------------------------------------------------------
 187 void SAL_CALL OPreparedStatement::setByte( sal_Int32 parameterIndex, sal_Int8 x ) throw(SQLException, RuntimeException)
 188 {
 189     ::osl::MutexGuard aGuard( m_aMutex );
 190     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 191
 192
 193 }
 194 // -------------------------------------------------------------------------
 195
 196 void SAL_CALL OPreparedStatement::setDate( sal_Int32 parameterIndex, const Date& aData ) throw(SQLException, RuntimeException)
 197 {
 198     ::osl::MutexGuard aGuard( m_aMutex );
 199     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 200
 201 }
 202 // -------------------------------------------------------------------------
 203
 204
 205 void SAL_CALL OPreparedStatement::setTime( sal_Int32 parameterIndex, const Time& aVal ) throw(SQLException, RuntimeException)
 206 {
 207     ::osl::MutexGuard aGuard( m_aMutex );
 208     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 209
 210 }
 211 // -------------------------------------------------------------------------
 212
 213 void SAL_CALL OPreparedStatement::setTimestamp( sal_Int32 parameterIndex, const DateTime& aVal ) throw(SQLException, RuntimeException)
 214 {
 215     ::osl::MutexGuard aGuard( m_aMutex );
 216     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 217
 218 }
 219 // -------------------------------------------------------------------------
 220
 221 void SAL_CALL OPreparedStatement::setDouble( sal_Int32 parameterIndex, double x ) throw(SQLException, RuntimeException)
 222 {
 223     ::osl::MutexGuard aGuard( m_aMutex );
 224     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 225
 226 }
 227
 228 // -------------------------------------------------------------------------
 229
 230 void SAL_CALL OPreparedStatement::setFloat( sal_Int32 parameterIndex, float x ) throw(SQLException, RuntimeException)
 231 {
 232     ::osl::MutexGuard aGuard( m_aMutex );
 233     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 234
 235 }
 236 // -------------------------------------------------------------------------
 237
 238 void SAL_CALL OPreparedStatement::setInt( sal_Int32 parameterIndex, sal_Int32 x ) throw(SQLException, RuntimeException)
 239 {
 240     ::osl::MutexGuard aGuard( m_aMutex );
 241     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 242
 243 }
 244 // -------------------------------------------------------------------------
 245
 246 void SAL_CALL OPreparedStatement::setLong( sal_Int32 parameterIndex, sal_Int64 aVal ) throw(SQLException, RuntimeException)
 247 {
 248     ::osl::MutexGuard aGuard( m_aMutex );
 249     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 250
 251 }
 252 // -------------------------------------------------------------------------
 253
 254 void SAL_CALL OPreparedStatement::setNull( sal_Int32 parameterIndex, sal_Int32 sqlType ) throw(SQLException, RuntimeException)
 255 {
 256     ::osl::MutexGuard aGuard( m_aMutex );
 257     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 258
 259 }
 260 // -------------------------------------------------------------------------
 261
 262 void SAL_CALL OPreparedStatement::setClob( sal_Int32 parameterIndex, const Reference< XClob >& x ) throw(SQLException, RuntimeException)
 263 {
 264     ::osl::MutexGuard aGuard( m_aMutex );
 265     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 266
 267 }
 268 // -------------------------------------------------------------------------
 269
 270 void SAL_CALL OPreparedStatement::setBlob( sal_Int32 parameterIndex, const Reference< XBlob >& x ) throw(SQLException, RuntimeException)
 271 {
 272     ::osl::MutexGuard aGuard( m_aMutex );
 273     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 274
 275 }
 276 // -------------------------------------------------------------------------
 277
 278 void SAL_CALL OPreparedStatement::setArray( sal_Int32 parameterIndex, const Reference< XArray >& x ) throw(SQLException, RuntimeException)
 279 {
 280     ::osl::MutexGuard aGuard( m_aMutex );
 281     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 282
 283 }
 284 // -------------------------------------------------------------------------
 285
 286 void SAL_CALL OPreparedStatement::setRef( sal_Int32 parameterIndex, const Reference< XRef >& x ) throw(SQLException, RuntimeException)
 287 {
 288     ::osl::MutexGuard aGuard( m_aMutex );
 289     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 290
 291 }
 292 // -------------------------------------------------------------------------
 293
 294 void SAL_CALL OPreparedStatement::setObjectWithInfo( sal_Int32 parameterIndex, const Any& x, sal_Int32 sqlType, sal_Int32 scale ) throw(SQLException, RuntimeException)
 295 {
 296     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 297     ::osl::MutexGuard aGuard( m_aMutex );
 298
 299 }
 300 // -------------------------------------------------------------------------
 301
 302 void SAL_CALL OPreparedStatement::setObjectNull( sal_Int32 parameterIndex, sal_Int32 sqlType, const ::rtl::OUString& typeName ) throw(SQLException, RuntimeException)
 303 {
 304     ::osl::MutexGuard aGuard( m_aMutex );
 305     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 306
 307 }
 308 // -------------------------------------------------------------------------
 309
 310 void SAL_CALL OPreparedStatement::setObject( sal_Int32 parameterIndex, const Any& x ) throw(SQLException, RuntimeException)
 311 {
 312     ::osl::MutexGuard aGuard( m_aMutex );
 313     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 314
 315 }
 316 // -------------------------------------------------------------------------
 317
 318 void SAL_CALL OPreparedStatement::setShort( sal_Int32 parameterIndex, sal_Int16 x ) throw(SQLException, RuntimeException)
 319 {
 320     ::osl::MutexGuard aGuard( m_aMutex );
 321     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 322
 323 }
 324 // -------------------------------------------------------------------------
 325
 326 void SAL_CALL OPreparedStatement::setBytes( sal_Int32 parameterIndex, const Sequence< sal_Int8 >& x ) throw(SQLException, RuntimeException)
 327 {
 328     ::osl::MutexGuard aGuard( m_aMutex );
 329     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 330
 331 }
 332 // -------------------------------------------------------------------------
 333
 334
 335 void SAL_CALL OPreparedStatement::setCharacterStream( sal_Int32 parameterIndex, const Reference< ::com::sun::star::io::XInputStream >& x, sal_Int32 length ) throw(SQLException, RuntimeException)
 336 {
 337     ::osl::MutexGuard aGuard( m_aMutex );
 338     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 339
 340 }
 341 // -------------------------------------------------------------------------
 342
 343 void SAL_CALL OPreparedStatement::setBinaryStream( sal_Int32 parameterIndex, const Reference< ::com::sun::star::io::XInputStream >& x, sal_Int32 length ) throw(SQLException, RuntimeException)
 344 {
 345     ::osl::MutexGuard aGuard( m_aMutex );
 346     checkDisposed(OStatement_BASE::rBHelper.bDisposed);
 347
 348 }
 349 // -------------------------------------------------------------------------
 350
 351 void SAL_CALL OPreparedStatement::clearParameters(  ) throw(SQLException, RuntimeException)
 352 {
 353 }
 354 // -------------------------------------------------------------------------
 355 void SAL_CALL OPreparedStatement::clearBatch(  ) throw(SQLException, RuntimeException)
 356 {
 357 }
 358 // -------------------------------------------------------------------------
 359
 360 void SAL_CALL OPreparedStatement::addBatch( ) throw(SQLException, RuntimeException)
 361 {
 362 }
 363 // -------------------------------------------------------------------------
 364
 365 Sequence< sal_Int32 > SAL_CALL OPreparedStatement::executeBatch(  ) throw(SQLException, RuntimeException)
 366 {
 367     return Sequence< sal_Int32 > ();
 368 }
 369 // -------------------------------------------------------------------------
 370 void OPreparedStatement::setFastPropertyValue_NoBroadcast(sal_Int32 nHandle,const Any& rValue) throw (Exception)
 371 {
 372     switch(nHandle)
 373     {
 374         case PROPERTY_ID_RESULTSETCONCURRENCY:
 375             break;
 376         case PROPERTY_ID_RESULTSETTYPE:
 377             break;
 378         case PROPERTY_ID_FETCHDIRECTION:
 379             break;
 380         case PROPERTY_ID_USEBOOKMARKS:
 381             break;
 382         default:
 383             OStatement_Base::setFastPropertyValue_NoBroadcast(nHandle,rValue);
 384     }
 385 }
 386 // -----------------------------------------------------------------------------
 387 void OPreparedStatement::checkParameterIndex(sal_Int32 _parameterIndex)
 388 {
 389     if( !_parameterIndex || _parameterIndex > m_nNumParams)
 390         throw SQLException();
 391 }
 392 // -----------------------------------------------------------------------------
 393
 394