public static int resultSetTypeToSqlLite ( int columnType ) { int type ; switch ( columnType ) { case Types . INTEGER : case Types . BIGINT : case Types . SMALLINT : case Types . TINYINT : case Types . BOOLEAN : type = ResultUtils . FIELD_TYPE_INTEGER ; break ; case Types . VARCHAR : case Types . DATE : type = ResultUtils . FIELD_TYPE_STRING ; break ; case Types . REAL : case Types . FLOAT : case Types . DOUBLE : type = ResultUtils . FIELD_TYPE_FLOAT ; break ; case Types . BLOB : type = ResultUtils . FIELD_TYPE_BLOB ; break ; case Types . NULL : type = ResultUtils . FIELD_TYPE_NULL ; break ; default : throw new GeoPackageException ( "Unsupported ResultSet Metadata Column Type: " + columnType ) ; } return type ; }
Get the SQLite type from the ResultSetMetaData column type