ODBC-JDBC Bridge Installation Guide

1. Copy the code below into a file named UniversalJDBCTest.java
2. Modify the connection parameters (driverClass, jdbcURL, user, password)
3. Save the file in your project directory
4. Compile and run following the instructions below

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class UniversalJDBCTest {
    public static void main(String[] args) {
        // ============================================
        // EDIT THESE VALUES FOR YOUR DATABASE
        // ============================================
        String driverClass = "org.postgresql.Driver";
        String jdbcURL = "jdbc:postgresql://localhost:5432/mydb";
        String username = "myuser";
        String password = "mypassword";
        
        // ============================================
        // CONNECTION TEST BEGINS
        // ============================================
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        
        try {
            System.out.println("=== JDBC Connection Test ===\n");
            
            // Step 1: Load JDBC Driver
            System.out.println("[1] Loading JDBC Driver: " + driverClass);
            Class.forName(driverClass);
            System.out.println("    ✓ Driver loaded successfully\n");
            
            // Step 2: Establish Connection
            System.out.println("[2] Connecting to: " + jdbcURL);
            conn = DriverManager.getConnection(jdbcURL, username, password);
            System.out.println("    ✓ Connection established successfully\n");
            
            // Step 3: Get Connection Metadata
            System.out.println("[3] Database Metadata:");
            DatabaseMetaData meta = conn.getMetaData();
            System.out.println("    Database: " + meta.getDatabaseProductName());
            System.out.println("    Version: " + meta.getDatabaseProductVersion());
            System.out.println("    Driver: " + meta.getDriverName());
            System.out.println("    Driver Version: " + meta.getDriverVersion() + "\n");
            
            // Step 4: Execute Test Query
            System.out.println("[4] Executing test query...");
            stmt = conn.createStatement();
            rs = stmt.executeQuery("SELECT 1 as test_column");
            
            if (rs.next()) {
                System.out.println("    ✓ Query executed successfully");
                System.out.println("    Test value: " + rs.getInt("test_column") + "\n");
            }
            
            // Step 5: Display Available Tables
            System.out.println("[5] Available Tables in Database:");
            ResultSet tables = meta.getTables(null, null, "%", new String[]{"TABLE"});
            int tableCount = 0;
            while (tables.next() && tableCount < 10) {
                System.out.println("    - " + tables.getString("TABLE_NAME"));
                tableCount++;
            }
            if (tableCount == 10) {
                System.out.println("    (showing first 10 tables)\n");
            } else {
                System.out.println();
            }
            
            // Step 6: Connection Close Test
            System.out.println("[6] Closing connection...");
            if (rs != null) rs.close();
            if (stmt != null) stmt.close();
            if (conn != null) conn.close();
            System.out.println("    ✓ Connection closed successfully\n");
            
            System.out.println("=== TEST COMPLETED SUCCESSFULLY ===");
            System.out.println("\nYour JDBC driver is properly configured.");
            System.out.println("You can now proceed with ODBC DSN configuration.");
            
        } catch (ClassNotFoundException e) {
            System.err.println("ERROR: JDBC Driver not found!");
            System.err.println("Make sure the driver .jar is in your CLASSPATH");
            System.err.println("Details: " + e.getMessage());
        } catch (Exception e) {
            System.err.println("ERROR: Connection failed!");
            System.err.println("Details: " + e.getMessage());
            e.printStackTrace();
        }
    }
}