|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.knime.core.node.port.database.DatabaseReaderConnection
public final class DatabaseReaderConnection
Creates a connection to read from database.
Constructor Summary | |
---|---|
DatabaseReaderConnection(DatabaseQueryConnectionSettings conn)
Creates a empty handle for a new connection. |
Method Summary | |
---|---|
BufferedDataTable |
createTable(ExecutionContext exec)
Read data from database. |
(package private) DataTable |
createTable(int cachedNoRows)
|
DataTableSpec |
getDataTableSpec()
Returns a data table spec that reflects the meta data form the database result set. |
DatabaseQueryConnectionSettings |
getQueryConnection()
|
void |
setDBQueryConnection(DatabaseQueryConnectionSettings conn)
Sets anew connection object. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public DatabaseReaderConnection(DatabaseQueryConnectionSettings conn)
conn
- a database connection objectMethod Detail |
---|
public void setDBQueryConnection(DatabaseQueryConnectionSettings conn)
conn
- the connectionpublic DatabaseQueryConnectionSettings getQueryConnection()
public DataTableSpec getDataTableSpec() throws SQLException
SQLException
- if the connection to the database could not be
establishedpublic BufferedDataTable createTable(ExecutionContext exec) throws CanceledExecutionException, SQLException
exec
- used for progress info
CanceledExecutionException
- if canceled in between
SQLException
- if the connection could not be openedDataTable createTable(int cachedNoRows) throws SQLException
cachedNoRows
- number of rows cached for data preview
SQLException
- if the connection could not be opened
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |