java.sql.SQLNonTransientConnectionException

Six Stars

java.sql.SQLNonTransientConnectionException

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."

Seven Stars

Re: java.sql.SQLNonTransientConnectionException

Hi @Abhi529,

 

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 

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch