EnsLib.SQL.OutboundAdapter and StayConnected Setting

Has anyone use any other setting then -1 on the Stay Connected setting on a SQL.OutboundAdapter? I am having issues with a particular database and wonder if it would be beneficial since I only connect once a day to read the data from the Adapter to create an HL7 message.

Thanks

Scott Roth

  • 0
  • 0
  • 268
  • 1
  • 2

Answers

Definitely, try Stay Connected = 5 so the connection would drop five seconds after data transfer.

Good question, Scott. Yep, we also use stay connected =5, otherwise it will raise too often the alert. We are using ODBC, not JDBC though, however I don't think that makes much difference in this connection config.