Thank you very much for the feedback and for the nice words. Glad you're liking it.
Cheers, Lukas 2015-11-27 11:16 GMT+01:00 Sascha P. <[email protected]>: > Hi Lukas, > > you're right. > > ctx = DSL.using(ds, SQLDialect.MARIADB); > > It was a copy & paste error. Sorry for noise. > > By the way, i love the concept of jooq! It is a realy great product > > cheers > MrPeacock > > Am Freitag, 27. November 2015 10:29:06 UTC+1 schrieb Lukas Eder: >> >> Hi MrPeacock >> >> You seem to be using the MySQL dialect for SQLite: The backticks are >> usually only used in MySQL and MariaDB. >> Apart from that, SQLite doesn't really support case-sensitive >> table/column names. jOOQ only quotes reserved words and names with special >> characters, by default, for SQLite. >> >> That probably explains the exception. >> >> Cheers, >> Lukas >> >> 2015-11-27 10:11 GMT+01:00 Sascha P. <[email protected]>: >> >>> Hello List, >>> >>> >>> i've some trouble with updating POJOs. Inserting POJOs with DAO works >>> like a charm. E.g.: >>> >>> >>> Users users = new Users(); >>> >>> users.setName(name); >>> >>> ... >>> >>> dao.insert(users); >>> >>> >>> but if i want to Update an existing record then an excepiton is thrown... >>> >>> >>> >>> org.jooq.exception.DataAccessException: SQL [update `users` set >>> `users`.`name` = ?, `users`.`private_key` = ?, `users`.`public_key` = ? >>> where `users`.`id` = ?]; [SQLITE_ERROR] SQL error or missing database (near >>> ".": syntax error) >>> >>> at org.jooq.impl.Utils.translate(Utils.java:1690) >>> >>> at >>> org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:660) >>> >>> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:356) >>> >>> at >>> org.jooq.impl.UpdatableRecordImpl.storeUpdate0(UpdatableRecordImpl.java:240) >>> >>> at >>> org.jooq.impl.UpdatableRecordImpl.access$100(UpdatableRecordImpl.java:85) >>> >>> at >>> org.jooq.impl.UpdatableRecordImpl$2.operate(UpdatableRecordImpl.java:199) >>> >>> at org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:128) >>> >>> at >>> org.jooq.impl.UpdatableRecordImpl.storeUpdate(UpdatableRecordImpl.java:195) >>> >>> at org.jooq.impl.UpdatableRecordImpl.update(UpdatableRecordImpl.java:150) >>> >>> at org.jooq.impl.UpdatableRecordImpl.update(UpdatableRecordImpl.java:145) >>> >>> at org.jooq.impl.DAOImpl.update(DAOImpl.java:188) >>> >>> at org.jooq.impl.DAOImpl.update(DAOImpl.java:167) >>> >>> at >>> >>> ... >>> >>> >>> using this code >>> >>> >>> Users user = dao.fetchByName(name).get(0); >>> >>> user.setPrivateKey(privateKey); >>> >>> dao.update(user); >>> >>> >>> Any hints whats wrong? >>> >>> >>> I am using SQLite 3.8.11.2 and Jooq 3.7.1 >>> >>> >>> Cheers >>> >>> MrPeacock >>> >>> -- >>> 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. > -- 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.
