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

Example 1 with SQLServerXADataSource

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

the class PoolingTest method testConnectionPoolReget.

@Test
public void testConnectionPoolReget() throws SQLException {
    SQLServerXADataSource ds = new SQLServerXADataSource();
    ds.setURL(connectionString);
    PooledConnection pc = ds.getPooledConnection();
    Connection con = pc.getConnection();
    // now reget a connection
    Connection con2 = pc.getConnection();
    // assert that the first connection is closed.
    assertTrue(con.isClosed(), "First connection is not closed");
}

Example 2 with SQLServerXADataSource

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

the class PoolingTest method testConnectionPoolConnFunctions.

@Test
public void testConnectionPoolConnFunctions() throws SQLException {
    String tableName = RandomUtil.getIdentifier("table");
    tableName = DBTable.escapeIdentifier(tableName);
    String sql1 = "if exists (select * from dbo.sysobjects where name = '" + tableName + "' and type = 'U')\n" + "drop table " + tableName + "\n" + "create table " + tableName + "\n" + "(\n" + "wibble_id int primary key not null,\n" + "counter int null\n" + ");";
    String sql2 = "if exists (select * from dbo.sysobjects where name = '" + tableName + "' and type = 'U')\n" + "drop table " + tableName + "\n";
    SQLServerXADataSource ds = new SQLServerXADataSource();
    ds.setURL(connectionString);
    PooledConnection pc = ds.getPooledConnection();
    try (Connection con = pc.getConnection();
        Statement statement = con.createStatement()) {
        statement.execute(sql1);
        statement.execute(sql2);
        con.clearWarnings();
    }
    pc.close();
}

Example 3 with SQLServerXADataSource

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

the class PoolingTest method testConnectionPoolClientConnectionId.

@Test
public void testConnectionPoolClientConnectionId() throws SQLException {
    SQLServerXADataSource ds = new SQLServerXADataSource();
    ds.setURL(connectionString);
    PooledConnection pc = ds.getPooledConnection();
    ISQLServerConnection con = (ISQLServerConnection) pc.getConnection();
    UUID Id1 = con.getClientConnectionId();
    assertTrue(Id1 != null, "Unexecepted: ClientConnectionId is null from Pool");
    con.close();
    // now reget the connection
    ISQLServerConnection con2 = (ISQLServerConnection) pc.getConnection();
    UUID Id2 = con2.getClientConnectionId();
    con2.close();
    assertEquals(Id1, Id2, "ClientConnection Ids from pool are not the same.");
}

Example 4 with SQLServerXADataSource

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

the class PoolingTest method testPooling.

@Test
public void testPooling() throws SQLException {
    assumeTrue(!DBConnection.isSqlAzure(DriverManager.getConnection(connectionString)), "Skipping test case on Azure SQL.");
    String randomTableName = RandomUtil.getIdentifier("table");
    // make the table a temporary table (will be created in tempdb database)
    String tempTableName = "#" + randomTableName;
    SQLServerXADataSource XADataSource1 = new SQLServerXADataSource();
    XADataSource1.setURL(connectionString);
    XADataSource1.setDatabaseName("tempdb");
    PooledConnection pc = XADataSource1.getPooledConnection();
    try (Connection conn = pc.getConnection()) {
        // create table in tempdb database
        conn.createStatement().execute("create table [" + tempTableName + "] (myid int)");
        conn.createStatement().execute("insert into [" + tempTableName + "] values (1)");
    }
    boolean tempTableFileRemoved = false;
    try (Connection conn = pc.getConnection()) {
        conn.createStatement().executeQuery("select * from [" + tempTableName + "]");
    } catch (SQLException e) {
        // make sure the temporary table is not found.
        if (e.getMessage().startsWith("Invalid object name")) {
            tempTableFileRemoved = true;
        }
    }
    assertTrue(tempTableFileRemoved, "Temporary table is not removed.");
}

Example 5 with SQLServerXADataSource

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

the class PoolingTest method testConnectionPoolClose.

@Test
public void testConnectionPoolClose() throws SQLException {
    SQLServerXADataSource ds = new SQLServerXADataSource();
    ds.setURL(connectionString);
    PooledConnection pc = ds.getPooledConnection();
    Connection con = pc.getConnection();
    pc.close();
    // assert that the first connection is closed.
    assertTrue(con.isClosed(), "Connection is not closed with pool close");
}