LoadMetadataHelpers

java.lang.Object
- com.adbs.metadata.LoadMetadataHelpers

public class LoadMetadataHelpers
extends java.lang.Object

Field Summary

Fields
Modifier and Type	Field and Description
`static int`	`ServerVersionInformixDefault`
`static int`	`ServerVersionInformixDS10`
`static int`	`ServerVersionInformixDS11`
`static int`	`ServerVersionInformixDS8`
`static int`	`ServerVersionInformixDS9`
`static int`	`ServerVersionInformixMax`
`static int`	`ServerVersionInformixMin`
`static int`	`ServerVersionMSSQL2000`
`static int`	`ServerVersionMSSQL2005`
`static int`	`ServerVersionMSSQL2008`
`static int`	`ServerVersionMSSQL2012`
`static int`	`ServerVersionMSSQL2014`
`static int`	`ServerVersionMSSQL7`
`static int`	`ServerVersionMSSQLDefault`
`static int`	`ServerVersionMSSQLMax`
`static int`	`ServerVersionMSSQLMin`
`static int`	`ServerVersionOracle10`
`static int`	`ServerVersionOracle11`
`static int`	`ServerVersionOracle7`
`static int`	`ServerVersionOracle8`
`static int`	`ServerVersionOracle9`
`static int`	`ServerVersionOracleDefault`
`static int`	`ServerVersionOracleMax`
`static int`	`ServerVersionOracleMin`

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method and Description
`static int`	`calcServerVersionInformix(BaseMetadataProvider metadataProvider)`
`static int`	`calcServerVersionMSSQL(BaseMetadataProvider metadataProvider)`
`static int`	`calcServerVersionMySQL(BaseMetadataProvider metadataProvider)`
`static int`	`calcServerVersionOracle(BaseMetadataProvider metadataProvider)`
`static boolean`	`getDatabaseListMSSQL(BaseSQLContext sqlContext, SQLQualifiedNameList databaseList)`
`static boolean`	`getDatabaseListMySQL(BaseSQLContext sqlContext, SQLQualifiedNameList databaseList)`
`static boolean`	`getDatabaseListSQLite(BaseSQLContext sqlContext, SQLQualifiedNameList databaseList)`
`static boolean`	`getDatabaseListSybase(BaseSQLContext sqlContext, SQLQualifiedNameList databaseList)`
`static SQLQualifiedName`	`getDefaultDatabaseNameDB2(BaseSQLContext sqlContext)`
`static SQLQualifiedName`	`getDefaultDatabaseNameMSSQL(BaseSQLContext sqlContext)`
`static SQLQualifiedName`	`getDefaultDatabaseNameMySQL(BaseSQLContext sqlContext)`
`static SQLQualifiedName`	`getDefaultDatabaseNamePostgreSQL(BaseSQLContext sqlContext)`
`static SQLQualifiedName`	`getDefaultDatabaseNameSQL92(BaseSQLContext sqlContext)`
`static SQLQualifiedName`	`getDefaultDatabaseNameSQLite(BaseSQLContext sqlContext)`
`static SQLQualifiedName`	`getDefaultDatabaseNameSybase(BaseSQLContext sqlContext)`
`static boolean`	`getDefaultSchemaNamesDB2(BaseSQLContext sqlContext, SQLIdentifiersCollection defaultSchemaNames)`
`static boolean`	`getDefaultSchemaNamesMSSQL(BaseSQLContext sqlContext, SQLIdentifiersCollection defaultSchemaNames)`
`static boolean`	`getDefaultSchemaNamesOracle(BaseSQLContext sqlContext, SQLIdentifiersCollection defaultSchemaNames)`
`static boolean`	`getDefaultSchemaNamesPostgreSQL(BaseSQLContext sqlContext, SQLIdentifiersCollection defaultSchemaNames)`
`static boolean`	`getDefaultSchemaNamesSybase(BaseSQLContext sqlContext, SQLIdentifiersCollection defaultSchemaNames)`
`static boolean`	`getDefaultSchemaNamesTeradata(BaseSQLContext sqlContext, SQLIdentifiersCollection defaultSchemaNames)`
`static boolean`	`getSchemaListDB2(BaseSQLContext sqlContext, SQLIdentifiersCollection schemasList, SQLQualifiedName fromDatabase)`
`static boolean`	`getSchemaListInformix(BaseSQLContext sqlContext, SQLIdentifiersCollection schemasList, SQLQualifiedName fromDatabase)`
`static boolean`	`getSchemaListMSSQL(BaseSQLContext sqlContext, SQLIdentifiersCollection schemasList, SQLQualifiedName fromDatabase)`
`static boolean`	`getSchemaListOracle(BaseSQLContext sqlContext, SQLIdentifiersCollection schemasList, SQLQualifiedName fromDatabase)`
`static boolean`	`getSchemaListPostgreSQL(BaseSQLContext sqlContext, SQLIdentifiersCollection schemasList, SQLQualifiedName fromDatabase)`
`static boolean`	`getSchemaListSybase(BaseSQLContext sqlContext, SQLIdentifiersCollection schemasList, SQLQualifiedName fromDatabase)`
`static boolean`	`getSchemaListTeradata(BaseSQLContext sqlContext, SQLIdentifiersCollection schemasList, SQLQualifiedName fromDatabase)`
`static SyntaxSupportsConectedServer`	`isConnectedServerIsDB2(BaseMetadataProvider metadataProvider)`
`static SyntaxSupportsConectedServer`	`isConnectedServerIsFirebird(BaseMetadataProvider metadataProvider)`
`static SyntaxSupportsConectedServer`	`isConnectedServerIsInformix(BaseMetadataProvider metadataProvider)`
`static SyntaxSupportsConectedServer`	`isConnectedServerIsMSAccess(BaseMetadataProvider metadataProvider)`
`static SyntaxSupportsConectedServer`	`isConnectedServerIsMSSQL(BaseMetadataProvider metadataProvider)`
`static SyntaxSupportsConectedServer`	`isConnectedServerIsMSSQLCE(BaseMetadataProvider metadataProvider)`
`static SyntaxSupportsConectedServer`	`isConnectedServerIsMySQL(BaseMetadataProvider metadataProvider)`
`static SyntaxSupportsConectedServer`	`isConnectedServerIsOracle(BaseMetadataProvider metadataProvider)`
`static SyntaxSupportsConectedServer`	`isConnectedServerIsPostgreSQL(BaseMetadataProvider metadataProvider)`
`static SyntaxSupportsConectedServer`	`isConnectedServerIsSQL92(BaseMetadataProvider metadataProvider)`
`static SyntaxSupportsConectedServer`	`isConnectedServerIsSQLite(BaseMetadataProvider metadataProvider)`
`static SyntaxSupportsConectedServer`	`isConnectedServerIsSybase(BaseMetadataProvider metadataProvider)`
`static boolean`	`isConnectedServerIsSybaseASA(BaseMetadataProvider metadataProvider)`
`static boolean`	`isConnectedServerIsSybaseASE(BaseMetadataProvider metadataProvider)`
`static SyntaxSupportsConectedServer`	`isConnectedServerIsTeradata(BaseMetadataProvider metadataProvider)`
`static SyntaxSupportsConectedServer`	`isConnectedServerIsVistaDB(BaseMetadataProvider metadataProvider)`
`static boolean`	`loadMetadataObjectsDB2(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataObjectsFirebird(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataObjectsInformix(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataObjectsMSSQL(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataObjectsMSSQLCE(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataObjectsMySQL(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataObjectsOracle(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataObjectsPostgreSQL(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataObjectsSQL92(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataObjectsSQLite(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataObjectsSybase(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataObjectsTeradata(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataRelationsDB2(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataRelationsFirebird(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataRelationsInformix(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataRelationsMSSQL(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataRelationsMSSQLCE(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataRelationsMySQL(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataRelationsOracle(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataRelationsPostgreSQL(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataRelationsSQL92(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataRelationsSybase(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataRelationsSybaseASA(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataRelationsSybaseASE(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static boolean`	`loadMetadataRelationsTeradata(BaseSQLContext sqlContext, MetadataContainer metadataContainer, MetadataFilter metadataFilter, SQLQualifiedName database)`
`static int`	`parseServerVersionMySQL(java.lang.String version)`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail
- ServerVersionMSSQL7
```
public static final int ServerVersionMSSQL7
```
  See Also:
  
  Constant Field Values
