SimpleConnectionITest

all > org.itsallcode.jdbc > SimpleConnectionITest
27

tests
0

failures
0

ignored
0.184s

duration
100%

successful

Tests

Test Method name Duration Result
batchInsert() batchInsert() 0.007s passed
batchInsertEmptyInput() batchInsertEmptyInput() 0.005s passed
batchStatement() batchStatement() 0.005s passed
batchUpdate() batchUpdate() 0.013s passed
directBatchUpdate() directBatchUpdate() 0.008s passed
executeQueryEmptyResult() executeQueryEmptyResult() 0.005s passed
executeQueryFails() executeQueryFails() 0.002s passed
executeQueryOnlyOneIteratorAllowed() executeQueryOnlyOneIteratorAllowed() 0.008s passed
executeQuerySingleRow() executeQuerySingleRow() 0.029s passed
[1] type+label-lowercase, org.itsallcode.jdbc.SimpleConnectionITest$$Lambda$751/0x00007f4b383e4690@30ae6721 executeQueryWithCustomRowMapper(String, RowMapper)[1] 0.009s passed
[2] type+label-uppercase, org.itsallcode.jdbc.SimpleConnectionITest$$Lambda$752/0x00007f4b383e48b0@4aa4bfa1 executeQueryWithCustomRowMapper(String, RowMapper)[2] 0.003s passed
[3] type+index, org.itsallcode.jdbc.SimpleConnectionITest$$Lambda$753/0x00007f4b383e4ad0@361a618e executeQueryWithCustomRowMapper(String, RowMapper)[3] 0.005s passed
[4] generic+label-lowercase, org.itsallcode.jdbc.SimpleConnectionITest$$Lambda$754/0x00007f4b383e4cf0@500e995b executeQueryWithCustomRowMapper(String, RowMapper)[4] 0.003s passed
[5] generic+label-uppercase, org.itsallcode.jdbc.SimpleConnectionITest$$Lambda$755/0x00007f4b383e4f10@3459ccd9 executeQueryWithCustomRowMapper(String, RowMapper)[5] 0.002s passed
[6] generic+index, org.itsallcode.jdbc.SimpleConnectionITest$$Lambda$756/0x00007f4b383e5130@93fb20b executeQueryWithCustomRowMapper(String, RowMapper)[6] 0.003s passed
[7] specific type+label-lowercase, org.itsallcode.jdbc.SimpleConnectionITest$$Lambda$757/0x00007f4b383e5350@670e6fa3 executeQueryWithCustomRowMapper(String, RowMapper)[7] 0.005s passed
[8] specific type+label-uppercase, org.itsallcode.jdbc.SimpleConnectionITest$$Lambda$758/0x00007f4b383e5570@62a89e92 executeQueryWithCustomRowMapper(String, RowMapper)[8] 0.003s passed
[9] specific type+index, org.itsallcode.jdbc.SimpleConnectionITest$$Lambda$759/0x00007f4b383e5790@1fcef7 executeQueryWithCustomRowMapper(String, RowMapper)[9] 0.004s passed
executeQueryWithGenericRowMapper() executeQueryWithGenericRowMapper() 0.007s passed
executeQueryWithParameter() executeQueryWithParameter() 0.006s passed
executeScript() executeScript() 0.004s passed
executeStatement() executeStatement() 0.009s passed
executeStatementFails() executeStatementFails() 0.002s passed
executeStatementWithParameter() executeStatementWithParameter() 0.005s passed
insert() insert() 0.012s passed
multipleTransactions() multipleTransactions() 0.018s passed
wrap() wrap() 0.002s passed

Standard error

