How to fix the following Exception in Talend:
"cannot execute because the driver has not finished reading the current open ResultSet. The driver cannot finish reading the current ResultSet because its buffer (8192 bytes) is full. The current ResultSet must be fully iterated through or closed before another statement can execute."
You may have to split the load to get this working.
If your source and target are same servers(same DB software in the same physical/virtual machine), you may try using ELT components