Solved SQLibrary error TYPE_FORWARD_ONLY

For anybody that has experience using SQLibrary, or that can still help.

I've been unable to use result.last() because the ResultSet is apparently "TYPE_FORWARD_ONLY". I've seen on other threads for fixing this (not specifically for SQLibrary) that this can be stopped by using a "Statement" to run the query, along with ResultSet.TYPE_SCROLL_INSENSITIVE, but I've yet to find a way to use a Statement with the plugin. My code so far that's breaking:

Code:java

public void checkForPlayer(String player, long playTime) {
try {
plugin.getLogger().info("checkForPlayer Select");
ResultSet result = SQLite.query("SELECT * FROM playTime WHERE player='" + player + "';");
plugin.getLogger().info("checkForPlayer result.last");
result.last();
plugin.getLogger().info("Row: " + result.getRow());
if(result.getRow() == 0) {
plugin.getLogger().info("CheckForPlayer Insert");
SQLite.query("INSERT INTO playTime(player, playTime) VALUES('" + player + "', '" + playTime + "');");
}
}catch (SQLException e) {
plugin.getLogger().info("checkForPlayer Exception");
plugin.getLogger().info(e.getMessage());
}
}

Any help? If there's a better way of doing this, it'd be appreciated!

Not to worry, I fixed this myself by using a COUNT(*) statement to get the number of rows. If anyone has the same error, I can post the way to fix it.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.