[Resolvido] MySQL - Erro de conexão

[List("HeyKick");]

Bom estou tendo um erro no meu console, que apos eu digitar um comando que va setar um valor na database

ele repeti e a conexão

    private final String bancodedados;

    private final String host;

    private final String porta;

    private final String senha;

    private final String usuario;



    public MySQL(String db, String host, String port, String pw, String user) {

        this.bancodedados = db;

        this.host = host;

        this.porta = port;

        this.senha = pw;

        this.usuario = user;

    }



    public synchronized Connection conectar() {



        try {

            Class.forName("com.mysql.jdbc.Driver");

            return DriverManager.getConnection("jdbc:mysql://" + host + ":" + porta + "/" + bancodedados, usuario, senha);

        } catch (SQLException | ClassNotFoundException e) {

            e.printStackTrace();

            return null;

        }



    }



    public synchronized void execute(String query) {

        Connection con = conectar();

        try {

            con.prepareStatement(query).executeUpdate();

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            try {

                con.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }



    }



    public synchronized ResultSet getQueryResult(String query) {

        Connection con = conectar();

        try {

            con.close();

            return con.prepareStatement(query).executeQuery();

        } catch (SQLException e) {

            e.printStackTrace();

            return null;

        }

    }

Erro que acontece no console

15.10 17:01:32 [Server] WARN [hKits] Task #8 for hKits v1.0 generated an exception

15.10 17:01:32 [Server] INFO java.lang.NullPointerException

15.10 17:01:32 [Server] INFO at hyperkits.score.Score.scoreKitPvP(Score.java:71) ~[?:?]

15.10 17:01:32 [Server] INFO at hyperkits.eventos.Eventos$2.run(Eventos.java:103) ~[?:?]

15.10 17:01:32 [Server] INFO at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:71) ~[spigot-1.8.jar:git-Spigot-76236cb-d4e32ce]

15.10 17:01:32 [Server] INFO at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:350) [spigot-1.8.jar:git-Spigot-76236cb-d4e32ce]

15.10 17:01:32 [Server] INFO at net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:723) [spigot-1.8.jar:git-Spigot-76236cb-d4e32ce]

15.10 17:01:32 [Server] INFO at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:374) [spigot-1.8.jar:git-Spigot-76236cb-d4e32ce]

15.10 17:01:32 [Server] INFO at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654) [spigot-1.8.jar:git-Spigot-76236cb-d4e32ce]

15.10 17:01:32 [Server] INFO at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557) [spigot-1.8.jar:git-Spigot-76236cb-d4e32ce]

15.10 17:01:32 [Server] INFO at java.lang.Thread.run(Thread.java:745) [?:1.8.0_40]

15.10 17:01:33 [Server] WARN com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Too many connections

15.10 17:01:33 [Server] WARN at sun.reflect.GeneratedConstructorAccessor34.newInstance(Unknown Source)

15.10 17:01:33 [Server] WARN at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

15.10 17:01:33 [Server] WARN at java.lang.reflect.Constructor.newInstance(Constructor.java:422)

15.10 17:01:33 [Server] WARN at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

15.10 17:01:33 [Server] WARN at com.mysql.jdbc.Util.getInstance(Util.java:382)

15.10 17:01:33 [Server] WARN at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)

15.10 17:01:33 [Server] WARN at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)

15.10 17:01:33 [Server] WARN at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)

15.10 17:01:33 [Server] WARN at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)

15.10 17:01:33 [Server] WARN at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)

15.10 17:01:33 [Server] WARN at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)

15.10 17:01:33 [Server] WARN at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)

15.10 17:01:33 [Server] WARN at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)

15.10 17:01:33 [Server] WARN at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)

15.10 17:01:33 [Server] WARN at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)

15.10 17:01:33 [Server] WARN at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

15.10 17:01:33 [Server] WARN at sun.reflect.GeneratedConstructorAccessor26.newInstance(Unknown Source)

15.10 17:01:33 [Server] WARN at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

15.10 17:01:33 [Server] WARN at java.lang.reflect.Constructor.newInstance(Constructor.java:422)

15.10 17:01:33 [Server] WARN at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

15.10 17:01:33 [Server] WARN at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)

15.10 17:01:33 [Server] WARN at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)

15.10 17:01:33 [Server] WARN at java.sql.DriverManager.getConnection(DriverManager.java:664)

15.10 17:01:33 [Server] WARN at java.sql.DriverManager.getConnection(DriverManager.java:247)

15.10 17:01:33 [Server] WARN at hyperkits.mysql.MySQL.conectar(MySQL.java:34)

15.10 17:01:33 [Server] WARN at hyperkits.score.Score.scoreKitPvP(Score.java:71)

15.10 17:01:33 [Server] WARN at hyperkits.eventos.Eventos$2.run(Eventos.java:103)

15.10 17:01:33 [Server] WARN at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:71)

15.10 17:01:33 [Server] WARN at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:350)

15.10 17:01:33 [Server] WARN at net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:723)

15.10 17:01:33 [Server] WARN at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:374)

15.10 17:01:33 [Server] WARN at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654)

15.10 17:01:33 [Server] WARN at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557)

15.10 17:01:33 [Server] WARN at java.lang.Thread.run(Thread.java:745)

[Langsdorf]

Deixe a conexão aberta e fecha no onDisable. Ficar abrindo e fechando é mais lento...

[List("HeyKick");]

Deixe a conexão aberta e fecha no onDisable. Ficar abrindo e fechando é mais lento...

Tem como me dar um exemplo, estou recem iniciando meu MySQL 

[leonardosc]

O erro ta na classe Score, linha 71.

 

Posta aqui.

[List("HeyKick");]

O erro ta na classe Score, linha 71.

 

Posta aqui.

Não e não, achei o erro, pode fechar, meu prof ajudo kkk

eu nao tava fechando

public synchronized ResultSet getQueryResult(String query) {
        Connection con = conectar();
        try {
            con.close();
            return con.prepareStatement(query).executeQuery();
        } catch (SQLException e) {
            e.printStackTrace();
            return null;
        }
    }

Editado Outubro 15, 2016 por AugustoSR

[Langsdorf]

Sua dúvida foi marcada como [Resolvido] e movido à área de dúvidas resolvidas.


Atenciosamente,
Gamer's Board