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.

Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.
Vaadin + JDBC
Hello there,
I am currently having difficulites with embedding my Java code (incl. MySQL database connection) in the Vaadin framework.
I was wondering if there is any way to use Vaadin solely with the simple JDBC API or if it is only possible with JPA, Hibernate, etc.? I only have a couple of tables with small content (233 rows, 8500 columns) and I am the only developer on this small project (Bachelor thesis).
Therefore I thought that JDBC would fit my needs just fine, but I cannot find any helpful resources on how to connect my Code with Vaadin neatly in order to write a small web interface for user interaction.
I would be so very greatful to hear from you, as no one at my working group has had experciance with Vaadin and I am worried that I might have to re-write my entire code!
Sincerely, Marie
JDBC is actually more of a standard way to access a DB in Vaadin than JPA and Hibernate is.
Just create a JDBCConnectionPool and then use TableQuery or FreeformQueries in addition with SQLContainers to access your table(s). For examples on how to it just have a look at the Book of Vaadin.
public class Pool implements Serializable {
/**
*
*/
//TODO implementar un Pool adeacuado para volumen
private static final long serialVersionUID = 1L;
JDBCConnectionPool pool;
public Pool(String Driver,String url,String user,String password) throws SQLException {
pool = new SimpleJDBCConnectionPool(Driver, url,
user, password, 2, 5);
}
public JDBCConnectionPool getPool() {
return pool;
}
}
and then in other class
public SQLExtContainer getTabla(String NombreTabla,String llave,Boolean autoCommit) throws Exception{
TableQuery tq= new TableQuery(NombreTabla, pool.getPool());
tq.setVersionColumn(llave);
SQLExtContainer sql = new SQLExtContainer(tq);
sql.setAutoCommit(autoCommit);
return sql;
}
Thank you so much for the input!
I will give it a try for sure and let you know how that went! ;-)