- ServerVersionMSSQL2000
```
public static final int ServerVersionMSSQL2000
```
  See Also:
  
  Constant Field Values
- ServerVersionMSSQL2005
```
public static final int ServerVersionMSSQL2005
```
  See Also:
  
  Constant Field Values
- ServerVersionMSSQL2008
```
public static final int ServerVersionMSSQL2008
```
  See Also:
  
  Constant Field Values
- ServerVersionMSSQL2012
```
public static final int ServerVersionMSSQL2012
```
  See Also:
  
  Constant Field Values
- ServerVersionMSSQL2014
```
public static final int ServerVersionMSSQL2014
```
  See Also:
  
  Constant Field Values
- ServerVersionMSSQLMin
```
public static final int ServerVersionMSSQLMin
```
  See Also:
  
  Constant Field Values
- ServerVersionMSSQLMax
```
public static final int ServerVersionMSSQLMax
```
  See Also:
  
  Constant Field Values
- ServerVersionMSSQLDefault
```
public static final int ServerVersionMSSQLDefault
```
  See Also:
  
  Constant Field Values
- ServerVersionOracle7
```
public static final int ServerVersionOracle7
```
  See Also:
  
  Constant Field Values
- ServerVersionOracle8
```
public static final int ServerVersionOracle8
```
  See Also:
  
  Constant Field Values
