Celoxis JDBC Probe is a java program that helps understanding of connection to understand connection issues with your database server.
Download
Click here to download the jdbc-probe.zip file.
| Info | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
This test needs to be run from on the server where Celoxis will be is installed; NOT on the database server. |
...
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), |
| pgsql (for Postgresql 9.0), mssql (for SQL Server 2008, 2012, 2014) | |
| 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. |
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)))) |
|
FAILURE: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor. [java.sql.SQLException] | One of the parameter you are passing is incorrect or the database does not exist on the connection properties you are specifying. |
Common errors for MSSQL
| ERROR MESSAGE | POSSIBLE CAUSES |
|---|---|
| Error establishing socket. |
|
| Login failed for user | Username or password is incorrect. |
| Cannot open database requested in login |
|
| 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. |
| The TCP/IP port is disabled or not accepting connections |
Also, check that the firewall is not blocking the connection. |
Common errors for Postgresql
| ERROR MESSAGE | POSSIBLE CAUSES |
|---|---|
| The connection attempt failed |
|
| Connection rejected: FATAL: password authentication failed for user | Username or password is incorrect |
| Backend start-up failed: FATAL: database "celoxis" does not exist |
|