/**************************************************************
*
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you under the Apache License, Version 2.0 (the
* "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
* KIND, either express or implied. See the License for the
* specific language governing permissions and limitations
* under the License.
*
*************************************************************/
// MARKER(update_precomp.py): autogen include statement, do not remove
#include "precompiled_connectivity.hxx"
#include "hsqldb/HView.hxx"
#include "hsqldb/HTools.hxx"
#include "propertyids.hxx"
#include "connectivity/dbexception.hxx"
#include "connectivity/dbtools.hxx"
/** === begin UNO includes === **/
#include <com/sun/star/lang/WrappedTargetException.hpp>
#include <com/sun/star/lang/DisposedException.hpp>
#include <com/sun/star/sdbc/XRow.hpp>
/** === end UNO includes === **/
#include <cppuhelper/exc_hlp.hxx>
#include <tools/diagnose_ex.h>
#include <unotools/sharedunocomponent.hxx>
//........................................................................
namespace connectivity { namespace hsqldb
{
//........................................................................
/** === begin UNO using === **/
using ::com::sun::star::uno::Reference;
using ::com::sun::star::uno::UNO_QUERY;
using ::com::sun::star::uno::UNO_QUERY_THROW;
using ::com::sun::star::uno::Exception;
using ::com::sun::star::uno::RuntimeException;
using ::com::sun::star::uno::Any;
using ::com::sun::star::uno::makeAny;
using ::com::sun::star::sdbc::XDatabaseMetaData;
using ::com::sun::star::sdbc::SQLException;
using ::com::sun::star::sdbc::XConnection;
using ::com::sun::star::lang::WrappedTargetException;
using ::com::sun::star::sdbc::XResultSet;
using ::com::sun::star::sdbc::XStatement;
using ::com::sun::star::lang::DisposedException;
using ::com::sun::star::sdbc::XRow;
/** === end UNO using === **/
//====================================================================
//= HView
//====================================================================
//--------------------------------------------------------------------
HView::HView( const Reference< XConnection >& _rxConnection, sal_Bool _bCaseSensitive,
const ::rtl::OUString& _rSchemaName, const ::rtl::OUString& _rName )
:HView_Base( _bCaseSensitive, _rName, _rxConnection->getMetaData(), 0, ::rtl::OUString(), _rSchemaName, ::rtl::OUString() )
,m_xConnection( _rxConnection )
{
}
//--------------------------------------------------------------------
HView::~HView()
{
}
//--------------------------------------------------------------------
IMPLEMENT_FORWARD_XINTERFACE2( HView, HView_Base, HView_IBASE )
IMPLEMENT_FORWARD_XTYPEPROVIDER2( HView, HView_Base, HView_IBASE )
//--------------------------------------------------------------------
void SAL_CALL HView::alterCommand( const ::rtl::OUString& _rNewCommand ) throw (SQLException, RuntimeException)
{
// not really atomic ... as long as we do not have something like
// ALTER VIEW <name> TO <command>
// in HSQL, we need to do it this way ...
//
// I can imagine scenarios where this fails, e.g. when dropping the view
// succeedes, re-creating it fails, some other thread alters a table which
// the view was based on, and then we try to restore the view with the
// original command, which then fails, too.
//
// However, there's not much chance to prevent this kind of errors without
// backend support.
::rtl::OUString sQualifiedName( ::dbtools::composeTableName(
m_xMetaData, m_CatalogName, m_SchemaName, m_Name, true, ::dbtools::eInDataManipulation ) );
::utl::SharedUNOComponent< XStatement > xStatement; xStatement.set( m_xConnection->createStatement(), UNO_QUERY_THROW );
// create a statement which can be used to re-create the original view, in case
// dropping it succeeds, but creating it with a new statement fails
::rtl::OUStringBuffer aRestoreCommand;
aRestoreCommand.appendAscii( "CREATE VIEW " );
aRestoreCommand.append ( sQualifiedName );
aRestoreCommand.appendAscii( " AS " );
aRestoreCommand.append ( impl_getCommand_throw( true ) );
::rtl::OUString sRestoreCommand( aRestoreCommand.makeStringAndClear() );
bool bDropSucceeded( false );
try
{
// drop the existing view
::rtl::OUStringBuffer aCommand;
aCommand.appendAscii( "DROP VIEW " );
aCommand.append ( sQualifiedName );
xStatement->execute( aCommand.makeStringAndClear() );
bDropSucceeded = true;
// create a new one with the same name
aCommand.appendAscii( "CREATE VIEW " );
aCommand.append ( sQualifiedName );
aCommand.appendAscii( " AS " );
aCommand.append ( _rNewCommand );
xStatement->execute( aCommand.makeStringAndClear() );
}
catch( const SQLException& )
{
if ( bDropSucceeded )
// drop succeeded, but creation failed -> re-create the view with the original
// statemnet
xStatement->execute( sRestoreCommand );
throw;
}
catch( const RuntimeException& )
{
if ( bDropSucceeded )
xStatement->execute( sRestoreCommand );
throw;
}
catch( const Exception& )
{
if ( bDropSucceeded )
xStatement->execute( sRestoreCommand );
DBG_UNHANDLED_EXCEPTION();
}
}
//--------------------------------------------------------------------
void SAL_CALL HView::getFastPropertyValue( Any& _rValue, sal_Int32 _nHandle ) const
{
if ( _nHandle == PROPERTY_ID_COMMAND )
{
// retrieve the very current command, don't rely on the base classes cached value
// (which we initialized empty, anyway)
_rValue <<= impl_getCommand_throw( false );
return;
}
HView_Base::getFastPropertyValue( _rValue, _nHandle );
}
//--------------------------------------------------------------------
::rtl::OUString HView::impl_getCommand_throw( bool _bAllowSQLException ) const
{
::rtl::OUString sCommand;
try
{
::rtl::OUStringBuffer aCommand;
aCommand.appendAscii( "SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.SYSTEM_VIEWS " );
HTools::appendTableFilterCrit( aCommand, m_CatalogName, m_SchemaName, m_Name, false );
::utl::SharedUNOComponent< XStatement > xStatement; xStatement.set( m_xConnection->createStatement(), UNO_QUERY_THROW );
Reference< XResultSet > xResult( xStatement->executeQuery( aCommand.makeStringAndClear() ), UNO_QUERY_THROW );
if ( !xResult->next() )
{
// hmm. There is no view view the name as we know it. Can only mean some other instance
// dropped this view meanwhile ...
throw DisposedException();
}
Reference< XRow > xRow( xResult, UNO_QUERY_THROW );
sCommand = xRow->getString( 1 );
}
catch( const RuntimeException& ) { throw; }
catch( const SQLException& e )
{
if ( _bAllowSQLException )
throw;
throw WrappedTargetException( e.Message, static_cast< XAlterView* >( const_cast< HView* >( this ) ), ::cppu::getCaughtException() );
}
catch( const Exception& )
{
DBG_UNHANDLED_EXCEPTION();
}
return sCommand;
}
//........................................................................
} } // namespace connectivity::hsqldb
//........................................................................