org.tribuo.data.sql

Class SQLDBConfig

java.lang.Object

org.tribuo.data.sql.SQLDBConfig

All Implemented Interfaces:

com.oracle.labs.mlrg.olcut.config.Configurable, com.oracle.labs.mlrg.olcut.provenance.Provenancable<com.oracle.labs.mlrg.olcut.provenance.ConfiguredObjectProvenance>

public class SQLDBConfig
extends Object
implements com.oracle.labs.mlrg.olcut.config.Configurable, com.oracle.labs.mlrg.olcut.provenance.Provenancable<com.oracle.labs.mlrg.olcut.provenance.ConfiguredObjectProvenance>

N.B. This class accepts raw SQL strings and executes them directly via JDBC. It DOES NOT perform any SQL escaping or other injection prevention. It is the user's responsibility to ensure that SQL passed to this class performs as desired. SQL database configuration. If you specify the host, port, and db strings and use oracle.jdbc.OracleDriver as your JDBC Driver, then this will automatically generate a connectionString, otherwise it must be specified manually and host, port, and db fields can be omitted. DriverManager's default logic will be used to determine which Driver to use for a given connection string.

Constructor Summary

Constructors

Constructor and Description
SQLDBConfig(String connectionString, Map<String,String> properties)
SQLDBConfig(String connectionString, String username, String password, Map<String,String> properties)
SQLDBConfig(String host, String port, String db, String username, String password, Map<String,String> properties)

Method Summary

Modifier and Type	Method and Description
Connection	getConnection() Constructs a connection based on the object fields.
com.oracle.labs.mlrg.olcut.provenance.ConfiguredObjectProvenance	getProvenance()
Statement	getStatement() Constructs a statement based on the object fields.
void	postConfig() Used by the OLCUT configuration system, and should not be called by external code.
String	toString()

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLDBConfig

public SQLDBConfig(String connectionString,
                   String username,
                   String password,
                   Map<String,String> properties)

SQLDBConfig

public SQLDBConfig(String host,
                   String port,
                   String db,
                   String username,
                   String password,
                   Map<String,String> properties)

SQLDBConfig

public SQLDBConfig(String connectionString,
                   Map<String,String> properties)

Method Detail

postConfig

public void postConfig()

Used by the OLCUT configuration system, and should not be called by external code.

Specified by:

postConfig in interface com.oracle.labs.mlrg.olcut.config.Configurable

getConnection

public Connection getConnection()
                         throws SQLException

Constructs a connection based on the object fields.

Returns:

A connection to the database.

Throws:

SQLException - If the connection failed.

getStatement

public Statement getStatement()
                       throws SQLException

Constructs a statement based on the object fields. Uses fetchSize to determine fetch size and sets defaults for querying data.

Returns:

A statement object for querying the database.

Throws:

SQLException - If the connection failed.

toString

public String toString()

Overrides:

toString in class Object

getProvenance

public com.oracle.labs.mlrg.olcut.provenance.ConfiguredObjectProvenance getProvenance()

Specified by:

getProvenance in interface com.oracle.labs.mlrg.olcut.provenance.Provenancable<com.oracle.labs.mlrg.olcut.provenance.ConfiguredObjectProvenance>