I'm working on eclipse with JOOQ, but on the line where I make the insert I get 'QUESTION can not resolve to variable'. The table 'question' and I have it created in mysql.
public void insertarPregunta(AbsPregunta prta){
try (java.sql.Connection conn = DriverManager.getConnection(url, userName, password))
{
DSLContext create = DSL.using(conn, SQLDialect.MYSQL);
int id = prta.getId();
String enunciado = prta.getEnunciado();
XStream xstream = new XStream();
xstream.alias("pregunta", AbsPregunta.class);
String xml = xstream.toXML(prta);
create.insertInto(PREGUNTA, PREGUNTA.ID, PREGUNTA.ENUNCIADO, PREGUNTA.OBJXML)
.values(id, enunciado, xml)
.execute();
}
catch (Exception e) {
e.printStackTrace();
}