1

Mysql table is like 

CREATE TABLE `User` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `telphone` varchar(32) NOT NULL,
  `name` varchar(64) NOT NULL DEFAULT '',
  `password` varchar(64) NOT NULL DEFAULT '',
  `balance` int(11) NOT NULL DEFAULT '0',
  `user_type` int(2) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `phone_index` (`telphone`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

And the code I write is :

@Service
public class CommonDao {
    @Resource
    private DSLContext jooqContext;

    public <R extends Record> R insertAndGet(Table<R> table, R r, Field<?>... f) {
        return jooqContext.insertInto(table).set(r).returning(f).fetchOne();
    }
}

It always return null when I use the insert and get, and the data actually insert into the database. But When I delete the unique key in the mysql, It works fine.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
yunfan
  • 760
  • 1
  • 11
  • 24
  • Which version of jooq are you using? It would also be helpful if you could set a breakpoint in AbstractQuery#execute(), copy at the sql being generated and post it in your question. – Brent Douglas Jun 25 '15 at 20:18

0 Answers0