Package com.adbs.metadata
Class LoadMetadataHelpers
- java.lang.Object
-
- com.adbs.metadata.LoadMetadataHelpers
-
public class LoadMetadataHelpers extends java.lang.Object
-
-
Field Summary
Fields Modifier and Type Field 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
-
-
-
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
-
-