Home / Java / How to Fix Java SQL Connection Failed Error

Java

How to Fix Java SQL Connection Failed Error

Resolve Java SQL connection failures with diagnosis steps for network, authentication, and configuration issues.

Published: Nov 23, 20259 min readBy FixWikiHub Editorial Team

Abstract illustration for Java troubleshooting guides.

# How to Fix Java SQL Connection Failed Error

Your Java application fails to connect to the database with one of these errors:

bash

java.sql.SQLException: Connection refused
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:247)
    at com.myapp.DatabaseManager.connect(DatabaseManager.java:25)

Or:

bash

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago.

Or:

bash

java.sql.SQLException: Access denied for user 'myuser'@'192.168.1.100' (using password: YES)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)

Database connection failures can have many causes: network issues, authentication problems, driver configuration, or database server status.

Introduction

This article covers troubleshooting steps and solutions for How to Fix Java SQL Connection Failed Error. The error typically occurs in production environments and can cause service disruptions if not addressed promptly.

Symptoms

Common error messages include:

bash

java.sql.SQLException: Connection refused
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:247)
    at com.myapp.DatabaseManager.connect(DatabaseManager.java:25)

bash

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago.

bash

java.sql.SQLException: Access denied for user 'myuser'@'192.168.1.100' (using password: YES)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)

Common Causes

Configuration misconfiguration
Missing or incorrect credentials
Network connectivity issues
Version compatibility problems
Resource exhaustion or limits
Permission or access denied

Step-by-Step Fix

Step 1: Verify Database Server is Running

```bash # MySQL mysqladmin -h localhost -u root -p status

# PostgreSQL pg_isready -h localhost -p 5432

# SQL Server sqlcmd -S localhost -U sa -P password -Q "SELECT @@VERSION"

# Check if port is listening netstat -an | grep 3306 # MySQL default netstat -an | grep 5432 # PostgreSQL default netstat -an | grep 1433 # SQL Server default ```

Step 2: Test Connection from Command Line

```bash # MySQL mysql -h 192.168.1.100 -P 3306 -u myuser -p

# PostgreSQL psql -h 192.168.1.100 -p 5432 -U myuser -d mydb

# SQL Server sqlcmd -S 192.168.1.100,1433 -U myuser -P password ```

Step 3: Check Network Connectivity

```bash # Test basic connectivity ping 192.168.1.100

# Test specific port telnet 192.168.1.100 3306 # Or using nc nc -zv 192.168.1.100 3306

# Check firewall rules # Linux sudo iptables -L -n | grep 3306 sudo ufw status

# Windows netsh advfirewall firewall show rule name=all | findstr 3306 ```

Step 4: Verify JDBC URL Format

Common URL formats for different databases:

```java // MySQL String url = "jdbc:mysql://host:3306/database?useSSL=false&serverTimezone=UTC";

// PostgreSQL String url = "jdbc:postgresql://host:5432/database";

// SQL Server String url = "jdbc:sqlserver://host:1433;databaseName=database";

// Oracle String url = "jdbc:oracle:thin:@host:1521:SID";

// H2 (embedded) String url = "jdbc:h2:mem:testdb"; ```

Step 5: Test with a Simple Program

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

public class ConnectionTest { public static void main(String[] args) { String url = "jdbc:mysql://localhost:3306/testdb"; String user = "myuser"; String password = "mypassword";

System.out.println("Loading driver..."); try { Class.forName("com.mysql.cj.jdbc.Driver"); System.out.println("Driver loaded successfully"); } catch (ClassNotFoundException e) { System.err.println("Driver not found: " + e.getMessage()); return; }

System.out.println("Attempting connection..."); try (Connection conn = DriverManager.getConnection(url, user, password)) { System.out.println("Connection successful!"); System.out.println("Connection valid: " + conn.isValid(5)); } catch (SQLException e) { System.err.println("Connection failed!"); System.err.println("SQLState: " + e.getSQLState()); System.err.println("Error Code: " + e.getErrorCode()); System.err.println("Message: " + e.getMessage()); e.printStackTrace(); } } } ```

Step-by-Step Fix

Solution 1: Fix Connection Refused

If you see "Connection refused", the server isn't accepting connections:

```bash # Check if MySQL is running sudo systemctl status mysql

