Here are some limitations of JDBC encountered during the implementations of Jaqy.
32-bit Row Position and Activity Count¶
There are a number of places where the use of 32-bit int that are very limited in today’s Big Data world.
Lacking Good Type Information¶
The only thing in JDBC that provides type information is DatabaseMetadata.getTypeInfo(). Yet it is not all that useful.
- There can be multiple types mapped to a single JDBC type without a way of
indicating the default one to use. For instance, in PostgreSQL, both
- For types such as VARCHAR(100) CHARACTER SET LATIN, there are basically no way to infer the type name based on the type information.
Poor Array and Struct Type Support¶
ResultSetMetaData and ParameterMetaData have only the basic type information, without any mechanism obtaining the element or attribute types. Needless to say, there is no way to obtain nested Array or Struct information.
There is also no way to obtain the Struct attributes.