Announcement

Collapse

Mirth Connect 4.1.0 Released!

Mirth Connect 4.1.0 is now available as an appliance update and on our GitHub page. Mirth Connect 4.1.0 includes new features such as new event log messages, additional fields to the Welcome to Mirth Connect screen, new information included in alerts as well as many smaller changes, updates, and improvements. This release also contains several improvements to commercial extensions. 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