connectivity/source/drivers/jdbc/DatabaseMetaData.cxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   2 /*
   3  * This file is part of the LibreOffice project.
   4  *
   5  * This Source Code Form is subject to the terms of the Mozilla Public
   6  * License, v. 2.0. If a copy of the MPL was not distributed with this
   7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   8  *
   9  * This file incorporates work covered by the following license notice:
  10  *
  11  *   Licensed to the Apache Software Foundation (ASF) under one or more
  12  *   contributor license agreements. See the NOTICE file distributed
  13  *   with this work for additional information regarding copyright
  14  *   ownership. The ASF licenses this file to you under the Apache
  15  *   License, Version 2.0 (the "License"); you may not use this file
  16  *   except in compliance with the License. You may obtain a copy of
  17  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  18  */
  19
  20 #include <sal/config.h>
  21
  22 #include <string_view>
  23
  24 #include <sal/macros.h>
  25 #include <java/sql/DatabaseMetaData.hxx>
  26 #include <java/sql/Connection.hxx>
  27 #include <java/sql/ResultSet.hxx>
  28 #include <java/sql/SQLException.hxx>
  29 #include <java/tools.hxx>
  30 #include <java/lang/String.hxx>
  31 #include <FDatabaseMetaDataResultSet.hxx>
  32 #include <comphelper/types.hxx>
  33 #include <TPrivilegesResultSet.hxx>
  34 #include <strings.hxx>
  35
  36 using namespace ::comphelper;
  37
  38 using namespace connectivity;
  39 using namespace ::com::sun::star::uno;
  40 using namespace ::com::sun::star::sdbc;
  41
  42 jclass java_sql_DatabaseMetaData::theClass              = nullptr;
  43
  44 java_sql_DatabaseMetaData::~java_sql_DatabaseMetaData()
  45 {
  46     SDBThreadAttach::releaseRef();
  47 }
  48
  49 jclass java_sql_DatabaseMetaData::getMyClass() const
  50 {
  51     // the class must be fetched only once, therefore static
  52     if( !theClass )
  53         theClass = findMyClass("java/sql/DatabaseMetaData");
  54     return theClass;
  55 }
  56
  57 java_sql_DatabaseMetaData::java_sql_DatabaseMetaData( JNIEnv * pEnv, jobject myObj, java_sql_Connection& _rConnection )
  58     :ODatabaseMetaDataBase( &_rConnection,_rConnection.getConnectionInfo() )
  59     ,java_lang_Object( pEnv, myObj )
  60     ,m_pConnection( &_rConnection )
  61     ,m_aLogger( _rConnection.getLogger() )
  62 {
  63     SDBThreadAttach::addRef();
  64 }
  65
  66
  67 Reference< XResultSet > java_sql_DatabaseMetaData::impl_getTypeInfo_throw(  )
  68 {
  69     static jmethodID mID(nullptr);
  70     return impl_callResultSetMethod( "getTypeInfo", mID );
  71 }
  72
  73 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getCatalogs(  )
  74 {
  75     static jmethodID mID(nullptr);
  76     return impl_callResultSetMethod( "getCatalogs", mID );
  77 }
  78
  79 OUString java_sql_DatabaseMetaData::impl_getCatalogSeparator_throw(  )
  80 {
  81     static jmethodID mID(nullptr);
  82     return impl_callStringMethod( "getCatalogSeparator", mID );
  83 }
  84
  85 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getSchemas(  )
  86 {
  87     static jmethodID mID(nullptr);
  88     return impl_callResultSetMethod( "getSchemas", mID );
  89 }
  90
  91 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getColumnPrivileges(
  92         const Any& catalog, const OUString& schema, const OUString& table, const OUString& columnNamePattern )
  93 {
  94     static jmethodID mID(nullptr);
  95     return impl_callResultSetMethodWithStrings( "getColumnPrivileges", mID, catalog, schema, table, &columnNamePattern );
  96 }
  97
  98 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getColumns(
  99         const Any& catalog, const OUString& schemaPattern, const OUString& tableNamePattern, const OUString& columnNamePattern )
 100 {
 101     static jmethodID mID(nullptr);
 102     return impl_callResultSetMethodWithStrings( "getColumns", mID, catalog, schemaPattern, tableNamePattern, &columnNamePattern );
 103 }
 104
 105
 106 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getTables(
 107         const Any& catalog, const OUString& schemaPattern, const OUString& tableNamePattern, const Sequence< OUString >& _types )
 108 {
 109     static const char * const cMethodName = "getTables";
 110
 111     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_METHOD, cMethodName );
 112
 113     jobject out(nullptr);
 114     SDBThreadAttach t; OSL_ENSURE(t.pEnv,"Java environment has been deleted!");
 115
 116     {
 117         static const char * const cSignature = "(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)Ljava/sql/ResultSet;";
 118         // execute Java-Call
 119         static jmethodID mID(nullptr);
 120         obtainMethodId_throwSQL(t.pEnv, cMethodName,cSignature, mID);
 121         OSL_VERIFY( !isExceptionOccurred(t.pEnv) );
 122         jvalue args[4];
 123
 124         args[3].l = nullptr;
 125         sal_Int32 typeFilterCount = _types.getLength();
 126         if ( typeFilterCount )
 127         {
 128             jobjectArray pObjArray = t.pEnv->NewObjectArray( static_cast<jsize>(typeFilterCount), java_lang_String::st_getMyClass(), nullptr );
 129             OSL_VERIFY( !isExceptionOccurred( t.pEnv ) );
 130             const OUString* typeFilter = _types.getConstArray();
 131             bool bIncludeAllTypes = false;
 132             for ( sal_Int32 i=0; i<typeFilterCount; ++i, ++typeFilter )
 133             {
 134                 if ( *typeFilter == "%" )
 135                 {
 136                     bIncludeAllTypes = true;
 137                     break;
 138                 }
 139                 jstring aT = convertwchar_tToJavaString( t.pEnv, *typeFilter );
 140                 t.pEnv->SetObjectArrayElement( pObjArray, static_cast<jsize>(i), aT );
 141                 OSL_VERIFY( !isExceptionOccurred( t.pEnv ) );
 142             }
 143
 144             if ( bIncludeAllTypes )
 145             {
 146                 // the SDBC API allows to pass "%" as table type filter, but in JDBC, "all table types"
 147                 // is represented by the table type being <null/>
 148                 t.pEnv->DeleteLocalRef( pObjArray );
 149                 OSL_VERIFY( !isExceptionOccurred( t.pEnv ) );
 150             }
 151             else
 152             {
 153                 args[3].l = pObjArray;
 154             }
 155         }
 156         // if we are to display "all catalogs", then respect m_aCatalogRestriction
 157         Any aCatalogFilter( catalog );
 158         if ( !aCatalogFilter.hasValue() )
 159             aCatalogFilter = m_pConnection->getCatalogRestriction();
 160         // similar for schema
 161         Any aSchemaFilter;
 162         if ( schemaPattern == "%" )
 163             aSchemaFilter = m_pConnection->getSchemaRestriction();
 164         else
 165             aSchemaFilter <<= schemaPattern;
 166
 167         args[0].l = aCatalogFilter.hasValue() ? convertwchar_tToJavaString( t.pEnv, ::comphelper::getString( aCatalogFilter ) ) : nullptr;
 168         args[1].l = aSchemaFilter.hasValue() ? convertwchar_tToJavaString( t.pEnv, ::comphelper::getString( aSchemaFilter ) ) : nullptr;
 169         args[2].l = convertwchar_tToJavaString(t.pEnv,tableNamePattern);
 170         out = t.pEnv->CallObjectMethod( object, mID, args[0].l, args[1].l,args[2].l,args[3].l);
 171         jthrowable jThrow = t.pEnv->ExceptionOccurred();
 172         if ( jThrow )
 173             t.pEnv->ExceptionClear();// we have to clear the exception here because we want to handle it below
 174         if ( aCatalogFilter.hasValue() )
 175         {
 176             t.pEnv->DeleteLocalRef(static_cast<jstring>(args[0].l));
 177             OSL_VERIFY( !isExceptionOccurred( t.pEnv ) );
 178         }
 179         if(args[1].l)
 180         {
 181             t.pEnv->DeleteLocalRef(static_cast<jstring>(args[1].l));
 182             OSL_VERIFY( !isExceptionOccurred( t.pEnv ) );
 183         }
 184         if(!tableNamePattern.isEmpty())
 185         {
 186             t.pEnv->DeleteLocalRef(static_cast<jstring>(args[2].l));
 187             OSL_VERIFY( !isExceptionOccurred( t.pEnv ) );
 188         }
 189         //for(INT16 i=0;i<len;i++)
 190         if ( args[3].l )
 191         {
 192             t.pEnv->DeleteLocalRef( static_cast<jobjectArray>(args[3].l) );
 193             OSL_VERIFY( !isExceptionOccurred( t.pEnv ) );
 194         }
 195
 196         if ( jThrow )
 197         {
 198             if ( t.pEnv->IsInstanceOf( jThrow,java_sql_SQLException_BASE::st_getMyClass() ) )
 199             {
 200                 java_sql_SQLException_BASE aException( t.pEnv, jThrow );
 201                 SQLException e( aException.getMessage(),
 202                                     *this,
 203                                     aException.getSQLState(),
 204                                     aException.getErrorCode(),
 205                                     Any()
 206                                 );
 207                 throw  e;
 208             }
 209         }
 210     }
 211
 212     if ( !out )
 213         return nullptr;
 214
 215     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_SUCCESS, cMethodName );
 216     return new java_sql_ResultSet( t.pEnv, out, m_aLogger,*m_pConnection);
 217 }
 218
 219 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getProcedureColumns(
 220         const Any& catalog, const OUString& schemaPattern, const OUString& procedureNamePattern, const OUString& columnNamePattern )
 221 {
 222     static jmethodID mID(nullptr);
 223     return impl_callResultSetMethodWithStrings( "getProcedureColumns", mID, catalog, schemaPattern, procedureNamePattern, &columnNamePattern );
 224 }
 225
 226 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getProcedures( const Any&
 227                 catalog, const OUString& schemaPattern, const OUString& procedureNamePattern )
 228 {
 229     static jmethodID mID(nullptr);
 230     return impl_callResultSetMethodWithStrings( "getProcedures", mID, catalog, schemaPattern, procedureNamePattern );
 231 }
 232
 233 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getVersionColumns(
 234         const Any& catalog, const OUString& schema, const OUString& table )
 235 {
 236     static jmethodID mID(nullptr);
 237     return impl_callResultSetMethodWithStrings( "getVersionColumns", mID, catalog, schema, table );
 238 }
 239
 240 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxBinaryLiteralLength(  )
 241 {
 242     static jmethodID mID(nullptr);
 243     return impl_callIntMethod_ThrowSQL("getMaxBinaryLiteralLength", mID);
 244 }
 245
 246 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxRowSize(  )
 247 {
 248     static jmethodID mID(nullptr);
 249     return impl_callIntMethod_ThrowSQL("getMaxRowSize", mID);
 250 }
 251
 252 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxCatalogNameLength(  )
 253 {
 254     static jmethodID mID(nullptr);
 255     return impl_callIntMethod_ThrowSQL("getMaxCatalogNameLength", mID);
 256 }
 257
 258 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxCharLiteralLength(  )
 259 {
 260     static jmethodID mID(nullptr);
 261     return impl_callIntMethod_ThrowSQL("getMaxCharLiteralLength", mID);
 262 }
 263
 264 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxColumnNameLength(  )
 265 {
 266     static jmethodID mID(nullptr);
 267     return impl_callIntMethod_ThrowSQL("getMaxColumnNameLength", mID);
 268 }
 269
 270 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxColumnsInIndex(  )
 271 {
 272     static jmethodID mID(nullptr);
 273     return impl_callIntMethod_ThrowSQL("getMaxColumnsInIndex", mID);
 274 }
 275
 276 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxCursorNameLength(  )
 277 {
 278     static jmethodID mID(nullptr);
 279     return impl_callIntMethod_ThrowSQL("getMaxCursorNameLength", mID);
 280 }
 281
 282 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxConnections(  )
 283 {
 284     static jmethodID mID(nullptr);
 285     return impl_callIntMethod_ThrowSQL("getMaxConnections", mID);
 286 }
 287
 288 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxColumnsInTable(  )
 289 {
 290     static jmethodID mID(nullptr);
 291     return impl_callIntMethod_ThrowSQL("getMaxColumnsInTable", mID);
 292 }
 293
 294 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxStatementLength(  )
 295 {
 296     static jmethodID mID(nullptr);
 297     return impl_callIntMethod_ThrowSQL("getMaxStatementLength", mID);
 298 }
 299
 300 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxTableNameLength(  )
 301 {
 302     static jmethodID mID(nullptr);
 303     return impl_callIntMethod_ThrowSQL("getMaxTableNameLength", mID);
 304 }
 305
 306 sal_Int32 java_sql_DatabaseMetaData::impl_getMaxTablesInSelect_throw(  )
 307 {
 308     static jmethodID mID(nullptr);
 309     return impl_callIntMethod_ThrowSQL("getMaxTablesInSelect", mID);
 310 }
 311
 312 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getExportedKeys(
 313         const Any& catalog, const OUString& schema, const OUString& table )
 314 {
 315     static jmethodID mID(nullptr);
 316     return impl_callResultSetMethodWithStrings( "getExportedKeys", mID, catalog, schema, table );
 317 }
 318
 319 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getImportedKeys(
 320         const Any& catalog, const OUString& schema, const OUString& table )
 321 {
 322     static jmethodID mID(nullptr);
 323     return impl_callResultSetMethodWithStrings( "getImportedKeys", mID, catalog, schema, table );
 324 }
 325
 326 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getPrimaryKeys(
 327         const Any& catalog, const OUString& schema, const OUString& table )
 328 {
 329     static jmethodID mID(nullptr);
 330     return impl_callResultSetMethodWithStrings( "getPrimaryKeys", mID, catalog, schema, table );
 331 }
 332
 333 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getIndexInfo(
 334         const Any& catalog, const OUString& schema, const OUString& table,
 335         sal_Bool unique, sal_Bool approximate )
 336 {
 337     static const char * const cMethodName = "getIndexInfo";
 338
 339     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_METHOD, cMethodName );
 340
 341     jobject out(nullptr);
 342     SDBThreadAttach t; OSL_ENSURE(t.pEnv,"Java environment has been deleted!");
 343
 344     {
 345         static const char * const cSignature = "(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ZZ)Ljava/sql/ResultSet;";
 346         // execute Java-Call
 347         static jmethodID mID(nullptr);
 348         obtainMethodId_throwSQL(t.pEnv, cMethodName,cSignature, mID);
 349         jvalue args[5];
 350         // convert Parameter
 351         args[0].l = catalog.hasValue() ? convertwchar_tToJavaString(t.pEnv,comphelper::getString(catalog)) : nullptr;
 352         args[1].l = schema.toChar() == '%' ? nullptr : convertwchar_tToJavaString(t.pEnv,schema);
 353         args[2].l = convertwchar_tToJavaString(t.pEnv,table);
 354         args[3].z = unique;
 355         args[4].z = approximate;
 356         out = t.pEnv->CallObjectMethod( object, mID, args[0].l,args[1].l,args[2].l,args[3].z,args[4].z );
 357
 358         // and clean up
 359         if(catalog.hasValue())
 360             t.pEnv->DeleteLocalRef(static_cast<jstring>(args[0].l));
 361         if(args[1].l)
 362             t.pEnv->DeleteLocalRef(static_cast<jstring>(args[1].l));
 363         if(!table.isEmpty())
 364             t.pEnv->DeleteLocalRef(static_cast<jstring>(args[2].l));
 365         ThrowLoggedSQLException( m_aLogger, t.pEnv, *this );
 366     }
 367     if ( !out )
 368         return nullptr;
 369
 370     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_SUCCESS, cMethodName );
 371     return new java_sql_ResultSet( t.pEnv, out, m_aLogger,*m_pConnection);
 372 }
 373
 374 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getBestRowIdentifier(
 375         const Any& catalog, const OUString& schema, const OUString& table, sal_Int32 scope,
 376         sal_Bool nullable )
 377 {
 378     static const char * const cMethodName = "getBestRowIdentifier";
 379
 380     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_METHOD, cMethodName );
 381
 382     jobject out(nullptr);
 383     SDBThreadAttach t; OSL_ENSURE(t.pEnv,"Java environment has been deleted!");
 384
 385     {
 386         static const char * const cSignature = "(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;IZ)Ljava/sql/ResultSet;";
 387         // execute Java-Call
 388         static jmethodID mID(nullptr);
 389         obtainMethodId_throwSQL(t.pEnv, cMethodName,cSignature, mID);
 390         jvalue args[3];
 391         // convert Parameter
 392         args[0].l = catalog.hasValue() ? convertwchar_tToJavaString(t.pEnv,comphelper::getString(catalog)) : nullptr;
 393         args[1].l = schema.toChar() == '%' ? nullptr : convertwchar_tToJavaString(t.pEnv,schema);
 394         args[2].l = convertwchar_tToJavaString(t.pEnv,table);
 395         out = t.pEnv->CallObjectMethod( object, mID, args[0].l,args[1].l,args[2].l,scope,nullable);
 396
 397         // and cleanup
 398         if(catalog.hasValue())
 399             t.pEnv->DeleteLocalRef(static_cast<jstring>(args[0].l));
 400         if(args[1].l)
 401             t.pEnv->DeleteLocalRef(static_cast<jstring>(args[1].l));
 402         if(!table.isEmpty())
 403             t.pEnv->DeleteLocalRef(static_cast<jstring>(args[2].l));
 404         ThrowLoggedSQLException( m_aLogger, t.pEnv, *this );
 405     }
 406
 407     if ( !out )
 408         return nullptr;
 409
 410     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_SUCCESS, cMethodName );
 411     return new java_sql_ResultSet( t.pEnv, out, m_aLogger,*m_pConnection);
 412 }
 413
 414 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getTablePrivileges(
 415         const Any& catalog, const OUString& schemaPattern, const OUString& tableNamePattern )
 416 {
 417     if ( m_pConnection->isIgnoreDriverPrivilegesEnabled() )
 418         return new OResultSetPrivileges(this,catalog,schemaPattern,tableNamePattern);
 419
 420     static jmethodID mID(nullptr);
 421     Reference< XResultSet > xReturn( impl_callResultSetMethodWithStrings( "getTablePrivileges", mID, catalog, schemaPattern, tableNamePattern ) );
 422
 423     if ( xReturn.is() )
 424     {
 425         // we have to check the result columns for the tables privileges
 426         Reference< XResultSetMetaDataSupplier > xMetaSup(xReturn,UNO_QUERY);
 427         if ( xMetaSup.is() )
 428         {
 429             Reference< XResultSetMetaData> xMeta = xMetaSup->getMetaData();
 430             if ( xMeta.is() && xMeta->getColumnCount() != 7 )
 431             {
 432                 // here we know that the count of column doesn't match
 433                 std::map<sal_Int32,sal_Int32> aColumnMatching;
 434                 static const std::u16string_view sPrivs[] = {
 435                                             u"TABLE_CAT",
 436                                             u"TABLE_SCHEM",
 437                                             u"TABLE_NAME",
 438                                             u"GRANTOR",
 439                                             u"GRANTEE",
 440                                             u"PRIVILEGE",
 441                                             u"IS_GRANTABLE"
 442                                         };
 443
 444                 OUString sColumnName;
 445                 sal_Int32 nCount = xMeta->getColumnCount();
 446                 for (sal_Int32 i = 1 ; i <= nCount ; ++i)
 447                 {
 448                     sColumnName = xMeta->getColumnName(i);
 449                     for (size_t j = 0 ; j < std::size(sPrivs); ++j)
 450                     {
 451                         if ( sPrivs[j] == sColumnName )
 452                         {
 453                             aColumnMatching.emplace(i,j+1);
 454                             break;
 455                         }
 456                     }
 457
 458                 }
 459                 // fill our own resultset
 460                 rtl::Reference<ODatabaseMetaDataResultSet> pNewPrivRes = new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eTablePrivileges );
 461                 Reference< XResultSet > xTemp = xReturn;
 462                 xReturn = pNewPrivRes;
 463                 ODatabaseMetaDataResultSet::ORows aRows;
 464                 Reference< XRow > xRow(xTemp,UNO_QUERY);
 465                 OUString sValue;
 466
 467                 ODatabaseMetaDataResultSet::ORow aRow(8);
 468                 while ( xRow.is() && xTemp->next() )
 469                 {
 470                     for (const auto& [nCol, nPriv] : aColumnMatching)
 471                     {
 472                         sValue = xRow->getString(nCol);
 473                         if ( xRow->wasNull() )
 474                             aRow[nPriv] = ODatabaseMetaDataResultSet::getEmptyValue();
 475                         else
 476                             aRow[nPriv] = new ORowSetValueDecorator(sValue);
 477                     }
 478
 479                     aRows.push_back(aRow);
 480                 }
 481                 pNewPrivRes->setRows(std::move(aRows));
 482             }
 483         }
 484     }
 485     return xReturn;
 486 }
 487
 488 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getCrossReference(
 489         const Any& primaryCatalog, const OUString& primarySchema,
 490         const OUString& primaryTable, const Any& foreignCatalog,
 491         const OUString& foreignSchema, const OUString& foreignTable )
 492 {
 493     static const char * const cMethodName = "getCrossReference";
 494     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_METHOD, cMethodName );
 495
 496     jobject out(nullptr);
 497     SDBThreadAttach t; OSL_ENSURE(t.pEnv,"Java environment has been deleted!");
 498     {
 499         static const char * const cSignature = "(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;";
 500         // execute Java-Call
 501         static jmethodID mID(nullptr);
 502         obtainMethodId_throwSQL(t.pEnv, cMethodName,cSignature, mID);
 503         jvalue args[6];
 504         // convert Parameter
 505         args[0].l = primaryCatalog.hasValue() ? convertwchar_tToJavaString(t.pEnv,comphelper::getString(primaryCatalog)) : nullptr;
 506         args[1].l = primarySchema.toChar() == '%' ? nullptr : convertwchar_tToJavaString(t.pEnv,primarySchema);
 507         args[2].l = convertwchar_tToJavaString(t.pEnv,primaryTable);
 508         args[3].l = foreignCatalog.hasValue() ? convertwchar_tToJavaString(t.pEnv,comphelper::getString(foreignCatalog)) : nullptr;
 509         args[4].l = foreignSchema.toChar() == '%' ? nullptr : convertwchar_tToJavaString(t.pEnv,foreignSchema);
 510         args[5].l = convertwchar_tToJavaString(t.pEnv,foreignTable);
 511         out = t.pEnv->CallObjectMethod( object, mID, args[0].l,args[2].l,args[2].l,args[3].l,args[4].l,args[5].l );
 512
 513         // and clean up
 514         if(primaryCatalog.hasValue())
 515             t.pEnv->DeleteLocalRef(static_cast<jstring>(args[0].l));
 516         if(args[1].l)
 517             t.pEnv->DeleteLocalRef(static_cast<jstring>(args[1].l));
 518         if(!primaryTable.isEmpty())
 519             t.pEnv->DeleteLocalRef(static_cast<jstring>(args[2].l));
 520         if(foreignCatalog.hasValue())
 521             t.pEnv->DeleteLocalRef(static_cast<jstring>(args[3].l));
 522         if(args[4].l)
 523             t.pEnv->DeleteLocalRef(static_cast<jstring>(args[4].l));
 524         if(!foreignTable.isEmpty())
 525             t.pEnv->DeleteLocalRef(static_cast<jstring>(args[5].l));
 526         ThrowLoggedSQLException( m_aLogger, t.pEnv, *this );
 527     }
 528
 529     if ( !out )
 530         return nullptr;
 531
 532     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_SUCCESS, cMethodName );
 533     return new java_sql_ResultSet( t.pEnv, out, m_aLogger,*m_pConnection);
 534 }
 535
 536
 537 bool java_sql_DatabaseMetaData::impl_callBooleanMethod( const char* _pMethodName, jmethodID& _inout_MethodID )
 538 {
 539     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_METHOD, _pMethodName );
 540     bool out( java_lang_Object::callBooleanMethod(_pMethodName,_inout_MethodID) );
 541     m_aLogger.log< const char*, bool>( LogLevel::FINEST, STR_LOG_META_DATA_RESULT, _pMethodName, out );
 542     return out;
 543 }
 544
 545
 546 OUString java_sql_DatabaseMetaData::impl_callStringMethod( const char* _pMethodName, jmethodID& _inout_MethodID )
 547 {
 548     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_METHOD, _pMethodName );
 549
 550     const OUString sReturn( callStringMethod(_pMethodName,_inout_MethodID) );
 551     if ( m_aLogger.isLoggable( LogLevel::FINEST ) )
 552     {
 553         OUString sLoggedResult( sReturn );
 554         if ( sLoggedResult.isEmpty() )
 555             sLoggedResult = "<empty string>";
 556         m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_RESULT, _pMethodName, sLoggedResult );
 557     }
 558
 559     return sReturn;
 560 }
 561
 562 sal_Int32 java_sql_DatabaseMetaData::impl_callIntMethod_ThrowSQL(const char* _pMethodName, jmethodID& _inout_MethodID)
 563 {
 564     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_METHOD, _pMethodName );
 565     sal_Int32 out( callIntMethod_ThrowSQL(_pMethodName,_inout_MethodID) );
 566     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_RESULT, _pMethodName, out );
 567     return out;
 568 }
 569
 570 sal_Int32 java_sql_DatabaseMetaData::impl_callIntMethod_ThrowRuntime(const char* _pMethodName, jmethodID& _inout_MethodID)
 571 {
 572     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_METHOD, _pMethodName );
 573     sal_Int32 out( callIntMethod_ThrowRuntime(_pMethodName,_inout_MethodID) );
 574     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_RESULT, _pMethodName, out );
 575     return out;
 576 }
 577
 578 bool java_sql_DatabaseMetaData::impl_callBooleanMethodWithIntArg( const char* _pMethodName, jmethodID& _inout_MethodID, sal_Int32 _nArgument )
 579 {
 580     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_METHOD_ARG1, _pMethodName, _nArgument );
 581
 582     bool out( callBooleanMethodWithIntArg(_pMethodName,_inout_MethodID,_nArgument) );
 583
 584     m_aLogger.log< const char*, bool >( LogLevel::FINEST, STR_LOG_META_DATA_RESULT, _pMethodName, out );
 585     return out;
 586 }
 587
 588
 589 Reference< XResultSet > java_sql_DatabaseMetaData::impl_callResultSetMethod( const char* _pMethodName, jmethodID& _inout_MethodID )
 590 {
 591     SDBThreadAttach t;
 592     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_METHOD, _pMethodName );
 593     jobject out(callResultSetMethod(t.env(),_pMethodName,_inout_MethodID));
 594     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_SUCCESS, _pMethodName );
 595     return new java_sql_ResultSet( t.pEnv, out, m_aLogger,*m_pConnection);
 596 }
 597
 598
 599 Reference< XResultSet > java_sql_DatabaseMetaData::impl_callResultSetMethodWithStrings( const char* _pMethodName, jmethodID& _inout_MethodID,
 600     const Any& _rCatalog, const OUString& _rSchemaPattern, const OUString& _rLeastPattern,
 601     const OUString* _pOptionalAdditionalString )
 602 {
 603     bool bCatalog = _rCatalog.hasValue();
 604     OUString sCatalog;
 605     _rCatalog >>= sCatalog;
 606
 607     bool bSchema = _rSchemaPattern.toChar() != '%';
 608
 609     // log the call
 610     if ( m_aLogger.isLoggable( LogLevel::FINEST ) )
 611     {
 612         OUString sCatalogLog = bCatalog ? sCatalog : u"null"_ustr;
 613         OUString sSchemaLog = bSchema ? _rSchemaPattern : u"null"_ustr;
 614         if ( _pOptionalAdditionalString )
 615             m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_METHOD_ARG4, _pMethodName, sCatalogLog, sSchemaLog, _rLeastPattern, *_pOptionalAdditionalString );
 616         else
 617             m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_METHOD_ARG3, _pMethodName, sCatalogLog, sSchemaLog, _rLeastPattern );
 618     }
 619
 620     jobject out(nullptr);
 621
 622     SDBThreadAttach t;
 623     OSL_ENSURE( t.pEnv, "java_sql_DatabaseMetaData::impl_callResultSetMethodWithStrings: no Java environment anymore!" );
 624
 625     {
 626         const  char* pSignature = _pOptionalAdditionalString
 627             ?   "(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;"
 628             :   "(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;";
 629         // obtain method ID
 630         obtainMethodId_throwSQL(t.pEnv, _pMethodName,pSignature, _inout_MethodID);
 631
 632         // call method
 633
 634         {
 635             jvalue args[4];
 636             // convert parameters
 637             args[0].l = bCatalog ? convertwchar_tToJavaString( t.pEnv, sCatalog ) : nullptr;
 638             args[1].l = bSchema ? convertwchar_tToJavaString( t.pEnv, _rSchemaPattern ) : nullptr;
 639             args[2].l = convertwchar_tToJavaString( t.pEnv, _rLeastPattern );
 640             args[3].l = _pOptionalAdditionalString ? convertwchar_tToJavaString( t.pEnv, *_pOptionalAdditionalString ) : nullptr;
 641
 642             // actually do the call
 643             if ( _pOptionalAdditionalString )
 644                 out = t.pEnv->CallObjectMethod( object, _inout_MethodID, args[0].l, args[1].l, args[2].l, args[3].l );
 645             else
 646                 out = t.pEnv->CallObjectMethod( object, _inout_MethodID, args[0].l, args[1].l, args[2].l );
 647
 648             // clean up
 649             if ( args[0].l )
 650                 t.pEnv->DeleteLocalRef( static_cast<jstring>(args[0].l) );
 651             if ( args[1].l )
 652                 t.pEnv->DeleteLocalRef( static_cast<jstring>(args[1].l) );
 653             if ( args[2].l )
 654                 t.pEnv->DeleteLocalRef( static_cast<jstring>(args[2].l) );
 655             if ( args[3].l )
 656                 t.pEnv->DeleteLocalRef( static_cast<jstring>(args[3].l) );
 657
 658             ThrowLoggedSQLException( m_aLogger, t.pEnv, *this );
 659         }
 660     }
 661
 662     if ( !out )
 663         return nullptr;
 664
 665     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_SUCCESS, _pMethodName );
 666     return new java_sql_ResultSet( t.pEnv, out, m_aLogger,*m_pConnection);
 667 }
 668
 669
 670 sal_Bool SAL_CALL java_sql_DatabaseMetaData::doesMaxRowSizeIncludeBlobs(  )
 671 {
 672     static jmethodID mID(nullptr);
 673     return impl_callBooleanMethod( "doesMaxRowSizeIncludeBlobs", mID );
 674 }
 675
 676 sal_Bool SAL_CALL java_sql_DatabaseMetaData::storesLowerCaseQuotedIdentifiers(  )
 677 {
 678     static jmethodID mID(nullptr);
 679     return impl_callBooleanMethod( "storesLowerCaseQuotedIdentifiers", mID );
 680 }
 681
 682 sal_Bool SAL_CALL java_sql_DatabaseMetaData::storesLowerCaseIdentifiers(  )
 683 {
 684     static jmethodID mID(nullptr);
 685     return impl_callBooleanMethod( "storesLowerCaseIdentifiers", mID );
 686 }
 687
 688 bool java_sql_DatabaseMetaData::impl_storesMixedCaseQuotedIdentifiers_throw(  )
 689 {
 690     static jmethodID mID(nullptr);
 691     return impl_callBooleanMethod( "storesMixedCaseQuotedIdentifiers", mID );
 692 }
 693
 694 sal_Bool SAL_CALL java_sql_DatabaseMetaData::storesMixedCaseIdentifiers(  )
 695 {
 696     static jmethodID mID(nullptr);
 697     return impl_callBooleanMethod( "storesMixedCaseIdentifiers", mID );
 698 }
 699
 700 sal_Bool SAL_CALL java_sql_DatabaseMetaData::storesUpperCaseQuotedIdentifiers(  )
 701 {
 702     static jmethodID mID(nullptr);
 703     return impl_callBooleanMethod( "storesUpperCaseQuotedIdentifiers", mID );
 704 }
 705
 706 sal_Bool SAL_CALL java_sql_DatabaseMetaData::storesUpperCaseIdentifiers(  )
 707 {
 708     static jmethodID mID(nullptr);
 709     return impl_callBooleanMethod( "storesUpperCaseIdentifiers", mID );
 710 }
 711
 712 bool java_sql_DatabaseMetaData::impl_supportsAlterTableWithAddColumn_throw(  )
 713 {
 714     static jmethodID mID(nullptr);
 715     return impl_callBooleanMethod( "supportsAlterTableWithAddColumn", mID );
 716 }
 717
 718 bool java_sql_DatabaseMetaData::impl_supportsAlterTableWithDropColumn_throw(  )
 719 {
 720     static jmethodID mID(nullptr);
 721     return impl_callBooleanMethod( "supportsAlterTableWithDropColumn", mID );
 722 }
 723
 724 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxIndexLength(  )
 725 {
 726     static jmethodID mID(nullptr);
 727     return impl_callIntMethod_ThrowSQL("getMaxIndexLength", mID);
 728 }
 729
 730 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsNonNullableColumns(  )
 731 {
 732     static jmethodID mID(nullptr);
 733     return impl_callBooleanMethod( "supportsNonNullableColumns", mID );
 734 }
 735
 736 OUString SAL_CALL java_sql_DatabaseMetaData::getCatalogTerm(  )
 737 {
 738     static jmethodID mID(nullptr);
 739     return impl_callStringMethod( "getCatalogTerm", mID );
 740 }
 741
 742 OUString java_sql_DatabaseMetaData::impl_getIdentifierQuoteString_throw(  )
 743 {
 744     static jmethodID mID(nullptr);
 745     return impl_callStringMethod( "getIdentifierQuoteString", mID );
 746 }
 747
 748 OUString SAL_CALL java_sql_DatabaseMetaData::getExtraNameCharacters(  )
 749 {
 750     static jmethodID mID(nullptr);
 751     return impl_callStringMethod( "getExtraNameCharacters", mID );
 752 }
 753
 754 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsDifferentTableCorrelationNames(  )
 755 {
 756     static jmethodID mID(nullptr);
 757     return impl_callBooleanMethod( "supportsDifferentTableCorrelationNames", mID );
 758 }
 759
 760 bool java_sql_DatabaseMetaData::impl_isCatalogAtStart_throw(  )
 761 {
 762     static jmethodID mID(nullptr);
 763     return impl_callBooleanMethod( "isCatalogAtStart", mID );
 764 }
 765
 766 sal_Bool SAL_CALL java_sql_DatabaseMetaData::dataDefinitionIgnoredInTransactions(  )
 767 {
 768     static jmethodID mID(nullptr);
 769     return impl_callBooleanMethod( "dataDefinitionIgnoredInTransactions", mID );
 770 }
 771
 772 sal_Bool SAL_CALL java_sql_DatabaseMetaData::dataDefinitionCausesTransactionCommit(  )
 773 {
 774     static jmethodID mID(nullptr);
 775     return impl_callBooleanMethod( "dataDefinitionCausesTransactionCommit", mID );
 776 }
 777
 778 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsDataManipulationTransactionsOnly(  )
 779 {
 780     static jmethodID mID(nullptr);
 781     return impl_callBooleanMethod( "supportsDataManipulationTransactionsOnly", mID );
 782 }
 783
 784 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsDataDefinitionAndDataManipulationTransactions(  )
 785 {
 786     static jmethodID mID(nullptr);
 787     return impl_callBooleanMethod( "supportsDataDefinitionAndDataManipulationTransactions", mID );
 788 }
 789
 790 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsPositionedDelete(  )
 791 {
 792     static jmethodID mID(nullptr);
 793     return impl_callBooleanMethod( "supportsPositionedDelete", mID );
 794 }
 795
 796 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsPositionedUpdate(  )
 797 {
 798     static jmethodID mID(nullptr);
 799     return impl_callBooleanMethod( "supportsPositionedUpdate", mID );
 800 }
 801
 802 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsOpenStatementsAcrossRollback(  )
 803 {
 804     static jmethodID mID(nullptr);
 805     return impl_callBooleanMethod( "supportsOpenStatementsAcrossRollback", mID );
 806 }
 807
 808 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsOpenStatementsAcrossCommit(  )
 809 {
 810     static jmethodID mID(nullptr);
 811     return impl_callBooleanMethod( "supportsOpenStatementsAcrossCommit", mID );
 812 }
 813
 814 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsOpenCursorsAcrossCommit(  )
 815 {
 816     static jmethodID mID(nullptr);
 817     return impl_callBooleanMethod( "supportsOpenCursorsAcrossCommit", mID );
 818 }
 819
 820 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsOpenCursorsAcrossRollback(  )
 821 {
 822     static jmethodID mID(nullptr);
 823     return impl_callBooleanMethod( "supportsOpenCursorsAcrossRollback", mID );
 824 }
 825
 826 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsTransactionIsolationLevel( sal_Int32 level )
 827 {
 828     static jmethodID mID(nullptr);
 829     return impl_callBooleanMethodWithIntArg( "supportsTransactionIsolationLevel", mID, level );
 830 }
 831
 832 bool java_sql_DatabaseMetaData::impl_supportsSchemasInDataManipulation_throw(  )
 833 {
 834     static jmethodID mID(nullptr);
 835     return impl_callBooleanMethod( "supportsSchemasInDataManipulation", mID );
 836 }
 837
 838 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsANSI92FullSQL(  )
 839 {
 840     static jmethodID mID(nullptr);
 841     return impl_callBooleanMethod( "supportsANSI92FullSQL", mID );
 842 }
 843
 844 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsANSI92EntryLevelSQL(  )
 845 {
 846     static jmethodID mID(nullptr);
 847     return impl_callBooleanMethod( "supportsANSI92EntryLevelSQL", mID );
 848 }
 849
 850 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsIntegrityEnhancementFacility(  )
 851 {
 852     static jmethodID mID(nullptr);
 853     return impl_callBooleanMethod( "supportsIntegrityEnhancementFacility", mID );
 854 }
 855
 856 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsSchemasInIndexDefinitions(  )
 857 {
 858     static jmethodID mID(nullptr);
 859     return impl_callBooleanMethod( "supportsSchemasInIndexDefinitions", mID );
 860 }
 861
 862 bool java_sql_DatabaseMetaData::impl_supportsSchemasInTableDefinitions_throw(  )
 863 {
 864     static jmethodID mID(nullptr);
 865     return impl_callBooleanMethod( "supportsSchemasInTableDefinitions", mID );
 866 }
 867
 868 bool java_sql_DatabaseMetaData::impl_supportsCatalogsInTableDefinitions_throw(  )
 869 {
 870     static jmethodID mID(nullptr);
 871     return impl_callBooleanMethod( "supportsCatalogsInTableDefinitions", mID );
 872 }
 873
 874 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsCatalogsInIndexDefinitions(  )
 875 {
 876     static jmethodID mID(nullptr);
 877     return impl_callBooleanMethod( "supportsCatalogsInIndexDefinitions", mID );
 878 }
 879
 880 bool java_sql_DatabaseMetaData::impl_supportsCatalogsInDataManipulation_throw(  )
 881 {
 882     static jmethodID mID(nullptr);
 883     return impl_callBooleanMethod( "supportsCatalogsInDataManipulation", mID );
 884 }
 885
 886 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsOuterJoins(  )
 887 {
 888     static jmethodID mID(nullptr);
 889     return impl_callBooleanMethod( "supportsOuterJoins", mID );
 890 }
 891
 892 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getTableTypes(  )
 893 {
 894     static jmethodID mID(nullptr);
 895     return impl_callResultSetMethod( "getTableTypes", mID );
 896 }
 897
 898 sal_Int32 java_sql_DatabaseMetaData::impl_getMaxStatements_throw(  )
 899 {
 900     static jmethodID mID(nullptr);
 901     return impl_callIntMethod_ThrowSQL("getMaxStatements", mID);
 902 }
 903
 904 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxProcedureNameLength(  )
 905 {
 906     static jmethodID mID(nullptr);
 907     return impl_callIntMethod_ThrowSQL("getMaxProcedureNameLength", mID);
 908 }
 909
 910 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxSchemaNameLength(  )
 911 {
 912     static jmethodID mID(nullptr);
 913     return impl_callIntMethod_ThrowSQL("getMaxSchemaNameLength", mID);
 914 }
 915
 916 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsTransactions(  )
 917 {
 918     static jmethodID mID(nullptr);
 919     return impl_callBooleanMethod( "supportsTransactions", mID );
 920 }
 921
 922
 923 sal_Bool SAL_CALL java_sql_DatabaseMetaData::allProceduresAreCallable(  )
 924 {
 925     static jmethodID mID(nullptr);
 926     return impl_callBooleanMethod( "allProceduresAreCallable", mID );
 927 }
 928
 929 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsStoredProcedures(  )
 930 {
 931     static jmethodID mID(nullptr);
 932     return impl_callBooleanMethod( "supportsStoredProcedures", mID );
 933 }
 934
 935 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsSelectForUpdate(  )
 936 {
 937     static jmethodID mID(nullptr);
 938     return impl_callBooleanMethod( "supportsSelectForUpdate", mID );
 939 }
 940
 941 sal_Bool SAL_CALL java_sql_DatabaseMetaData::allTablesAreSelectable(  )
 942 {
 943     static jmethodID mID(nullptr);
 944     return impl_callBooleanMethod( "allTablesAreSelectable", mID );
 945 }
 946
 947 sal_Bool SAL_CALL java_sql_DatabaseMetaData::isReadOnly(  )
 948 {
 949     static jmethodID mID(nullptr);
 950     return impl_callBooleanMethod( "isReadOnly", mID );
 951 }
 952
 953 sal_Bool SAL_CALL java_sql_DatabaseMetaData::usesLocalFiles(  )
 954 {
 955     static jmethodID mID(nullptr);
 956     return impl_callBooleanMethod( "usesLocalFiles", mID );
 957 }
 958
 959 sal_Bool SAL_CALL java_sql_DatabaseMetaData::usesLocalFilePerTable(  )
 960 {
 961     static jmethodID mID(nullptr);
 962     return impl_callBooleanMethod( "usesLocalFilePerTable", mID );
 963 }
 964
 965 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsTypeConversion(  )
 966 {
 967     static jmethodID mID(nullptr);
 968     return impl_callBooleanMethod( "supportsTypeConversion", mID );
 969 }
 970
 971 sal_Bool SAL_CALL java_sql_DatabaseMetaData::nullPlusNonNullIsNull(  )
 972 {
 973     static jmethodID mID(nullptr);
 974     return impl_callBooleanMethod( "nullPlusNonNullIsNull", mID );
 975 }
 976
 977 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsColumnAliasing(  )
 978 {
 979     static jmethodID mID(nullptr);
 980     return impl_callBooleanMethod( "supportsColumnAliasing", mID );
 981 }
 982
 983 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsTableCorrelationNames(  )
 984 {
 985     static jmethodID mID(nullptr);
 986     return impl_callBooleanMethod( "supportsTableCorrelationNames", mID );
 987 }
 988
 989 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsConvert( sal_Int32 fromType, sal_Int32 toType )
 990 {
 991     static const char* const pMethodName = "supportsConvert";
 992     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_METHOD_ARG2, pMethodName, fromType, toType );
 993
 994     bool out( false );
 995     SDBThreadAttach t;
 996
 997     {
 998         static jmethodID mID(nullptr);
 999         obtainMethodId_throwSQL(t.pEnv, pMethodName,"(II)Z", mID);
1000         out = t.pEnv->CallBooleanMethod( object, mID, fromType, toType );
1001         ThrowLoggedSQLException( m_aLogger, t.pEnv, *this );
1002     }
1003
1004     m_aLogger.log< const char*, bool >( LogLevel::FINEST, STR_LOG_META_DATA_RESULT, pMethodName, out );
1005     return out;
1006 }
1007
1008 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsExpressionsInOrderBy(  )
1009 {
1010     static jmethodID mID(nullptr);
1011     return impl_callBooleanMethod( "supportsExpressionsInOrderBy", mID );
1012 }
1013
1014 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsGroupBy(  )
1015 {
1016     static jmethodID mID(nullptr);
1017     return impl_callBooleanMethod( "supportsGroupBy", mID );
1018 }
1019
1020 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsGroupByBeyondSelect(  )
1021 {
1022     static jmethodID mID(nullptr);
1023     return impl_callBooleanMethod( "supportsGroupByBeyondSelect", mID );
1024 }
1025
1026 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsGroupByUnrelated(  )
1027 {
1028     static jmethodID mID(nullptr);
1029     return impl_callBooleanMethod( "supportsGroupByUnrelated", mID );
1030 }
1031
1032 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsMultipleTransactions(  )
1033 {
1034     static jmethodID mID(nullptr);
1035     return impl_callBooleanMethod( "supportsMultipleTransactions", mID );
1036 }
1037
1038 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsMultipleResultSets(  )
1039 {
1040     static jmethodID mID(nullptr);
1041     return impl_callBooleanMethod( "supportsMultipleResultSets", mID );
1042 }
1043
1044 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsLikeEscapeClause(  )
1045 {
1046     static jmethodID mID(nullptr);
1047     return impl_callBooleanMethod( "supportsLikeEscapeClause", mID );
1048 }
1049
1050 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsOrderByUnrelated(  )
1051 {
1052     static jmethodID mID(nullptr);
1053     return impl_callBooleanMethod( "supportsOrderByUnrelated", mID );
1054 }
1055
1056 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsUnion(  )
1057 {
1058     static jmethodID mID(nullptr);
1059     return impl_callBooleanMethod( "supportsUnion", mID );
1060 }
1061
1062 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsUnionAll(  )
1063 {
1064     static jmethodID mID(nullptr);
1065     return impl_callBooleanMethod( "supportsUnionAll", mID );
1066 }
1067
1068 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsMixedCaseIdentifiers(  )
1069 {
1070     static jmethodID mID(nullptr);
1071     return impl_callBooleanMethod( "supportsMixedCaseIdentifiers", mID );
1072 }
1073
1074 bool java_sql_DatabaseMetaData::impl_supportsMixedCaseQuotedIdentifiers_throw(  )
1075 {
1076     static jmethodID mID(nullptr);
1077     return impl_callBooleanMethod( "supportsMixedCaseQuotedIdentifiers", mID );
1078 }
1079
1080 sal_Bool SAL_CALL java_sql_DatabaseMetaData::nullsAreSortedAtEnd(  )
1081 {
1082     static jmethodID mID(nullptr);
1083     return impl_callBooleanMethod( "nullsAreSortedAtEnd", mID );
1084 }
1085
1086 sal_Bool SAL_CALL java_sql_DatabaseMetaData::nullsAreSortedAtStart(  )
1087 {
1088     static jmethodID mID(nullptr);
1089     return impl_callBooleanMethod( "nullsAreSortedAtStart", mID );
1090 }
1091
1092 sal_Bool SAL_CALL java_sql_DatabaseMetaData::nullsAreSortedHigh(  )
1093 {
1094     static jmethodID mID(nullptr);
1095     return impl_callBooleanMethod( "nullsAreSortedHigh", mID );
1096 }
1097
1098 sal_Bool SAL_CALL java_sql_DatabaseMetaData::nullsAreSortedLow(  )
1099 {
1100     static jmethodID mID(nullptr);
1101     return impl_callBooleanMethod( "nullsAreSortedLow", mID );
1102 }
1103
1104 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsSchemasInProcedureCalls(  )
1105 {
1106     static jmethodID mID(nullptr);
1107     return impl_callBooleanMethod( "supportsSchemasInProcedureCalls", mID );
1108 }
1109
1110 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsSchemasInPrivilegeDefinitions(  )
1111 {
1112     static jmethodID mID(nullptr);
1113     return impl_callBooleanMethod( "supportsSchemasInPrivilegeDefinitions", mID );
1114 }
1115
1116 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsCatalogsInProcedureCalls(  )
1117 {
1118     static jmethodID mID(nullptr);
1119     return impl_callBooleanMethod( "supportsCatalogsInProcedureCalls", mID );
1120 }
1121
1122 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsCatalogsInPrivilegeDefinitions(  )
1123 {
1124     static jmethodID mID(nullptr);
1125     return impl_callBooleanMethod( "supportsCatalogsInPrivilegeDefinitions", mID );
1126 }
1127
1128 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsCorrelatedSubqueries(  )
1129 {
1130     static jmethodID mID(nullptr);
1131     return impl_callBooleanMethod( "supportsCorrelatedSubqueries", mID );
1132 }
1133
1134 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsSubqueriesInComparisons(  )
1135 {
1136     static jmethodID mID(nullptr);
1137     return impl_callBooleanMethod( "supportsSubqueriesInComparisons", mID );
1138 }
1139
1140 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsSubqueriesInExists(  )
1141 {
1142     static jmethodID mID(nullptr);
1143     return impl_callBooleanMethod( "supportsSubqueriesInExists", mID );
1144 }
1145
1146 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsSubqueriesInIns(  )
1147 {
1148     static jmethodID mID(nullptr);
1149     return impl_callBooleanMethod( "supportsSubqueriesInIns", mID );
1150 }
1151
1152 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsSubqueriesInQuantifieds(  )
1153 {
1154     static jmethodID mID(nullptr);
1155     return impl_callBooleanMethod( "supportsSubqueriesInQuantifieds", mID );
1156 }
1157
1158 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsANSI92IntermediateSQL(  )
1159 {
1160     static jmethodID mID(nullptr);
1161     return impl_callBooleanMethod( "supportsANSI92IntermediateSQL", mID );
1162 }
1163
1164 OUString SAL_CALL java_sql_DatabaseMetaData::getURL(  )
1165 {
1166     OUString sURL = m_pConnection->getURL();
1167     if ( sURL.isEmpty() )
1168     {
1169         static jmethodID mID(nullptr);
1170         sURL = impl_callStringMethod( "getURL", mID );
1171     }
1172     return sURL;
1173 }
1174
1175 OUString SAL_CALL java_sql_DatabaseMetaData::getUserName(  )
1176 {
1177     static jmethodID mID(nullptr);
1178     return impl_callStringMethod( "getUserName", mID );
1179 }
1180
1181 OUString SAL_CALL java_sql_DatabaseMetaData::getDriverName(  )
1182 {
1183     static jmethodID mID(nullptr);
1184     return impl_callStringMethod( "getDriverName", mID );
1185 }
1186
1187 OUString SAL_CALL java_sql_DatabaseMetaData::getDriverVersion(  )
1188 {
1189     static jmethodID mID(nullptr);
1190     return impl_callStringMethod( "getDriverVersion", mID );
1191 }
1192
1193 OUString SAL_CALL java_sql_DatabaseMetaData::getDatabaseProductVersion(  )
1194 {
1195     static jmethodID mID(nullptr);
1196     return impl_callStringMethod( "getDatabaseProductVersion", mID );
1197 }
1198
1199 OUString SAL_CALL java_sql_DatabaseMetaData::getDatabaseProductName(  )
1200 {
1201     static jmethodID mID(nullptr);
1202     return impl_callStringMethod( "getDatabaseProductName", mID );
1203 }
1204
1205 OUString SAL_CALL java_sql_DatabaseMetaData::getProcedureTerm(  )
1206 {
1207     static jmethodID mID(nullptr);
1208     return impl_callStringMethod( "getProcedureTerm", mID );
1209 }
1210
1211 OUString SAL_CALL java_sql_DatabaseMetaData::getSchemaTerm(  )
1212 {
1213     static jmethodID mID(nullptr);
1214     return impl_callStringMethod( "getSchemaTerm", mID );
1215 }
1216
1217 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getDriverMajorVersion(  )
1218 {
1219     static jmethodID mID(nullptr);
1220     return impl_callIntMethod_ThrowRuntime("getDriverMajorVersion", mID);
1221 }
1222
1223 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getDefaultTransactionIsolation(  )
1224 {
1225     static jmethodID mID(nullptr);
1226     return impl_callIntMethod_ThrowSQL("getDefaultTransactionIsolation", mID);
1227 }
1228
1229 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getDriverMinorVersion(  )
1230 {
1231     static jmethodID mID(nullptr);
1232     return impl_callIntMethod_ThrowRuntime("getDriverMinorVersion", mID);
1233 }
1234
1235 OUString SAL_CALL java_sql_DatabaseMetaData::getSQLKeywords(  )
1236 {
1237     static jmethodID mID(nullptr);
1238     return impl_callStringMethod( "getSQLKeywords", mID );
1239 }
1240
1241 OUString SAL_CALL java_sql_DatabaseMetaData::getSearchStringEscape(  )
1242 {
1243     static jmethodID mID(nullptr);
1244     return impl_callStringMethod( "getSearchStringEscape", mID );
1245 }
1246
1247 OUString SAL_CALL java_sql_DatabaseMetaData::getStringFunctions(  )
1248 {
1249     static jmethodID mID(nullptr);
1250     return impl_callStringMethod( "getStringFunctions", mID );
1251 }
1252
1253 OUString SAL_CALL java_sql_DatabaseMetaData::getTimeDateFunctions(  )
1254 {
1255     static jmethodID mID(nullptr);
1256     return impl_callStringMethod( "getTimeDateFunctions", mID );
1257 }
1258
1259 OUString SAL_CALL java_sql_DatabaseMetaData::getSystemFunctions(  )
1260 {
1261     static jmethodID mID(nullptr);
1262     return impl_callStringMethod( "getSystemFunctions", mID );
1263 }
1264
1265 OUString SAL_CALL java_sql_DatabaseMetaData::getNumericFunctions(  )
1266 {
1267     static jmethodID mID(nullptr);
1268     return impl_callStringMethod( "getNumericFunctions", mID );
1269 }
1270
1271 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsExtendedSQLGrammar(  )
1272 {
1273     static jmethodID mID(nullptr);
1274     return impl_callBooleanMethod( "supportsExtendedSQLGrammar", mID );
1275 }
1276
1277 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsCoreSQLGrammar(  )
1278 {
1279     static jmethodID mID(nullptr);
1280     return impl_callBooleanMethod( "supportsCoreSQLGrammar", mID );
1281 }
1282
1283 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsMinimumSQLGrammar(  )
1284 {
1285     static jmethodID mID(nullptr);
1286     return impl_callBooleanMethod( "supportsMinimumSQLGrammar", mID );
1287 }
1288
1289 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsFullOuterJoins(  )
1290 {
1291     static jmethodID mID(nullptr);
1292     return impl_callBooleanMethod( "supportsFullOuterJoins", mID );
1293 }
1294
1295 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsLimitedOuterJoins(  )
1296 {
1297     static jmethodID mID(nullptr);
1298     return impl_callBooleanMethod( "supportsLimitedOuterJoins", mID );
1299 }
1300
1301 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxColumnsInGroupBy(  )
1302 {
1303     static jmethodID mID(nullptr);
1304     return impl_callIntMethod_ThrowSQL("getMaxColumnsInGroupBy", mID);
1305 }
1306
1307 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxColumnsInOrderBy(  )
1308 {
1309     static jmethodID mID(nullptr);
1310     return impl_callIntMethod_ThrowSQL("getMaxColumnsInOrderBy", mID);
1311 }
1312
1313 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxColumnsInSelect(  )
1314 {
1315     static jmethodID mID(nullptr);
1316     return impl_callIntMethod_ThrowSQL("getMaxColumnsInSelect", mID);
1317 }
1318
1319 sal_Int32 SAL_CALL java_sql_DatabaseMetaData::getMaxUserNameLength(  )
1320 {
1321     static jmethodID mID(nullptr);
1322     return impl_callIntMethod_ThrowSQL("getMaxUserNameLength", mID);
1323 }
1324
1325 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsResultSetType( sal_Int32 setType )
1326 {
1327     static jmethodID mID(nullptr);
1328     return impl_callBooleanMethodWithIntArg( "supportsResultSetType", mID, setType );
1329 }
1330
1331 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsResultSetConcurrency( sal_Int32 setType, sal_Int32 concurrency )
1332 {
1333     static const char* const pMethodName = "supportsResultSetConcurrency";
1334     m_aLogger.log( LogLevel::FINEST, STR_LOG_META_DATA_METHOD_ARG2, pMethodName, setType, concurrency );
1335
1336     bool out( false );
1337     SDBThreadAttach t;
1338
1339     {
1340         static jmethodID mID(nullptr);
1341         obtainMethodId_throwSQL(t.pEnv, pMethodName,"(II)Z", mID);
1342         out =   t.pEnv->CallBooleanMethod( object, mID, setType, concurrency);
1343         ThrowLoggedSQLException( m_aLogger, t.pEnv, *this );
1344     }
1345
1346     m_aLogger.log< const char*, bool >( LogLevel::FINEST, STR_LOG_META_DATA_RESULT, pMethodName, out );
1347     return out;
1348 }
1349
1350 sal_Bool SAL_CALL java_sql_DatabaseMetaData::ownUpdatesAreVisible( sal_Int32 setType )
1351 {
1352     static jmethodID mID(nullptr);
1353     return impl_callBooleanMethodWithIntArg( "ownUpdatesAreVisible", mID, setType );
1354 }
1355
1356 sal_Bool SAL_CALL java_sql_DatabaseMetaData::ownDeletesAreVisible( sal_Int32 setType )
1357 {
1358     static jmethodID mID(nullptr);
1359     return impl_callBooleanMethodWithIntArg( "ownDeletesAreVisible", mID, setType );
1360 }
1361
1362 sal_Bool SAL_CALL java_sql_DatabaseMetaData::ownInsertsAreVisible( sal_Int32 setType )
1363 {
1364     static jmethodID mID(nullptr);
1365     return impl_callBooleanMethodWithIntArg( "ownInsertsAreVisible", mID, setType );
1366 }
1367
1368 sal_Bool SAL_CALL java_sql_DatabaseMetaData::othersUpdatesAreVisible( sal_Int32 setType )
1369 {
1370     static jmethodID mID(nullptr);
1371     return impl_callBooleanMethodWithIntArg( "othersUpdatesAreVisible", mID, setType );
1372 }
1373
1374 sal_Bool SAL_CALL java_sql_DatabaseMetaData::othersDeletesAreVisible( sal_Int32 setType )
1375 {
1376     static jmethodID mID(nullptr);
1377     return impl_callBooleanMethodWithIntArg( "othersDeletesAreVisible", mID, setType );
1378 }
1379
1380 sal_Bool SAL_CALL java_sql_DatabaseMetaData::othersInsertsAreVisible( sal_Int32 setType )
1381 {
1382     static jmethodID mID(nullptr);
1383     return impl_callBooleanMethodWithIntArg( "othersInsertsAreVisible", mID, setType );
1384 }
1385
1386 sal_Bool SAL_CALL java_sql_DatabaseMetaData::updatesAreDetected( sal_Int32 setType )
1387 {
1388     static jmethodID mID(nullptr);
1389     return impl_callBooleanMethodWithIntArg( "updatesAreDetected", mID, setType );
1390 }
1391
1392 sal_Bool SAL_CALL java_sql_DatabaseMetaData::deletesAreDetected( sal_Int32 setType )
1393 {
1394     static jmethodID mID(nullptr);
1395     return impl_callBooleanMethodWithIntArg( "deletesAreDetected", mID, setType );
1396 }
1397
1398 sal_Bool SAL_CALL java_sql_DatabaseMetaData::insertsAreDetected( sal_Int32 setType )
1399 {
1400     static jmethodID mID(nullptr);
1401     return impl_callBooleanMethodWithIntArg( "insertsAreDetected", mID, setType );
1402 }
1403
1404 sal_Bool SAL_CALL java_sql_DatabaseMetaData::supportsBatchUpdates(  )
1405 {
1406     static jmethodID mID(nullptr);
1407     return impl_callBooleanMethod( "supportsBatchUpdates", mID );
1408 }
1409
1410 Reference< XResultSet > SAL_CALL java_sql_DatabaseMetaData::getUDTs(
1411         const Any& catalog, const OUString& schemaPattern, const OUString& typeNamePattern,
1412         const Sequence< sal_Int32 >& types )
1413 {
1414     jobject out(nullptr);
1415     SDBThreadAttach t; OSL_ENSURE(t.pEnv,"Java environment has been deleted!");
1416     {
1417
1418
1419         static const char * const cSignature = "(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[I)Ljava/sql/ResultSet;";
1420         static const char * const cMethodName = "getUDTs";
1421         // dismiss Java-Call
1422         static jmethodID mID(nullptr);
1423         obtainMethodId_throwSQL(t.pEnv, cMethodName,cSignature, mID);
1424         {
1425             jvalue args[4];
1426             // initialize temporary Variable
1427             args[0].l = catalog.hasValue() ? convertwchar_tToJavaString(t.pEnv,comphelper::getString(catalog)) : nullptr;
1428             args[1].l = schemaPattern.toChar() == '%' ? nullptr : convertwchar_tToJavaString(t.pEnv,schemaPattern);
1429             args[2].l = convertwchar_tToJavaString(t.pEnv,typeNamePattern);
1430             jintArray pArray = t.pEnv->NewIntArray(types.getLength());
1431             jint * typesData = reinterpret_cast<jint *>(
1432                const_cast<sal_Int32 *>(types.getConstArray()));
1433             // 4th param of Set*ArrayRegion changed from pointer to non-const to
1434             // pointer to const between <http://docs.oracle.com/javase/6/docs/
1435             // technotes/guides/jni/spec/functions.html#wp22933> and
1436             // <http://docs.oracle.com/javase/7/docs/technotes/guides/jni/spec/
1437             // functions.html#wp22933>; work around that difference in a way
1438             // that doesn't trigger loplugin:redundantcast
1439             t.pEnv->SetIntArrayRegion(pArray,0,types.getLength(),typesData);
1440             args[3].l = pArray;
1441
1442             out = t.pEnv->CallObjectMethod( object, mID, args[0].l, args[1].l,args[2].l,args[3].l);
1443
1444             if(catalog.hasValue())
1445                 t.pEnv->DeleteLocalRef(static_cast<jstring>(args[0].l));
1446             if(!schemaPattern.isEmpty())
1447                 t.pEnv->DeleteLocalRef(static_cast<jstring>(args[1].l));
1448             if(!typeNamePattern.isEmpty())
1449                 t.pEnv->DeleteLocalRef(static_cast<jstring>(args[2].l));
1450             if(args[3].l)
1451                 t.pEnv->DeleteLocalRef(static_cast<jintArray>(args[3].l));
1452             ThrowLoggedSQLException( m_aLogger, t.pEnv, *this );
1453         }
1454     }
1455
1456     return out ? new java_sql_ResultSet( t.pEnv, out, m_aLogger,*m_pConnection ) : nullptr;
1457 }
1458
1459
1460 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */