Adapting the examples from the site to My running database I got the
following error:
SQL [select `INTERNO`.`ID_INTERNO`, `INTERNO`.`NOME_INTERNO`, `INTERNO`.
`RGI` from `INTERNO`]; GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 8
`
Can someone help me?
The code that generate the error is:
public static void main(String[] args) throws Exception {
Connection conn;
conn = ConnectionFactory.getConnection();
DSLContext create = DSL.using(conn, SQLDialect.MYSQL);
Result<Record> result = create.select().from(INTERNO).fetch();
for (Record r : result) {
Integer id = r.getValue(INTERNO.ID_INTERNO);
String firstName = r.getValue(INTERNO.NOME_INTERNO);
Integer lastName = r.getValue(INTERNO.ID_UP);
System.out.println("ID: " + id + " first name: " + firstName
+ " last name: " + lastName);
}
}
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