# Start if stopped sudo systemctl start mysql

# Check MySQL bind address cat /etc/mysql/mysql.conf.d/mysqld.cnf | grep bind-address ```

If bind-address is 127.0.0.1, remote connections are blocked. To allow remote connections:

ini

# /etc/mysql/mysql.conf.d/mysqld.cnf
bind-address = 0.0.0.0

Then restart MySQL:

bash

sudo systemctl restart mysql

Grant remote access:

```sql -- Connect as root mysql -u root -p

-- Grant remote access to user CREATE USER 'myuser'@'%' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'%'; FLUSH PRIVILEGES;

-- Or for specific IP CREATE USER 'myuser'@'192.168.1.%' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'192.168.1.%'; FLUSH PRIVILEGES; ```

Solution 2: Fix Access Denied

Authentication errors require correct credentials and permissions:

```sql -- Check user exists and host SELECT user, host FROM mysql.user WHERE user = 'myuser';

-- Reset password ALTER USER 'myuser'@'localhost' IDENTIFIED BY 'newpassword'; ALTER USER 'myuser'@'%' IDENTIFIED BY 'newpassword'; FLUSH PRIVILEGES;

-- For MySQL 8+ with caching_sha2_password ALTER USER 'myuser'@'%' IDENTIFIED WITH mysql_native_password BY 'password'; FLUSH PRIVILEGES; ```

Update your Java connection:

```java // For MySQL 8+, specify authentication plugin String url = "jdbc:mysql://localhost:3306/mydb?" + "useSSL=false&" + "serverTimezone=UTC&" + "allowPublicKeyRetrieval=true";

// Use try-with-resources try (Connection conn = DriverManager.getConnection(url, "myuser", "password")) { // Use connection } ```

Solution 3: Add JDBC Driver Dependency

If driver class not found:

Maven: ```xml  <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.33</version> </dependency>

<dependency> <groupId>org.postgresql</groupId> <artifactId>postgresql</artifactId> <version>42.7.1</version> </dependency>

<dependency> <groupId>com.microsoft.sqlserver</groupId> <artifactId>mssql-jdbc</artifactId> <version>12.4.2.jre11</version> </dependency> ```

Gradle: ```groovy // MySQL implementation 'mysql:mysql-connector-java:8.0.33'

// PostgreSQL implementation 'org.postgresql:postgresql:42.7.1'

// SQL Server implementation 'com.microsoft.sqlserver:mssql-jdbc:12.4.2.jre11' ```

Solution 4: Fix SSL/TLS Issues

Modern databases require SSL by default:

bash

javax.net.ssl.SSLHandshakeException: No appropriate protocol

Options in connection URL:

```java // Disable SSL (not recommended for production) String url = "jdbc:mysql://host:3306/db?useSSL=false";

// Use SSL without verification (testing only) String url = "jdbc:mysql://host:3306/db?useSSL=true&verifyServerCertificate=false";

// Proper SSL configuration String url = "jdbc:mysql://host:3306/db?" + "useSSL=true&" + "requireSSL=true&" + "trustCertificateKeyStoreUrl=file:/path/to/truststore.jks&" + "trustCertificateKeyStorePassword=changeit"; ```

Solution 5: Configure Connection Pool

For better reliability, use a connection pool:

HikariCP (Recommended):

```java import com.zaxxer.hikari.HikariConfig; import com.zaxxer.hikari.HikariDataSource;

public class DatabasePool { private static HikariDataSource dataSource;

static { HikariConfig config = new HikariConfig(); config.setJdbcUrl("jdbc:mysql://localhost:3306/mydb"); config.setUsername("myuser"); config.setPassword("password"); config.setMaximumPoolSize(10); config.setMinimumIdle(2); config.setConnectionTimeout(30000); config.setIdleTimeout(600000); config.setMaxLifetime(1800000); config.setPoolName("MyAppPool");

// Connection validation query config.setConnectionTestQuery("SELECT 1");

dataSource = new HikariDataSource(config); }

public static Connection getConnection() throws SQLException { return dataSource.getConnection(); } } ```

Maven dependency: ``xml <dependency> <groupId>com.zaxxer</groupId> <artifactId>HikariCP</artifactId> <version>5.1.0</version> </dependency>

Solution 6: Handle Connection Timeouts

```java // Add timeout parameters to URL String url = "jdbc:mysql://host:3306/mydb?" + "connectTimeout=10000&" + // 10 seconds to establish connection "socketTimeout=30000&" + // 30 seconds socket timeout "autoReconnect=true&" + // Reconnect on failure "maxReconnects=3"; // Max reconnection attempts

// Configure in connection pool HikariConfig config = new HikariConfig(); config.setConnectionTimeout(10000); // 10 seconds config.setMaxLifetime(1800000); // 30 minutes config.setValidationTimeout(5000); // 5 seconds for validation ```

Solution 7: Fix Firewall and Network Issues

```bash # Linux - Open MySQL port sudo ufw allow 3306/tcp sudo ufw reload

# Or iptables sudo iptables -A INPUT -p tcp --dport 3306 -j ACCEPT sudo service iptables save

# Check if application can reach database # From application server: telnet db-server-ip 3306 traceroute db-server-ip ```

For Docker containers:

```yaml # docker-compose.yml version: '3' services: app: image: myapp depends_on: - db environment: - DB_HOST=db - DB_PORT=3306 networks: - app-network

db: image: mysql:8.0 environment: - MYSQL_ROOT_PASSWORD=rootpassword - MYSQL_DATABASE=mydb ports: - "3306:3306" networks: - app-network

networks: app-network: ```

Verification

Test the connection with proper error handling:

```java import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement;

public class VerifyConnection { public static void main(String[] args) { String url = "jdbc:mysql://localhost:3306/mydb?useSSL=false&serverTimezone=UTC";

try (Connection conn = DriverManager.getConnection(url, "myuser", "password")) { System.out.println("Connected to database!");

// Test query try (Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT 1")) { if (rs.next()) { System.out.println("Query executed successfully. Result: " + rs.getInt(1)); } }

// Check connection details System.out.println("Database: " + conn.getCatalog()); System.out.println("Auto-commit: " + conn.getAutoCommit()); System.out.println("Valid: " + conn.isValid(5));

} catch (Exception e) { System.err.println("Connection test failed!"); System.err.println("Exception type: " + e.getClass().getName()); System.err.println("Message: " + e.getMessage());

if (e.getCause() != null) { System.err.println("Cause: " + e.getCause().getMessage()); } } } } ```

Verification

Error	Cause	Solution
Connection refused	Server not running or not listening	Start server, check bind-address
Access denied	Wrong credentials or permissions	Check user exists, reset password
Communications link failure	Network/firewall issue	Check firewall, test port connectivity
No suitable driver	Driver not in classpath	Add JDBC driver dependency
SSL connection error	SSL configuration mismatch	Add SSL parameters or disable for testing
Timeout	Slow network or unresponsive server	Increase timeout, check server load

The diagnostic order: verify server running, test with command-line tools, check credentials, verify JDBC driver, and examine connection URL parameters.

[Technical troubleshooting: Fix Beanvalidation Constraintviolationexception En](beanvalidation-constraintviolationexception-entity-persist)
[Technical troubleshooting: Fix Classnotfoundexception Maven Shade Plugin Relo](classnotfoundexception-maven-shade-plugin-relocation)
[Technical troubleshooting: Fix Concurrentmodificationexception Arraylist Iter](concurrentmodificationexception-arraylist-iteration)
[Fix Ehcache Cache Eviction Memory Overflow Fix Issue in Java](ehcache-cache-eviction-memory-overflow-fix)
[Fix Java Ehcache Eviction Memory Threshold Fix Issue in Java](java-ehcache-eviction-memory-threshold-fix)

Was this guide helpful?

Related search paths

People also search for

If the symptom is close but not identical, these search paths usually surface the right neighboring fixes faster than scrolling the full archive.

Java SQL Connection Failed Error Java SQL Connection Failed Error Java Java SQL Connection Failed Error troubleshooting Java SQL Connection Failed Error fix Resolve Java SQL connection failures with diagnosis steps for network, authentication, and configuration issues Java Resolve Java SQL connection failures with diagnosis steps for network, authentication, and configuration issues

Explore Related Topics

Browse Guides from Other Categories

