Class ConnectionManager
java.lang.Object
com.dandymadeproductions.ajqvue.datasource.ConnectionManager
The ConnectionManager class provides a central class to manage all
connections that are used by the Ajqvue application to access the
various databases support.
-
Field Summary
Fields -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic voidcloseConnection(Connection dbConnection, String description) static StringcreateConnectionURLString(ConnectionProperties properties) static voiddisplaySQLErrors(SQLException e, String classCaller) static StringfindDatabaseDriverJAR(String subProtocol, String driver) static Stringstatic CachedRowSetstatic Stringstatic ConnectiongetConnection(String description) static ConnectionPropertiesstatic Stringstatic Stringstatic FilteredRowSetstatic Stringstatic intstatic WebRowSetstatic voidloadDBTables(Connection dbConnection) static voidsetConnectionProperties(ConnectionProperties properties) static voidsetDabaseDriver(Driver driver) static voidsetDatabaseProperties(DatabaseProperties properties) static voidsetMemoryConnection(Connection connection) static voidsetSchemaPattern(String pattern) static void
-
Field Details
-
MYSQL
- See Also:
-
MARIADB
- See Also:
-
POSTGRESQL
- See Also:
-
HSQL
- See Also:
-
HSQL2
- See Also:
-
ORACLE
- See Also:
-
SQLITE
- See Also:
-
MSACCESS
- See Also:
-
MSSQL
- See Also:
-
DERBY
- See Also:
-
H2
- See Also:
-
OTHERDB
- See Also:
-
-
Constructor Details
-
ConnectionManager
public ConnectionManager()
-
-
Method Details
-
getConnection
-
closeConnection
-
shutdown
-
displaySQLErrors
-
createConnectionURLString
-
findDatabaseDriverJAR
-
loadDBTables
- Throws:
SQLException
-
getCatalogSeparator
-
getConnectionProperties
-
getDataSourceType
-
getDBProductName_And_Version
-
getIdentifierQuoteString
-
getMaxColumnNameLength
public static int getMaxColumnNameLength() -
getSchemas
-
getAllSchemasPattern
-
getTableNames
-
getCachedRowSet
- Throws:
SQLException
-
getFilteredRowSet
- Throws:
SQLException
-
getWebRowSet
- Throws:
SQLException
-
setConnectionProperties
-
setDabaseDriver
-
setDatabaseProperties
-
setMemoryConnection
-
setSchemaPattern
-