[Su37Erich]

Hello again!
Is it recommeded to have only a MySQL connection for everything?
Because I got this error sometimes:

Quote:

com.mysql.jdbc.exceptions.jdbc4.CommunicationsExce ption: The last packet successfully received from the server was 58,393,529 milliseconds ago. The last packet sent successfully to the server was 58,393,539 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

Here is my code to connect to the database:

Код:

public static Connection createConnection(String server, String user, String password, String dataBase){
        Connection connection = null;
        try{
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection("jdbc:mysql://"+server+":3306/?autoReconnect=true"+dataBase, user, password);
        }catch(ClassNotFoundException | SQLException e){
            connection = null;
        }
        return connection;
    }

I read that connections should be only opened and closed every time you use them, and I should use a thing called connection pool, I tried it but it simply doesn't work for me:

Код:

public class Player{
    private static DataSource ds;
    static{
        try{
            InitialContext context = new InitialContext();
            ds = (DataSource)context.lookup("java:comp/env/jdbc/MySQLDB");
        }catch(NamingException e){
            System.out.println("Error: "+e);
        }
    }
static{
        Connection connection = null;
        Statement st = null;
        ResultSet result = null;
        try{
            connection = ds.getConnection();
            st = connection.createStatement();
            result = st.executeQuery("SELECT Value FROM Settings WHERE ValueName='Max Players Online'");
            if(result.next()){
                maxPlayersOn = result.getByte(1);
            }else{
                maxPlayersOn = 0;
            }
        }catch(SQLException e){
            System.out.println("SQL Error "+e);
        }finally{
            if(result != null){try{result.close();}catch(SQLException ignored){}}
            if(st != null){try{st.close();} catch(SQLException ignored){}}
            if(connection != null){try{connection.close();} catch(SQLException ignored){}
            }
        }
    }
}

But I get:

Quote:

Error javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial

Now I am very frustrated since in Pawn you just needed only one connection and everything worked fine, but using Java the things become very complex for me, I do not know what even means context or datasource and the relationship with MySQL!
I really appreciate any help