Scribd Logo
Upload

Welcome to Scribd!

  • 2 views

    Cache Result Set

    Uploaded by

    etest2272

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd

    Cache Result Set

    Uploaded by

    etest2272
    2 views2 pages

    Original Title

    CacheResultSet

    Copyright

    © © All Rights Reserved

    Available Formats

    TXT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    2 views2 pages

    Cache Result Set

    Uploaded by

    etest2272

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    You are on page 1of 2

    /*=====================================================================

    File: CacheResultSet.java
    Summary: This Microsoft JDBC Driver for SQL Server sample application
    demonstrates how to use a result set to retrieve a large set
    of data from a SQL Server database. In addition, it
    demonstrates how to control the amount of data that is fetched
    from the database and cached on the client.
    ---------------------------------------------------------------------
    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 java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    import java.util.ArrayList;

    import com.microsoft.sqlserver.jdbc.SQLServerResultSet;

    public class CacheResultSet {

    @SuppressWarnings("serial")
    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>";

    try (Connection con = DriverManager.getConnection(connectionUrl);


    Statement stmt =
    con.createStatement(SQLServerResultSet.TYPE_SS_SERVER_CURSOR_FORWARD_ONLY,
    SQLServerResultSet.CONCUR_READ_ONLY);) {

    String SQL = "SELECT * FROM Sales.SalesOrderDetail;";

    for (int n : new ArrayList<Integer>() {


    {
    add(1);
    add(10);
    add(100);
    add(1000);
    add(0);
    }
    }) {
    // Perform a fetch for every nth row in the result set.
    try (ResultSet rs = stmt.executeQuery(SQL)) {
    timerTest(n, rs);
    }
    }
    }
    // Handle any errors that may have occurred.
    catch (SQLException e) {
    e.printStackTrace();
    }
    }

    private static void timerTest(int fetchSize,


    ResultSet rs) throws SQLException {

    // Declare the variables for tracking the row count and elapsed time.
    int rowCount = 0;
    long startTime = 0;
    long stopTime = 0;
    long runTime = 0;

    // Set the fetch size then iterate through the result set to
    // cache the data locally.
    rs.setFetchSize(fetchSize);
    startTime = System.currentTimeMillis();
    while (rs.next()) {
    rowCount++;
    }
    stopTime = System.currentTimeMillis();
    runTime = stopTime - startTime;

    // Display the results of the timer test.


    System.out.println("FETCH SIZE: " + rs.getFetchSize());
    System.out.println("ROWS PROCESSED: " + rowCount);
    System.out.println("TIME TO EXECUTE: " + runTime);
    System.out.println();
    }
    }

    You might also like