Limitation on number of records for JDBC adapter services

Is there a limitation on the number of records that can be selected/inserted using JDBC adapter services? Is there a fixed number of records, exceeding which, the service would fail?

Thanks in advance!

Most likely you will be limited by the JVM memory and any constraints imposed by the JDBC driver being used. It is likely to be an overall byte size limit rather than a record count limit.

Thank you reamon.