Discover troubleshooting guides from related categories to expand your knowledge.

FAQ

Java Troubleshooting FAQs

Common questions about troubleshooting and preventing similar issues

How do I know if this java-errors troubleshooting guide applies to my situation?

This guide is designed for java-errors issues. If you're experiencing similar symptoms described in the article, follow the step-by-step instructions. Start with the most common causes and work through the diagnostic process.

Is it safe to follow these java-errors troubleshooting steps?

Yes, all steps are designed to be safe and non-destructive. We recommend creating backups before making significant changes and testing each step before proceeding to the next.

How long does it typically take to resolve this type of java-errors issue?

Most java-errors issues can be resolved within 30 minutes to 2 hours, depending on the complexity and root cause. Follow the troubleshooting flow to identify and fix the problem efficiently.

How can I prevent this java-errors issue from happening again?

Regular maintenance, monitoring, and following best practices for java-errors configuration can help prevent recurrence. Consider implementing automated checks and alerts for early detection.

Written by

FixWikiHub Editorial Team

Our editorial team consists of experienced DevOps engineers, systems administrators, and cloud architects with hands-on experience in production environments across AWS, Azure, GCP, and on-premises infrastructure.

Every guide undergoes technical review for accuracy and is updated when software versions, commands, or best practices change.

Last updated: Nov 23, 2025

About our team

Important Notice

Disclaimer & Safety Guidelines

The troubleshooting steps in this guide are provided for educational and informational purposes. Before applying any changes to production systems:

Test in a staging environment first — Always verify commands and configurations in a non-production environment before deploying to live systems.
Create backups — Ensure you have current backups of databases, configurations, and critical files before making changes.
Understand the impact — Review how each step may affect your specific environment, dependencies, and users.
Consult official documentation — This guide supplements, but does not replace, official vendor documentation and best practices.

FixWikiHub is not responsible for any damages arising from the use of this content. See our Terms of Use for more information.

Resources

Official Documentation & Further Reading

For authoritative information, consult the official documentation for the technologies discussed in this guide. Our troubleshooting content supplements, but does not replace, vendor documentation.

AWS Documentation — Official Amazon Web Services guides and API references
Kubernetes Documentation — Official Kubernetes documentation
Nginx Documentation — Official Nginx web server documentation
Apache Documentation — Official Apache HTTP Server documentation
Docker Documentation — Official Docker container documentation

How to Fix Java SQL Connection Failed Error

Introduction

Symptoms

Common Causes

Step-by-Step Fix

Step 1: Verify Database Server is Running

Step 2: Test Connection from Command Line

Step 3: Check Network Connectivity

Step 4: Verify JDBC URL Format

Step 5: Test with a Simple Program

Step-by-Step Fix

Solution 1: Fix Connection Refused

Solution 2: Fix Access Denied

Solution 3: Add JDBC Driver Dependency

Solution 4: Fix SSL/TLS Issues

Solution 5: Configure Connection Pool

Solution 6: Handle Connection Timeouts

Solution 7: Fix Firewall and Network Issues

Verification

Verification

People also search for

Browse Guides from Other Categories

WordPress

SSL

DNS

Java Troubleshooting FAQs

FixWikiHub Editorial Team

Disclaimer & Safety Guidelines

Official Documentation & Further Reading

How to Fix Java SQL Connection Failed Error

Introduction

Symptoms

Common Causes

Step-by-Step Fix

Step 1: Verify Database Server is Running

Step 2: Test Connection from Command Line

Step 3: Check Network Connectivity

Step 4: Verify JDBC URL Format

Step 5: Test with a Simple Program

Step-by-Step Fix

Solution 1: Fix Connection Refused

Solution 2: Fix Access Denied

Solution 3: Add JDBC Driver Dependency

Solution 4: Fix SSL/TLS Issues

Solution 5: Configure Connection Pool

Solution 6: Handle Connection Timeouts

Solution 7: Fix Firewall and Network Issues

Verification

Verification

Related Articles

People also search for

Share this guide

More Java Troubleshooting Guides

Browse Guides from Other Categories

Java Troubleshooting FAQs

FixWikiHub Editorial Team

Disclaimer & Safety Guidelines

Official Documentation & Further Reading