1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
|
/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*************************************************************************
*
* Effective License of whole file:
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License version 2.1, as published by the Free Software Foundation.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston,
* MA 02111-1307 USA
*
* Parts "Copyright by Sun Microsystems, Inc" prior to August 2011:
*
* The Contents of this file are made available subject to the terms of
* the GNU Lesser General Public License Version 2.1
*
* Copyright: 2000 by Sun Microsystems, Inc.
*
* Contributor(s): Joerg Budischewski
*
* All parts contributed on or after August 2011:
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
************************************************************************/
#pragma once
#include "pq_connection.hxx"
#include <com/sun/star/sdbc/XDatabaseMetaData.hpp>
#include <cppuhelper/implbase.hxx>
namespace pq_sdbc_driver
{
class DatabaseMetaData :
public ::cppu::WeakImplHelper< css::sdbc::XDatabaseMetaData >
{
::rtl::Reference< comphelper::RefCountedMutex > m_xMutex;
ConnectionSettings *m_pSettings;
css::uno::Reference< css::sdbc::XConnection > m_origin;
css::uno::Reference< css::sdbc::XPreparedStatement > m_getIntSetting_stmt;
css::uno::Reference< css::sdbc::XPreparedStatement > m_getReferences_stmt[16];
css::uno::Reference< css::sdbc::XPreparedStatement > m_getTablePrivs_stmt;
css::uno::Reference< css::sdbc::XPreparedStatement > m_getColumnPrivs_stmt;
/// @throws css::sdbc::SQLException
/// @throws css::uno::RuntimeException
sal_Int32 getIntSetting(const OUString& settingName);
/// @throws css::sdbc::SQLException
/// @throws css::uno::RuntimeException
sal_Int32 getMaxIndexKeys();
/// @throws css::sdbc::SQLException
/// @throws css::uno::RuntimeException
sal_Int32 getMaxNameLength();
/// @throws css::sdbc::SQLException
/// @throws css::uno::RuntimeException
css::uno::Reference< css::sdbc::XResultSet > getImportedExportedKeys(
const css::uno::Any& primaryCatalog, const OUString& primarySchema, const OUString& primaryTable,
const css::uno::Any& foreignCatalog, const OUString& foreignSchema, const OUString& foreignTable );
void init_getReferences_stmt ();
void init_getPrivs_stmt ();
public:
DatabaseMetaData(
::rtl::Reference< comphelper::RefCountedMutex > reMutex,
css::uno::Reference< css::sdbc::XConnection > origin,
ConnectionSettings *pSettings
);
public:
// Methods
virtual sal_Bool SAL_CALL allProceduresAreCallable( ) override;
virtual sal_Bool SAL_CALL allTablesAreSelectable( ) override;
virtual OUString SAL_CALL getURL( ) override;
virtual OUString SAL_CALL getUserName( ) override;
virtual sal_Bool SAL_CALL isReadOnly( ) override;
virtual sal_Bool SAL_CALL nullsAreSortedHigh( ) override;
virtual sal_Bool SAL_CALL nullsAreSortedLow( ) override;
virtual sal_Bool SAL_CALL nullsAreSortedAtStart( ) override;
virtual sal_Bool SAL_CALL nullsAreSortedAtEnd( ) override;
virtual OUString SAL_CALL getDatabaseProductName( ) override;
virtual OUString SAL_CALL getDatabaseProductVersion( ) override;
virtual OUString SAL_CALL getDriverName( ) override;
virtual OUString SAL_CALL getDriverVersion( ) override;
virtual sal_Int32 SAL_CALL getDriverMajorVersion( ) override;
virtual sal_Int32 SAL_CALL getDriverMinorVersion( ) override;
virtual sal_Bool SAL_CALL usesLocalFiles( ) override;
virtual sal_Bool SAL_CALL usesLocalFilePerTable( ) override;
virtual sal_Bool SAL_CALL supportsMixedCaseIdentifiers( ) override;
virtual sal_Bool SAL_CALL storesUpperCaseIdentifiers( ) override;
virtual sal_Bool SAL_CALL storesLowerCaseIdentifiers( ) override;
virtual sal_Bool SAL_CALL storesMixedCaseIdentifiers( ) override;
virtual sal_Bool SAL_CALL supportsMixedCaseQuotedIdentifiers( ) override;
virtual sal_Bool SAL_CALL storesUpperCaseQuotedIdentifiers( ) override;
virtual sal_Bool SAL_CALL storesLowerCaseQuotedIdentifiers( ) override;
virtual sal_Bool SAL_CALL storesMixedCaseQuotedIdentifiers( ) override;
virtual OUString SAL_CALL getIdentifierQuoteString( ) override;
virtual OUString SAL_CALL getSQLKeywords( ) override;
virtual OUString SAL_CALL getNumericFunctions( ) override;
virtual OUString SAL_CALL getStringFunctions( ) override;
virtual OUString SAL_CALL getSystemFunctions( ) override;
virtual OUString SAL_CALL getTimeDateFunctions( ) override;
virtual OUString SAL_CALL getSearchStringEscape( ) override;
virtual OUString SAL_CALL getExtraNameCharacters( ) override;
virtual sal_Bool SAL_CALL supportsAlterTableWithAddColumn( ) override;
virtual sal_Bool SAL_CALL supportsAlterTableWithDropColumn( ) override;
virtual sal_Bool SAL_CALL supportsColumnAliasing( ) override;
virtual sal_Bool SAL_CALL nullPlusNonNullIsNull( ) override;
virtual sal_Bool SAL_CALL supportsTypeConversion( ) override;
virtual sal_Bool SAL_CALL supportsConvert( sal_Int32 fromType, sal_Int32 toType ) override;
virtual sal_Bool SAL_CALL supportsTableCorrelationNames( ) override;
virtual sal_Bool SAL_CALL supportsDifferentTableCorrelationNames( ) override;
virtual sal_Bool SAL_CALL supportsExpressionsInOrderBy( ) override;
virtual sal_Bool SAL_CALL supportsOrderByUnrelated( ) override;
virtual sal_Bool SAL_CALL supportsGroupBy( ) override;
virtual sal_Bool SAL_CALL supportsGroupByUnrelated( ) override;
virtual sal_Bool SAL_CALL supportsGroupByBeyondSelect( ) override;
virtual sal_Bool SAL_CALL supportsLikeEscapeClause( ) override;
virtual sal_Bool SAL_CALL supportsMultipleResultSets( ) override;
virtual sal_Bool SAL_CALL supportsMultipleTransactions( ) override;
virtual sal_Bool SAL_CALL supportsNonNullableColumns( ) override;
virtual sal_Bool SAL_CALL supportsMinimumSQLGrammar( ) override;
virtual sal_Bool SAL_CALL supportsCoreSQLGrammar( ) override;
virtual sal_Bool SAL_CALL supportsExtendedSQLGrammar( ) override;
virtual sal_Bool SAL_CALL supportsANSI92EntryLevelSQL( ) override;
virtual sal_Bool SAL_CALL supportsANSI92IntermediateSQL( ) override;
virtual sal_Bool SAL_CALL supportsANSI92FullSQL( ) override;
virtual sal_Bool SAL_CALL supportsIntegrityEnhancementFacility( ) override;
virtual sal_Bool SAL_CALL supportsOuterJoins( ) override;
virtual sal_Bool SAL_CALL supportsFullOuterJoins( ) override;
virtual sal_Bool SAL_CALL supportsLimitedOuterJoins( ) override;
virtual OUString SAL_CALL getSchemaTerm( ) override;
virtual OUString SAL_CALL getProcedureTerm( ) override;
virtual OUString SAL_CALL getCatalogTerm( ) override;
virtual sal_Bool SAL_CALL isCatalogAtStart( ) override;
virtual OUString SAL_CALL getCatalogSeparator( ) override;
virtual sal_Bool SAL_CALL supportsSchemasInDataManipulation( ) override;
virtual sal_Bool SAL_CALL supportsSchemasInProcedureCalls( ) override;
virtual sal_Bool SAL_CALL supportsSchemasInTableDefinitions( ) override;
virtual sal_Bool SAL_CALL supportsSchemasInIndexDefinitions( ) override;
virtual sal_Bool SAL_CALL supportsSchemasInPrivilegeDefinitions( ) override;
virtual sal_Bool SAL_CALL supportsCatalogsInDataManipulation( ) override;
virtual sal_Bool SAL_CALL supportsCatalogsInProcedureCalls( ) override;
virtual sal_Bool SAL_CALL supportsCatalogsInTableDefinitions( ) override;
virtual sal_Bool SAL_CALL supportsCatalogsInIndexDefinitions( ) override;
virtual sal_Bool SAL_CALL supportsCatalogsInPrivilegeDefinitions( ) override;
virtual sal_Bool SAL_CALL supportsPositionedDelete( ) override;
virtual sal_Bool SAL_CALL supportsPositionedUpdate( ) override;
virtual sal_Bool SAL_CALL supportsSelectForUpdate( ) override;
virtual sal_Bool SAL_CALL supportsStoredProcedures( ) override;
virtual sal_Bool SAL_CALL supportsSubqueriesInComparisons( ) override;
virtual sal_Bool SAL_CALL supportsSubqueriesInExists( ) override;
virtual sal_Bool SAL_CALL supportsSubqueriesInIns( ) override;
virtual sal_Bool SAL_CALL supportsSubqueriesInQuantifieds( ) override;
virtual sal_Bool SAL_CALL supportsCorrelatedSubqueries( ) override;
virtual sal_Bool SAL_CALL supportsUnion( ) override;
virtual sal_Bool SAL_CALL supportsUnionAll( ) override;
virtual sal_Bool SAL_CALL supportsOpenCursorsAcrossCommit( ) override;
virtual sal_Bool SAL_CALL supportsOpenCursorsAcrossRollback( ) override;
virtual sal_Bool SAL_CALL supportsOpenStatementsAcrossCommit( ) override;
virtual sal_Bool SAL_CALL supportsOpenStatementsAcrossRollback( ) override;
virtual sal_Int32 SAL_CALL getMaxBinaryLiteralLength( ) override;
virtual sal_Int32 SAL_CALL getMaxCharLiteralLength( ) override;
virtual sal_Int32 SAL_CALL getMaxColumnNameLength( ) override;
virtual sal_Int32 SAL_CALL getMaxColumnsInGroupBy( ) override;
virtual sal_Int32 SAL_CALL getMaxColumnsInIndex( ) override;
virtual sal_Int32 SAL_CALL getMaxColumnsInOrderBy( ) override;
virtual sal_Int32 SAL_CALL getMaxColumnsInSelect( ) override;
virtual sal_Int32 SAL_CALL getMaxColumnsInTable( ) override;
virtual sal_Int32 SAL_CALL getMaxConnections( ) override;
virtual sal_Int32 SAL_CALL getMaxCursorNameLength( ) override;
virtual sal_Int32 SAL_CALL getMaxIndexLength( ) override;
virtual sal_Int32 SAL_CALL getMaxSchemaNameLength( ) override;
virtual sal_Int32 SAL_CALL getMaxProcedureNameLength( ) override;
virtual sal_Int32 SAL_CALL getMaxCatalogNameLength( ) override;
virtual sal_Int32 SAL_CALL getMaxRowSize( ) override;
virtual sal_Bool SAL_CALL doesMaxRowSizeIncludeBlobs( ) override;
virtual sal_Int32 SAL_CALL getMaxStatementLength( ) override;
virtual sal_Int32 SAL_CALL getMaxStatements( ) override;
virtual sal_Int32 SAL_CALL getMaxTableNameLength( ) override;
virtual sal_Int32 SAL_CALL getMaxTablesInSelect( ) override;
virtual sal_Int32 SAL_CALL getMaxUserNameLength( ) override;
virtual sal_Int32 SAL_CALL getDefaultTransactionIsolation( ) override;
virtual sal_Bool SAL_CALL supportsTransactions( ) override;
virtual sal_Bool SAL_CALL supportsTransactionIsolationLevel( sal_Int32 level ) override;
virtual sal_Bool SAL_CALL supportsDataDefinitionAndDataManipulationTransactions( ) override;
virtual sal_Bool SAL_CALL supportsDataManipulationTransactionsOnly( ) override;
virtual sal_Bool SAL_CALL dataDefinitionCausesTransactionCommit( ) override;
virtual sal_Bool SAL_CALL dataDefinitionIgnoredInTransactions( ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getProcedures( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& procedureNamePattern ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getProcedureColumns( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& procedureNamePattern, const OUString& columnNamePattern ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getTables( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& tableNamePattern, const css::uno::Sequence< OUString >& types ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getSchemas( ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getCatalogs( ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getTableTypes( ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getColumns( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& tableNamePattern, const OUString& columnNamePattern ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getColumnPrivileges( const css::uno::Any& catalog, const OUString& schema, const OUString& table, const OUString& columnNamePattern ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getTablePrivileges( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& tableNamePattern ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getBestRowIdentifier( const css::uno::Any& catalog, const OUString& schema, const OUString& table, sal_Int32 scope, sal_Bool nullable ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getVersionColumns( const css::uno::Any& catalog, const OUString& schema, const OUString& table ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getPrimaryKeys( const css::uno::Any& catalog, const OUString& schema, const OUString& table ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getImportedKeys( const css::uno::Any& catalog, const OUString& schema, const OUString& table ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getExportedKeys( const css::uno::Any& catalog, const OUString& schema, const OUString& table ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getCrossReference( const css::uno::Any& primaryCatalog, const OUString& primarySchema, const OUString& primaryTable, const css::uno::Any& foreignCatalog, const OUString& foreignSchema, const OUString& foreignTable ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getTypeInfo( ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getIndexInfo( const css::uno::Any& catalog, const OUString& schema, const OUString& table, sal_Bool unique, sal_Bool approximate ) override;
virtual sal_Bool SAL_CALL supportsResultSetType( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL supportsResultSetConcurrency( sal_Int32 setType, sal_Int32 concurrency ) override;
virtual sal_Bool SAL_CALL ownUpdatesAreVisible( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL ownDeletesAreVisible( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL ownInsertsAreVisible( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL othersUpdatesAreVisible( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL othersDeletesAreVisible( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL othersInsertsAreVisible( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL updatesAreDetected( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL deletesAreDetected( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL insertsAreDetected( sal_Int32 setType ) override;
virtual sal_Bool SAL_CALL supportsBatchUpdates( ) override;
virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getUDTs( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& typeNamePattern, const css::uno::Sequence< sal_Int32 >& types ) override;
virtual css::uno::Reference< css::sdbc::XConnection > SAL_CALL getConnection( ) override;
};
}
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|
