Celoxis - JDBC Probe

Celoxis JDBC Probe is a java program that helps understanding of connection issues with your database server.

Supported Databases

Download

Click here to download the JDBCProbe.zip file.

Usage

  1. Unzip the JDBCProbe.zip file. A folder with the file JDBCProbe.class should be created.
  2. Open a command prompt and cd to the folder containing the JDBCProbe.class file.
  3. On Microsoft Windows run the program (substituting values according to your configuration) as: 
    java -cp .;drivers/* jdbctest product=oracle name=celoxis user=tim password=fox host=localhost
    On Linux or Mac OS run the program (substituting values according to your confiuration) as: 
    java -cp '.:drivers/*' jdbctest product=oracle name=celoxis user=tim password=fox host=localhost

You will receive a success message if the connection was successful. If the connection fails, the message returned by the driver is printed. This error message will give you a clue about the possible causes as explained later in this document.

Options

product
One of oracle (for Oracle), pgsql (for Postgresql), mssql (for Microsoft SQL Server)
name
The name of your database
user & password
The username and password to be used to connect to the database. NOTE: In case of SQL server, the login and database must be configured to use the SQL Authentication mode (or Mixed mode), not Windows authentication mode only.
host
The machine name of the server where the database is running
port
The port of the database server. This is an optional field and when unspecified the default port will be used.

Understanding the Error Messages

Oracle

The Network Adapter could not establish the connection
1) The host name is not resolvable using DNS 2) Database server is not running on the host 3) The database port on the database server is inaccessible because of a firewall
Invalid username/password; logon denied
Username or password is incorrect
Connection refused(DESCRIPTION=(TMP=) (VSNNUM=153092352)(ERR=12505) (ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
1) The database name is incorrect 2) The user doesn't have privileges to logon to the database

Microsoft SQL Server

Error establishing socket
1) The host name is not resolvable using DNS 2) Databse server is not running on the host 3) The database port on the database server is inaccessible because of a firewall
Login failed for user
Username or password is incorrect
Cannot open database requested in login
1) The database name is incorrect 2) The user doesn't have privileges to logon to the database
Not Associated with a trusted SQL Server Connection
This occurs typically when Microsoft Sql Server installation is configured to use only Windows authentication and not SQL Server authentication. To solve the problem: Change the Authentication change the authentication mode to sql server authentication.

PostgreSQL

The connection attempt failed
1) The host name is not resolvable using DNS 2) Database server is not running on the host 3) The database port on the database server is inaccessible because of a firewall
Connection rejected: FATAL: password authentication failed for user
Username or password is incorrect
Backend start-up failed: FATAL: database "abc" does not exist
1) The database name (abc) is incorrect 2) The user doesn't have privileges to logon to the database