Package uk.ac.starlink.table.jdbc
Class TypeMappers
java.lang.Object
uk.ac.starlink.table.jdbc.TypeMappers
TypeMapper implementation classes.
- Since:
- 2 Feb 2010
- Author:
- Mark Taylor
-
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final TypeMapper
TypeMapper implementation likeSTANDARD
, but which uses a 'T' character as the separator between the date and time parts of timestamp serializations.static final TypeMapper
TypeMapper implementation which performs no conversions.static final TypeMapper
TypeMapper implementation which performs generally useful conversions. -
Method Summary
Modifier and TypeMethodDescriptionstatic <T> ValueHandler
createArrayValueHandler
(ResultSetMetaData meta, int jcol1, Class<T> arrayClazz) Constructs a new ValueHandler which converts JDBC Array values to java array objects of a specific type.static ValueHandler
createIdentityValueHandler
(ResultSetMetaData meta, int jcol1) Constructs a new ValueHandler which performs no conversions.static ValueHandler
createStringValueHandler
(ResultSetMetaData meta, int jcol1) Constructs a new ValueHandler which converts values to Strings.static ValueHandler
createTimestampValueHandler
(ResultSetMetaData meta, int jcol1, char dateTimeSeparator) Constructs a new ValueHandler which converts JDBC Timestamp values to Strings, with a configurable date/time separator character.static Class
<?> getArrayClass
(ResultSetMetaData meta, int jcol1) Tries to guess a suitable output value type for an array-valued column in a ResultSet.
-
Field Details
-
STANDARD
TypeMapper implementation which performs generally useful conversions. In particular,Date
subclasses (includingjava.sql.Date
,java.sql.Time
andjava.sql.Timestamp
are turned into Strings, using JDBC timestamp escape format (which is ISO-8601 with a space character separating date and time). The intention is that by using this implementation you will get an output table which can be written using non-specialist output formats such as FITS and VOTable. -
DALI
TypeMapper implementation likeSTANDARD
, but which uses a 'T' character as the separator between the date and time parts of timestamp serializations. Use of the 'T' separator is mandated by the Data Access Layer Interface standard v1.0, section 3.1.2 (http://www.ivoa.net/documents/DALI/), and so is appropriate for output from VO services such as TAP. -
IDENTITY
TypeMapper implementation which performs no conversions. The output types are just as JDBC provides them.
-
-
Method Details
-
createIdentityValueHandler
public static ValueHandler createIdentityValueHandler(ResultSetMetaData meta, int jcol1) throws SQLException Constructs a new ValueHandler which performs no conversions.- Parameters:
meta
- JDBC metadata objectjcol1
- JDBC column index (first column is 1)- Throws:
SQLException
-
createStringValueHandler
public static ValueHandler createStringValueHandler(ResultSetMetaData meta, int jcol1) throws SQLException Constructs a new ValueHandler which converts values to Strings.- Parameters:
meta
- JDBC metadata objectjcol1
- JDBC column index (first column is 1)- Throws:
SQLException
-
createTimestampValueHandler
public static ValueHandler createTimestampValueHandler(ResultSetMetaData meta, int jcol1, char dateTimeSeparator) throws SQLException Constructs a new ValueHandler which converts JDBC Timestamp values to Strings, with a configurable date/time separator character. The input values are assumed to be of typeTimestamp
.- Parameters:
meta
- JDBC metadata objectjcol1
- JDBC column index (first column is 1)dateTimeSeparator
- separator character between date and time parts of ISO-8601 string; usually either ' ' or 'T'- Throws:
SQLException
-
createArrayValueHandler
public static <T> ValueHandler createArrayValueHandler(ResultSetMetaData meta, int jcol1, Class<T> arrayClazz) throws SQLException Constructs a new ValueHandler which converts JDBC Array values to java array objects of a specific type. This is suitable whenResultSetMetaData.getColumnClassName(int)
returns "java.sql.Array
".The required output class
arrayClazz
must be specified explicitly. If this class not a good match for the payload of theArray
values, value conversion won't work very well. The methodgetArrayClass
can be used to guess a good value for this parameter.- Parameters:
meta
- JDBC metadata objectjcol1
- JDBC column index (first column is 1)arrayClazz
- required output type- Throws:
SQLException
-
getArrayClass
Tries to guess a suitable output value type for an array-valued column in a ResultSet. The returned type will be STIL-friendly, that is a String[] or primitive type array. If the type is not recognised, null is returned.- Parameters:
meta
- JDBC metadata objectjcol1
- JDBC column index (first column is 1)- Returns:
- best-efforts guess at output array type, or null
-