Announcement

Collapse
No announcement yet.

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