- ServerVersionOracle9
```
public static final int ServerVersionOracle9
```
  See Also:
  
  Constant Field Values
- ServerVersionOracle10
```
public static final int ServerVersionOracle10
```
  See Also:
  
  Constant Field Values
- ServerVersionOracle11
```
public static final int ServerVersionOracle11
```
  See Also:
  
  Constant Field Values
- ServerVersionOracleMin
```
public static final int ServerVersionOracleMin
```
  See Also:
  
  Constant Field Values
- ServerVersionOracleMax
```
public static final int ServerVersionOracleMax
```
  See Also:
  
  Constant Field Values
- ServerVersionOracleDefault
```
public static final int ServerVersionOracleDefault
```
  See Also:
  
  Constant Field Values
- ServerVersionInformixDS8
```
public static final int ServerVersionInformixDS8
```
  See Also:
  
  Constant Field Values
- ServerVersionInformixDS9
```
public static final int ServerVersionInformixDS9
```
  See Also:
  
  Constant Field Values
- ServerVersionInformixDS10
```
public static final int ServerVersionInformixDS10
```
  See Also:
  
  Constant Field Values
- ServerVersionInformixDS11
```
public static final int ServerVersionInformixDS11
```
  See Also:
  
  Constant Field Values
- ServerVersionInformixMin
```
public static final int ServerVersionInformixMin
```
  See Also:
  
  Constant Field Values
- ServerVersionInformixMax
```
public static final int ServerVersionInformixMax
```
  See Also:
  
  Constant Field Values
- ServerVersionInformixDefault
```
public static final int ServerVersionInformixDefault
```
  See Also:
  
  Constant Field Values

Method Detail

isConnectedServerIsSQL92

public static SyntaxSupportsConectedServer isConnectedServerIsSQL92(BaseMetadataProvider metadataProvider)

loadMetadataObjectsSQL92

public static boolean loadMetadataObjectsSQL92(BaseSQLContext sqlContext,
                                               MetadataContainer metadataContainer,
                                               MetadataFilter metadataFilter,
                                               SQLQualifiedName database)
                                        throws QueryBuilderException

Throws:: QueryBuilderException

loadMetadataRelationsSQL92

public static boolean loadMetadataRelationsSQL92(BaseSQLContext sqlContext,
                                                 MetadataContainer metadataContainer,
                                                 MetadataFilter metadataFilter,
                                                 SQLQualifiedName database)
                                          throws QueryBuilderException

Throws:: QueryBuilderException

getDefaultDatabaseNameSQL92

public static SQLQualifiedName getDefaultDatabaseNameSQL92(BaseSQLContext sqlContext)

isConnectedServerIsMSSQL

public static SyntaxSupportsConectedServer isConnectedServerIsMSSQL(BaseMetadataProvider metadataProvider)

calcServerVersionMSSQL

public static int calcServerVersionMSSQL(BaseMetadataProvider metadataProvider)

getDefaultDatabaseNameMSSQL

