/*=====================================================================
File: [Link]
Summary: This Microsoft JDBC Driver for SQL Server sample application
demonstrates how to read the large data from a database and
how to get the adaptive buffering mode. It also demonstrates
how to retrieve a large single-column value from a SQL Server
database by using the getCharacterStream method.
---------------------------------------------------------------------
This file is part of the Microsoft JDBC Driver for SQL Server Code Samples.
Copyright (C) Microsoft Corporation. All rights reserved.
This source code is intended only as a supplement to Microsoft
Development Tools and/or on-line documentation. See these other
materials for detailed information regarding Microsoft code samples.
THIS CODE AND INFORMATION ARE PROVIDED "AS IS" WITHOUT WARRANTY OF
ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO
THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A
PARTICULAR PURPOSE.
=====================================================================*/
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class ReadLargeData {
public static void main(String[] args) {
// Create a variable for the connection string.
String connectionUrl =
"jdbc:sqlserver://<server>:<port>;databaseName=AdventureWorks;user=<user>;password=
<password>";
// Create test data as an example.
StringBuffer buffer = new StringBuffer(4000);
for (int i = 0; i < 4000; i++)
[Link]((char) ('A'));
try (Connection con = [Link](connectionUrl);
Statement stmt = [Link]();
PreparedStatement pstmt = [Link]("UPDATE
[Link] SET DocumentSummary = ? WHERE (DocumentID = 1)");) {
[Link](1, [Link]());
[Link]();
// In adaptive mode, the application does not have to use a server
cursor
// to avoid OutOfMemoryError when the SELECT statement produces very
large
// results.
// Create and execute an SQL statement that returns some data.
String SQL = "SELECT Title, DocumentSummary FROM [Link]";
// Display the response buffering mode.
SQLServerStatement SQLstmt = (SQLServerStatement) stmt;
[Link]("Response buffering mode is: " +
[Link]());
[Link]();
// Get the updated data from the database and display it.
ResultSet rs = [Link](SQL);
while ([Link]()) {
Reader reader = [Link](2);
if (reader != null) {
char output[] = new char[40];
while ([Link](output) != -1) {
// Do something with the chunk of the data that was
// read.
}
[Link]([Link](1) + " has been accessed for
the summary column.");
// Close the stream.
[Link]();
}
}
}
// Handle any errors that may have occurred.
catch (Exception e) {
[Link]();
}
}
}
