1*cdf0e10cSrcweir /************************************************************************* 2*cdf0e10cSrcweir * 3*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4*cdf0e10cSrcweir * 5*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * This file is part of OpenOffice.org. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 12*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 13*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 16*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 17*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 19*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 20*cdf0e10cSrcweir * 21*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 22*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 23*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 24*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 25*cdf0e10cSrcweir * 26*cdf0e10cSrcweir ************************************************************************/ 27*cdf0e10cSrcweir 28*cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove 29*cdf0e10cSrcweir #include "precompiled_connectivity.hxx" 30*cdf0e10cSrcweir #include "ado/AResultSetMetaData.hxx" 31*cdf0e10cSrcweir #include <com/sun/star/sdbc/DataType.hpp> 32*cdf0e10cSrcweir #include <com/sun/star/sdbc/ColumnValue.hpp> 33*cdf0e10cSrcweir #include "ado/Awrapado.hxx" 34*cdf0e10cSrcweir #include "connectivity/dbexception.hxx" 35*cdf0e10cSrcweir 36*cdf0e10cSrcweir using namespace connectivity; 37*cdf0e10cSrcweir using namespace connectivity::ado; 38*cdf0e10cSrcweir using namespace com::sun::star::uno; 39*cdf0e10cSrcweir using namespace com::sun::star::lang; 40*cdf0e10cSrcweir using namespace com::sun::star::beans; 41*cdf0e10cSrcweir using namespace com::sun::star::sdbc; 42*cdf0e10cSrcweir 43*cdf0e10cSrcweir OResultSetMetaData::OResultSetMetaData( ADORecordset* _pRecordSet) 44*cdf0e10cSrcweir : m_pRecordSet(_pRecordSet), 45*cdf0e10cSrcweir m_nColCount(-1) 46*cdf0e10cSrcweir { 47*cdf0e10cSrcweir if ( m_pRecordSet ) 48*cdf0e10cSrcweir m_pRecordSet->AddRef(); 49*cdf0e10cSrcweir } 50*cdf0e10cSrcweir // ------------------------------------------------------------------------- 51*cdf0e10cSrcweir OResultSetMetaData::~OResultSetMetaData() 52*cdf0e10cSrcweir { 53*cdf0e10cSrcweir if ( m_pRecordSet ) 54*cdf0e10cSrcweir m_pRecordSet->Release(); 55*cdf0e10cSrcweir } 56*cdf0e10cSrcweir // ------------------------------------------------------------------------- 57*cdf0e10cSrcweir sal_Int32 SAL_CALL OResultSetMetaData::getColumnDisplaySize( sal_Int32 column ) throw(SQLException, RuntimeException) 58*cdf0e10cSrcweir { 59*cdf0e10cSrcweir WpADOField aField = ADOS::getField(m_pRecordSet,column); 60*cdf0e10cSrcweir if(aField.IsValid() && aField.GetActualSize() != -1) 61*cdf0e10cSrcweir return aField.GetActualSize(); 62*cdf0e10cSrcweir return 0; 63*cdf0e10cSrcweir } 64*cdf0e10cSrcweir // ------------------------------------------------------------------------- 65*cdf0e10cSrcweir 66*cdf0e10cSrcweir sal_Int32 SAL_CALL OResultSetMetaData::getColumnType( sal_Int32 column ) throw(SQLException, RuntimeException) 67*cdf0e10cSrcweir { 68*cdf0e10cSrcweir WpADOField aField = ADOS::getField(m_pRecordSet,column); 69*cdf0e10cSrcweir return ADOS::MapADOType2Jdbc(aField.GetADOType()); 70*cdf0e10cSrcweir } 71*cdf0e10cSrcweir // ------------------------------------------------------------------------- 72*cdf0e10cSrcweir 73*cdf0e10cSrcweir sal_Int32 SAL_CALL OResultSetMetaData::getColumnCount( ) throw(SQLException, RuntimeException) 74*cdf0e10cSrcweir { 75*cdf0e10cSrcweir if(m_nColCount != -1 ) 76*cdf0e10cSrcweir return m_nColCount; 77*cdf0e10cSrcweir 78*cdf0e10cSrcweir if ( !m_pRecordSet ) 79*cdf0e10cSrcweir return 0; 80*cdf0e10cSrcweir 81*cdf0e10cSrcweir ADOFields* pFields = NULL; 82*cdf0e10cSrcweir m_pRecordSet->get_Fields(&pFields); 83*cdf0e10cSrcweir WpOLEAppendCollection<ADOFields, ADOField, WpADOField> aFields(pFields); 84*cdf0e10cSrcweir m_nColCount = aFields.GetItemCount(); 85*cdf0e10cSrcweir return m_nColCount; 86*cdf0e10cSrcweir } 87*cdf0e10cSrcweir // ------------------------------------------------------------------------- 88*cdf0e10cSrcweir 89*cdf0e10cSrcweir sal_Bool SAL_CALL OResultSetMetaData::isCaseSensitive( sal_Int32 column ) throw(SQLException, RuntimeException) 90*cdf0e10cSrcweir { 91*cdf0e10cSrcweir sal_Bool bRet = sal_False; 92*cdf0e10cSrcweir WpADOField aField = ADOS::getField(m_pRecordSet,column); 93*cdf0e10cSrcweir if ( aField.IsValid() ) 94*cdf0e10cSrcweir { 95*cdf0e10cSrcweir WpADOProperties aProps( aField.get_Properties() ); 96*cdf0e10cSrcweir if ( aProps.IsValid() ) 97*cdf0e10cSrcweir bRet = OTools::getValue( aProps, ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("ISCASESENSITIVE")) ); 98*cdf0e10cSrcweir } 99*cdf0e10cSrcweir return bRet; 100*cdf0e10cSrcweir } 101*cdf0e10cSrcweir // ------------------------------------------------------------------------- 102*cdf0e10cSrcweir 103*cdf0e10cSrcweir ::rtl::OUString SAL_CALL OResultSetMetaData::getSchemaName( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException) 104*cdf0e10cSrcweir { 105*cdf0e10cSrcweir return ::rtl::OUString(); 106*cdf0e10cSrcweir } 107*cdf0e10cSrcweir // ------------------------------------------------------------------------- 108*cdf0e10cSrcweir 109*cdf0e10cSrcweir ::rtl::OUString SAL_CALL OResultSetMetaData::getColumnName( sal_Int32 column ) throw(SQLException, RuntimeException) 110*cdf0e10cSrcweir { 111*cdf0e10cSrcweir WpADOField aField = ADOS::getField(m_pRecordSet,column); 112*cdf0e10cSrcweir if(aField.IsValid()) 113*cdf0e10cSrcweir return aField.GetName(); 114*cdf0e10cSrcweir 115*cdf0e10cSrcweir return ::rtl::OUString(); 116*cdf0e10cSrcweir } 117*cdf0e10cSrcweir // ------------------------------------------------------------------------- 118*cdf0e10cSrcweir ::rtl::OUString SAL_CALL OResultSetMetaData::getTableName( sal_Int32 column ) throw(SQLException, RuntimeException) 119*cdf0e10cSrcweir { 120*cdf0e10cSrcweir ::rtl::OUString sTableName; 121*cdf0e10cSrcweir 122*cdf0e10cSrcweir WpADOField aField = ADOS::getField(m_pRecordSet,column); 123*cdf0e10cSrcweir if ( aField.IsValid() ) 124*cdf0e10cSrcweir { 125*cdf0e10cSrcweir WpADOProperties aProps( aField.get_Properties() ); 126*cdf0e10cSrcweir if ( aProps.IsValid() ) 127*cdf0e10cSrcweir sTableName = OTools::getValue( aProps, ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("BASETABLENAME")) ); 128*cdf0e10cSrcweir } 129*cdf0e10cSrcweir return sTableName; 130*cdf0e10cSrcweir } 131*cdf0e10cSrcweir // ------------------------------------------------------------------------- 132*cdf0e10cSrcweir ::rtl::OUString SAL_CALL OResultSetMetaData::getCatalogName( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException) 133*cdf0e10cSrcweir { 134*cdf0e10cSrcweir return ::rtl::OUString(); 135*cdf0e10cSrcweir } 136*cdf0e10cSrcweir // ------------------------------------------------------------------------- 137*cdf0e10cSrcweir ::rtl::OUString SAL_CALL OResultSetMetaData::getColumnTypeName( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException) 138*cdf0e10cSrcweir { 139*cdf0e10cSrcweir return ::rtl::OUString(); 140*cdf0e10cSrcweir } 141*cdf0e10cSrcweir // ------------------------------------------------------------------------- 142*cdf0e10cSrcweir ::rtl::OUString SAL_CALL OResultSetMetaData::getColumnLabel( sal_Int32 column ) throw(SQLException, RuntimeException) 143*cdf0e10cSrcweir { 144*cdf0e10cSrcweir return getColumnName(column); 145*cdf0e10cSrcweir } 146*cdf0e10cSrcweir // ------------------------------------------------------------------------- 147*cdf0e10cSrcweir ::rtl::OUString SAL_CALL OResultSetMetaData::getColumnServiceName( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException) 148*cdf0e10cSrcweir { 149*cdf0e10cSrcweir return ::rtl::OUString(); 150*cdf0e10cSrcweir } 151*cdf0e10cSrcweir // ------------------------------------------------------------------------- 152*cdf0e10cSrcweir 153*cdf0e10cSrcweir sal_Bool SAL_CALL OResultSetMetaData::isCurrency( sal_Int32 column ) throw(SQLException, RuntimeException) 154*cdf0e10cSrcweir { 155*cdf0e10cSrcweir WpADOField aField = ADOS::getField(m_pRecordSet,column); 156*cdf0e10cSrcweir if(aField.IsValid()) 157*cdf0e10cSrcweir { 158*cdf0e10cSrcweir return ((aField.GetAttributes() & adFldFixed) == adFldFixed) && (aField.GetADOType() == adCurrency); 159*cdf0e10cSrcweir } 160*cdf0e10cSrcweir return sal_False; 161*cdf0e10cSrcweir } 162*cdf0e10cSrcweir // ------------------------------------------------------------------------- 163*cdf0e10cSrcweir 164*cdf0e10cSrcweir sal_Bool SAL_CALL OResultSetMetaData::isAutoIncrement( sal_Int32 column ) throw(SQLException, RuntimeException) 165*cdf0e10cSrcweir { 166*cdf0e10cSrcweir sal_Bool bRet = sal_False; 167*cdf0e10cSrcweir WpADOField aField = ADOS::getField(m_pRecordSet,column); 168*cdf0e10cSrcweir if ( aField.IsValid() ) 169*cdf0e10cSrcweir { 170*cdf0e10cSrcweir WpADOProperties aProps( aField.get_Properties() ); 171*cdf0e10cSrcweir if ( aProps.IsValid() ) 172*cdf0e10cSrcweir { 173*cdf0e10cSrcweir bRet = OTools::getValue( aProps, ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("ISAUTOINCREMENT")) ); 174*cdf0e10cSrcweir #if OSL_DEBUG_LEVEL > 0 175*cdf0e10cSrcweir sal_Int32 nCount = aProps.GetItemCount(); 176*cdf0e10cSrcweir for (sal_Int32 i = 0; i<nCount; ++i) 177*cdf0e10cSrcweir { 178*cdf0e10cSrcweir WpADOProperty aProp = aProps.GetItem(i); 179*cdf0e10cSrcweir ::rtl::OUString sName = aProp.GetName(); 180*cdf0e10cSrcweir ::rtl::OUString sVal = aProp.GetValue(); 181*cdf0e10cSrcweir } 182*cdf0e10cSrcweir #endif 183*cdf0e10cSrcweir } 184*cdf0e10cSrcweir } 185*cdf0e10cSrcweir return bRet; 186*cdf0e10cSrcweir } 187*cdf0e10cSrcweir // ------------------------------------------------------------------------- 188*cdf0e10cSrcweir 189*cdf0e10cSrcweir 190*cdf0e10cSrcweir sal_Bool SAL_CALL OResultSetMetaData::isSigned( sal_Int32 column ) throw(SQLException, RuntimeException) 191*cdf0e10cSrcweir { 192*cdf0e10cSrcweir WpADOField aField = ADOS::getField(m_pRecordSet,column); 193*cdf0e10cSrcweir if(aField.IsValid()) 194*cdf0e10cSrcweir { 195*cdf0e10cSrcweir DataTypeEnum eType = aField.GetADOType(); 196*cdf0e10cSrcweir return !(eType == adUnsignedBigInt || eType == adUnsignedInt || eType == adUnsignedSmallInt || eType == adUnsignedTinyInt); 197*cdf0e10cSrcweir } 198*cdf0e10cSrcweir return sal_False; 199*cdf0e10cSrcweir } 200*cdf0e10cSrcweir // ------------------------------------------------------------------------- 201*cdf0e10cSrcweir sal_Int32 SAL_CALL OResultSetMetaData::getPrecision( sal_Int32 column ) throw(SQLException, RuntimeException) 202*cdf0e10cSrcweir { 203*cdf0e10cSrcweir WpADOField aField = ADOS::getField(m_pRecordSet,column); 204*cdf0e10cSrcweir if(aField.IsValid()) 205*cdf0e10cSrcweir return aField.GetPrecision(); 206*cdf0e10cSrcweir return 0; 207*cdf0e10cSrcweir } 208*cdf0e10cSrcweir // ------------------------------------------------------------------------- 209*cdf0e10cSrcweir sal_Int32 SAL_CALL OResultSetMetaData::getScale( sal_Int32 column ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException) 210*cdf0e10cSrcweir { 211*cdf0e10cSrcweir WpADOField aField = ADOS::getField(m_pRecordSet,column); 212*cdf0e10cSrcweir if(aField.IsValid()) 213*cdf0e10cSrcweir return aField.GetNumericScale(); 214*cdf0e10cSrcweir return 0; 215*cdf0e10cSrcweir } 216*cdf0e10cSrcweir // ------------------------------------------------------------------------- 217*cdf0e10cSrcweir 218*cdf0e10cSrcweir sal_Int32 SAL_CALL OResultSetMetaData::isNullable( sal_Int32 column ) throw(SQLException, RuntimeException) 219*cdf0e10cSrcweir { 220*cdf0e10cSrcweir WpADOField aField = ADOS::getField(m_pRecordSet,column); 221*cdf0e10cSrcweir if(aField.IsValid()) 222*cdf0e10cSrcweir { 223*cdf0e10cSrcweir return (aField.GetAttributes() & adFldIsNullable) == adFldIsNullable; 224*cdf0e10cSrcweir } 225*cdf0e10cSrcweir return sal_False; 226*cdf0e10cSrcweir } 227*cdf0e10cSrcweir // ------------------------------------------------------------------------- 228*cdf0e10cSrcweir 229*cdf0e10cSrcweir sal_Bool SAL_CALL OResultSetMetaData::isSearchable( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException) 230*cdf0e10cSrcweir { 231*cdf0e10cSrcweir return sal_True; 232*cdf0e10cSrcweir } 233*cdf0e10cSrcweir // ------------------------------------------------------------------------- 234*cdf0e10cSrcweir 235*cdf0e10cSrcweir sal_Bool SAL_CALL OResultSetMetaData::isReadOnly( sal_Int32 column ) throw(SQLException, RuntimeException) 236*cdf0e10cSrcweir { 237*cdf0e10cSrcweir WpADOField aField = ADOS::getField(m_pRecordSet,column); 238*cdf0e10cSrcweir if(aField.IsValid()) 239*cdf0e10cSrcweir { 240*cdf0e10cSrcweir // return (aField.GetStatus() & adFieldReadOnly) == adFieldReadOnly; 241*cdf0e10cSrcweir } 242*cdf0e10cSrcweir return sal_False; 243*cdf0e10cSrcweir } 244*cdf0e10cSrcweir // ------------------------------------------------------------------------- 245*cdf0e10cSrcweir 246*cdf0e10cSrcweir sal_Bool SAL_CALL OResultSetMetaData::isDefinitelyWritable( sal_Int32 column ) throw(SQLException, RuntimeException) 247*cdf0e10cSrcweir { 248*cdf0e10cSrcweir WpADOField aField = ADOS::getField(m_pRecordSet,column); 249*cdf0e10cSrcweir if(aField.IsValid()) 250*cdf0e10cSrcweir { 251*cdf0e10cSrcweir return (aField.GetAttributes() & adFldUpdatable) == adFldUpdatable; 252*cdf0e10cSrcweir } 253*cdf0e10cSrcweir return sal_False; 254*cdf0e10cSrcweir ; 255*cdf0e10cSrcweir } 256*cdf0e10cSrcweir // ------------------------------------------------------------------------- 257*cdf0e10cSrcweir sal_Bool SAL_CALL OResultSetMetaData::isWritable( sal_Int32 column ) throw(SQLException, RuntimeException) 258*cdf0e10cSrcweir { 259*cdf0e10cSrcweir return isDefinitelyWritable(column); 260*cdf0e10cSrcweir } 261*cdf0e10cSrcweir // ------------------------------------------------------------------------- 262*cdf0e10cSrcweir 263