Celoxis uses JDBC to connect to the database. Celoxis not being able to connect to the database There could be because of a number of reasonsvarious reasons for the connection to fail. To help you debug the problem, we have written a simple program that will facilitate help you to understand the problem.
...
- Open a terminal window on Unix/Linux or Command prompt in Windows
- Go to the directory jdbctest
On Microsoft Windows run the program (substituting values according to your configuration) as:
NOTE: Type the words in bold AS IS. Words in italics needs to be substituted.Code Block java -cp .;drivers/* jdbctest product=oracle name=celoxis user=scott password=tiger host=localhost
On Unix (or Linux) run the program (substituting values according to your confiuration) as:
Code Block java -cp '.:drivers/*' jdbctest product=oracle name=celoxis user=scott password=tiger host=localhost
Note
| product | one of the following: oracle (for Oracle), pgsql postgresql_90 (for Postgresql 9.0), mssql_2000 2008 (for SQL Server 20002008), mssql_2005 2012 (for SQL Server 20052012) or mssql_2008 2014 (for SQL Server 20082014) |
| name | Name of your database |
| user/password | 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. |
...
| 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)))) |
|
...