Xqe-jdb-0001 Problem Establishing Connection. Please Check The Database Server [top] Official

import java.util.Properties; ... Properties props = new Properties(); props.setProperty("logLevel", "1"); // Oracle props.setProperty("loggerLevel", "DEBUG"); // PostgreSQL driver Catch the exact SQLException :

Add connectTimeout parameter to avoid indefinite hang: import java

Share your database type, application version, and the exact output of telnet and netstat commands in a support forum—chances are, the answer lies in the difference between what you think is configured and what is actually listening on the wire. Step 5: Examine Connection Pool and Database Limits

– update it and then refresh the application’s connection pool. Step 5: Examine Connection Pool and Database Limits Check if the database has reached max_connections : Cognos BI server

# Linux - check if DB process is running systemctl status postgresql (or mysql / oracle / mssql) services.msc → look for SQL Server, OracleService, etc. Also test local connection: psql -U your_user -d your_db -h localhost mysql -u your_user -p -h 127.0.0.1

Start the service and verify that it binds to the expected IP/port. Step 2: Test Basic Network Connectivity From the machine running the XQE engine (e.g., Cognos BI server, ETL host):

# Ping test (checks ICMP, but some firewalls block ping) ping your-database-hostname telnet your-database-hostname 5432 (for PostgreSQL) telnet your-database-hostname 3306 (for MySQL) telnet your-database-hostname 1521 (for Oracle) telnet your-database-hostname 1433 (for SQL Server)