1*b1cdbd2cSJim Jagielski /************************************************************** 2*b1cdbd2cSJim Jagielski * 3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski * distributed with this work for additional information 6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski * 11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski * under the License. 19*b1cdbd2cSJim Jagielski * 20*b1cdbd2cSJim Jagielski *************************************************************/ 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim Jagielski 23*b1cdbd2cSJim Jagielski 24*b1cdbd2cSJim Jagielski // MARKER(update_precomp.py): autogen include statement, do not remove 25*b1cdbd2cSJim Jagielski #include "precompiled_connectivity.hxx" 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski #include "hsqldb/HView.hxx" 28*b1cdbd2cSJim Jagielski #include "hsqldb/HTools.hxx" 29*b1cdbd2cSJim Jagielski 30*b1cdbd2cSJim Jagielski #include "propertyids.hxx" 31*b1cdbd2cSJim Jagielski 32*b1cdbd2cSJim Jagielski #include "connectivity/dbexception.hxx" 33*b1cdbd2cSJim Jagielski #include "connectivity/dbtools.hxx" 34*b1cdbd2cSJim Jagielski 35*b1cdbd2cSJim Jagielski /** === begin UNO includes === **/ 36*b1cdbd2cSJim Jagielski #include <com/sun/star/lang/WrappedTargetException.hpp> 37*b1cdbd2cSJim Jagielski #include <com/sun/star/lang/DisposedException.hpp> 38*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbc/XRow.hpp> 39*b1cdbd2cSJim Jagielski /** === end UNO includes === **/ 40*b1cdbd2cSJim Jagielski 41*b1cdbd2cSJim Jagielski #include <cppuhelper/exc_hlp.hxx> 42*b1cdbd2cSJim Jagielski #include <tools/diagnose_ex.h> 43*b1cdbd2cSJim Jagielski #include <unotools/sharedunocomponent.hxx> 44*b1cdbd2cSJim Jagielski 45*b1cdbd2cSJim Jagielski //........................................................................ 46*b1cdbd2cSJim Jagielski namespace connectivity { namespace hsqldb 47*b1cdbd2cSJim Jagielski { 48*b1cdbd2cSJim Jagielski //........................................................................ 49*b1cdbd2cSJim Jagielski 50*b1cdbd2cSJim Jagielski /** === begin UNO using === **/ 51*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::Reference; 52*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::UNO_QUERY; 53*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::UNO_QUERY_THROW; 54*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::Exception; 55*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::RuntimeException; 56*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::Any; 57*b1cdbd2cSJim Jagielski using ::com::sun::star::uno::makeAny; 58*b1cdbd2cSJim Jagielski using ::com::sun::star::sdbc::XDatabaseMetaData; 59*b1cdbd2cSJim Jagielski using ::com::sun::star::sdbc::SQLException; 60*b1cdbd2cSJim Jagielski using ::com::sun::star::sdbc::XConnection; 61*b1cdbd2cSJim Jagielski using ::com::sun::star::lang::WrappedTargetException; 62*b1cdbd2cSJim Jagielski using ::com::sun::star::sdbc::XResultSet; 63*b1cdbd2cSJim Jagielski using ::com::sun::star::sdbc::XStatement; 64*b1cdbd2cSJim Jagielski using ::com::sun::star::lang::DisposedException; 65*b1cdbd2cSJim Jagielski using ::com::sun::star::sdbc::XRow; 66*b1cdbd2cSJim Jagielski /** === end UNO using === **/ 67*b1cdbd2cSJim Jagielski 68*b1cdbd2cSJim Jagielski //==================================================================== 69*b1cdbd2cSJim Jagielski //= HView 70*b1cdbd2cSJim Jagielski //==================================================================== 71*b1cdbd2cSJim Jagielski //-------------------------------------------------------------------- HView(const Reference<XConnection> & _rxConnection,sal_Bool _bCaseSensitive,const::rtl::OUString & _rSchemaName,const::rtl::OUString & _rName)72*b1cdbd2cSJim Jagielski HView::HView( const Reference< XConnection >& _rxConnection, sal_Bool _bCaseSensitive, 73*b1cdbd2cSJim Jagielski const ::rtl::OUString& _rSchemaName, const ::rtl::OUString& _rName ) 74*b1cdbd2cSJim Jagielski :HView_Base( _bCaseSensitive, _rName, _rxConnection->getMetaData(), 0, ::rtl::OUString(), _rSchemaName, ::rtl::OUString() ) 75*b1cdbd2cSJim Jagielski ,m_xConnection( _rxConnection ) 76*b1cdbd2cSJim Jagielski { 77*b1cdbd2cSJim Jagielski } 78*b1cdbd2cSJim Jagielski 79*b1cdbd2cSJim Jagielski //-------------------------------------------------------------------- ~HView()80*b1cdbd2cSJim Jagielski HView::~HView() 81*b1cdbd2cSJim Jagielski { 82*b1cdbd2cSJim Jagielski } 83*b1cdbd2cSJim Jagielski 84*b1cdbd2cSJim Jagielski //-------------------------------------------------------------------- IMPLEMENT_FORWARD_XINTERFACE2(HView,HView_Base,HView_IBASE)85*b1cdbd2cSJim Jagielski IMPLEMENT_FORWARD_XINTERFACE2( HView, HView_Base, HView_IBASE ) 86*b1cdbd2cSJim Jagielski IMPLEMENT_FORWARD_XTYPEPROVIDER2( HView, HView_Base, HView_IBASE ) 87*b1cdbd2cSJim Jagielski 88*b1cdbd2cSJim Jagielski //-------------------------------------------------------------------- 89*b1cdbd2cSJim Jagielski void SAL_CALL HView::alterCommand( const ::rtl::OUString& _rNewCommand ) throw (SQLException, RuntimeException) 90*b1cdbd2cSJim Jagielski { 91*b1cdbd2cSJim Jagielski // not really atomic ... as long as we do not have something like 92*b1cdbd2cSJim Jagielski // ALTER VIEW <name> TO <command> 93*b1cdbd2cSJim Jagielski // in HSQL, we need to do it this way ... 94*b1cdbd2cSJim Jagielski // 95*b1cdbd2cSJim Jagielski // I can imagine scenarios where this fails, e.g. when dropping the view 96*b1cdbd2cSJim Jagielski // succeedes, re-creating it fails, some other thread alters a table which 97*b1cdbd2cSJim Jagielski // the view was based on, and then we try to restore the view with the 98*b1cdbd2cSJim Jagielski // original command, which then fails, too. 99*b1cdbd2cSJim Jagielski // 100*b1cdbd2cSJim Jagielski // However, there's not much chance to prevent this kind of errors without 101*b1cdbd2cSJim Jagielski // backend support. 102*b1cdbd2cSJim Jagielski 103*b1cdbd2cSJim Jagielski ::rtl::OUString sQualifiedName( ::dbtools::composeTableName( 104*b1cdbd2cSJim Jagielski m_xMetaData, m_CatalogName, m_SchemaName, m_Name, true, ::dbtools::eInDataManipulation ) ); 105*b1cdbd2cSJim Jagielski 106*b1cdbd2cSJim Jagielski ::utl::SharedUNOComponent< XStatement > xStatement; xStatement.set( m_xConnection->createStatement(), UNO_QUERY_THROW ); 107*b1cdbd2cSJim Jagielski 108*b1cdbd2cSJim Jagielski // create a statement which can be used to re-create the original view, in case 109*b1cdbd2cSJim Jagielski // dropping it succeeds, but creating it with a new statement fails 110*b1cdbd2cSJim Jagielski ::rtl::OUStringBuffer aRestoreCommand; 111*b1cdbd2cSJim Jagielski aRestoreCommand.appendAscii( "CREATE VIEW " ); 112*b1cdbd2cSJim Jagielski aRestoreCommand.append ( sQualifiedName ); 113*b1cdbd2cSJim Jagielski aRestoreCommand.appendAscii( " AS " ); 114*b1cdbd2cSJim Jagielski aRestoreCommand.append ( impl_getCommand_throw( true ) ); 115*b1cdbd2cSJim Jagielski ::rtl::OUString sRestoreCommand( aRestoreCommand.makeStringAndClear() ); 116*b1cdbd2cSJim Jagielski 117*b1cdbd2cSJim Jagielski bool bDropSucceeded( false ); 118*b1cdbd2cSJim Jagielski try 119*b1cdbd2cSJim Jagielski { 120*b1cdbd2cSJim Jagielski // drop the existing view 121*b1cdbd2cSJim Jagielski ::rtl::OUStringBuffer aCommand; 122*b1cdbd2cSJim Jagielski aCommand.appendAscii( "DROP VIEW " ); 123*b1cdbd2cSJim Jagielski aCommand.append ( sQualifiedName ); 124*b1cdbd2cSJim Jagielski xStatement->execute( aCommand.makeStringAndClear() ); 125*b1cdbd2cSJim Jagielski bDropSucceeded = true; 126*b1cdbd2cSJim Jagielski 127*b1cdbd2cSJim Jagielski // create a new one with the same name 128*b1cdbd2cSJim Jagielski aCommand.appendAscii( "CREATE VIEW " ); 129*b1cdbd2cSJim Jagielski aCommand.append ( sQualifiedName ); 130*b1cdbd2cSJim Jagielski aCommand.appendAscii( " AS " ); 131*b1cdbd2cSJim Jagielski aCommand.append ( _rNewCommand ); 132*b1cdbd2cSJim Jagielski xStatement->execute( aCommand.makeStringAndClear() ); 133*b1cdbd2cSJim Jagielski } 134*b1cdbd2cSJim Jagielski catch( const SQLException& ) 135*b1cdbd2cSJim Jagielski { 136*b1cdbd2cSJim Jagielski if ( bDropSucceeded ) 137*b1cdbd2cSJim Jagielski // drop succeeded, but creation failed -> re-create the view with the original 138*b1cdbd2cSJim Jagielski // statemnet 139*b1cdbd2cSJim Jagielski xStatement->execute( sRestoreCommand ); 140*b1cdbd2cSJim Jagielski throw; 141*b1cdbd2cSJim Jagielski } 142*b1cdbd2cSJim Jagielski catch( const RuntimeException& ) 143*b1cdbd2cSJim Jagielski { 144*b1cdbd2cSJim Jagielski if ( bDropSucceeded ) 145*b1cdbd2cSJim Jagielski xStatement->execute( sRestoreCommand ); 146*b1cdbd2cSJim Jagielski throw; 147*b1cdbd2cSJim Jagielski } 148*b1cdbd2cSJim Jagielski catch( const Exception& ) 149*b1cdbd2cSJim Jagielski { 150*b1cdbd2cSJim Jagielski if ( bDropSucceeded ) 151*b1cdbd2cSJim Jagielski xStatement->execute( sRestoreCommand ); 152*b1cdbd2cSJim Jagielski DBG_UNHANDLED_EXCEPTION(); 153*b1cdbd2cSJim Jagielski } 154*b1cdbd2cSJim Jagielski } 155*b1cdbd2cSJim Jagielski 156*b1cdbd2cSJim Jagielski //-------------------------------------------------------------------- getFastPropertyValue(Any & _rValue,sal_Int32 _nHandle) const157*b1cdbd2cSJim Jagielski void SAL_CALL HView::getFastPropertyValue( Any& _rValue, sal_Int32 _nHandle ) const 158*b1cdbd2cSJim Jagielski { 159*b1cdbd2cSJim Jagielski if ( _nHandle == PROPERTY_ID_COMMAND ) 160*b1cdbd2cSJim Jagielski { 161*b1cdbd2cSJim Jagielski // retrieve the very current command, don't rely on the base classes cached value 162*b1cdbd2cSJim Jagielski // (which we initialized empty, anyway) 163*b1cdbd2cSJim Jagielski _rValue <<= impl_getCommand_throw( false ); 164*b1cdbd2cSJim Jagielski return; 165*b1cdbd2cSJim Jagielski } 166*b1cdbd2cSJim Jagielski 167*b1cdbd2cSJim Jagielski HView_Base::getFastPropertyValue( _rValue, _nHandle ); 168*b1cdbd2cSJim Jagielski } 169*b1cdbd2cSJim Jagielski 170*b1cdbd2cSJim Jagielski //-------------------------------------------------------------------- impl_getCommand_throw(bool _bAllowSQLException) const171*b1cdbd2cSJim Jagielski ::rtl::OUString HView::impl_getCommand_throw( bool _bAllowSQLException ) const 172*b1cdbd2cSJim Jagielski { 173*b1cdbd2cSJim Jagielski ::rtl::OUString sCommand; 174*b1cdbd2cSJim Jagielski 175*b1cdbd2cSJim Jagielski try 176*b1cdbd2cSJim Jagielski { 177*b1cdbd2cSJim Jagielski ::rtl::OUStringBuffer aCommand; 178*b1cdbd2cSJim Jagielski aCommand.appendAscii( "SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.SYSTEM_VIEWS " ); 179*b1cdbd2cSJim Jagielski HTools::appendTableFilterCrit( aCommand, m_CatalogName, m_SchemaName, m_Name, false ); 180*b1cdbd2cSJim Jagielski ::utl::SharedUNOComponent< XStatement > xStatement; xStatement.set( m_xConnection->createStatement(), UNO_QUERY_THROW ); 181*b1cdbd2cSJim Jagielski Reference< XResultSet > xResult( xStatement->executeQuery( aCommand.makeStringAndClear() ), UNO_QUERY_THROW ); 182*b1cdbd2cSJim Jagielski if ( !xResult->next() ) 183*b1cdbd2cSJim Jagielski { 184*b1cdbd2cSJim Jagielski // hmm. There is no view view the name as we know it. Can only mean some other instance 185*b1cdbd2cSJim Jagielski // dropped this view meanwhile ... 186*b1cdbd2cSJim Jagielski throw DisposedException(); 187*b1cdbd2cSJim Jagielski } 188*b1cdbd2cSJim Jagielski 189*b1cdbd2cSJim Jagielski Reference< XRow > xRow( xResult, UNO_QUERY_THROW ); 190*b1cdbd2cSJim Jagielski sCommand = xRow->getString( 1 ); 191*b1cdbd2cSJim Jagielski } 192*b1cdbd2cSJim Jagielski catch( const RuntimeException& ) { throw; } 193*b1cdbd2cSJim Jagielski catch( const SQLException& e ) 194*b1cdbd2cSJim Jagielski { 195*b1cdbd2cSJim Jagielski if ( _bAllowSQLException ) 196*b1cdbd2cSJim Jagielski throw; 197*b1cdbd2cSJim Jagielski throw WrappedTargetException( e.Message, static_cast< XAlterView* >( const_cast< HView* >( this ) ), ::cppu::getCaughtException() ); 198*b1cdbd2cSJim Jagielski } 199*b1cdbd2cSJim Jagielski catch( const Exception& ) 200*b1cdbd2cSJim Jagielski { 201*b1cdbd2cSJim Jagielski DBG_UNHANDLED_EXCEPTION(); 202*b1cdbd2cSJim Jagielski } 203*b1cdbd2cSJim Jagielski 204*b1cdbd2cSJim Jagielski return sCommand; 205*b1cdbd2cSJim Jagielski } 206*b1cdbd2cSJim Jagielski 207*b1cdbd2cSJim Jagielski //........................................................................ 208*b1cdbd2cSJim Jagielski } } // namespace connectivity::hsqldb 209*b1cdbd2cSJim Jagielski //........................................................................ 210