1*9b5730f6SAndrew Rist /************************************************************** 2cdf0e10cSrcweir * 3*9b5730f6SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4*9b5730f6SAndrew Rist * or more contributor license agreements. See the NOTICE file 5*9b5730f6SAndrew Rist * distributed with this work for additional information 6*9b5730f6SAndrew Rist * regarding copyright ownership. The ASF licenses this file 7*9b5730f6SAndrew Rist * to you under the Apache License, Version 2.0 (the 8*9b5730f6SAndrew Rist * "License"); you may not use this file except in compliance 9*9b5730f6SAndrew Rist * with the License. You may obtain a copy of the License at 10cdf0e10cSrcweir * 11*9b5730f6SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12cdf0e10cSrcweir * 13*9b5730f6SAndrew Rist * Unless required by applicable law or agreed to in writing, 14*9b5730f6SAndrew Rist * software distributed under the License is distributed on an 15*9b5730f6SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*9b5730f6SAndrew Rist * KIND, either express or implied. See the License for the 17*9b5730f6SAndrew Rist * specific language governing permissions and limitations 18*9b5730f6SAndrew Rist * under the License. 19cdf0e10cSrcweir * 20*9b5730f6SAndrew Rist *************************************************************/ 21*9b5730f6SAndrew Rist 22*9b5730f6SAndrew Rist 23cdf0e10cSrcweir 24cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove 25cdf0e10cSrcweir #include "precompiled_connectivity.hxx" 26cdf0e10cSrcweir #include "ado/ADriver.hxx" 27cdf0e10cSrcweir #include "ado/AConnection.hxx" 28cdf0e10cSrcweir #include "ado/Awrapadox.hxx" 29cdf0e10cSrcweir #include "ado/ACatalog.hxx" 30cdf0e10cSrcweir #include "ado/Awrapado.hxx" 31cdf0e10cSrcweir #include "ado/adoimp.hxx" 32cdf0e10cSrcweir #include <com/sun/star/lang/DisposedException.hpp> 33cdf0e10cSrcweir #include "connectivity/dbexception.hxx" 34cdf0e10cSrcweir #include "resource/ado_res.hrc" 35cdf0e10cSrcweir #include <Objbase.h> 36cdf0e10cSrcweir 37cdf0e10cSrcweir 38cdf0e10cSrcweir #include "resource/sharedresources.hxx" 39cdf0e10cSrcweir 40cdf0e10cSrcweir using namespace connectivity; 41cdf0e10cSrcweir using namespace connectivity::ado; 42cdf0e10cSrcweir using namespace com::sun::star::uno; 43cdf0e10cSrcweir using namespace com::sun::star::lang; 44cdf0e10cSrcweir using namespace com::sun::star::beans; 45cdf0e10cSrcweir using namespace com::sun::star::sdbc; 46cdf0e10cSrcweir using namespace com::sun::star::sdbcx; 47cdf0e10cSrcweir using namespace com::sun::star::lang; 48cdf0e10cSrcweir 49cdf0e10cSrcweir // -------------------------------------------------------------------------------- 50cdf0e10cSrcweir // -------------------------------------------------------------------------------- 51cdf0e10cSrcweir ODriver::ODriver(const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _xORB) 52cdf0e10cSrcweir : ODriver_BASE(m_aMutex) 53cdf0e10cSrcweir ,m_xORB(_xORB) 54cdf0e10cSrcweir { 55cdf0e10cSrcweir if ( FAILED(CoInitializeEx(NULL, COINIT_APARTMENTTHREADED)) ) 56cdf0e10cSrcweir { 57cdf0e10cSrcweir CoUninitialize(); 58cdf0e10cSrcweir int h = CoInitializeEx(NULL, COINIT_APARTMENTTHREADED); 59cdf0e10cSrcweir (void)h; 60cdf0e10cSrcweir ++h; 61cdf0e10cSrcweir } 62cdf0e10cSrcweir } 63cdf0e10cSrcweir // ------------------------------------------------------------------------- 64cdf0e10cSrcweir ODriver::~ODriver() 65cdf0e10cSrcweir { 66cdf0e10cSrcweir CoUninitialize(); 67cdf0e10cSrcweir CoInitialize(NULL); 68cdf0e10cSrcweir } 69cdf0e10cSrcweir //------------------------------------------------------------------------------ 70cdf0e10cSrcweir void ODriver::disposing() 71cdf0e10cSrcweir { 72cdf0e10cSrcweir ::osl::MutexGuard aGuard(m_aMutex); 73cdf0e10cSrcweir 74cdf0e10cSrcweir 75cdf0e10cSrcweir for (OWeakRefArray::iterator i = m_xConnections.begin(); m_xConnections.end() != i; ++i) 76cdf0e10cSrcweir { 77cdf0e10cSrcweir Reference< XComponent > xComp(i->get(), UNO_QUERY); 78cdf0e10cSrcweir if (xComp.is()) 79cdf0e10cSrcweir xComp->dispose(); 80cdf0e10cSrcweir } 81cdf0e10cSrcweir m_xConnections.clear(); 82cdf0e10cSrcweir 83cdf0e10cSrcweir ODriver_BASE::disposing(); 84cdf0e10cSrcweir } 85cdf0e10cSrcweir // static ServiceInfo 86cdf0e10cSrcweir //------------------------------------------------------------------------------ 87cdf0e10cSrcweir rtl::OUString ODriver::getImplementationName_Static( ) throw(RuntimeException) 88cdf0e10cSrcweir { 89cdf0e10cSrcweir return rtl::OUString::createFromAscii("com.sun.star.comp.sdbc.ado.ODriver"); 90cdf0e10cSrcweir } 91cdf0e10cSrcweir //------------------------------------------------------------------------------ 92cdf0e10cSrcweir Sequence< ::rtl::OUString > ODriver::getSupportedServiceNames_Static( ) throw (RuntimeException) 93cdf0e10cSrcweir { 94cdf0e10cSrcweir Sequence< ::rtl::OUString > aSNS( 2 ); 95cdf0e10cSrcweir aSNS[0] = ::rtl::OUString::createFromAscii("com.sun.star.sdbc.Driver"); 96cdf0e10cSrcweir aSNS[1] = ::rtl::OUString::createFromAscii("com.sun.star.sdbcx.Driver"); 97cdf0e10cSrcweir return aSNS; 98cdf0e10cSrcweir } 99cdf0e10cSrcweir //------------------------------------------------------------------ 100cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::uno::XInterface > SAL_CALL connectivity::ado::ODriver_CreateInstance(const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _rxFactory) throw( ::com::sun::star::uno::Exception ) 101cdf0e10cSrcweir { 102cdf0e10cSrcweir return *(new ODriver(_rxFactory)); 103cdf0e10cSrcweir } 104cdf0e10cSrcweir 105cdf0e10cSrcweir // -------------------------------------------------------------------------------- 106cdf0e10cSrcweir ::rtl::OUString SAL_CALL ODriver::getImplementationName( ) throw(RuntimeException) 107cdf0e10cSrcweir { 108cdf0e10cSrcweir return getImplementationName_Static(); 109cdf0e10cSrcweir } 110cdf0e10cSrcweir 111cdf0e10cSrcweir // -------------------------------------------------------------------------------- 112cdf0e10cSrcweir sal_Bool SAL_CALL ODriver::supportsService( const ::rtl::OUString& _rServiceName ) throw(RuntimeException) 113cdf0e10cSrcweir { 114cdf0e10cSrcweir Sequence< ::rtl::OUString > aSupported(getSupportedServiceNames()); 115cdf0e10cSrcweir const ::rtl::OUString* pSupported = aSupported.getConstArray(); 116cdf0e10cSrcweir const ::rtl::OUString* pEnd = pSupported + aSupported.getLength(); 117cdf0e10cSrcweir for (;pSupported != pEnd && !pSupported->equals(_rServiceName); ++pSupported) 118cdf0e10cSrcweir ; 119cdf0e10cSrcweir 120cdf0e10cSrcweir return pSupported != pEnd; 121cdf0e10cSrcweir } 122cdf0e10cSrcweir 123cdf0e10cSrcweir // -------------------------------------------------------------------------------- 124cdf0e10cSrcweir Sequence< ::rtl::OUString > SAL_CALL ODriver::getSupportedServiceNames( ) throw(RuntimeException) 125cdf0e10cSrcweir { 126cdf0e10cSrcweir return getSupportedServiceNames_Static(); 127cdf0e10cSrcweir } 128cdf0e10cSrcweir 129cdf0e10cSrcweir // -------------------------------------------------------------------------------- 130cdf0e10cSrcweir Reference< XConnection > SAL_CALL ODriver::connect( const ::rtl::OUString& url, const Sequence< PropertyValue >& info ) throw(SQLException, RuntimeException) 131cdf0e10cSrcweir { 132cdf0e10cSrcweir if ( ! acceptsURL(url) ) 133cdf0e10cSrcweir return NULL; 134cdf0e10cSrcweir 135cdf0e10cSrcweir OConnection* pCon = new OConnection(this); 136cdf0e10cSrcweir pCon->construct(url,info); 137cdf0e10cSrcweir Reference< XConnection > xCon = pCon; 138cdf0e10cSrcweir m_xConnections.push_back(WeakReferenceHelper(*pCon)); 139cdf0e10cSrcweir 140cdf0e10cSrcweir return xCon; 141cdf0e10cSrcweir } 142cdf0e10cSrcweir // -------------------------------------------------------------------------------- 143cdf0e10cSrcweir sal_Bool SAL_CALL ODriver::acceptsURL( const ::rtl::OUString& url ) 144cdf0e10cSrcweir throw(SQLException, RuntimeException) 145cdf0e10cSrcweir { 146cdf0e10cSrcweir return (!url.compareTo(::rtl::OUString::createFromAscii("sdbc:ado:"),9)); 147cdf0e10cSrcweir } 148cdf0e10cSrcweir // ----------------------------------------------------------------------------- 149cdf0e10cSrcweir void ODriver::impl_checkURL_throw(const ::rtl::OUString& _sUrl) 150cdf0e10cSrcweir { 151cdf0e10cSrcweir if ( !acceptsURL(_sUrl) ) 152cdf0e10cSrcweir { 153cdf0e10cSrcweir SharedResources aResources; 154cdf0e10cSrcweir const ::rtl::OUString sMessage = aResources.getResourceString(STR_URI_SYNTAX_ERROR); 155cdf0e10cSrcweir ::dbtools::throwGenericSQLException(sMessage ,*this); 156cdf0e10cSrcweir } // if ( !acceptsURL(_sUrl) ) 157cdf0e10cSrcweir } 158cdf0e10cSrcweir // -------------------------------------------------------------------------------- 159cdf0e10cSrcweir Sequence< DriverPropertyInfo > SAL_CALL ODriver::getPropertyInfo( const ::rtl::OUString& url, const Sequence< PropertyValue >& /*info*/ ) throw(SQLException, RuntimeException) 160cdf0e10cSrcweir { 161cdf0e10cSrcweir impl_checkURL_throw(url); 162cdf0e10cSrcweir if ( acceptsURL(url) ) 163cdf0e10cSrcweir { 164cdf0e10cSrcweir ::std::vector< DriverPropertyInfo > aDriverInfo; 165cdf0e10cSrcweir 166cdf0e10cSrcweir Sequence< ::rtl::OUString > aBooleanValues(2); 167cdf0e10cSrcweir aBooleanValues[0] = ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "false" ) ); 168cdf0e10cSrcweir aBooleanValues[1] = ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "true" ) ); 169cdf0e10cSrcweir 170cdf0e10cSrcweir aDriverInfo.push_back(DriverPropertyInfo( 171cdf0e10cSrcweir ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("IgnoreDriverPrivileges")) 172cdf0e10cSrcweir ,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Ignore the privileges from the database driver.")) 173cdf0e10cSrcweir ,sal_False 174cdf0e10cSrcweir ,::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "false" ) ) 175cdf0e10cSrcweir ,aBooleanValues) 176cdf0e10cSrcweir ); 177cdf0e10cSrcweir aDriverInfo.push_back(DriverPropertyInfo( 178cdf0e10cSrcweir ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("EscapeDateTime")) 179cdf0e10cSrcweir ,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Escape date time format.")) 180cdf0e10cSrcweir ,sal_False 181cdf0e10cSrcweir ,::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "true" ) ) 182cdf0e10cSrcweir ,aBooleanValues) 183cdf0e10cSrcweir ); 184cdf0e10cSrcweir aDriverInfo.push_back(DriverPropertyInfo( 185cdf0e10cSrcweir ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("TypeInfoSettings")) 186cdf0e10cSrcweir ,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Defines how the type info of the database metadata should be manipulated.")) 187cdf0e10cSrcweir ,sal_False 188cdf0e10cSrcweir ,::rtl::OUString( ) 189cdf0e10cSrcweir ,Sequence< ::rtl::OUString > ()) 190cdf0e10cSrcweir ); 191cdf0e10cSrcweir return Sequence< DriverPropertyInfo >(&aDriverInfo[0],aDriverInfo.size()); 192cdf0e10cSrcweir } 193cdf0e10cSrcweir return Sequence< DriverPropertyInfo >(); 194cdf0e10cSrcweir } 195cdf0e10cSrcweir // -------------------------------------------------------------------------------- 196cdf0e10cSrcweir sal_Int32 SAL_CALL ODriver::getMajorVersion( ) throw(RuntimeException) 197cdf0e10cSrcweir { 198cdf0e10cSrcweir return 1; 199cdf0e10cSrcweir } 200cdf0e10cSrcweir // -------------------------------------------------------------------------------- 201cdf0e10cSrcweir sal_Int32 SAL_CALL ODriver::getMinorVersion( ) throw(RuntimeException) 202cdf0e10cSrcweir { 203cdf0e10cSrcweir return 0; 204cdf0e10cSrcweir } 205cdf0e10cSrcweir // -------------------------------------------------------------------------------- 206cdf0e10cSrcweir // XDataDefinitionSupplier 207cdf0e10cSrcweir Reference< XTablesSupplier > SAL_CALL ODriver::getDataDefinitionByConnection( const Reference< ::com::sun::star::sdbc::XConnection >& connection ) throw(::com::sun::star::sdbc::SQLException, RuntimeException) 208cdf0e10cSrcweir { 209cdf0e10cSrcweir ::osl::MutexGuard aGuard( m_aMutex ); 210cdf0e10cSrcweir if (ODriver_BASE::rBHelper.bDisposed) 211cdf0e10cSrcweir throw DisposedException(); 212cdf0e10cSrcweir 213cdf0e10cSrcweir OConnection* pConnection = NULL; 214cdf0e10cSrcweir Reference< ::com::sun::star::lang::XUnoTunnel> xTunnel(connection,UNO_QUERY); 215cdf0e10cSrcweir if(xTunnel.is()) 216cdf0e10cSrcweir { 217cdf0e10cSrcweir OConnection* pSearchConnection = reinterpret_cast< OConnection* >( xTunnel->getSomething(OConnection::getUnoTunnelImplementationId()) ); 218cdf0e10cSrcweir 219cdf0e10cSrcweir for (OWeakRefArray::iterator i = m_xConnections.begin(); m_xConnections.end() != i; ++i) 220cdf0e10cSrcweir { 221cdf0e10cSrcweir if ((OConnection*) Reference< XConnection >::query(i->get().get()).get() == pSearchConnection) 222cdf0e10cSrcweir { 223cdf0e10cSrcweir pConnection = pSearchConnection; 224cdf0e10cSrcweir break; 225cdf0e10cSrcweir } 226cdf0e10cSrcweir } 227cdf0e10cSrcweir 228cdf0e10cSrcweir } 229cdf0e10cSrcweir 230cdf0e10cSrcweir Reference< XTablesSupplier > xTab = NULL; 231cdf0e10cSrcweir if(pConnection) 232cdf0e10cSrcweir { 233cdf0e10cSrcweir WpADOCatalog aCatalog; 234cdf0e10cSrcweir aCatalog.Create(); 235cdf0e10cSrcweir if(aCatalog.IsValid()) 236cdf0e10cSrcweir { 237cdf0e10cSrcweir aCatalog.putref_ActiveConnection(*pConnection->getConnection()); 238cdf0e10cSrcweir OCatalog* pCatalog = new OCatalog(aCatalog,pConnection); 239cdf0e10cSrcweir xTab = pCatalog; 240cdf0e10cSrcweir pConnection->setCatalog(xTab); 241cdf0e10cSrcweir pConnection->setCatalog(pCatalog); 242cdf0e10cSrcweir } 243cdf0e10cSrcweir } 244cdf0e10cSrcweir return xTab; 245cdf0e10cSrcweir } 246cdf0e10cSrcweir // -------------------------------------------------------------------------------- 247cdf0e10cSrcweir Reference< XTablesSupplier > SAL_CALL ODriver::getDataDefinitionByURL( const ::rtl::OUString& url, const Sequence< PropertyValue >& info ) throw(::com::sun::star::sdbc::SQLException, RuntimeException) 248cdf0e10cSrcweir { 249cdf0e10cSrcweir impl_checkURL_throw(url); 250cdf0e10cSrcweir return getDataDefinitionByConnection(connect(url,info)); 251cdf0e10cSrcweir } 252cdf0e10cSrcweir 253cdf0e10cSrcweir // ----------------------------------------------------------------------------- 254cdf0e10cSrcweir void ADOS::ThrowException(ADOConnection* _pAdoCon,const Reference< XInterface >& _xInterface) throw(SQLException, RuntimeException) 255cdf0e10cSrcweir { 256cdf0e10cSrcweir ADOErrors *pErrors = NULL; 257cdf0e10cSrcweir _pAdoCon->get_Errors(&pErrors); 258cdf0e10cSrcweir if(!pErrors) 259cdf0e10cSrcweir return; // no error found 260cdf0e10cSrcweir 261cdf0e10cSrcweir pErrors->AddRef( ); 262cdf0e10cSrcweir 263cdf0e10cSrcweir // alle aufgelaufenen Fehler auslesen und ausgeben 264cdf0e10cSrcweir sal_Int32 nLen; 265cdf0e10cSrcweir pErrors->get_Count(&nLen); 266cdf0e10cSrcweir if (nLen) 267cdf0e10cSrcweir { 268cdf0e10cSrcweir ::rtl::OUString sError; 269cdf0e10cSrcweir ::rtl::OUString aSQLState; 270cdf0e10cSrcweir SQLException aException; 271cdf0e10cSrcweir aException.ErrorCode = 1000; 272cdf0e10cSrcweir for (sal_Int32 i = nLen-1; i>=0; --i) 273cdf0e10cSrcweir { 274cdf0e10cSrcweir ADOError *pError = NULL; 275cdf0e10cSrcweir pErrors->get_Item(OLEVariant(i),&pError); 276cdf0e10cSrcweir WpADOError aErr(pError); 277cdf0e10cSrcweir OSL_ENSURE(pError,"No error in collection found! BAD!"); 278cdf0e10cSrcweir if(pError) 279cdf0e10cSrcweir { 280cdf0e10cSrcweir if(i==nLen-1) 281cdf0e10cSrcweir aException = SQLException(aErr.GetDescription(),_xInterface,aErr.GetSQLState(),aErr.GetNumber(),Any()); 282cdf0e10cSrcweir else 283cdf0e10cSrcweir { 284cdf0e10cSrcweir SQLException aTemp = SQLException(aErr.GetDescription(), 285cdf0e10cSrcweir _xInterface,aErr.GetSQLState(),aErr.GetNumber(),makeAny(aException)); 286cdf0e10cSrcweir aTemp.NextException <<= aException; 287cdf0e10cSrcweir aException = aTemp; 288cdf0e10cSrcweir } 289cdf0e10cSrcweir } 290cdf0e10cSrcweir } 291cdf0e10cSrcweir pErrors->Clear(); 292cdf0e10cSrcweir pErrors->Release(); 293cdf0e10cSrcweir throw aException; 294cdf0e10cSrcweir } 295cdf0e10cSrcweir pErrors->Release(); 296cdf0e10cSrcweir } 297cdf0e10cSrcweir 298cdf0e10cSrcweir 299