org.relique.jdbc.csv

Class CsvDriver

java.lang.Object

org.relique.jdbc.csv.CsvDriver

All Implemented Interfaces:

Driver

public class CsvDriver
extends Object
implements Driver

This class implements the java.sql.Driver JDBC interface for the CsvJdbc driver.

Field Summary

Fields

Modifier and Type	Field and Description
static String	CHARSET
static String	COLUMN_TYPES
static String	COMMENT_CHAR
static String	CRYPTO_FILTER_CLASS_NAME
static String	DATE_FORMAT
static String	DEFAULT_COLUMN_TYPES
static String	DEFAULT_COMMENT_CHAR
static String	DEFAULT_DATE_FORMAT
static String	DEFAULT_DEFECTIVE_HEADERS
static String	DEFAULT_EXTENSION
static String	DEFAULT_FILE_TAIL_PREPEND
static String	DEFAULT_HEADERLINE
static String	DEFAULT_IGNORE_UNPARSEABLE_LINES
static boolean	DEFAULT_INDEXED_FILES
static boolean	DEFAULT_IS_HEADER_FIXED_WIDTH
static String	DEFAULT_MISSING_VALUE
static String	DEFAULT_QUOTE_STYLE
static char	DEFAULT_QUOTECHAR
static String	DEFAULT_SEPARATOR
static String	DEFAULT_SKIP_LEADING_DATA_LINES
static String	DEFAULT_SKIP_LEADING_LINES
static boolean	DEFAULT_SUPPRESS
static String	DEFAULT_TIME_FORMAT
static String	DEFAULT_TIME_ZONE_NAME
static String	DEFAULT_TIMESTAMP_FORMAT
static boolean	DEFAULT_TRIM_HEADERS
static boolean	DEFAULT_TRIM_VALUES
static String	DEFECTIVE_HEADERS
static String	FILE_EXTENSION
static String	FILE_TAIL_PREPEND
static String	FIXED_WIDTHS
static String	FUNCTION
static String	HEADERLINE
static String	IGNORE_UNPARSEABLE_LINES
static String	INDEXED_FILES
static String	IS_HEADER_FIXED_WIDTH
static String	LOCALE
static String	MISSING_VALUE
static String	QUOTE_STYLE
static String	QUOTECHAR
static String	READER_CLASS_PREFIX
static String	SEPARATOR
static String	SKIP_LEADING_DATA_LINES
static String	SKIP_LEADING_LINES
static String	SUPPRESS_HEADERS
static String	TIME_FORMAT
static String	TIME_ZONE_NAME
static String	TIMESTAMP_FORMAT
static String	TRANSPOSED_FIELDS_TO_SKIP
static String	TRANSPOSED_LINES
static String	TRIM_HEADERS
static String	TRIM_VALUES
static String	URL_PREFIX
static String	ZIP_FILE_PREFIX

Constructor Summary

Constructors

Constructor and Description
CsvDriver()

Method Summary

Modifier and Type	Method and Description
boolean	acceptsURL(String url)
Connection	connect(String url, Properties info)
int	getMajorVersion()
int	getMinorVersion()
Logger	getParentLogger()
DriverPropertyInfo[]	getPropertyInfo(String url, Properties info)
boolean	jdbcCompliant()
static void	writeLog(String message)
static void	writeToCsv(ResultSet resultSet, PrintStream out, boolean writeHeaderLine) Convenience method to write a ResultSet to a CSV file.

Methods inherited from class java.lang.Object

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

Field Detail

DEFAULT_EXTENSION

public static final String DEFAULT_EXTENSION

See Also:

Constant Field Values

DEFAULT_SEPARATOR

public static final String DEFAULT_SEPARATOR

See Also:

Constant Field Values

DEFAULT_QUOTECHAR

public static final char DEFAULT_QUOTECHAR

See Also:

Constant Field Values

DEFAULT_HEADERLINE

public static final String DEFAULT_HEADERLINE

DEFAULT_SUPPRESS

public static final boolean DEFAULT_SUPPRESS

See Also:

Constant Field Values

DEFAULT_IS_HEADER_FIXED_WIDTH

public static final boolean DEFAULT_IS_HEADER_FIXED_WIDTH

See Also:

Constant Field Values

DEFAULT_TRIM_HEADERS

public static final boolean DEFAULT_TRIM_HEADERS

See Also:

Constant Field Values

DEFAULT_TRIM_VALUES

public static final boolean DEFAULT_TRIM_VALUES

See Also:

Constant Field Values

DEFAULT_COLUMN_TYPES

public static final String DEFAULT_COLUMN_TYPES

See Also:

Constant Field Values

DEFAULT_INDEXED_FILES

public static final boolean DEFAULT_INDEXED_FILES

See Also:

Constant Field Values

DEFAULT_TIMESTAMP_FORMAT

public static final String DEFAULT_TIMESTAMP_FORMAT

DEFAULT_DATE_FORMAT

public static final String DEFAULT_DATE_FORMAT

See Also:

Constant Field Values

DEFAULT_TIME_FORMAT

public static final String DEFAULT_TIME_FORMAT

See Also:

Constant Field Values

DEFAULT_COMMENT_CHAR

public static final String DEFAULT_COMMENT_CHAR

DEFAULT_SKIP_LEADING_LINES

public static final String DEFAULT_SKIP_LEADING_LINES

DEFAULT_IGNORE_UNPARSEABLE_LINES

public static final String DEFAULT_IGNORE_UNPARSEABLE_LINES

See Also:

Constant Field Values

DEFAULT_MISSING_VALUE

public static final String DEFAULT_MISSING_VALUE

DEFAULT_FILE_TAIL_PREPEND

