// I assume test_val will never be ' '
ResultSet r = select.executeQuery ("SELECT test_val FROM test");

##</code><code>##

// My code turns ' ' to NULL now
ResultSet r = select.executeQuery ("SELECT rtrim(test_val) FROM test");