Can't connect to DB in server project

Support questions related to CloverDXServer

CiscoChi
Posts: 29
Joined: Wed Sep 02, 2009 12:23 am

Can't connect to DB in server project

Postby CiscoChi » Tue Oct 13, 2009 1:46 am

Hi,
I am testing a server project configuration, and have not been able to create a valid database connection through Designer. If I try to execute through the server scheduling tool, then it runs the database dependent components, which is evident from the logging, however, I can't get this to work from Eclipse. The error I'm getting when I try to validate the connection is:
2009-10-12 17:07:53,640 ERROR 950275 [WatchDog] Phase initialization failed with reason: DB_EXECUTE0 ...FAILED !
Reason: org.jetel.exception.JetelException: Cannot establish DB connection (cmsg_dw). caused by: org.jetel.exception.JetelException: Can't connect to DB. caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.

jurban
Posts: 163
Joined: Fri Jul 20, 2007 9:25 am

Re: Can't connect to DB in server project

Postby jurban » Tue Oct 13, 2009 8:53 am

Hi,
this looks like you're not able to connect from your computer to the DB server. DB validation is currently performed from your client computer (running the Designer). You network can be configured so that the server can connect to the DB (i.e. the graphs will run OK) but your client computer cannot.

Jaro
Jaroslav Urban
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com

CiscoChi
Posts: 29
Joined: Wed Sep 02, 2009 12:23 am

Re: Can't connect to DB in server project

Postby CiscoChi » Tue Oct 13, 2009 6:15 pm

I think this was my fault. The db I was trying to connect to seemed to be down. I restarted it, and I was able to connect.

Thanks.


cron