@Test public void testExecuteUpdateWithCreateTable() throws Exception { try (Connection connection = createConnection("blackhole", "blackhole")) { try (Statement statement = connection.createStatement()) { assertEquals(statement.executeUpdate("CREATE TABLE test_execute_create (x bigint)"), 0); assertNull(statement.getResultSet()); assertEquals(statement.getUpdateCount(), 0); assertEquals(statement.getLargeUpdateCount(), 0); } } }
@Test public void testGetUpdateCount() throws Exception { try (Connection connection = createConnection()) { try (Statement statement = connection.createStatement()) { assertTrue(statement.execute("SELECT 123 x, 'foo' y")); assertEquals(statement.getUpdateCount(), -1); assertEquals(statement.getLargeUpdateCount(), -1); } } }
@Test public void testExecuteUpdateWithInsert() throws Exception { try (Connection connection = createConnection("blackhole", "blackhole")) { try (Statement statement = connection.createStatement()) { assertEquals(statement.executeUpdate("INSERT INTO test_table VALUES (1), (2)"), 2); assertNull(statement.getResultSet()); assertEquals(statement.getUpdateCount(), 2); assertEquals(statement.getLargeUpdateCount(), 2); } } }
@Test public void testStatementReuse() throws Exception { try (Connection connection = createConnection("blackhole", "blackhole")) { try (Statement statement = connection.createStatement()) { // update statement assertFalse(statement.execute("INSERT INTO test_table VALUES (1), (2)")); assertNull(statement.getResultSet()); assertEquals(statement.getUpdateCount(), 2); assertEquals(statement.getLargeUpdateCount(), 2); // query statement assertTrue(statement.execute("SELECT 123 x, 'foo' y, CAST(NULL AS bigint) z")); ResultSet resultSet = statement.getResultSet(); assertNotNull(resultSet); assertEquals(statement.getUpdateCount(), -1); assertEquals(statement.getLargeUpdateCount(), -1); resultSet.close(); // update statement assertFalse(statement.execute("INSERT INTO test_table VALUES (1), (2), (3)")); assertNull(statement.getResultSet()); assertEquals(statement.getUpdateCount(), 3); assertEquals(statement.getLargeUpdateCount(), 3); } } }
@Test public void testExecuteWithQuery() throws Exception { try (Connection connection = createConnection()) { try (Statement statement = connection.createStatement()) { assertTrue(statement.execute("SELECT 123 x, 'foo' y, CAST(NULL AS bigint) z")); ResultSet rs = statement.getResultSet(); assertEquals(statement.getUpdateCount(), -1); assertEquals(statement.getLargeUpdateCount(), -1); assertTrue(rs.next()); assertEquals(rs.getLong(1), 123); assertFalse(rs.wasNull()); assertEquals(rs.getLong("x"), 123); assertFalse(rs.wasNull()); assertEquals(rs.getLong(3), 0); assertTrue(rs.wasNull()); assertEquals(rs.getLong("z"), 0); assertTrue(rs.wasNull()); assertNull(rs.getObject("z")); assertTrue(rs.wasNull()); assertEquals(rs.getString(2), "foo"); assertFalse(rs.wasNull()); assertEquals(rs.getString("y"), "foo"); assertFalse(rs.wasNull()); assertFalse(rs.next()); } } }
results = ImmutableList.of(ImmutableList.of(limitedStatement.getLargeUpdateCount()));
@Test @TestForIssue( jiraKey = "HHH-11308" ) public void testJdbc42() { doInHibernate( this::sessionFactory, session -> { for ( int i = 0; i < 5; i++ ) { IrrelevantEntity entity = new IrrelevantEntity(); entity.setName( getClass().getName() ); session.persist( entity ); } session.flush(); session.doWork( connection -> { try( Statement statement = connection.createStatement()) { statement.executeUpdate( "DELETE FROM IrrelevantEntity" ); assertEquals( 5, statement.getLargeUpdateCount()); } } ); } ); }
@Override public long getLargeUpdateCount() throws SQLException { return statement.getLargeUpdateCount(); }
@Override public long getLargeUpdateCount() throws SQLException { return statement.getLargeUpdateCount(); }
@Override public long getLargeUpdateCount() throws SQLException { long x = statement.getLargeUpdateCount(); logger.logf(level, "%s.getLargeUpdateCount() = %s", statementID, x); return x; }
@Override public long getLargeUpdateCount() throws SQLException { if (isClosed()) throw new SQLException(MSG_STATEMENT_CLOSED); return st.getLargeUpdateCount(); } // --- End JDBC 4.2 ---
/** * {@inheritDoc} */ @Override public long getLargeUpdateCount() throws SQLException { try { return delegator.getLargeUpdateCount(); } catch (SQLException se) { owner.fireConnectionError(se); throw se; } }
/** * @since 2.5.0 */ @Override public long getLargeUpdateCount() throws SQLException { checkOpen(); try { return statement.getLargeUpdateCount(); } catch (final SQLException e) { handleException(e); return 0; } }
/** * @since 2.5.0 */ @Override public long getLargeUpdateCount() throws SQLException { checkOpen(); try { return statement.getLargeUpdateCount(); } catch (final SQLException e) { handleException(e); return 0; } }
@Test public void testGetUpdateCount() throws Exception { try (Connection connection = createConnection()) { try (Statement statement = connection.createStatement()) { assertTrue(statement.execute("SELECT 123 x, 'foo' y")); assertEquals(statement.getUpdateCount(), -1); assertEquals(statement.getLargeUpdateCount(), -1); } } }
@Test public void testGetUpdateCount() throws Exception { try (Connection connection = createConnection()) { try (Statement statement = connection.createStatement()) { assertTrue(statement.execute("SELECT 123 x, 'foo' y")); assertEquals(statement.getUpdateCount(), -1); assertEquals(statement.getLargeUpdateCount(), -1); } } }
@Test public void testExecuteUpdateWithCreateTable() throws Exception { try (Connection connection = createConnection("blackhole", "blackhole")) { try (Statement statement = connection.createStatement()) { assertEquals(statement.executeUpdate("CREATE TABLE test_execute_create (x bigint)"), 0); assertNull(statement.getResultSet()); assertEquals(statement.getUpdateCount(), 0); assertEquals(statement.getLargeUpdateCount(), 0); } } }
@Test public void testExecuteUpdateWithCreateTable() throws Exception { try (Connection connection = createConnection("blackhole", "blackhole")) { try (Statement statement = connection.createStatement()) { assertEquals(statement.executeUpdate("CREATE TABLE test_execute_create (x bigint)"), 0); assertNull(statement.getResultSet()); assertEquals(statement.getUpdateCount(), 0); assertEquals(statement.getLargeUpdateCount(), 0); } } }
@Test public void testExecuteUpdateWithCreateTable() throws Exception { try (Connection connection = createConnection("blackhole", "blackhole")) { try (Statement statement = connection.createStatement()) { assertEquals(statement.executeUpdate("CREATE TABLE test_execute_create (x bigint)"), 0); assertNull(statement.getResultSet()); assertEquals(statement.getUpdateCount(), 0); assertEquals(statement.getLargeUpdateCount(), 0); } } }
@Test public void testGetUpdateCount() throws Exception { try (Connection connection = createConnection()) { try (Statement statement = connection.createStatement()) { assertTrue(statement.execute("SELECT 123 x, 'foo' y")); assertEquals(statement.getUpdateCount(), -1); assertEquals(statement.getLargeUpdateCount(), -1); } } }