I use Cachemate with a Palm TX, but I don't tansfer with hotsync. Windows Vista didn't like hotsync. I think that's been fixed now, but I still don't hotsync.
My method is this:
First, I use GSAK to export my query to a Cachemate file. Then, I unplug the SD card from the Palm and plug it into my computer. Next, I copy the cachemate file to the SD card and then plug it back into the Palm.