public static SQLQualifiedName getDefaultDatabaseNameMSSQL(BaseSQLContext sqlContext)

getDefaultSchemaNamesMSSQL

public static boolean getDefaultSchemaNamesMSSQL(BaseSQLContext sqlContext,
                                                 SQLIdentifiersCollection defaultSchemaNames)

getDatabaseListMSSQL

public static boolean getDatabaseListMSSQL(BaseSQLContext sqlContext,
                                           SQLQualifiedNameList databaseList)
                                    throws QueryBuilderException

Throws:: QueryBuilderException

loadMetadataObjectsMSSQL

public static boolean loadMetadataObjectsMSSQL(BaseSQLContext sqlContext,
                                               MetadataContainer metadataContainer,
                                               MetadataFilter metadataFilter,
                                               SQLQualifiedName database)
                                        throws QueryBuilderException

Throws:: QueryBuilderException

getSchemaListMSSQL

public static boolean getSchemaListMSSQL(BaseSQLContext sqlContext,
                                         SQLIdentifiersCollection schemasList,
                                         SQLQualifiedName fromDatabase)

loadMetadataRelationsMSSQL

public static boolean loadMetadataRelationsMSSQL(BaseSQLContext sqlContext,
                                                 MetadataContainer metadataContainer,
                                                 MetadataFilter metadataFilter,
                                                 SQLQualifiedName database)
                                          throws QueryBuilderException

Throws:: QueryBuilderException

isConnectedServerIsMSSQLCE

public static SyntaxSupportsConectedServer isConnectedServerIsMSSQLCE(BaseMetadataProvider metadataProvider)

loadMetadataObjectsMSSQLCE

public static boolean loadMetadataObjectsMSSQLCE(BaseSQLContext sqlContext,
                                                 MetadataContainer metadataContainer,
                                                 MetadataFilter metadataFilter,
                                                 SQLQualifiedName database)

loadMetadataRelationsMSSQLCE

public static boolean loadMetadataRelationsMSSQLCE(BaseSQLContext sqlContext,
                                                   MetadataContainer metadataContainer,
                                                   MetadataFilter metadataFilter,
                                                   SQLQualifiedName database)

isConnectedServerIsMySQL

public static SyntaxSupportsConectedServer isConnectedServerIsMySQL(BaseMetadataProvider metadataProvider)

parseServerVersionMySQL

public static int parseServerVersionMySQL(java.lang.String version)
                                   throws java.lang.Exception

Throws:: java.lang.Exception

calcServerVersionMySQL

public static int calcServerVersionMySQL(BaseMetadataProvider metadataProvider)

getDefaultDatabaseNameMySQL

public static SQLQualifiedName getDefaultDatabaseNameMySQL(BaseSQLContext sqlContext)

getDatabaseListMySQL

public static boolean getDatabaseListMySQL(BaseSQLContext sqlContext,
                                           SQLQualifiedNameList databaseList)
                                    throws QueryBuilderException

Throws:: QueryBuilderException

loadMetadataObjectsMySQL

public static boolean loadMetadataObjectsMySQL(BaseSQLContext sqlContext,
                                               MetadataContainer metadataContainer,
                                               MetadataFilter metadataFilter,
                                               SQLQualifiedName database)
                                        throws QueryBuilderException

Throws:: QueryBuilderException

loadMetadataRelationsMySQL

public static boolean loadMetadataRelationsMySQL(BaseSQLContext sqlContext,
                                                 MetadataContainer metadataContainer,
                                                 MetadataFilter metadataFilter,
                                                 SQLQualifiedName database)
                                          throws QueryBuilderException

Throws:: QueryBuilderException

isConnectedServerIsOracle

public static SyntaxSupportsConectedServer isConnectedServerIsOracle(BaseMetadataProvider metadataProvider)

getDefaultSchemaNamesOracle

public static boolean getDefaultSchemaNamesOracle(BaseSQLContext sqlContext,
                                                  SQLIdentifiersCollection defaultSchemaNames)

getSchemaListOracle

public static boolean getSchemaListOracle(BaseSQLContext sqlContext,
                                          SQLIdentifiersCollection schemasList,
                                          SQLQualifiedName fromDatabase)

loadMetadataObjectsOracle

