code: 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;
  	}
docs: Get the SQLite type from the ResultSetMetaData column type
  
  @param columnType
  column type
  @return SQLite type