From 3794537cf4435296253118bc4af84df57ae28836 Mon Sep 17 00:00:00 2001
From: Tyler Murphy <tylermurphy534@gmail.com>
Date: Wed, 13 Apr 2022 12:02:36 -0400
Subject: 1.4.0 rc2

---
 .../net/tylermurphy/hideAndSeek/database/PlayerInfoTable.java | 11 +++++++++--
 1 file changed, 9 insertions(+), 2 deletions(-)

(limited to 'src/main/java/net/tylermurphy/hideAndSeek/database/PlayerInfoTable.java')

diff --git a/src/main/java/net/tylermurphy/hideAndSeek/database/PlayerInfoTable.java b/src/main/java/net/tylermurphy/hideAndSeek/database/PlayerInfoTable.java
index e859687..7b9b476 100644
--- a/src/main/java/net/tylermurphy/hideAndSeek/database/PlayerInfoTable.java
+++ b/src/main/java/net/tylermurphy/hideAndSeek/database/PlayerInfoTable.java
@@ -20,8 +20,10 @@
 package net.tylermurphy.hideAndSeek.database;
 
 import net.tylermurphy.hideAndSeek.Main;
+import net.tylermurphy.hideAndSeek.configuration.Config;
 import net.tylermurphy.hideAndSeek.util.WinType;
 
+import java.io.ByteArrayInputStream;
 import java.io.IOException;
 import java.io.InputStream;
 import java.sql.*;
@@ -42,7 +44,7 @@ public class PlayerInfoTable {
                 + ");";
 
         try(Connection connection = Database.connect(); Statement statement = connection.createStatement()){
-            statement.execute(sql);
+            statement.executeUpdate(sql);
         } catch (SQLException e){
             Main.plugin.getLogger().severe("SQL Error: " + e.getMessage());
         }
@@ -59,6 +61,8 @@ public class PlayerInfoTable {
             statement.setBytes(1, bytes);
             ResultSet rs  = statement.executeQuery();
             if(rs.next()){
+                rs.close();
+                connection.close();
                 return new PlayerInfo(
                         uuid,
                         rs.getInt("wins"),
@@ -67,6 +71,7 @@ public class PlayerInfoTable {
                         rs.getInt("games_played")
                 );
             }
+            rs.close();
         } catch (SQLException e){
             Main.plugin.getLogger().severe("SQL Error: " + e.getMessage());
         } catch (IOException e) {
@@ -84,7 +89,7 @@ public class PlayerInfoTable {
             List<PlayerInfo> infoList = new ArrayList<>();
             while(rs.next()){
                 PlayerInfo info = new PlayerInfo(
-                        Database.convertBinaryStream(rs.getBinaryStream("uuid")),
+                        Database.convertBinaryStream(new ByteArrayInputStream(rs.getBytes("uuid"))),
                         rs.getInt("wins"),
                         rs.getInt("seeker_wins"),
                         rs.getInt("hider_wins"),
@@ -92,6 +97,8 @@ public class PlayerInfoTable {
                 );
                 infoList.add(info);
             }
+            rs.close();
+            connection.close();
             return infoList;
         } catch (SQLException e){
             Main.plugin.getLogger().severe("SQL Error: " + e.getMessage());
-- 
cgit v1.2.3-freya