public class JDBCCellReader extends java.lang.Object implements CellReader
Constructor and Description |
---|
JDBCCellReader(java.lang.String jdbcUrl,
java.util.Properties jdbcProperties,
java.lang.String query)
Create a new JDBC cell reader by connecting to a database and performing a query.
|
JDBCCellReader(java.lang.String jdbcUrl,
java.util.Properties jdbcProperties,
java.lang.String query,
java.lang.Integer fetchSize,
boolean debug)
Create a new JDBC cell reader by connecting to a database and performing a query.
|
Modifier and Type | Method and Description |
---|---|
void |
close()
Complete the transfer.
|
java.lang.String[] |
getHeaderRow()
Return the header row.
|
java.lang.String[] |
readDataRow()
Read and return the next row of data.
|
public JDBCCellReader(java.lang.String jdbcUrl, java.util.Properties jdbcProperties, java.lang.String query) throws java.sql.SQLException
jdbcUrl
- The JDBC URL of the database to connect tojdbcProperties
- The properties to use for the connectionquery
- The query to performjava.sql.SQLException
public JDBCCellReader(java.lang.String jdbcUrl, java.util.Properties jdbcProperties, java.lang.String query, java.lang.Integer fetchSize, boolean debug) throws java.sql.SQLException
jdbcUrl
- The JDBC URL of the database to connect tojdbcProperties
- The properties to use for the connectionquery
- The query to performfetchSize
- Hint to JDBC driver to fetch resultsdebug
- Report to Java logging any non-fatal errors produced by JDBC driverjava.sql.SQLException
public java.lang.String[] getHeaderRow()
getHeaderRow
in interface CellReader
public java.lang.String[] readDataRow() throws AnaplanAPIException
readDataRow
in interface CellReader
AnaplanAPIException
public void close()
close
in interface CellReader