<div>
But wouldn't the prepared statement require me to loop through the result set record-by-record still? &nbsp;I was hoping for some sort of more direct &quot;bulk&quot; method.
</div>


But wouldn't the prepared statement require me to loop through the result set record-by-record still?  I was hoping for some sort of more direct "bulk" method.

<div>
Well that's how cursors work. Are you talking about Access by any chance?
</div>


Well that's how cursors work. Are you talking about Access by any chance?

<div>
Sure enough, using the RDBMS's &quot;INSERT INTO&quot; statement I was able to insert to an external database, and it was quite fast.
</div>


Sure enough, using the RDBMS's "INSERT INTO" statement I was able to insert to an external database, and it was quite fast.

<div>
<div class="content wysiwyg-content">
Pretty straightforward:<br />
<br />
I have two different connections to two different databases, and I need to find the absolute fastest way to move the data from a table in connection 1 to an identical table in connection 2. &nbsp;<br />
<br />
I'm hoping I don't have to go row-by-row with a bajillion &quot;UPDATE&quot; calls to do this.
</div>
</div>


Pretty straightforward:

I have two different connections to two different databases, and I need to find the absolute fastest way to move the data from a table in connection 1 to an identical table in connection 2.  

I'm hoping I don't have to go row-by-row with a bajillion "UPDATE" calls to do this.

Java - Fastest way to copy resultset?

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.