public static boolean loadMetadataObjectsOracle(BaseSQLContext sqlContext,
                                                MetadataContainer metadataContainer,
                                                MetadataFilter metadataFilter,
                                                SQLQualifiedName database)
                                         throws QueryBuilderException

Throws:: QueryBuilderException

loadMetadataRelationsOracle

public static boolean loadMetadataRelationsOracle(BaseSQLContext sqlContext,
                                                  MetadataContainer metadataContainer,
                                                  MetadataFilter metadataFilter,
                                                  SQLQualifiedName database)
                                           throws QueryBuilderException

Throws:: QueryBuilderException

calcServerVersionOracle

public static int calcServerVersionOracle(BaseMetadataProvider metadataProvider)

isConnectedServerIsMSAccess

public static SyntaxSupportsConectedServer isConnectedServerIsMSAccess(BaseMetadataProvider metadataProvider)

isConnectedServerIsPostgreSQL

public static SyntaxSupportsConectedServer isConnectedServerIsPostgreSQL(BaseMetadataProvider metadataProvider)

getDefaultDatabaseNamePostgreSQL

public static SQLQualifiedName getDefaultDatabaseNamePostgreSQL(BaseSQLContext sqlContext)

getDefaultSchemaNamesPostgreSQL

public static boolean getDefaultSchemaNamesPostgreSQL(BaseSQLContext sqlContext,
                                                      SQLIdentifiersCollection defaultSchemaNames)

loadMetadataObjectsPostgreSQL

public static boolean loadMetadataObjectsPostgreSQL(BaseSQLContext sqlContext,
                                                    MetadataContainer metadataContainer,
                                                    MetadataFilter metadataFilter,
                                                    SQLQualifiedName database)
                                             throws QueryBuilderException

Throws:: QueryBuilderException

loadMetadataRelationsPostgreSQL

public static boolean loadMetadataRelationsPostgreSQL(BaseSQLContext sqlContext,
                                                      MetadataContainer metadataContainer,
                                                      MetadataFilter metadataFilter,
                                                      SQLQualifiedName database)
                                               throws QueryBuilderException

Throws:: QueryBuilderException

getSchemaListPostgreSQL

public static boolean getSchemaListPostgreSQL(BaseSQLContext sqlContext,
                                              SQLIdentifiersCollection schemasList,
                                              SQLQualifiedName fromDatabase)

isConnectedServerIsFirebird

public static SyntaxSupportsConectedServer isConnectedServerIsFirebird(BaseMetadataProvider metadataProvider)

loadMetadataObjectsFirebird

public static boolean loadMetadataObjectsFirebird(BaseSQLContext sqlContext,
                                                  MetadataContainer metadataContainer,
                                                  MetadataFilter metadataFilter,
                                                  SQLQualifiedName database)
                                           throws QueryBuilderException

Throws:: QueryBuilderException

loadMetadataRelationsFirebird

public static boolean loadMetadataRelationsFirebird(BaseSQLContext sqlContext,
                                                    MetadataContainer metadataContainer,
                                                    MetadataFilter metadataFilter,
                                                    SQLQualifiedName database)
                                             throws QueryBuilderException

Throws:: QueryBuilderException

isConnectedServerIsDB2

public static SyntaxSupportsConectedServer isConnectedServerIsDB2(BaseMetadataProvider metadataProvider)

getDefaultDatabaseNameDB2

public static SQLQualifiedName getDefaultDatabaseNameDB2(BaseSQLContext sqlContext)

getDefaultSchemaNamesDB2

public static boolean getDefaultSchemaNamesDB2(BaseSQLContext sqlContext,
                                               SQLIdentifiersCollection defaultSchemaNames)

loadMetadataObjectsDB2

public static boolean loadMetadataObjectsDB2(BaseSQLContext sqlContext,
                                             MetadataContainer metadataContainer,
                                             MetadataFilter metadataFilter,
                                             SQLQualifiedName database)
                                      throws QueryBuilderException

Throws:: QueryBuilderException

loadMetadataRelationsDB2

public static boolean loadMetadataRelationsDB2(BaseSQLContext sqlContext,
                                               MetadataContainer metadataContainer,
                                               MetadataFilter metadataFilter,
                                               SQLQualifiedName database)
                                        throws QueryBuilderException

Throws:: QueryBuilderException

getSchemaListDB2

