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

scatto86

• February 25, 2014 00:00

• Answered

Follow

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.

• 

  admin

  • February 26, 2014 08:46

  0

  Comment actions Permalink

  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.

Please sign in to leave a comment.