Package de.julianweinelt.datacat.dbx.database.providers.db

Class DBMSSQL

java.lang.Object

de.julianweinelt.datacat.dbx.database.ADatabase

de.julianweinelt.datacat.dbx.database.providers.db.DBMSSQL

public class DBMSSQL
extends ADatabase

Nested Class Summary

Nested classes/interfaces inherited from class de.julianweinelt.datacat.dbx.database.ADatabase

ADatabase.ParameterBuilder, ADatabase.SchemaInfo, ADatabase.TableInfo

Field Summary

Fields inherited from class de.julianweinelt.datacat.dbx.database.ADatabase

conn

Constructor Summary

Constructors

Constructor	Description
DBMSSQL(String host, int port, String username, String password)

Method Summary

Modifier and Type	Method	Description
String	getDatabaseProductName()
String	getDatabaseProductVersion()
List<String>	getDatabases()	Get all database schemas on this database server.
ADatabase.SchemaInfo	getSchemaInfo(String database)
ResultSet	getTableData(String database, String table)
List<String>	getTables(String database)
String	internalName()
void	setStreaming(boolean streaming)	Set the database connecting to streaming mode.

Methods inherited from class de.julianweinelt.datacat.dbx.database.ADatabase

commit, connect, connect, createDatabaseIfNotExists, disconnect, extractTableMeta, of, prepareStatement, rollback, useDatabase

Methods inherited from class java.lang.Object

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

Constructor Details

DBMSSQL

public DBMSSQL(String host,
 int port,
 String username,
 String password)

Method Details

internalName

public String internalName()

Specified by:

internalName in class ADatabase

setStreaming

public void setStreaming(boolean streaming)

Description copied from class: ADatabase

Set the database connecting to streaming mode.

Specified by:

setStreaming in class ADatabase

Parameters:

streaming - streaming mode

getDatabases

public List<String> getDatabases()

Description copied from class: ADatabase

Get all database schemas on this database server.

Specified by:

getDatabases in class ADatabase

Returns:

A List of String objects with the names of the database schemas

getTables

public List<String> getTables(String database)

Specified by:

getTables in class ADatabase

getTableData

public ResultSet getTableData(String database,
 String table)
                       throws SQLException

Specified by:

getTableData in class ADatabase

Throws:

SQLException

getSchemaInfo

public ADatabase.SchemaInfo getSchemaInfo(String database)

Specified by:

getSchemaInfo in class ADatabase

getDatabaseProductName

public String getDatabaseProductName()

Specified by:

getDatabaseProductName in class ADatabase

getDatabaseProductVersion

public String getDatabaseProductVersion()

Specified by:

getDatabaseProductVersion in class ADatabase