Important Notice - Forums is archived
To simplify things and help our users to be more productive, we have archived the current forum and focus our efforts on helping developers on Stack Overflow. You can post new questions on Stack Overflow or join our Discord channel.

TUTORIALVaadin lets you build secure, UX-first PWAs entirely in Java.
Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.
Calling javascript synchronously by Enver Haase, 1 month ago
TableQuery statement syntax
I have a method end i can not understand how to create SQL transaction
private void initContainers(){
try {
TableQuery q1 = new TableQuery("bill", connectionPool, new MSSQLGenerator());
q1.setVersionColumn("OPTLOCK");
q1.setDebug(debugMode);
personContainer = new SQLContainer(q1);
personContainer.setDebugMode(debugMode);
}
catch (SQLException e){e.printStackTrace();}
}
the Table Query create new statement DB -> SELECT * FROM (SELECT row_number() OVER ( ORDER BY "ID" ASC) AS rownum, * FROM bill) AS a WHERE a.rownum BETWEEN 0 AND 1
how to create a corect statement or call a procedure in Table Query method
Last updated on
You cannot reply to this thread.