Hi, We want to have a function in the process which would check

anagha_abhyankar over 10 years ago

Hi,

We want to have a function in the process which would check if DB is up and running just like a ping to the DB which will return an error code and a message.

Is there a smart service available out of the box for the same?

Thanks,

Anagha
...

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 10 years ago

No, that setting is to force JBoss to re-connect if the DB goes down but I agree won't prevent the node from failure. You could create a custom smart service that would run this simple select and catch the exception gracefully so you can wait for the reconnection to happen in your model (reconnection will happen if you use this setting in appian-ds.xml and if the DB becomes available again)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 10 years ago

No, that setting is to force JBoss to re-connect if the DB goes down but I agree won't prevent the node from failure. You could create a custom smart service that would run this simple select and catch the exception gracefully so you can wait for the reconnection to happen in your model (reconnection will happen if you use this setting in appian-ds.xml and if the DB becomes available again)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data