public static boolean getSchemaListDB2(BaseSQLContext sqlContext,
                                       SQLIdentifiersCollection schemasList,
                                       SQLQualifiedName fromDatabase)

isConnectedServerIsSybase

public static SyntaxSupportsConectedServer isConnectedServerIsSybase(BaseMetadataProvider metadataProvider)

isConnectedServerIsSybaseASA

public static boolean isConnectedServerIsSybaseASA(BaseMetadataProvider metadataProvider)

isConnectedServerIsSybaseASE

public static boolean isConnectedServerIsSybaseASE(BaseMetadataProvider metadataProvider)

getDefaultDatabaseNameSybase

public static SQLQualifiedName getDefaultDatabaseNameSybase(BaseSQLContext sqlContext)

getDefaultSchemaNamesSybase

public static boolean getDefaultSchemaNamesSybase(BaseSQLContext sqlContext,
                                                  SQLIdentifiersCollection defaultSchemaNames)

getDatabaseListSybase

public static boolean getDatabaseListSybase(BaseSQLContext sqlContext,
                                            SQLQualifiedNameList databaseList)
                                     throws QueryBuilderException

Throws:: QueryBuilderException

loadMetadataObjectsSybase

public static boolean loadMetadataObjectsSybase(BaseSQLContext sqlContext,
                                                MetadataContainer metadataContainer,
                                                MetadataFilter metadataFilter,
                                                SQLQualifiedName database)
                                         throws QueryBuilderException

Throws:: QueryBuilderException

loadMetadataRelationsSybase

public static boolean loadMetadataRelationsSybase(BaseSQLContext sqlContext,
                                                  MetadataContainer metadataContainer,
                                                  MetadataFilter metadataFilter,
                                                  SQLQualifiedName database)
                                           throws QueryBuilderException

Throws:: QueryBuilderException

loadMetadataRelationsSybaseASA

public static boolean loadMetadataRelationsSybaseASA(BaseSQLContext sqlContext,
                                                     MetadataContainer metadataContainer,
                                                     MetadataFilter metadataFilter,
                                                     SQLQualifiedName database)
                                              throws QueryBuilderException

Throws:: QueryBuilderException

loadMetadataRelationsSybaseASE

public static boolean loadMetadataRelationsSybaseASE(BaseSQLContext sqlContext,
                                                     MetadataContainer metadataContainer,
                                                     MetadataFilter metadataFilter,
                                                     SQLQualifiedName database)
                                              throws QueryBuilderException

Throws:: QueryBuilderException

getSchemaListSybase

public static boolean getSchemaListSybase(BaseSQLContext sqlContext,
                                          SQLIdentifiersCollection schemasList,
                                          SQLQualifiedName fromDatabase)

isConnectedServerIsInformix

public static SyntaxSupportsConectedServer isConnectedServerIsInformix(BaseMetadataProvider metadataProvider)

loadMetadataObjectsInformix

public static boolean loadMetadataObjectsInformix(BaseSQLContext sqlContext,
                                                  MetadataContainer metadataContainer,
                                                  MetadataFilter metadataFilter,
                                                  SQLQualifiedName database)
                                           throws QueryBuilderException

Throws:: QueryBuilderException

loadMetadataRelationsInformix

public static boolean loadMetadataRelationsInformix(BaseSQLContext sqlContext,
                                                    MetadataContainer metadataContainer,
                                                    MetadataFilter metadataFilter,
                                                    SQLQualifiedName database)
                                             throws QueryBuilderException

Throws:: QueryBuilderException

getSchemaListInformix

public static boolean getSchemaListInformix(BaseSQLContext sqlContext,
                                            SQLIdentifiersCollection schemasList,
                                            SQLQualifiedName fromDatabase)

calcServerVersionInformix

public static int calcServerVersionInformix(BaseMetadataProvider metadataProvider)

isConnectedServerIsSQLite

public static SyntaxSupportsConectedServer isConnectedServerIsSQLite(BaseMetadataProvider metadataProvider)

loadMetadataObjectsSQLite

public static boolean loadMetadataObjectsSQLite(BaseSQLContext sqlContext,
                                                MetadataContainer metadataContainer,
                                                MetadataFilter metadataFilter,
                                                SQLQualifiedName database)
                                         throws QueryBuilderException

Throws:: QueryBuilderException

getDefaultDatabaseNameSQLite

