org.knime.core.node.port.database
Class DatabaseWriterConnection

java.lang.Object
  org.knime.core.node.port.database.DatabaseWriterConnection

public final class DatabaseWriterConnection
extends Object

Creates a connection to write to database.

Author:

Thomas Gabriel, University of Konstanz

Method Summary

static String

writeData(DatabaseConnectionSettings dbConn, String table, BufferedDataTable data, boolean appendData, ExecutionMonitor exec, Map<String,String> sqlTypes, CredentialsProvider cp) Create connection to write into database.

Methods inherited from class java.lang.Object

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

Method Detail

writeData

public static final String writeData(DatabaseConnectionSettings dbConn,
                                     String table,
                                     BufferedDataTable data,
                                     boolean appendData,
                                     ExecutionMonitor exec,
                                     Map<String,String> sqlTypes,
                                     CredentialsProvider cp)
                              throws Exception

Create connection to write into database.

Parameters:

dbConn - a database connection object

data - The data to write.

table - name of table to write

appendData - if checked the data is appended to an existing table

exec - Used the cancel writing.

sqlTypes - A mapping from column name to SQL-type.

cp - CredentialsProvider providing user/password

Returns:

error string or null, if non

Throws:

Exception - if connection could not be established