Package tech.tablesaw.io.jdbc

Class SqlResultSetReader

java.lang.Object

tech.tablesaw.io.jdbc.SqlResultSetReader

public class SqlResultSetReader
extends Object

Creates a Relation from the result of a SQL query, by passing the jdbc resultset to the constructor

Constructor Summary

Constructors

Constructor	Description
SqlResultSetReader()

Method Summary

Modifier and Type	Method	Description
static void	mapJdbcTypeToColumnType(Integer jdbc, ColumnType columnType)	Change or add a mapping between the given Jdbc type and column type.
static Table	read(ResultSet resultSet, String tableName)	Returns a new table with the given tableName, constructed from the given result set

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlResultSetReader

public SqlResultSetReader()

Method Detail

mapJdbcTypeToColumnType

public static void mapJdbcTypeToColumnType(Integer jdbc,
                                           ColumnType columnType)

Change or add a mapping between the given Jdbc type and column type. When reading from a database, the db column type is automatically assigned to the associated tablesaw column type

Parameters:

jdbc - an int representing a legal value from java.sql.types;

columnType - a tablesaw column type

read

public static Table read(ResultSet resultSet,
                         String tableName)
                  throws SQLException

Returns a new table with the given tableName, constructed from the given result set

Throws:

SQLException - if there is a problem detected in the database