com.northconcepts.datapipeline.transform.lookup

Class JdbcLookup

java.lang.Object

com.northconcepts.datapipeline.transform.lookup.Lookup

com.northconcepts.datapipeline.transform.lookup.JdbcLookup

public class JdbcLookup
extends Lookup

Constructor Summary

Constructors

Constructor and Description
JdbcLookup(Connection connection, String query) Creates a new instance with the autoCloseConnection property set to false.
JdbcLookup(Connection connection, String query, int... jdbcTypes) Creates a new instance with the autoCloseConnection property set to false.
JdbcLookup(JdbcConnectionFactory factory, String query) Creates a new instance with the autoCloseConnection property set to true.
JdbcLookup(JdbcConnectionFactory factory, String query, int... jdbcTypes) Creates a new instance with the autoCloseConnection property set to true.

Method Summary

Modifier and Type	Method and Description
protected void	close()
RecordList	get(Object... args)
boolean	isAutoCloseConnection() Indicates if the database connection in this lookup should be closed when the lookup is closed by the LookupTransformer via a TransformingReader or TransformingWriter.
JdbcLookup	setAutoCloseConnection(boolean autoCloseConnection) Indicates if the database connection in this lookup should be closed when the lookup is closed by the LookupTransformer via a TransformingReader or TransformingWriter.
String	toString()

Methods inherited from class com.northconcepts.datapipeline.transform.lookup.Lookup

get, open

Methods inherited from class java.lang.Object

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

Constructor Detail

JdbcLookup

public JdbcLookup(Connection connection,
                  String query,
                  int... jdbcTypes)

Creates a new instance with the autoCloseConnection property set to false.

Parameters:

connection -

query -

jdbcTypes - jdbcTypes tells the JDBC driver the SQL type of data to expect for any query params that are specified as question marks and sent with statement.setObject(...); or statement.setNull(...), otherwise, the driver will have to guess. For example java.util.Date can be DATE, TIME, TIMESTAMP, DATETIME, etc., on the SQL side.

JdbcLookup

public JdbcLookup(Connection connection,
                  String query)

Creates a new instance with the autoCloseConnection property set to false.

Parameters:

connection -

query -

JdbcLookup

public JdbcLookup(JdbcConnectionFactory factory,
                  String query,
                  int... jdbcTypes)

Creates a new instance with the autoCloseConnection property set to true.

Parameters:

factory -

query -

jdbcTypes - jdbcTypes tells the JDBC driver the SQL type of data to expect for any query params that are specified as question marks and sent with statement.setObject(...); or statement.setNull(...), otherwise, the driver will have to guess. For example java.util.Date can be DATE, TIME, TIMESTAMP, DATETIME, etc., on the SQL side.

JdbcLookup

public JdbcLookup(JdbcConnectionFactory factory,
                  String query)

Creates a new instance with the autoCloseConnection property set to true.

Parameters:

factory -

query -

Method Detail

get

public RecordList get(Object... args)

Specified by:

get in class Lookup

isAutoCloseConnection

public boolean isAutoCloseConnection()

Indicates if the database connection in this lookup should be closed when the lookup is closed by the LookupTransformer via a TransformingReader or TransformingWriter. The default is false if this instance was constructed with a Connection or true if constructed with a JdbcConnectionFactory.

setAutoCloseConnection

public JdbcLookup setAutoCloseConnection(boolean autoCloseConnection)

Indicates if the database connection in this lookup should be closed when the lookup is closed by the LookupTransformer via a TransformingReader or TransformingWriter. The default is false if this instance was constructed with a Connection or true if constructed with a JdbcConnectionFactory.

toString

public String toString()

Overrides:

toString in class Object

close

protected void close()

Overrides:

close in class Lookup