web stats
MySql DB Connection object in global scripts - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 08-21-2015, 05:53 AM
saro3392 saro3392 is offline
Mirth Newb
 
Join Date: Mar 2014
Posts: 23
saro3392 is on a distinguished road
Post MySql DB Connection object in global scripts

Hello All,,

Mirth Version - 3.2.1

I created the db connection (db object) in deploy global scripts and made global db object as global variable to use the same across all the channels.

I am using this global db object across 10 channels.

I never close the connection.

Today due to network idle timeout, db object connection broken. Then we manually redeployed the channel to refresh db connection object.

Following are my questions on this scenario:

1. Is there any way to refresh global script variables without redeploying the channel ?. If yes can i write user defined function to check db object connection status in preprocessor global scripts

2. Is it good practice to use the common MySql db object for all the channels and not closing the connection. Note: I came for this solution to reduce the cost of mysql operation.

Can anyone please suggest or help this?

Thanks in Advence
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 11:31 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation