public static void main(String[] args) throws Exception {
ConnectionManager mysqlCM =
ConnectionManagerProvider.createConnectionManager(
"adbcj:mysqlnetty://localhost/adbcjtck", "adbcjtck", "adbcjtck");
ConnectionManager pgCM =
ConnectionManagerProvider.createConnectionManager(
"adbcj:postgresql-netty://localhost/adbcjtck", "adbcjtck", "adbcjtck");
Connection mysql = mysqlCM.connect().getUninterruptably();
Connection pg = pgCM.connect().getUninterruptably();
final String insertTemplate = "INSERT INTO large (a, b, c) VALUES ('%s', '%s', '%s')";
for (int i = 0; i < 998; i++) {
String a = randString();
String b = randString();
String c = randString();
final String insert = String.format(insertTemplate, a, b, c);
mysql.executeUpdate(insert).get();
pg.executeUpdate(insert).get();
}
// mysql.close(false).get();
// pg.close(false).get();
// mysqlCM.close(true);
// pgCM.close(true);
}
@Test
public void closesPreparedStatements() throws InterruptedException {
final ConnectionManager connectionManager =
ConnectionManagerProvider.createConnectionManager(
"adbcj:pooled:mock:database", "sa", "pwd");
final MockConnectionManager mockFactory =
MockConnectionFactory.lastInstanceRequestedOnThisThread();
final Connection connection = connectionManager.connect().get();
connection.beginTransaction();
final MockConnection mockConnection = mockFactory.lastInstanceRequestedOnThisThread();
mockConnection.assertTransactionState(TransactionState.ACTIVE);
connection.close();
mockConnection.assertTransactionState(TransactionState.ROLLED_BACK);
}