MyBatis Handling Oracle Auto-increment issues (via triggers)

1. Create a sequence statement in Oracle and execute:

CreateSequence user_seq start with 1 increment by 1;

Create a trigger statement in Oracle and execute:

Create or Replace trigger User_triggerbefore insert on tb_userfor all Rowbegin select User_seq.nextval into:new.id from Dual End;

2. Then insert a record in MyBatis's mapper configuration file without specifying an ID

<?xml version= "1.0" encoding= "UTF-8"?> <! DOCTYPE Mapper Public "-//mybatis.org//dtd mapper 3.0//en" "Http://mybatis.org/dtd/mybatis-3-mapper.dtd" > <map Per namespace= "Com.cn.mapper.UserMapper" > <insert id= "Save" parametertype= "Com.cn.domain.User" Usegeneratedke Ys= "true" > INSERT into Tb_user (name,sex,age) VALUES (#{name},#{sex},${age}) </insert> </ma Pper>

MyBatis Handling Oracle Auto-increment issues (via triggers)