Celoxis uses JDBC to connect to the database. There could be various reasons for the connection to fail. To help you debug the problem, we have written a simple program that will help you to understand the problem.
Downloading the program
Download the jdbctest.zip file from http://download.celoxis.com/jdbctest/jdbctest.zip and unzip it. This will create a directory containing the following:
- drivers : this contains database drivers from Oracle, Microsoft and Postgresql
- jdbctest.java : this is a simple program that tries to connect to your database using JDBC and prints a success or a failure message
- jdbctest.class : the compiled version of jdbctest.java
Celoxis JDBC Probe is a java program that helps understanding of connection issues with your database server.
Download
Click here to download the jdbc-probe.zip file.
| Info |
|---|
This test needs to be run from the server where Celoxis will be installed; NOT on the database server. |
Usage
Running the test program
...
- Unzip the jdbc-probe.zip file. It should create a folder with the file JDBCProbe.class in it.
- Open a command prompt and cd to the folder that contains the JDBCProbe.class file.
On Microsoft Windows run the program (substituting values according to your configuration) as:
...
Code Block java -cp .;drivers/*
...
JDBCProbe 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:
Code Block java -cp '.:drivers/*'
...
JDBCProbe 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 the following: oracle (for Oracle), postgresql_90 (for Postgresql 9.0), mssql_2008 (for SQL Server 2008), mssql_2012 (for SQL Server 2012) or mssql_2014 (for SQL Server 2012, 2014) |
| name | Name The name of your database |
| user/password | Username 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. |
You will receive a success message if the connection was successful. If the connection fails, the message returned by the driver is printed. If you don't understand the output simply send us the output.
...
Understanding the Error Messages
Common errors for Oracle
| ERROR MESSAGE | POSSIBLE CAUSES |
|---|---|
| The Network Adapter could not establish the connection |
|
| 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)))) |
|
...