2025-01-18 18:22:16.779 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 2 after 2 took 5 ms 
2025-01-18 18:22:16.780 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 2 items with batch size 200000 completed in PT0.006399517S 
2025-01-18 18:22:16.780 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select * from test'... 
2025-01-18 18:22:16.806 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 1 after 1 took 0 ms 
2025-01-18 18:22:16.807 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 1 items with batch size 200000 completed in PT0.00127695S 
2025-01-18 18:22:16.808 [FINEST ] org.itsallcode.jdbc.batch.PreparedStatementBatchBuilder build Running insert statement 'insert into "TEST" ("ID","NAME") values (?,?)'... 
2025-01-18 18:22:16.810 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 3 after 3 took 0 ms 
2025-01-18 18:22:16.810 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 3 items with batch size 200000 completed in PT0.001478624S 
2025-01-18 18:22:16.811 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch No items added to batch, skip 
2025-01-18 18:22:16.811 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 3 items with batch size 200000 completed in PT0.002121467S 
2025-01-18 18:22:16.811 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select * from test'... 
2025-01-18 18:22:16.819 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select count(*) from test'... 
2025-01-18 18:22:16.828 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 1 after 1 took 0 ms 
2025-01-18 18:22:16.829 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 1 items with batch size 200000 completed in PT0.000873862S 
2025-01-18 18:22:16.830 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select count(*) from test'... 
2025-01-18 18:22:16.836 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select count(*) from test'... 
2025-01-18 18:22:16.840 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select count(*) from test'... 
2025-01-18 18:22:16.841 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select count(*) from test'... 
2025-01-18 18:22:16.847 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 1 after 1 took 0 ms 
2025-01-18 18:22:16.848 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 1 items with batch size 200000 completed in PT0.001033154S 
2025-01-18 18:22:16.848 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select * from test'... 
2025-01-18 18:22:16.853 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 1 after 1 took 0 ms 
2025-01-18 18:22:16.854 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 1 items with batch size 200000 completed in PT0.001002069S 
2025-01-18 18:22:16.854 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select * from test'... 
2025-01-18 18:22:16.862 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 1 after 1 took 0 ms 
2025-01-18 18:22:16.863 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 1 items with batch size 200000 completed in PT0.001371269S 
2025-01-18 18:22:16.863 [FINEST ] org.itsallcode.jdbc.batch.PreparedStatementBatchBuilder build Running insert statement 'insert into "TEST" ("ID","NAME") values (?,?)'... 
2025-01-18 18:22:16.864 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 3 after 3 took 0 ms 
2025-01-18 18:22:16.864 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 3 items with batch size 200000 completed in PT0.000671826S 
2025-01-18 18:22:16.864 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch No items added to batch, skip 
2025-01-18 18:22:16.865 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 3 items with batch size 200000 completed in PT0.001091415S 
2025-01-18 18:22:16.865 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select count(*) from test'... 
2025-01-18 18:22:16.872 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 1 after 1 took 0 ms 
2025-01-18 18:22:16.872 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 1 items with batch size 200000 completed in PT0.000821475S 
2025-01-18 18:22:16.872 [FINEST ] org.itsallcode.jdbc.batch.PreparedStatementBatchBuilder build Running insert statement 'insert into "TEST" ("ID","NAME") values (?,?)'... 
2025-01-18 18:22:16.873 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 3 after 3 took 0 ms 
2025-01-18 18:22:16.874 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 3 items with batch size 200000 completed in PT0.000982003S 
2025-01-18 18:22:16.874 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch No items added to batch, skip 
2025-01-18 18:22:16.874 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 3 items with batch size 200000 completed in PT0.001738367S 
2025-01-18 18:22:16.875 [FINEST ] org.itsallcode.jdbc.batch.PreparedStatementBatchBuilder build Running insert statement 'UPDATE TEST SET NAME = ? WHERE ID = ?'... 
2025-01-18 18:22:16.879 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 3 after 3 took 0 ms 
2025-01-18 18:22:16.879 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 3 items with batch size 200000 completed in PT0.001287429S 
2025-01-18 18:22:16.880 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch No items added to batch, skip 
2025-01-18 18:22:16.880 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 3 items with batch size 200000 completed in PT0.001842509S 
2025-01-18 18:22:16.880 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select * from test'... 
2025-01-18 18:22:16.886 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select count(*) from test'... 
2025-01-18 18:22:16.888 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select count(*) from missing_table'... 
2025-01-18 18:22:16.892 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select * from test where id=?'... 
2025-01-18 18:22:16.898 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 3 after 3 took 0 ms 
2025-01-18 18:22:16.899 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 2 after 5 took 0 ms 
2025-01-18 18:22:16.899 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 5 items with batch size 3 completed in PT0.001829065S 
2025-01-18 18:22:16.899 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select count(*) from test'... 
2025-01-18 18:22:16.904 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 1 after 1 took 0 ms 
2025-01-18 18:22:16.904 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 1 items with batch size 200000 completed in PT0.000901743S 
2025-01-18 18:22:16.904 [FINEST ] org.itsallcode.jdbc.batch.PreparedStatementBatchBuilder build Running insert statement 'insert into "TEST" ("ID","NAME") values (?,?)'... 
2025-01-18 18:22:16.905 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch No items added to batch, skip 
2025-01-18 18:22:16.905 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 0 items with batch size 200000 completed in PT0.000191576S 
2025-01-18 18:22:16.905 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch No items added to batch, skip 
2025-01-18 18:22:16.905 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 0 items with batch size 200000 completed in PT0.000635089S 
2025-01-18 18:22:16.906 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select * from test'... 
2025-01-18 18:22:16.909 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 2 after 2 took 0 ms 
2025-01-18 18:22:16.910 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 2 items with batch size 200000 completed in PT0.000974027S 
2025-01-18 18:22:16.910 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select count(*) from test'... 
2025-01-18 18:22:16.914 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 1 after 1 took 0 ms 
2025-01-18 18:22:16.914 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 1 items with batch size 200000 completed in PT0.000681615S 
2025-01-18 18:22:16.914 [FINEST ] org.itsallcode.jdbc.batch.PreparedStatementBatchBuilder build Running insert statement 'insert into "TEST" ("ID","NAME") values (?,?)'... 
2025-01-18 18:22:16.915 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 3 after 3 took 0 ms 
2025-01-18 18:22:16.915 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 3 items with batch size 200000 completed in PT0.000606706S 
2025-01-18 18:22:16.915 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch No items added to batch, skip 
2025-01-18 18:22:16.916 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 3 items with batch size 200000 completed in PT0.001032757S 
2025-01-18 18:22:16.916 [FINEST ] org.itsallcode.jdbc.batch.PreparedStatementBatchBuilder build Running insert statement 'UPDATE TEST SET NAME = ? WHERE ID = ?'... 
2025-01-18 18:22:16.918 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 3 after 3 took 0 ms 
2025-01-18 18:22:16.918 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 3 items with batch size 200000 completed in PT0.001499834S 
2025-01-18 18:22:16.918 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select * from test'... 
2025-01-18 18:22:16.925 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select t.* from (values (1, 'a'), (2, 'b'), (3, 'c')) as t(id, name)'... 
2025-01-18 18:22:16.934 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select t.* from (values (1, 'a'), (2, 'b'), (3, 'c')) as t(id, name)'... 
2025-01-18 18:22:16.937 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select t.* from (values (1, 'a'), (2, 'b'), (3, 'c')) as t(id, name)'... 
2025-01-18 18:22:16.943 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select t.* from (values (1, 'a'), (2, 'b'), (3, 'c')) as t(id, name)'... 
2025-01-18 18:22:16.947 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select t.* from (values (1, 'a'), (2, 'b'), (3, 'c')) as t(id, name)'... 
2025-01-18 18:22:16.950 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select t.* from (values (1, 'a'), (2, 'b'), (3, 'c')) as t(id, name)'... 
2025-01-18 18:22:16.953 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select t.* from (values (1, 'a'), (2, 'b'), (3, 'c')) as t(id, name)'... 
2025-01-18 18:22:16.958 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select t.* from (values (1, 'a'), (2, 'b'), (3, 'c')) as t(id, name)'... 
2025-01-18 18:22:16.963 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select t.* from (values (1, 'a'), (2, 'b'), (3, 'c')) as t(id, name)'... 
2025-01-18 18:22:16.969 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select count(*) from test'... 
2025-01-18 18:22:16.974 [FINEST ] org.itsallcode.jdbc.batch.Batch executeBatch Execute batch of 2 after 2 took 0 ms 
2025-01-18 18:22:16.974 [FINE   ] org.itsallcode.jdbc.batch.Batch close Batch processing of 2 items with batch size 200000 completed in PT0.001249119S 
2025-01-18 18:22:16.976 [FINEST ] org.itsallcode.jdbc.ConnectionWrapper query Executing query 'select count(*) as result from test'...