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 and Description
static class	DatabaseMetaDataReader.Builder

Constructor Summary

Constructors

Constructor and Description
DatabaseMetaDataReader(String url, Properties properties)

Method Summary

Modifier and Type	Method and 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 Detail

DatabaseMetaDataReader

public DatabaseMetaDataReader(String url,
                              Properties properties)
                       throws SQLException

Throws:

SQLException

Method Detail

builder

public static DatabaseMetaDataReader.Builder builder(String url)

close

public void close()
           throws IOException

Specified by:

close in interface Closeable

Specified by:

close in interface AutoCloseable

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