gistfile1.txt

package com.example.demolistener;

import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.List;
import java.util.Map;

@SpringBootTest
class DemolistenerApplicationTests {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Test
    void contextLoads() {
        System.out.println(jdbcTemplate.queryForList("select * from auditlog"));
        while(true){
            List<Map<String, Object>> maps =
                    jdbcTemplate.queryForList(" WAITFOR (\n" +
                            "                        RECEIVE TOP(1)  message_type_name,    \n" +
                            "                        CAST(message_body AS varchar(max)),    \n" +
                            "                        conversation_handle\n" +
                            "            FROM dbo.TestQueue )");
            System.out.println("========================");
            System.out.println(maps);
        }
    }

}