Sending results from a Database query as the ACK

[hsingh00]

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

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

[chrisl]

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:

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