Hello, That should be an easy one. The error is here:
DSLContext create = DSL.using(conn, SQLDialect.MYSQL); Replace the above by: DSLContext create = DSL.using(conn, SQLDialect.FIREBIRD); Hope this helps, Lukas 2015-05-01 3:08 GMT+02:00 Erick de Oliveira Leal < [email protected]>: > 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. > -- 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.
