String query = "select case when testentity0_.id is not null then trim(BOTH" +
" from (?||?)) else testentity0_.name end as col_0_0_, trim(BOTH from (?||?)) as col_1_0_"
+ " from TEST_HHH_10848 testentity0_";
final PreparedStatement preparedStatement = connection.prepareStatement( query );
try {
preparedStatement.setString( 1, "." );
preparedStatement.setString( 2, "Test " );
preparedStatement.setString( 3, "." );
preparedStatement.setString( 4, "Test " );
final ResultSet resultSet = preparedStatement.executeQuery();
try {
resultSet.next();
final String result1 = resultSet.getString( 1 );
assertThat( result1.length(), is( 5 ) );
}
finally {
resultSet.close();
}
}
finally {
preparedStatement.close();
}