1 /************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance 9 * with the License. You may obtain a copy of the License at 10 * 11 * http://www.apache.org/licenses/LICENSE-2.0 12 * 13 * Unless required by applicable law or agreed to in writing, 14 * software distributed under the License is distributed on an 15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16 * KIND, either express or implied. See the License for the 17 * specific language governing permissions and limitations 18 * under the License. 19 * 20 *************************************************************/ 21 22 23 #ifndef _CONNECTIVITY_JAVA_SQL_DATABASEMETADATA_HXX_ 24 #define _CONNECTIVITY_JAVA_SQL_DATABASEMETADATA_HXX_ 25 26 #include "java/lang/Object.hxx" 27 #include "TDatabaseMetaDataBase.hxx" 28 29 #include "java/sql/ConnectionLog.hxx" 30 31 namespace connectivity 32 { 33 class java_sql_Connection; 34 //************************************************************** 35 //************ Class: java.sql.DatabaseMetaDataDate 36 //************************************************************** 37 38 class java_sql_DatabaseMetaData : public ODatabaseMetaDataBase, 39 public java_lang_Object 40 { 41 java_sql_Connection* m_pConnection; 42 java::sql::ConnectionLog m_aLogger; 43 44 // statische Daten fuer die Klasse 45 static jclass theClass; 46 47 public: 48 virtual jclass getMyClass() const; 49 virtual ~java_sql_DatabaseMetaData(); 50 // ein Konstruktor, der fuer das Returnen des Objektes benoetigt wird: 51 java_sql_DatabaseMetaData( JNIEnv * pEnv, jobject myObj, java_sql_Connection& _rConnection ); 52 53 private: 54 55 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > impl_getTypeInfo_throw(); 56 // cached database information 57 virtual ::rtl::OUString impl_getIdentifierQuoteString_throw( ); 58 virtual sal_Bool impl_isCatalogAtStart_throw( ); 59 virtual ::rtl::OUString impl_getCatalogSeparator_throw( ); 60 virtual sal_Bool impl_supportsCatalogsInTableDefinitions_throw( ); 61 virtual sal_Bool impl_supportsSchemasInTableDefinitions_throw( ) ; 62 virtual sal_Bool impl_supportsCatalogsInDataManipulation_throw( ); 63 virtual sal_Bool impl_supportsSchemasInDataManipulation_throw( ) ; 64 virtual sal_Bool impl_supportsMixedCaseQuotedIdentifiers_throw( ); 65 virtual sal_Bool impl_supportsAlterTableWithAddColumn_throw( ); 66 virtual sal_Bool impl_supportsAlterTableWithDropColumn_throw( ); 67 virtual sal_Int32 impl_getMaxStatements_throw( ); 68 virtual sal_Int32 impl_getMaxTablesInSelect_throw( ); 69 virtual sal_Bool impl_storesMixedCaseQuotedIdentifiers_throw( ); 70 71 virtual sal_Bool SAL_CALL allProceduresAreCallable( ); 72 virtual sal_Bool SAL_CALL allTablesAreSelectable( ); 73 virtual ::rtl::OUString SAL_CALL getURL( ); 74 virtual ::rtl::OUString SAL_CALL getUserName( ); 75 virtual sal_Bool SAL_CALL isReadOnly( ); 76 virtual sal_Bool SAL_CALL nullsAreSortedHigh( ); 77 virtual sal_Bool SAL_CALL nullsAreSortedLow( ); 78 virtual sal_Bool SAL_CALL nullsAreSortedAtStart( ); 79 virtual sal_Bool SAL_CALL nullsAreSortedAtEnd( ); 80 virtual ::rtl::OUString SAL_CALL getDatabaseProductName( ); 81 virtual ::rtl::OUString SAL_CALL getDatabaseProductVersion( ); 82 virtual ::rtl::OUString SAL_CALL getDriverName( ); 83 virtual ::rtl::OUString SAL_CALL getDriverVersion( ); 84 virtual sal_Int32 SAL_CALL getDriverMajorVersion( ); 85 virtual sal_Int32 SAL_CALL getDriverMinorVersion( ); 86 virtual sal_Bool SAL_CALL usesLocalFiles( ); 87 virtual sal_Bool SAL_CALL usesLocalFilePerTable( ); 88 virtual sal_Bool SAL_CALL supportsMixedCaseIdentifiers( ); 89 virtual sal_Bool SAL_CALL storesUpperCaseIdentifiers( ); 90 virtual sal_Bool SAL_CALL storesLowerCaseIdentifiers( ); 91 virtual sal_Bool SAL_CALL storesMixedCaseIdentifiers( ); 92 virtual sal_Bool SAL_CALL storesUpperCaseQuotedIdentifiers( ); 93 virtual sal_Bool SAL_CALL storesLowerCaseQuotedIdentifiers( ); 94 virtual ::rtl::OUString SAL_CALL getSQLKeywords( ); 95 virtual ::rtl::OUString SAL_CALL getNumericFunctions( ); 96 virtual ::rtl::OUString SAL_CALL getStringFunctions( ); 97 virtual ::rtl::OUString SAL_CALL getSystemFunctions( ); 98 virtual ::rtl::OUString SAL_CALL getTimeDateFunctions( ); 99 virtual ::rtl::OUString SAL_CALL getSearchStringEscape( ); 100 virtual ::rtl::OUString SAL_CALL getExtraNameCharacters( ); 101 virtual sal_Bool SAL_CALL supportsColumnAliasing( ); 102 virtual sal_Bool SAL_CALL nullPlusNonNullIsNull( ); 103 virtual sal_Bool SAL_CALL supportsTypeConversion( ); 104 virtual sal_Bool SAL_CALL supportsConvert( sal_Int32 fromType, sal_Int32 toType ); 105 virtual sal_Bool SAL_CALL supportsTableCorrelationNames( ); 106 virtual sal_Bool SAL_CALL supportsDifferentTableCorrelationNames( ); 107 virtual sal_Bool SAL_CALL supportsExpressionsInOrderBy( ); 108 virtual sal_Bool SAL_CALL supportsOrderByUnrelated( ); 109 virtual sal_Bool SAL_CALL supportsGroupBy( ); 110 virtual sal_Bool SAL_CALL supportsGroupByUnrelated( ); 111 virtual sal_Bool SAL_CALL supportsGroupByBeyondSelect( ); 112 virtual sal_Bool SAL_CALL supportsLikeEscapeClause( ); 113 virtual sal_Bool SAL_CALL supportsMultipleResultSets( ); 114 virtual sal_Bool SAL_CALL supportsMultipleTransactions( ); 115 virtual sal_Bool SAL_CALL supportsNonNullableColumns( ); 116 virtual sal_Bool SAL_CALL supportsMinimumSQLGrammar( ); 117 virtual sal_Bool SAL_CALL supportsCoreSQLGrammar( ); 118 virtual sal_Bool SAL_CALL supportsExtendedSQLGrammar( ); 119 virtual sal_Bool SAL_CALL supportsANSI92EntryLevelSQL( ); 120 virtual sal_Bool SAL_CALL supportsANSI92IntermediateSQL( ); 121 virtual sal_Bool SAL_CALL supportsANSI92FullSQL( ); 122 virtual sal_Bool SAL_CALL supportsIntegrityEnhancementFacility( ); 123 virtual sal_Bool SAL_CALL supportsOuterJoins( ); 124 virtual sal_Bool SAL_CALL supportsFullOuterJoins( ); 125 virtual sal_Bool SAL_CALL supportsLimitedOuterJoins( ); 126 virtual ::rtl::OUString SAL_CALL getSchemaTerm( ); 127 virtual ::rtl::OUString SAL_CALL getProcedureTerm( ); 128 virtual ::rtl::OUString SAL_CALL getCatalogTerm( ); 129 virtual sal_Bool SAL_CALL supportsSchemasInProcedureCalls( ); 130 virtual sal_Bool SAL_CALL supportsSchemasInIndexDefinitions( ); 131 virtual sal_Bool SAL_CALL supportsSchemasInPrivilegeDefinitions( ); 132 virtual sal_Bool SAL_CALL supportsCatalogsInProcedureCalls( ); 133 virtual sal_Bool SAL_CALL supportsCatalogsInIndexDefinitions( ); 134 virtual sal_Bool SAL_CALL supportsCatalogsInPrivilegeDefinitions( ); 135 virtual sal_Bool SAL_CALL supportsPositionedDelete( ); 136 virtual sal_Bool SAL_CALL supportsPositionedUpdate( ); 137 virtual sal_Bool SAL_CALL supportsSelectForUpdate( ); 138 virtual sal_Bool SAL_CALL supportsStoredProcedures( ); 139 virtual sal_Bool SAL_CALL supportsSubqueriesInComparisons( ); 140 virtual sal_Bool SAL_CALL supportsSubqueriesInExists( ); 141 virtual sal_Bool SAL_CALL supportsSubqueriesInIns( ); 142 virtual sal_Bool SAL_CALL supportsSubqueriesInQuantifieds( ); 143 virtual sal_Bool SAL_CALL supportsCorrelatedSubqueries( ); 144 virtual sal_Bool SAL_CALL supportsUnion( ); 145 virtual sal_Bool SAL_CALL supportsUnionAll( ); 146 virtual sal_Bool SAL_CALL supportsOpenCursorsAcrossCommit( ); 147 virtual sal_Bool SAL_CALL supportsOpenCursorsAcrossRollback( ); 148 virtual sal_Bool SAL_CALL supportsOpenStatementsAcrossCommit( ); 149 virtual sal_Bool SAL_CALL supportsOpenStatementsAcrossRollback( ); 150 virtual sal_Int32 SAL_CALL getMaxBinaryLiteralLength( ); 151 virtual sal_Int32 SAL_CALL getMaxCharLiteralLength( ); 152 virtual sal_Int32 SAL_CALL getMaxColumnNameLength( ); 153 virtual sal_Int32 SAL_CALL getMaxColumnsInGroupBy( ); 154 virtual sal_Int32 SAL_CALL getMaxColumnsInIndex( ); 155 virtual sal_Int32 SAL_CALL getMaxColumnsInOrderBy( ); 156 virtual sal_Int32 SAL_CALL getMaxColumnsInSelect( ); 157 virtual sal_Int32 SAL_CALL getMaxColumnsInTable( ); 158 virtual sal_Int32 SAL_CALL getMaxConnections( ); 159 virtual sal_Int32 SAL_CALL getMaxCursorNameLength( ); 160 virtual sal_Int32 SAL_CALL getMaxIndexLength( ); 161 virtual sal_Int32 SAL_CALL getMaxSchemaNameLength( ); 162 virtual sal_Int32 SAL_CALL getMaxProcedureNameLength( ); 163 virtual sal_Int32 SAL_CALL getMaxCatalogNameLength( ); 164 virtual sal_Int32 SAL_CALL getMaxRowSize( ); 165 virtual sal_Bool SAL_CALL doesMaxRowSizeIncludeBlobs( ); 166 virtual sal_Int32 SAL_CALL getMaxStatementLength( ); 167 virtual sal_Int32 SAL_CALL getMaxTableNameLength( ); 168 virtual sal_Int32 SAL_CALL getMaxUserNameLength( ); 169 virtual sal_Int32 SAL_CALL getDefaultTransactionIsolation( ); 170 virtual sal_Bool SAL_CALL supportsTransactions( ); 171 virtual sal_Bool SAL_CALL supportsTransactionIsolationLevel( sal_Int32 level ); 172 virtual sal_Bool SAL_CALL supportsDataDefinitionAndDataManipulationTransactions( ); 173 virtual sal_Bool SAL_CALL supportsDataManipulationTransactionsOnly( ); 174 virtual sal_Bool SAL_CALL dataDefinitionCausesTransactionCommit( ); 175 virtual sal_Bool SAL_CALL dataDefinitionIgnoredInTransactions( ); 176 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getProcedures( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& procedureNamePattern ); 177 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getProcedureColumns( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& procedureNamePattern, const ::rtl::OUString& columnNamePattern ); 178 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getTables( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& tableNamePattern, const ::com::sun::star::uno::Sequence< ::rtl::OUString >& types ); 179 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getSchemas( ); 180 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getCatalogs( ); 181 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getTableTypes( ); 182 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getColumns( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& tableNamePattern, const ::rtl::OUString& columnNamePattern ); 183 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getColumnPrivileges( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table, const ::rtl::OUString& columnNamePattern ); 184 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getTablePrivileges( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& tableNamePattern ); 185 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getBestRowIdentifier( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table, sal_Int32 scope, sal_Bool nullable ); 186 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getVersionColumns( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table ); 187 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getPrimaryKeys( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table ); 188 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getImportedKeys( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table ); 189 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getExportedKeys( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table ); 190 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getCrossReference( const ::com::sun::star::uno::Any& primaryCatalog, const ::rtl::OUString& primarySchema, const ::rtl::OUString& primaryTable, const ::com::sun::star::uno::Any& foreignCatalog, const ::rtl::OUString& foreignSchema, const ::rtl::OUString& foreignTable ); 191 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getIndexInfo( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schema, const ::rtl::OUString& table, sal_Bool unique, sal_Bool approximate ); 192 virtual sal_Bool SAL_CALL supportsResultSetType( sal_Int32 setType ); 193 virtual sal_Bool SAL_CALL supportsResultSetConcurrency( sal_Int32 setType, sal_Int32 concurrency ); 194 virtual sal_Bool SAL_CALL ownUpdatesAreVisible( sal_Int32 setType ); 195 virtual sal_Bool SAL_CALL ownDeletesAreVisible( sal_Int32 setType ); 196 virtual sal_Bool SAL_CALL ownInsertsAreVisible( sal_Int32 setType ); 197 virtual sal_Bool SAL_CALL othersUpdatesAreVisible( sal_Int32 setType ); 198 virtual sal_Bool SAL_CALL othersDeletesAreVisible( sal_Int32 setType ); 199 virtual sal_Bool SAL_CALL othersInsertsAreVisible( sal_Int32 setType ); 200 virtual sal_Bool SAL_CALL updatesAreDetected( sal_Int32 setType ); 201 virtual sal_Bool SAL_CALL deletesAreDetected( sal_Int32 setType ); 202 virtual sal_Bool SAL_CALL insertsAreDetected( sal_Int32 setType ); 203 virtual sal_Bool SAL_CALL supportsBatchUpdates( ); 204 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getUDTs( const ::com::sun::star::uno::Any& catalog, const ::rtl::OUString& schemaPattern, const ::rtl::OUString& typeNamePattern, const ::com::sun::star::uno::Sequence< sal_Int32 >& types ); 205 206 private: 207 sal_Bool impl_callBooleanMethod( const char* _pMethodName, jmethodID& _inout_MethodID ); 208 ::rtl::OUString impl_callStringMethod( const char* _pMethodName, jmethodID& _inout_MethodID ); 209 sal_Int32 impl_callIntMethod( const char* _pMethodName, jmethodID& _inout_MethodID ); 210 sal_Bool impl_callBooleanMethodWithIntArg( const char* _pMethodName, jmethodID& _inout_MethodID, sal_Int32 _nArgument ); 211 ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > 212 impl_callResultSetMethod( const char* _pMethodName, jmethodID& _inout_MethodID ); 213 ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > 214 impl_callResultSetMethodWithStrings( const char* _pMethodName, jmethodID& _inout_MethodID, const ::com::sun::star::uno::Any& _rCatalog, 215 const ::rtl::OUString& _rSchemaPattern, const ::rtl::OUString& _rLeastPattern, 216 const ::rtl::OUString* _pOptionalAdditionalString = NULL); 217 }; 218 } 219 #endif // _CONNECTIVITY_JAVA_SQL_DATABASEMETADATA_HXX_ 220