Examples with SQLServerStatement com.microsoft.sqlserver.jdbc.SQLServerStatement used on opensource projects

Example 11 with SQLServerStatement

use of com.microsoft.sqlserver.jdbc.SQLServerStatement in project mssql-jdbc by Microsoft.

the class PoolableTest method poolableTest.

/**
 * Poolable Test
 *
 * @throws SQLException
 * @throws ClassNotFoundException
 */
@Test
@DisplayName("Poolable Test")
public void poolableTest() throws SQLException, ClassNotFoundException {
    try (Connection conn = DriverManager.getConnection(connectionString);
        Statement statement = conn.createStatement()) {
        try {
            // First get the default values
            boolean isPoolable = ((SQLServerStatement) statement).isPoolable();
            assertEquals(isPoolable, false, "SQLServerStatement should not be Poolable by default");
            try (PreparedStatement prepStmt = connection.prepareStatement("select 1")) {
                isPoolable = ((SQLServerPreparedStatement) prepStmt).isPoolable();
                assertEquals(isPoolable, true, "SQLServerPreparedStatement should be Poolable by default");
            }
            try (CallableStatement callableStatement = connection.prepareCall("{  ? = CALL " + "ProcName" + " (?, ?, ?, ?) }")) {
                isPoolable = ((SQLServerCallableStatement) callableStatement).isPoolable();
                assertEquals(isPoolable, true, "SQLServerCallableStatement should be Poolable by default");
                // Now do couple of sets and gets
                ((SQLServerCallableStatement) callableStatement).setPoolable(false);
                assertEquals(((SQLServerCallableStatement) callableStatement).isPoolable(), false, "set did not work");
            }
            ((SQLServerStatement) statement).setPoolable(true);
            assertEquals(((SQLServerStatement) statement).isPoolable(), true, "set did not work");
        } catch (UnsupportedOperationException e) {
            assertEquals(System.getProperty("java.specification.version"), "1.5", "PoolableTest should be supported in anything other than 1.5");
            assertEquals(e.getMessage(), "This operation is not supported.", "Wrong exception message");
        }
    }
}