public static final String DEFAULT_FILE_TAIL_PREPEND

See Also:

Constant Field Values

DEFAULT_DEFECTIVE_HEADERS

public static final String DEFAULT_DEFECTIVE_HEADERS

See Also:

Constant Field Values

DEFAULT_SKIP_LEADING_DATA_LINES

public static final String DEFAULT_SKIP_LEADING_DATA_LINES

See Also:

Constant Field Values

FILE_EXTENSION

public static final String FILE_EXTENSION

See Also:

Constant Field Values

SEPARATOR

public static final String SEPARATOR

See Also:

Constant Field Values

QUOTECHAR

public static final String QUOTECHAR

See Also:

Constant Field Values

HEADERLINE

public static final String HEADERLINE

See Also:

Constant Field Values

SUPPRESS_HEADERS

public static final String SUPPRESS_HEADERS

See Also:

Constant Field Values

IS_HEADER_FIXED_WIDTH

public static final String IS_HEADER_FIXED_WIDTH

See Also:

Constant Field Values

TRIM_HEADERS

public static final String TRIM_HEADERS

See Also:

Constant Field Values

TRIM_VALUES

public static final String TRIM_VALUES

See Also:

Constant Field Values

COLUMN_TYPES

public static final String COLUMN_TYPES

See Also:

Constant Field Values

INDEXED_FILES

public static final String INDEXED_FILES

See Also:

Constant Field Values

TIMESTAMP_FORMAT

public static final String TIMESTAMP_FORMAT

See Also:

Constant Field Values

DATE_FORMAT

public static final String DATE_FORMAT

See Also:

Constant Field Values

TIME_FORMAT

public static final String TIME_FORMAT

See Also:

Constant Field Values

LOCALE

public static final String LOCALE

See Also:

Constant Field Values

COMMENT_CHAR

public static final String COMMENT_CHAR

See Also:

Constant Field Values

SKIP_LEADING_LINES

public static final String SKIP_LEADING_LINES

See Also:

Constant Field Values

IGNORE_UNPARSEABLE_LINES

public static final String IGNORE_UNPARSEABLE_LINES

See Also:

Constant Field Values

MISSING_VALUE

public static final String MISSING_VALUE

See Also:

Constant Field Values

FILE_TAIL_PREPEND

public static final String FILE_TAIL_PREPEND

See Also:

Constant Field Values

DEFECTIVE_HEADERS

public static final String DEFECTIVE_HEADERS

See Also:

Constant Field Values

SKIP_LEADING_DATA_LINES

public static final String SKIP_LEADING_DATA_LINES

See Also:

Constant Field Values

TRANSPOSED_LINES

public static final String TRANSPOSED_LINES

See Also:

Constant Field Values

TRANSPOSED_FIELDS_TO_SKIP

public static final String TRANSPOSED_FIELDS_TO_SKIP

See Also:

Constant Field Values

CHARSET

public static final String CHARSET

See Also:

Constant Field Values

URL_PREFIX

public static final String URL_PREFIX

See Also:

Constant Field Values

CRYPTO_FILTER_CLASS_NAME

public static final String CRYPTO_FILTER_CLASS_NAME

See Also:

Constant Field Values

TIME_ZONE_NAME

public static final String TIME_ZONE_NAME

See Also:

Constant Field Values

DEFAULT_TIME_ZONE_NAME

public static final String DEFAULT_TIME_ZONE_NAME

See Also:

Constant Field Values

QUOTE_STYLE

public static final String QUOTE_STYLE

See Also:

Constant Field Values

DEFAULT_QUOTE_STYLE

public static final String DEFAULT_QUOTE_STYLE

See Also:

Constant Field Values

READER_CLASS_PREFIX

public static final String READER_CLASS_PREFIX

See Also:

Constant Field Values

ZIP_FILE_PREFIX

public static final String ZIP_FILE_PREFIX

See Also:

Constant Field Values

FIXED_WIDTHS

public static final String FIXED_WIDTHS

See Also:

Constant Field Values

FUNCTION

public static final String FUNCTION

See Also:

Constant Field Values

Constructor Detail

CsvDriver

public CsvDriver()

Method Detail

getPropertyInfo

public DriverPropertyInfo[] getPropertyInfo(String url,
                                            Properties info)
                                     throws SQLException

Specified by:

getPropertyInfo in interface Driver

Throws:

SQLException

getMajorVersion

public int getMajorVersion()

Specified by:

getMajorVersion in interface Driver

getMinorVersion

public int getMinorVersion()

Specified by:

getMinorVersion in interface Driver

connect

public Connection connect(String url,
                          Properties info)
                   throws SQLException

Specified by:

connect in interface Driver

Throws:

SQLException

acceptsURL

public boolean acceptsURL(String url)
                   throws SQLException

Specified by:

acceptsURL in interface Driver

Throws:

SQLException

jdbcCompliant

public boolean jdbcCompliant()

Specified by:

jdbcCompliant in interface Driver

getParentLogger

public Logger getParentLogger()
                       throws SQLFeatureNotSupportedException

Specified by:

getParentLogger in interface Driver

Throws:

SQLFeatureNotSupportedException

writeLog

public static void writeLog(String message)

writeToCsv

public static void writeToCsv(ResultSet resultSet,
                              PrintStream out,
                              boolean writeHeaderLine)
                       throws SQLException

Convenience method to write a ResultSet to a CSV file. Output CSV file has the same format as the CSV file that is being queried, so that it can be used for later SQL queries.

Parameters:

resultSet - JDBC ResultSet to write.

out - open stream to write to.

writeHeaderLine - if true, the column names are written as first line.

Throws:

SQLException - if writing to CSV file fails.