Before the recent update, I was able to populate my grid with data from an Azure database and display it in my app. As some of the commands have changed, I have adapted my code and also have a separate class with getters, setters and a constructor but now it is only displaying header and the box for the grid (no headers or data content). I have checked connection string and naming in all places, password is also in place in my code and have tested it works in app created before the update. Can anybody see what is wrong?
public class MainView extends VerticalLayout {
private static final long serialVersionUID = 1L;
Connection connection = null;
public MainView() {
Grid<Service> grid = new Grid<>();
String connectionString = "jdbc:sqlserver://rtqa-sql-webapp-db.database.windows.net:1433;database=RTQA-DB;user=RTQAdbAdmin@rtqa-sql-webapp-db;password=***********;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;";
final VerticalLayout layout = new VerticalLayout();
try
{
connection = DriverManager.getConnection(connectionString);
ResultSet rs = connection.createStatement().executeQuery("SELECT * FROM Service;");
List<Service> serviceList = new ArrayList<Service>();
while(rs.next())
{
serviceList.add(new Service(rs.getLong("Service_Id"),
rs.getString("Machine_Name"),
rs.getDouble("Output")));
}
//Create grid
grid.setItems(serviceList);
grid.setColumns("serviceId", "machineName", "output");
grid.addColumn(Service::getServiceId).setHeader("Service Id");
grid.addColumn(Service::getMachineName).setHeader("Machine Name");
grid.addColumn(Service::getOutput).setHeader("Output");
}
catch(Exception e) {
layout.addComponentAsFirst(new Label(e.getMessage()));
}
setContent(layout, grid);
}
private void setContent(VerticalLayout layout, Grid<Service> grid) {
}
}