public static SQLQualifiedName getDefaultDatabaseNameSQLite(BaseSQLContext sqlContext)

getDatabaseListSQLite

public static boolean getDatabaseListSQLite(BaseSQLContext sqlContext,
                                            SQLQualifiedNameList databaseList)

isConnectedServerIsVistaDB

public static SyntaxSupportsConectedServer isConnectedServerIsVistaDB(BaseMetadataProvider metadataProvider)

isConnectedServerIsTeradata

public static SyntaxSupportsConectedServer isConnectedServerIsTeradata(BaseMetadataProvider metadataProvider)

getDefaultSchemaNamesTeradata

public static boolean getDefaultSchemaNamesTeradata(BaseSQLContext sqlContext,
                                                    SQLIdentifiersCollection defaultSchemaNames)

getSchemaListTeradata

public static boolean getSchemaListTeradata(BaseSQLContext sqlContext,
                                            SQLIdentifiersCollection schemasList,
                                            SQLQualifiedName fromDatabase)

loadMetadataObjectsTeradata

public static boolean loadMetadataObjectsTeradata(BaseSQLContext sqlContext,
                                                  MetadataContainer metadataContainer,
                                                  MetadataFilter metadataFilter,
                                                  SQLQualifiedName database)

loadMetadataRelationsTeradata

public static boolean loadMetadataRelationsTeradata(BaseSQLContext sqlContext,
                                                    MetadataContainer metadataContainer,
                                                    MetadataFilter metadataFilter,
                                                    SQLQualifiedName database)
                                             throws QueryBuilderException

Throws:: QueryBuilderException

Class LoadMetadataHelpers

Field Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

ServerVersionMSSQL7

ServerVersionMSSQL2000

ServerVersionMSSQL2005

ServerVersionMSSQL2008

ServerVersionMSSQL2012

ServerVersionMSSQL2014

ServerVersionMSSQLMin

ServerVersionMSSQLMax

ServerVersionMSSQLDefault

ServerVersionOracle7

ServerVersionOracle8

ServerVersionOracle9

ServerVersionOracle10

ServerVersionOracle11

ServerVersionOracleMin

ServerVersionOracleMax

ServerVersionOracleDefault

ServerVersionInformixDS8

ServerVersionInformixDS9

ServerVersionInformixDS10

ServerVersionInformixDS11

ServerVersionInformixMin

ServerVersionInformixMax

ServerVersionInformixDefault

Method Detail

isConnectedServerIsSQL92

loadMetadataObjectsSQL92

loadMetadataRelationsSQL92

getDefaultDatabaseNameSQL92

isConnectedServerIsMSSQL

calcServerVersionMSSQL

getDefaultDatabaseNameMSSQL

getDefaultSchemaNamesMSSQL

getDatabaseListMSSQL

loadMetadataObjectsMSSQL

getSchemaListMSSQL

loadMetadataRelationsMSSQL

isConnectedServerIsMSSQLCE

loadMetadataObjectsMSSQLCE

loadMetadataRelationsMSSQLCE

isConnectedServerIsMySQL

parseServerVersionMySQL

calcServerVersionMySQL

getDefaultDatabaseNameMySQL

getDatabaseListMySQL

loadMetadataObjectsMySQL

loadMetadataRelationsMySQL

isConnectedServerIsOracle

getDefaultSchemaNamesOracle

getSchemaListOracle

loadMetadataObjectsOracle

loadMetadataRelationsOracle

calcServerVersionOracle

isConnectedServerIsMSAccess

isConnectedServerIsPostgreSQL

getDefaultDatabaseNamePostgreSQL

getDefaultSchemaNamesPostgreSQL

loadMetadataObjectsPostgreSQL

loadMetadataRelationsPostgreSQL

getSchemaListPostgreSQL

isConnectedServerIsFirebird

loadMetadataObjectsFirebird

loadMetadataRelationsFirebird

isConnectedServerIsDB2

getDefaultDatabaseNameDB2

getDefaultSchemaNamesDB2

loadMetadataObjectsDB2

loadMetadataRelationsDB2

getSchemaListDB2

isConnectedServerIsSybase

isConnectedServerIsSybaseASA

isConnectedServerIsSybaseASE

getDefaultDatabaseNameSybase

getDefaultSchemaNamesSybase

getDatabaseListSybase