Announcement

Collapse

NextGen (Mirth) Connect 3.10.0 Released!

NextGen (Mirth) Connect 3.10.0 is now available as an appliance update and on our GitHub page. This release includes better SQL Server database support, security improvements through fixes and library updates, and improvements for the Advanced Clustering plugin with a focus on improving performance of many of the tasks that are carried out on a frequent interval. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

Sending results from a Database query as the ACK

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sending results from a Database query as the ACK

    Hey guys

    I'm attempting to send a custom ACK using the results from a database query. I looked at what others have done to create the custom ACK using this in the tranformer
    Code:
    ResponseMap.put(connector, ResponseFactory.getSuccessResponse(ack_message));
    but the variable that my results is equal to something like [email protected] No clue what that means.

    Could somebody please let me know how I can achieve this.

    Thanks in advance.

    Post edited by: hsingh00, at: 06/05/2007 09:31

  • #2
    Re:Sending results from a Database query as the ACK

    Your result from the DB is a rowset. You need to iterate over it to get values out:

    Code:
    while (results.next()){
     var column1 = results.getInt(1); //or maybe results.getString(1);
    }
    //note that the result list is indexed by 1, not 0
    Chris Lang

    Comment

    Working...
    X