TestDatabaseConnection.java

// Test Database Connection
// Run this to test if you can connect to MySQL database

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class TestDatabaseConnection {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/esecurewallet?useSSL=false&serverTimezone=UTC";
        String username = "root";
        String password = ""; // Change if you have a password
        
        System.out.println("========================================");
        System.out.println("Testing MySQL Database Connection");
        System.out.println("========================================");
        System.out.println("URL: " + url);
        System.out.println("Username: " + username);
        System.out.println("Password: " + (password.isEmpty() ? "(empty)" : "***"));
        System.out.println();
        
        try {
            // Load MySQL driver
            Class.forName("com.mysql.cj.jdbc.Driver");
            System.out.println("✓ MySQL Driver loaded successfully");
            
            // Try to connect
            System.out.println("Attempting to connect...");
            Connection conn = DriverManager.getConnection(url, username, password);
            
            if (conn != null) {
                System.out.println("✓✓✓ CONNECTION SUCCESSFUL! ✓✓✓");
                System.out.println("Database: " + conn.getCatalog());
                System.out.println("Auto-commit: " + conn.getAutoCommit());
                
                // Test query
                var stmt = conn.createStatement();
                var rs = stmt.executeQuery("SELECT DATABASE()");
                if (rs.next()) {
                    System.out.println("Current database: " + rs.getString(1));
                }
                
                // Check if tables exist
                rs = stmt.executeQuery("SHOW TABLES");
                System.out.println("\nTables in database:");
                boolean hasTables = false;
                while (rs.next()) {
                    System.out.println("  - " + rs.getString(1));
                    hasTables = true;
                }
                if (!hasTables) {
                    System.out.println("  (No tables found - Hibernate will create them)");
                }
                
                conn.close();
                System.out.println("\n✓ Connection closed successfully");
            }
        } catch (ClassNotFoundException e) {
            System.err.println("❌ ERROR: MySQL Driver not found!");
            System.err.println("Make sure mysql-connector-j-9.4.0.jar is in your classpath");
            e.printStackTrace();
        } catch (SQLException e) {
            System.err.println("❌❌❌ CONNECTION FAILED! ❌❌❌");
            System.err.println("Error Code: " + e.getErrorCode());
            System.err.println("SQL State: " + e.getSQLState());
            System.err.println("Error Message: " + e.getMessage());
            System.err.println("\nCommon Issues:");
            
            if (e.getMessage().contains("Communications link failure") || 
                e.getMessage().contains("Connection refused")) {
                System.err.println("  → MySQL server is not running!");
                System.err.println("  → Start MySQL via XAMPP Control Panel");
            } else if (e.getMessage().contains("Unknown database")) {
                System.err.println("  → Database 'esecurewallet' does not exist!");
                System.err.println("  → Run: CREATE DATABASE esecurewallet;");
            } else if (e.getMessage().contains("Access denied")) {
                System.err.println("  → Wrong username or password!");
                System.err.println("  → Update password in hibernate.cfg.xml");
            } else if (e.getMessage().contains("timeout")) {
                System.err.println("  → Connection timeout!");
                System.err.println("  → Check if MySQL is running and accessible");
            }
            
            e.printStackTrace();
        } catch (Exception e) {
            System.err.println("❌ Unexpected error: " + e.getMessage());
            e.printStackTrace();
        }
        
        System.out.println("\n========================================");
    }
}