Insert error in JOOQ SQL?

1

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();
    }

    
asked by Julian muñoz 08.06.2016 в 07:45
source

1 answer

0

It was an import error, I had to add this line.

import static com.pretech.jooq.tables.Pregunta.PREGUNTA;
    
answered by 08.06.2016 в 11:50