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!
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.
/**
*
*/
//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;
}
