@BeforeEach
    void initialize() throws Exception {
        val props = casProperties.getAuthn().getJdbc().getQuery().getFirst();
        val dataSource = JpaBeans.newDataSource(props.getDriverClass(), props.getUser(),
            props.getPassword(), props.getUrl());

        try (val connection = dataSource.getConnection()) {
            try (val statement = connection.createStatement()) {
                connection.setAutoCommit(true);
                statement.execute("CREATE TABLE IF NOT EXISTS users (id INT NOT NULL, uid VARCHAR(50), psw VARCHAR(512));");
                statement.execute("INSERT INTO users VALUES (1, 'casuser', '" + DigestUtils.sha256("Mellon") + "');");
            }
        }
    }
This is {@link CasJdbcAuthenticationConfigurationTests}.

@author Misagh Moayyed
@since 6.2.0
support/cas-server-support-jdbc/src/test/java/org/apereo/cas/jdbc/CasJdbcAuthenticationConfigurationTests.java