org.restsql.core.impl.mysql

Class MySqlColumnMetaData

java.lang.Object

org.restsql.core.impl.ColumnMetaDataImpl

org.restsql.core.impl.mysql.MySqlColumnMetaData

All Implemented Interfaces:

Comparable<ColumnMetaData>, ColumnMetaData

public class MySqlColumnMetaData
extends ColumnMetaDataImpl

MySQL specific implementation.

Author:

Mark Sawers

Constructor Summary

Constructors

Constructor and Description
MySqlColumnMetaData()

Method Summary

Methods

Modifier and Type	Method and Description
int	getColumnType(int columnType, String columnTypeName) Compensates for the MySQL JDBC driver which returns Date object for YEAR type.
Object	getResultByLabel(ResultSet resultSet) Compensates for the MySQL JDBC driver which returns Date object for YEAR type.
Object	getResultByNumber(ResultSet resultSet) Compensates for the MySQL JDBC driver which returns Date object for YEAR type.

Methods inherited from class org.restsql.core.impl.ColumnMetaDataImpl

compareTo, getColumnLabel, getColumnName, getColumnNumber, getColumnType, getColumnTypeName, getDatabaseName, getQualifiedColumnLabel, getQualifiedColumnName, getQualifiedTableName, getSequenceName, getTableName, getTableRole, isBinaryType, isCharOrDateTimeType, isNonqueriedForeignKey, isPrimaryKey, isReadOnly, isSequence, normalizeValue, setAttributes, setAttributes, setPrimaryKey, setSequence, setSequenceName, setTableRole

Methods inherited from class java.lang.Object

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

Constructor Detail

MySqlColumnMetaData

public MySqlColumnMetaData()

Method Detail

getColumnType

public int getColumnType(int columnType,
                String columnTypeName)

Compensates for the MySQL JDBC driver which returns Date object for YEAR type. Instead forces it to an INTEGER type. The documented Connection property to change this behavior does not work.

Overrides:

getColumnType in class ColumnMetaDataImpl

Returns:

one of the constants in {java.sql.Types}

See Also:

Types

getResultByLabel

public Object getResultByLabel(ResultSet resultSet)
                        throws SQLException

Compensates for the MySQL JDBC driver which returns Date object for YEAR type. Instead get the value as in int and create an Integer. The documented Connection property to change this behavior does not work.

Specified by:

getResultByLabel in interface ColumnMetaData

Overrides:

getResultByLabel in class ColumnMetaDataImpl

Throws:

SQLException

getResultByNumber

public Object getResultByNumber(ResultSet resultSet)
                         throws SQLException

Compensates for the MySQL JDBC driver which returns Date object for YEAR type. Instead get the value as in int and create an Integer. The documented Connection property to change this behavior does not work.

Specified by:

getResultByNumber in interface ColumnMetaData

Overrides:

getResultByNumber in class ColumnMetaDataImpl

Throws:

SQLException