Package com.gigaspaces.utils.jdbc

Class DatabaseMetaDataReader

java.lang.Object

com.gigaspaces.utils.jdbc.DatabaseMetaDataReader

All Implemented Interfaces:

Closeable, AutoCloseable

public class DatabaseMetaDataReader
extends Object
implements Closeable

API for reading metadata from a database using JDBC.

Since:

15.2.0

Author:

Niv Ingberg

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	DatabaseMetaDataReader.Builder

Constructor Summary

Constructors

Constructor	Description
DatabaseMetaDataReader(String url, Properties properties)

Method Summary

Modifier and Type	Method	Description
static DatabaseMetaDataReader.Builder	builder(String url)
void	close()
Connection	getConnection()
List<ColumnInfo>	getTableColumns(TableId table, Map<String,String> sampleDataMap)
List<IndexInfo>	getTableIndexes(TableId table, List<String> tablePrimaryKey)
TableInfo	getTableInfo(TableId table)
List<String>	getTablePrimaryKey(TableId table)
List<TableInfo>	getTables()
List<TableInfo>	getTables(TableQuery query)
List<TableId>	getTablesIds()
List<TableId>	getTablesIds(TableQuery query)
List<String>	getTableTypes()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

DatabaseMetaDataReader

public DatabaseMetaDataReader(String url,
 Properties properties)
                       throws SQLException

Throws:

SQLException

Method Details

builder

public static DatabaseMetaDataReader.Builder builder(String url)

close

public void close()
           throws IOException

Specified by:

close in interface AutoCloseable

Specified by:

close in interface Closeable

Throws:

IOException

getConnection

public Connection getConnection()

getTables

public List<TableInfo> getTables()
                          throws SQLException

Throws:

SQLException

getTables

public List<TableInfo> getTables(TableQuery query)
                          throws SQLException

Throws:

SQLException

getTablesIds

public List<TableId> getTablesIds()
                           throws SQLException

Throws:

SQLException

getTablesIds

public List<TableId> getTablesIds(TableQuery query)
                           throws SQLException

Throws:

SQLException

getTableTypes

public List<String> getTableTypes()
                           throws SQLException

Throws:

SQLException

getTableInfo

public TableInfo getTableInfo(TableId table)

getTableColumns

public List<ColumnInfo> getTableColumns(TableId table,
 Map<String,String> sampleDataMap)
                                 throws SQLException

Throws:

SQLException

getTablePrimaryKey

public List<String> getTablePrimaryKey(TableId table)
                                throws SQLException

Throws:

SQLException

getTableIndexes

public List<IndexInfo> getTableIndexes(TableId table,
 List<String> tablePrimaryKey)
                                throws SQLException

Throws:

SQLException