java.sql.SQLException: Cannot get working DB connection!

CloverDX Platform
1

Hello,
I installed cloverETL Server in a WebLogic domain called endeca_integrator_domain.
I followed this steps:
- create the domain;
- copy the clover.war application and the license file in the domain directory;
- create the file cloverServer.properties, with the property

license.file=/u01/app/endeca_3_1/user_projects/domains/endeca_integrator_domain/license.dat

- modify ./startWebLogic.sh adding:

export JAVA_OPTIONS=${JAVA_OPTIONS} -Dclover_config_file=/u01/app/endeca_3_1/user_projects/domains/endeca_integrator_domain/cloverServer.properties

- modify the ./bin/setDomainEnv.sh file setting the USER_MEM_ARGS variabile to -Xms128m -Xmx2048m -XX:MaxPermSize=512m
- execute the .startWebLogic.sh script and wait until the domain is in RUNNING mode
- installed the application from the console page

Yesterday the application was ok. Today I’ve stop the domain and then restarted it, and I get this error:

java.sql.SQLException: Cannot get working DB connection!

The application clover.war failed to start.
Any idea on how could I resolve this error?

Thank you.

2

Hi scatto86,

Please take a look into log - there should be more regarding this error - typically in complete stack trace there is information about cause of non-working db connection. Errors like unknown host, wrong account, missing JDBC driver comes to my mind.

Also you can check your db connection configuration via native DB client (MysqlWorkbench, SQL developer, …) to ensure problem is not caused by it.