Mercurial > hg > monetdb-java
view tests/Test_PSsomeamount.java @ 423:de2ef68b672f mapihandshake
Allow to set fetchsize from the connection url
author | Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com> |
---|---|
date | Tue, 02 Feb 2021 14:21:22 +0100 (2021-02-02) |
parents | bf9f6b6ecf40 |
children |
line wrap: on
line source
/* * This Source Code Form is subject to the terms of the Mozilla Public * License, v. 2.0. If a copy of the MPL was not distributed with this * file, You can obtain one at http://mozilla.org/MPL/2.0/. * * Copyright 1997 - July 2008 CWI, August 2008 - 2021 MonetDB B.V. */ import java.sql.*; /* Create a lot of PreparedStatements, to emulate webloads such as those * from Hibernate. */ public class Test_PSsomeamount { public static void main(String[] args) throws Exception { Connection con = DriverManager.getConnection(args[0]); Statement stmt = con.createStatement(); PreparedStatement pstmt; // >> true: auto commit should be on System.out.println("0. true\t" + con.getAutoCommit()); try { System.out.println("1. Preparing and executing a unique statement"); for (int i = 0; i < 100; i++) { pstmt = con.prepareStatement("select " + i + ", " + i + " = ?"); pstmt.setInt(1, i); ResultSet rs = pstmt.executeQuery(); if (rs.next() && i % 20 == 0) { System.out.println(rs.getInt(1) + ", " + rs.getBoolean(2)); } /* this call should cause resources on the server to be * freed */ pstmt.close(); } } catch (SQLException e) { System.out.println("FAILED :( "+ e.getMessage()); System.out.println("ABORTING TEST!!!"); } stmt.close(); con.close(); } }